Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC sender issue no data in PI

Hello,

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 .

Thank you,

Teresa

Former Member
Former Member replied

Hello Teresa,

Try to call a stored procedure with select statement, instead of the direct selection.

PI db username have right permissions?

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question