Here is my question :
I am using webmethods 6.1, Solaris, SQLSERVER2000.
I have written a flow service to capture the data and do a publishandwait.
On the otherside I have a subscribing service which gets the published data and inserts the data into sqlserver. Once the data is inserted It immediately picks up the data from the second table. it formulate the resultset and does a publish:reply.
This scenario works when the target tables are empty and there are no records. When I do a publishandwait second time it goes into infinite loop. I see the document in the broker which is not picked up by the subscribing service.
I am really puzzled. First time it works and and second time the target service does not even get the data which is published.
Help me in debugging this issue.
And also If I get a package which uses publishandwait, reply It would be of great help.
Please let me know if you require any more information
Thank you in-advance