JDBC sender issue no data in PI
We have a scenario Database to SAP we are using JDBC adapter at sender side and the Qos is EO.
Now the issue is database sender complained that they have sent the data from database but the data is not updating in SAP system as a result no Idoc created.
In the DB trace the DBA said that the SELECT executed successfully.
But I checked in PI and no failed or scheduled message in the Component Channel monitoring. The message id is greyed out. All I see is that Polling started and Processing finished successfully.
In SXMB_MONI there are no xml messages.
SELECT * FROM sys.tables works fine and I can see xml messages in SXMB_MONI and also see the audit trace log in RWB under CC monitoring.
Why is it not picking up data from other user tables in SQL server database?
I have analyzed the issue end to end .
Where is the adapter sending the converted xml messages if it has picked up data? If it has not then why cannot i see the trace and why is the message id greyed out in the CC monitoring?
Please help me to resolve this problem .
Try to call a stored procedure with select statement, instead of the direct selection.
PI db username have right permissions?