Sender CC for MS SQL 2005 Driver error invalid object name

[Former Member]

Hello people,

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://<IP>:1433;databaseName=<DB Name>

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.

Thanks Stefanos

[Former Member]

Hello,

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.<company_code>$SAP_SALES_TRANS_PAYMENTS WHERE TRANSFERRED_FLAG='0'

Best regards

Stefanos