JDBC sender issue with PI read date

[Former Member]

Hello Experts,

We have a scenario Database to SAP we are using JDBC adapter at sender side and the Qos is EOIO.

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.

As a proof sender has the PI read date so PI has read the file .

But I checked in PI and no failed or scheduled message found in PI adapter engine or integration engine and also no issue in SM58,SMQ2 and SMQ1 and also in BPM.

I have analyzed the issue end to end .

Suppose data is coming from database to PI and failed for temporary connection issue and not entered in PI so I am not able to see the data but the problem is if the connection issue occurred why the sender receive PI read date .

From my point of view as the Qos is EOIO if the message failed in PI no other message will be processed from the same queue but we can see the queue is clean and no failed/SCHEDULED message in AE and IE and SM58.So I belive the data not entered in PI .

Please help me to resolve this problem .

Thanks in advance for you support .

Regards,

Somenath

[Former Member · Accepted solution]

Hi Somenath,

Check your Selct query which you have specified in Sender JDBC Communciation channel.

Check this Select Query is working fine on your data base, Resulting with data. See for connection parameters to connect to your database.

Regards

Praveen K

[Former Member]

i think you sould try:

- Get XML inbound response, cek query using that data

- In Date Element Set datatype to date type if this field in database is a date

Regard

Tsamrul Fuad

[Former Member]

Hi ,

What you can Do is check the following places...

1. Check Queues.

2. Check On CC Monitoring - Channel Name, Check Whether any data picked at ny interval of time ....

3. Check If Communical Channel is picking any current data.

4. Check if Communication channel is not locked.

5, Check if Query Written in Select at Sender Channel is working fine and picking up any data .

Generally what happenes is : if Out of all messages any even a single is with erronous format , all data failed....... to avoid Such you can use ROWNUM , so it wil pick only 1 record at a time .. and hance Correct messages will pass only Erronous message will fail

Regards

Prabhat Sharma.

[rajasekhar_reddy14]

Data not enter in to PI means something went wrong in connection between PI and Data base, to identify this error monitor your communication channel, and check with data base team data available in tables or not.

Regards,

Raj

[Former Member]

Hello Somenath,

What I could understand is that PI is not polling. Have you checked in RWB -> Communication Channel Monitoring if the channel is polling the DB?

Refer to the following. They will help you with channels that are not polling the DB.

1)

As I donu2019t know which SP level your system is on, please check the note below and apply the patch accordingly.

> 1317686 - Adapter Framework Scheduler may fail to remove a job

2)

Check whether you have deployed on your system the patches described in this note.

> 1083488u2013 XI FTP/JDBC sender channel stop polling indefinitely

In addition, please set the parameter 'taskTimeout' as described in the above note.

3)

Please check if there are locks for this channel according to question 29 of the note below.

831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter

Follow the instructions and delete the lock related to the stopped communication channel. For the 7.1 versions, please note that the Lock Manager is under the /nwa/locks, or on the location "Availability and Performance Management -> Locks".

4)

Check if the channels is in the scheduleru2019s list. Use the URL below for that.

http://host:port/AdapterFramework/scheduler/scheduler.jsp?xml

I hope this helps!

Let us know the outcome.

Cheers,

Jorge Eidelwein