cancel
Showing results for 
Search instead for 
Did you mean: 

Message is inserting multiple times in target system

Former Member
0 Kudos

Dear Experts,

We are using MDM to JDBC system. we are sending 2 sales Org and multiple plants in sender XML message we had done a mapping by spliting 2 sales Org x No.of Plants (Eg: 2 sales Org x 5 Plants = Total 10 records to be inserted at target system).

But we observed all the 10 records are inserted 4 times with the time interval of every 5 mins in target system.

Pls let us know the solution if you have come across this kind of issues.

Thanks & Regards

Soumya

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member184681
Active Contributor
0 Kudos

Hi Soumya,

That delay period of 5 minutes between inserts makes me think that your JDBC execution is interpreted by PI as unsuccessful by your PI system, which makes it retry delivering the data. Check RWB Communication Channel Monitor if it will show your message as erroneous. Do you use direct inserts, or a stored procedure? In case of the latter, make sure your procedure does not return any error after processing the data (even though it is processed successfully).

Hope thie helps,

Greg

Former Member
0 Kudos

Dear Greg,

Thanks for your reply

Data is inserting in target system and we are getting error in RWB communication channel monitoring.The message is processed 4 times and failed all the times and the time interval between each processing is 5min.

In adapter engine the message status is successful for 1time and system error in other time.

Thanks & Regards

Soumya

former_member184681
Active Contributor
0 Kudos

Dear Soumya,

I think you should review the development on the receiver system side. Most probably it is giving you some strange response even though it saves the data properly. Your symptoms seem to confirm that (data saved correctly, but error in CC monitor in RWB).

Hope this helps,

Greg

rajasekhar_reddy14
Active Contributor
0 Kudos

Take payload from Moni and check how many time access tag repeated? based on that you will let you know the number of insert oprations perfromaned on data base, have a look in Reciever JDBC channel log message and see log message completely it displays how many time data inserted in to data base, it forms insert query.