SAP PI Interview Questions and SAP PI Tutorials
SAP PI Interview Questions and SAP PI Tutorials
can some one help me with the following problem?
I’m trying to implement a JDBC to IDoc XI/PI scenario with PI 7.1.
In RWB CC monitor i’m getting the following error : “Database-level error reported by JDBC driver while executing statement ‘SELECT * FROM SAP_SALES_TRANS_PAYMENTS WHERE TRANSFERRED_FLAG=’0”. The JDBC driver returned the following error message: ‘com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name ‘SAP_SALES_TRANS_PAYMENTS’.’. For details, contact your database server vendor”.
Communication channel configuration:
JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection: jdbc:sqlserver://
Query SQL Statement is : “SELECT * FROM SAP_SALES_TRANS_PAYMENTS WHERE TRANSFERRED_FLAG=’0′”
Update SQL Statement: “UPDATE SAP_SALES_TRANS_PAYMENTS SET TRANSFERRED_FLAG=’1′ WHERE TRANSFERRED_FLAG=’0′”
The name of the database is ‘SAP_SALES_TRANS_PAYMENTS’, is checked. Are the table name and/or table fields names key sensitive?
The MT definition is identical with the data base table.
Ans:
this issue is solved now.
The problem was in the name of the database table. The Database was created for more then one
company codes (by an other partner company ) and the full/right name in the query is
SAP PI Interview Questions and SAP PI Tutorials
SAP PI Interview Questions and SAP PI Tutorials
SELECT * FROM dbo.
SAP PI Interview Questions and SAP PI Tutorials
SAP PI Interview Questions and SAP PI Tutorials