Skip to Content
author's profile photo Former Member
Former Member

JDBC sender issue with PI read date

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 03, 2011 at 06:53 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 04, 2011 at 12:48 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2010 at 04:13 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 31, 2010 at 04:02 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 09, 2011 at 04:18 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.