on 09-28-2012 3:44 AM
Hello
I am working on JDBC to RFC scenario. I have a select statement in JDBC sender adapter.
When I give the table name wrong, here is the error message I am getting:
Database-level error reported by JDBC driver while executing statement 'select cust_id "cust_id", order_dt "order_dt", process "process" from tmp_rcp where process = ' ''. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-00942: table or view does not exist '. For details, contact your database server vendor.
9/27/12 10:04:28 PM | dcc367f3-2f01-4503-0d0f-a29c0639185c | Retry interval started. Length: 3600.0 seconds | |
9/27/12 10:04:28 PM | dcc367f3-2f01-4503-0d0f-a29c0639185c | Database-level error reported by JDBC driver while executing statement 'select cust_id "cust_id", order_dt "order_dt", process "process" from tmp_rcp where process = ' ''. The JDBC driver returned the following error message: 'java.sql.SQLException: ORA-00942: table or view does not exist '. For details, contact your database server vendor. | |
9/27/12 10:04:28 PM | Processing started | ||
9/27/12 10:02:48 PM | dcc367f3-2f01-4503-0d0f-a29c0639185c | Retry interval started. Length: 3600.0 seconds |
When I give everything correct in the adapter, I get the following message:
9/27/12 9:45:18 PM | dcc367f3-2f01-4503-0d0f-a29c0639185c | Polling interval started. Length: 3600.0 seconds | |
9/27/12 9:45:18 PM | dcc367f3-2f01-4503-0d0f-a29c0639185c | Processing finished successfully | |
9/27/12 9:45:18 PM | Processing started |
From the error message in the adapter, I can understand that PI is successfully connecting with ModelN. Even though the second message states that the processing finished successfully, there are no messages in my Monitor.
Anybody has any ideas on this issue?
Thanks
Naga
Naga,
It means your SQL doesnt return any result. Check if your SQL query returns any result or not.
Regards,
Sumit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure your select query returns resultset or not. Try the same sql query in the sql client tool like toad and check whether you get records or not. I'm sure yours is not sync scenario. Only for the sync scenario you need to set logging parameter LOGGING_SYNC =1 in the sxmb_adm to view messages in sxmb_moni.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naga,
Are you using Integrated configuration ? If yes, you will not find any messages in SXMB_MONI as we are by-passing Integration Engine(IE), Monitoring is only supported by RWB.
Regards
Hari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Naga,
have you checked in SAP ECC like any records were updated /created table level ? if yes then activete logging parameter in SXMB_ADM to see pipeline steps in MONI.Monitor RFC adapter also, so that you can get clear picture .
when you see adutio log in JDBC adapter click on message , if records were picked up then you can see payload in audit log.
Regards,
Raj
Hi Naga,
Sumit is right your SQL is not returning result, Please check whether User Name you are using in the sender channel have the authorisation to read data.
Try executing the SQL directly in SQL db using that username.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
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.