Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

JDBC Receiver error

Hi All,

I have a scenario where XI has to pick the file from ftp and update the stagging databse through JDBC.

XI is picking the file, but not getting failed while sending the data to JDBC.

Unable to execute statement for table or stored procedure. 'MSDYNAMICSEMPLINFO' (Structure 'STATEMENT') due to com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'MSDYNAMICSEMPLINFO'.

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'MSDYNAMICSEMPLINFO' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'MSDYNAMICSEMPLINFO'

Exception caught by adapter framework: null

MP: Exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MSDYNAMICSEMPLINFO' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'MSDYNAMICSEMPLINFO'

Delivery of the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MSDYNAMICSEMPLINFO' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'MSDYNAMICSEMPLINFO'

But the client say that the table is created at their end.

Please help

Edited by: Lavanya Ravi on May 17, 2011 8:01 AM

Former Member
Former Member replied

Hi,

Go to ESR & under your namespace, rt. click & create external defination.

In external defination select dbtb from the dropdown and select next

select the name of receiver JDBC CC & check out for available tables at DB end.

Thanks,

Krishna

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question