Skip to Content

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

JDBC sender adapter

Hello Experts,

For this problem I had raised message JDBC sender issue with PI read date before couple of month ago.

The issue is PI is fetching the data from the database and sending to SAP R/3.Now the issue is happenning very rare (once in month) .

The scenario is :

Suppose five data are read by PI from the database and also it will set

the time stamp(PI read date) so it can not be read by PI again.

Initial situation :

Table A

Record PI read date

R1 NULL

R2 null

R3 null

R4 null

R5 null

Once it is read by PI the table updated like below

TABLE A

Record PI read date

R1 20110516135609

R2 20110516135610

R3 20110516135611

R4 20110516135612

R5 20110516135613

Now we should get the five records in PI which we are not getting.

Suppose we have R1,R2 and R5 .The records R3 and R4 are missing in PI

but the PI read date is generated in the database table for all the

records .

I have already set the isolation level to serializable and checked the select update statement with database person and they confirmed it is correct , but the issue is still occrrring.Please advice.

Thanks,

Somenath

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