Invalid Object Name

[aayushaggarwal]

Hi Experts,

Actually, I am facing a problem in SAP PI version 7.1

One of my messages is stuck in the Message Monitoring (RWB) giving me the below error:

Error Delivering the message to the application using connection JDBC_http://sap.com/xi/XI/System failed, due to: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SP_SetPOStatus' (structure 'Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'MDO.sys.objects'..

I tried by comparing the payload with the payload of successful messages but 'no help'.

Payload:

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:MT_Set_PO_Status xmlns:ns0="http://Spotless.com.au/SCM_A042_I023">

- <Statement>

- <SP_SetPOStatus Action="EXECUTE">

  <PONumber isInput="TRUE" type="VARCHAR">9000012552</PONumber>

  <Status isInput="TRUE" type="VARCHAR">R</Status>

  </SP_SetPOStatus>

  </Statement>

  </ns0:MT_Set_PO_Status>

Could you please advise what is needed to be done ????

Thanks in Advance,

Aayush Aggarwal

[iaki_vila]

Hi Aayush,

Check the example structure here http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/09/07/jdbc-receiver-scenarios-best-prac...

Set a table tag and try to set the schema before the stored procedure.

Regards.

[aayushaggarwal]

Hi Inaki,

Thanks for the instant response.

But can you please explain what actually is the reason for this error and what should be done in this context??

Regards,

Aayush Aggarwal

[iaki_vila]

Hi Aayush,

If you check the JDBC XML formats in this link Defining an EXECUTE Statement - Advanced Adapter Engine - SAP Library, you have to generate a table denominated table with the stored procedure name

Regards.

Message was edited by: Iñaki Vila