Skip to Content
author's profile photo Former Member
Former Member

Error processing request in sax parser

Greetings,

we are using the same target message MT_SQL_INSERT_Request for two different data requests. They were both working until a month ago. Now only one is working. The second one processes through PI successfully but there are errors in the receiving communication channel and the message is never inserted into the SQL database table. I can see the following error messages when I view the status of the communication channel through the runtime workbench.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'REQUEST' (structure 'Request_INSERT_Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: A result set was generated for update.

Error processing request in sax parser: Error when executing statement for table/stored proc. 'REQUEST' (structure 'Request_INSERT_Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: A result set was generated for update.

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'REQUEST' (structure 'Request_INSERT_Statement'): com.microsoft.sqlserver.jdbc.SQLServerException: A result set was generated for update.

Do you have any idea what may have occurred?

Thanks,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jun 07, 2012 at 06:41 PM

    It looks problem from Data base end,check with your DB team

    http://www.inductiveautomation.com/forum/viewtopic.php?f=25&t=5920

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 07, 2012 at 06:49 PM

    >Do you have any idea what may have occurred?

    This is not a panic error. YOu are using MS SQLServer. The database sends the count updates for the insert or updates it does in the backend. Is your interface sync or async? Talk to you DBA to not send this resultset acknowledgement update. I guess there should be some option to get the resultset update.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2012 at 07:28 PM

    I am using the same insert process in two separate messages.

    One is working fine - the message is processed successfully and inserted into the receiving database table. The receiving communication channel processes successfully - all messages are good.

    Message with ID 8ef6c467-9447-42b6-10bf-91368c42eee6 processed

    Message processing completed successfully


    The second message passes through PI successfully but the receiving communication channel errors with the messages I listed before.

    the interface is an asynchronous connection.

    I would think that if the database was set to send the resultset back then the first message that is working would get a similar result back - but it is not. So i don't think this is the issue.

    The first message TransactionType 4 always processes correctly - as expected.

    The second message TransactionType 2 always fails with the same error.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.