Publish/Subscribe issue

, ,
21

Hey frnds…At last its working now :wink: .Thanks a lots for all ur suggestions.
Since i`m doing a self learning course on WM6,i need another help frnds.
The scenario is like this---->
If i insert a record into D1_orders table it publishes a doc,triggers a flow and inserts the same data into D2_orders–>this is working

If i insert a record into D1_LineItems table it publishes a doc,triggers a flow and inserts the same data into D2_LineItems–>this is working

Now when both the events happen,i need to insert some data,which is a combination of both the tables into an audit table.

How do i go abt wid this?
I tried using 2 conditions in a trigger and AND them,but the Joins property is not enabled.Says N/A(Not applicable)

Could someone guide me for the same.

22

When do we get this error
Server Log Entries as of 2006-04-12 11:43:30 GMT+05:30
[2043]2006-04-12 11:40:15 GMT+05:30 [ISS.0106.0004D] Received Duplicate Document of type: Dept1:L1InsertNotifyPublishDocument for activation key: Audit:AuditIn:wm6ffd94410c9ea11daa3229151233c424b
[2042]2006-04-12 11:40:13 GMT+05:30 [ISS.0106.0004D] Received Duplicate Document of type: Dept1:L1InsertNotifyPublishDocument for activation key: Audit:InsertInto2:wm6ffd94410c9ea11daa3229151233c424b
Wats the soln?

23

Sangeetha,
Go through this.
[url]https://advantage.webmethods.com/advantage?targChanId=kb_home&oid=1612979913[/url]
Thanks,
Jay

24

Hi Sangeetha, please explain me how you solved the problem of null value passed by trigger, I have the same problem!!!

I need to create a scenario identical to you…

25

Hi,

I also faced the same problem. But it’s really frustrating to find such a long discussion and finally the person who starts discussion solves the problem but didn’t mention how he solve the problem.
Just as jeevan suggested input document name of subscriber service should be fully qualified name of the publishable document type.
e.g. If you Publishable document type is in Package PublisherPackageName.FolderName::DocTypeName
then generate input document with name PublisherPackageName.FolderName::DocName.

Hope this will help others who are facing same problem.

Thanks and Regards,
Mayur Bhawar

26

Whether your Insert JDBC service is working fine…??

Are you able to see value insertSampInput, which is input for Insert JDBC service?

-Shaik