• srinath.m (11/11/2013)


    Marios, I've setup the database and ran scripts in the order they appear in supplementary material, but receiving the following error when triggered the job "dba - updStats - ServiceBroker"....

    Executed as user: xxxxx. Invalid object name '//UTILITY/UpdStats/InitiatorService'. [SQLSTATE 42S02] (Error 208) Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. [SQLSTATE 25000] (Error 266). The step failed.

    Would you be able to assist me with this situation, please...!!

    Hi, it doesn't look like this object has been created in 02_ServiceBrokerObjects.sql:

    USE UTILITY;

    GO

    CREATE SERVICE [//UTILITY/UpdStats/TargetService]

    ON QUEUE UpdStats_TargetQueue ([//UTILITY/Contract]);

    GO

    Can you run the following code and send me the results?

    USE [UTILITY];

    SELECT

    S.name AS [Service]

    ,Q.name AS [Queue]

    ,C.name AS [Contract]

    FROM

    sys.services AS S

    INNER JOIN

    sys.service_queues AS Q

    ON

    S.service_queue_id = Q.[object_id]

    LEFT OUTER JOIN

    sys.service_contract_usages AS U

    ON

    S.service_id = U.service_id

    LEFT OUTER JOIN

    sys.service_contracts AS C

    ON

    U.service_contract_id = C.service_contract_id;

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]