App Connect

 View Only

 Error emitting event on subflow

Nokuthula Mpofu's profile image
Nokuthula Mpofu posted Wed April 02, 2025 05:56 AM
A parsing error occurred when processing a message for RecordReplayStore ''DataStore''.  The error was ''ImbODBCStatement::checkRcInner() reported 'Root SQL exception' with values... '-1' ''odbc32.dll'' Nested Item{ ImbODBCStatement::checkRcInner() reported 'Child SQL exception' with values... ''07009'' '0' ''[Microsoft][ODBC Driver 18 for SQL Server]Invalid Descriptor Index'' }''.   
 
The message was placed on the backout queue.   
 
The message could not be parsed correctly and thus could not be recorded to the database. The message has been placed on the backout queue for manual processing.  If the problem persists, contact your IBM support center.  

I am getting the above error (in red) when an event is being emitted. The event message is then backed out onto queue, ''SYSTEM.BROKER.DC.BACKOUT''  . My application has subflow1 that calls subflow2 which it turn calls subflow3. The event is emitted on a node in subflow3.

We are using SQL Server 2022. We have noticed that when sublow3 is called directly from a message flow the event is emitted successfully.

 We have increased the length of EVENT_SRCADDR in the WMB_MSGS table form VARCHAR(100) to ARCHAR(256) to cater for the long event source names.

What could be the problem here?