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'
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
SELECT * FROM dbo.
