cancel
Showing results for 
Search instead for 
Did you mean: 

Regarding jdbc to idoc scenario ...!!!

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member303666
Active Participant
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks experts for helping me out ..!!

baskar_gopalakrishnan2
Active Contributor
0 Kudos

>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

Former Member
0 Kudos

Thanks for the reply ,

here is my Select Query

SELECT A.INTERFACE_TRANSACTION_ID, A.DOC_HEADER_TEXT, A.COMPANY_CODE, TO_CHAR(A.DOCUMENT_DATE,'YYYYMMDD') DOCUMENT_DATE, TO_CHAR(A.POSTING_DATE,'YYYYMMDD') POSTING_DATE, A.PERIOD, A.DOCUMENT_TYPE, A.REFERENCE, B.VENDOR_ACCOUNT, B.CF_MATERIAL_TYPE, B.CF_ENTRY_POINT, B.CF_SOURCE, B.PAYMENT_TERMS, TO_CHAR(B.BASELINE_DATE, 'YYYYMMDD') BASELINE_DATE, B.ASSIGNMENT, B.TEXT, B.ORDER_NUMBER, B.QUANTITY, B.UOM, B.GL_ACCOUNT, B.DOC_CURRENCY, B.DOC_AMOUNT, B.CURRENCY, B.AMOUNT, B.USER_STATUS, B.SPECIAL_GL_IND, B.PREV_DOC_NUMBER, TO_CHAR(B.PREV_POSTING_DATE,'YYYYMMDD') PREV_POSTING_DATE FROM CFCV_FP_HDR A JOIN CFCV_FP_DET B ON A.INTERFACE_TRANSACTION_ID = B.INTERFACE_TRANSACTION_ID AND B.STATUS_FLAG = 'M'

and where can i find the TOAD to test the Query as u stated .

Pls Help ..!!!

baskar_gopalakrishnan2
Active Contributor
0 Kudos

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.