IBM Support

Integration Server fails while processing EOF Message in MCF8.0

Troubleshooting


Problem

Integration Server fails while processing EOF Message in MCF8.0

Symptom

In MCF8.0 initial release, if JMS Receiver read End of File message, it waits for 300 seconds before proceeds. After waiting for 300 seconds, it will verify that there are exceptions for the given YantraMessageGroupID. While checking for exceptions, it fails because of Malformed SQL statement. For example

SELECT /*YANTRA*/ YFS_REPROCESS_ERROR.* FROM YFS_REPROCESS_ERROR YFS_REPROCESS_ERROR Where Sub_Flow_Name = 'ProcessEDI846Message' AND YANTRAMESSAGEID = 'edi846incoming.txt_200912021517409627' AND (STATE = 'Initial'' OR STATE = 'Saved') . There are two single quites after Initial

Error Message

If database is SQL server, the error message reads: Incorrect syntax near 'Saved'."

Resolving The Problem

The fix has been provided in HF1. It removed the extra ' of string Initial.

[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

NFX7902

Product Synonym

[<p><b>]Escalation ID[</b><p>];120315;[<p><b>]Fix ID[</b><p>];HF1;[<p><b>]Severity[</b><p>];Normal;[<p><b>]Type[</b><p>];NormalFix

Document Information

Modified date:
16 June 2018

UID

swg21552322

Page Feedback