Grass Valley iTX Delivery Manager v.2.6 - Manual (Page 96)

90
Troubleshooting
Verifying the Stored Procedures are present
Verifying the Stored Procedures are present
To verify the stored procedures are present:
1 Using your SQL Server Manager application expand Database > Programmability >
Stored procedures.
2 Check the following stored procedures have been added:
dbo.osp_OPUS_DM_Core_GetAssetXMLFromAssetName
dbo.osp_OPUS_DM_Core_GetAssetXMLFromAssetNameWithMetadata
Verifying the required functions are present
To verify the required functions are present:
1 Using your SQL Server Manager application expand Database > Programmability >
Functions > Scalar-valued Functions.
2 The following functions should have been added:
ofn_g3Media_ContnetSegmentType_GetPathFromID
ofn_OPUS_XML_GetContentEventsAsXML
ofn_OPUS_XML_MetadataEventsAsXML
Verifying the Service Broker is present
Note: This step is not required for SQL 2005.
To verify the service broker is present:
1 Using your SQL Server Manager application, select Properties > Options (Service
Broker)
2 Check that Broker Enabled = True .
3 Expand Database > Service Broker > Message Types
4 Check for MessageContractType
5 Expand Database->Service Broker->Contracts
6 Check for DMCoreContract
7 Expand Database->Service Broker->Queues
8 Check for dbo.DMCoreQueue
9 Expand Database->Service Broker->Service
10 Check for DMCoreService