My requirement is to extract the records from a table to insert the same to another table. Instead of directly inserting
them after extraction through adapter services, client specified to use publish/subscribe mechanism for this
(publishing a document for each extracted record, subscribing to the
published document and through it inserting the records in the target table.
I am using Broker and one IS only (both for publish and subscribe). The
strategy I used:
- insert notification for the source table and a trigger which takes insert notification publish document and invokes a flow service (in this I publish the records using a loop over records).
I have to subscribe to published documents through a trigger for which I
need the publishable document type. I tried to create a document refernce for the broker document type, but it is not allowing me to do it, saying that specified Broker Document Type is already bound to Document Type insertNotifyPublishDocument.
So I used the nsertNotifyPublishDocument even for the subscription trigger also. But I am not getting the result (updattion in the target table).
I observed the documents published number is getting increased in the Broker Admin, but not sure whether the particular records are getting published or not. How to see the exact document published in IS 6.1 ? I can take the document reference only in the Input fields place, which requires manual input, which I don’t want. I mapped the extracted records to a document for publish service. But I am getting an exception :
“Invalid input. ‘document’ is a required parameter of type IData”
If I specify the input (document reference of insertNotifyPublishDocument), I am getting the error:
"Invalid input. documentTypeName’ is a required parameter of type String.
Could anyone help me out in getting the result ?