on 07-19-2011 6:09 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks experts for helping me out ..!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ..!!!
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.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.