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

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