cancel
Showing results for 
Search instead for 
Did you mean: 

big bug in NW-PI-731, JDBC-adapter losing data

christoph_ostrop
Active Contributor
0 Kudos


Hi,

we recognized a big bug in NW-PI-731 SPS07, processing data with JDBC_xxxx_SENDER, sometimes it occurs, that for example, from 13974 documents should be processed, but only a part of 13137 documents are processed successfully, but 837 documents are missing in the target system,

In message-monitoring, PI displays all documents as processed successfully, but that is obviously wrong,

so PI is sometimes losing data - this behaviour we did not have had in NW-PI-700-SPS18

after upgrading to PI-731, we have big trouble with data processing.

did other SAP-customers noticed the same behaviour?

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi

You can count the total number message processed in PI from message monitoring in RWB.

If you see that the number is 13137, then there is a problem while reading the data from database

using JDBC sender adapter.

Since the number of records are high, you can try to restrict the number of records using rownum in

database select query.

Check this

PI 7.1 JDBC sender adapter huge load from DB se... | SCN

ralph_birk
Discoverer
0 Kudos

Hi,

we do't have a problem with huge loads. The messages we are losing are indeed relatively small because we send only chunks of 50 to 100 records per JDBC-Select.

The scenario is as follows:

The JDBC-Sender adapter reads 100 records and marks them as processed in the update-Statement. When updating the records we even write the messageID to the records, that we got from PI.

After that the message is lost in PI. You can't see it anymore, not in the SXMB_MONI and even not in the RWB! Although the messageID was written to the database you won't find the messageID in PI.

This happens only in 1 one of 10.000 cases. So it isn't reproducible. We suspect that it happens when PI is shutting down or if PI is short of memory.

Eoin_Kierans
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Christoph,

Can you detail if this is an Integrated Configuration or a classical scenario? What communication method is used to send the messages to target system?

Regards

Eoin

christoph_ostrop
Active Contributor
0 Kudos

my pi-colleague (Ralph Birk)  has the detail - please look at his entry.