on 02-01-2012 10:05 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.