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

Regarding jdbc to idoc scenario ...!!!

Hi Experts ,

Here i am facing a Problem while testing the JDBC to IDOC Screnario . Mine is the Sender System (OracleDatabase) and Receiver System is (SAP ECC) . i am using Sender JDBC Channel to pull and Update the table Records and post them into SAP ECC System using IDOC Receiver Channel ...!!

Now the Problem is when i try to trigger the Message i am not able to see the message in Moni . PI is not able to pick the message itself . i checked the sender channel in RWB its working fine . we are Triggering the Test Data through the RWB->Communication Channel monitoring-> here we Start the Sender JDBC Channel when ever we need to test them and will check in moni to see wheater the message is passed through PI .

Last week it was working fine but today , I am not able to see a single message in Moni ...!

Below is the Update Query which we are using

"UPDATE CFCV_FP_DET SET STATUS_FLAG = 'P', STATUS_FLAG_DESC = 'Processed by PI', DATETIME_PROCESSED = sysdate WHERE INTERFACE_TRANSACTION_ID IN (SELECT A.INTERFACE_TRANSACTION_ID FROM CFCV_FP_HDR A JOIN CFCV_FP_DET B ON A.INTERFACE_TRANSACTION_ID = B.INTERFACE_TRANSACTION_ID AND B.STATUS_FLAG = 'M')

"

Is this any issue with the Update Query as we are trying to run the test data through channel only not From the sender System (Oracle Database System ) in runtime ..!!

Help me with this Problem

Regards,

Aziz khan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jul 19, 2011 at 06:43 PM

    hi,

    jdbc 2 idoc

    last week the files are processed fine ..now it's not happen..first check the runtime parameters,and file access parameters.

    and check the jdbc quary in sender cc in xi syatem....

    send a mail to jdbc team to they placed the file r not in jdbc side...

    regards,

    kesava

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2011 at 05:59 PM

    >Last week it was working fine but today , I am not able to see a single message in Moni ...!

    Few suggestions.

    a) Your sql statement seems to be fine.

    b) Where is select statmetn? Use the select statement and test using toad or some db tool and see what happens.

    Question:

    a) Select statement only returns resultset data which you can map to idoc

    b) update statement will not return data except saying example 100 records updated.

    Where is your select sql query? Please use that query in toad and see what you get back. if you dont get any record then you will not get any message from jdbc adapter and so you will not see message in sxmb_moni. Hope that helps

    Add a comment
    10|10000 characters needed characters exceeded

    • I think your select query seems to be okay.

      You can use any database query run tool like SQLPlus or Toad etc. Basically I want you to see any record exist for the query in the table.

      Example: You are quering when B.Status_flag='M' to get the records. Assume there is no record with status_flag = 'M' and in this case you will not get any record. so you will not get any message from jdbc sender and in moni. Hope you understand.

      Ask your database team to run the query to check whether data exists for that query or not? That would be easy step too.

      Hope that helps.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2011 at 08:19 AM

    Thanks experts for helping me out ..!!

    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.