Resolution:
How to retrieve the status of records imported to a repository from an external system?

Environment:
=========
TIBCO Product name and version: TIBCO Collaborative Information Manager 7.2.X, 8.0.0
Operating System(s): All Operating Systems

Symptoms:
========
None.

Cause:
=====
None.

Resolution:
========
To realize this requirement, use a SendProtocolMessage activity in the in the wfin26catsourcev5.xml repository import workflow to publish the workflow InDocument to Java Messaging Service (JMS). The InDocument for the repository import workflow has the eventid, XPATH: //Message/Body/Document/BusinessDocument/CatalogAction/CatalogActionHeader/ThisDocID/DocID/IDNumber. The external system can receive the message sent by the SendProtocolMessage activity in the repository import workflow.

You would need to publish this document on JMS. You can find out how to use SendProtocolMessage activity from the wfin26productaddapprovalv3.xml workflow and %MQ_COMMON_DIR%\standard\samples\BackEndIntegration_Using_BW\Sample2.zip sample.

Once the document is published on JMS, you can use the GetEventService webservice to get the status of the repository import event.

Once the message/documented is received on JMS, you can use the following sql with the event id from the message to retrieve the status of the records imported.

select PLK.CATALOGID, PLK.OWNERID EVENTID, PLK.PRODUCTKEYID, PK.NAME RECORDID, PK.EXTENSION RECORDEXT, PLK.STATE FROM PRINCIPALKEY PLK, PRODUCTKEY PK
where PLK.PRODUCTKEYID = PK.ID and PLK.OWNERID = &ltEVENT ID>

Attachments:
==========
None.

References:
=========
None

How to retrieve the status of records imported to a repository from an external system?