Sender CC for MS SQL 2005 Driver error invalid object name


SAP PI Interview Questions and SAP PI Tutorials

SAP PI Interview Questions and SAP PI Tutorials

Sender CC for MS SQL 2005 Driver error invalid object name

Q:
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://:1433;databaseName=

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_SALES_TRANS_PAYMENTS WHERE TRANSFERRED_FLAG=’0′

SAP PI Interview Questions and SAP PI Tutorials

SAP PI Interview Questions and SAP PI Tutorials

Share this:
Share this page via Email Share this page via Stumble Upon Share this page via Digg this Share this page via Facebook Share this page via Twitter
PDF24    Send article as PDF   
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *