Difference in record count ?

[Former Member]

Hi Experts

We have a interface for inventory adjustment  from RMS to Webserver in which we are picking 5000  records for each poll interval and these 5000 rows updated successfully according to audit log.But when i check in the payload the number of records are decreased to 4900 and these 4900 are successfully inserted in Webserver. Kindly let me know why these records are missing.

I have mentioned transaction isolation level as serializable.

Regards

Nagur

[Former Member]

Hi Nagur,

Can you share the audit logs and also the sender channel parameters? I believe PI is not processing the file completely.

Regards,

AJ

[Former Member]

Hi Jain

Issue has been solved.I have unchecked Database Auto-Commit-Enabled (No Transaction Handling) parameter in sender communication channel.

Thanks

Nagur