Skip to Content
0
Former Member
Jul 20, 2010 at 07:52 PM

Error on JDBC Receiver Channel

276 Views

Hi,

I configured a Receiver JDBC Channel to read data from XI own DB. We are using MS SQL Server 2005.

During the test, I'm running to the following issue. Any ideas on what could be causing this error:

Log for CC monitor:

2010-07-20 13:53:20 Success The message was successfully retrieved from the receive queue. 
2010-07-20 13:53:20 Success Receiver JDBC adapter: processing started; QoS required: ExactlyOnce 
2010-07-20 13:53:20 Success JDBC adapter receiver channel RPI_LOOKUP_JDBC: processing started; party  , service RPI_DB 
2010-07-20 13:53:20 Success Delivering to channel: RPI_LOOKUP_JDBC 
2010-07-20 13:53:20 Success MP: Processing local module localejbs/CallSapAdapter 
2010-07-20 13:53:20 Success MP: Entering module processor 
2010-07-20 13:53:20 Success select sem_datetime, sem_user, sem_host, sem_flag from "/RPI/T_USER" where sem_user=dom1\user1
2010-07-20 13:53:20 Error JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'query' (structure 'stmt'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name '/RPI/T_USER'. 
2010-07-20 13:53:20 Error Unable to execute statement for table or stored procedure. 'query' (Structure 'stmt') due to com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name '/RPI/T_USER'. 
2010-07-20 13:53:20 Error 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. 'query' (structure 'stmt'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name '/RPI/T_USER'. 
2010-07-20 13:53:20 Error Exception caught by adapter framework: null 
2010-07-20 13:53:20 Error 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. 'query' (structure 'stmt'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name '/RPI/T_USER'.. 
2010-07-20 13:53:20 Error The message status set to NDLV.

Here is the payload:

<root>
 <stmt>
  <query action="SQL_QUERY">
   <access>
    select sem_datetime, sem_user, sem_host, sem_flag from "/RPI/T_USER" where sem_user='dom1\user1'
   </access>
  </query>
 </stmt>
</root>

Connection Settings:

JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Connection: jdbc:sqlserver://hostname.domain.net;databaseName=XI1;

I did check on the DB and am able to see the table /RPI/T_USER, with 0 records.

Thanks in advance,

Sumant.