PFB flow
Messages are equal and database records are updated successfully
I cannot use debugger because I am getting this error message when I am trying to deploy the app.
Begin running task [Deploying [GetStaticOfferData.msgflow] to integration server [default]]
BIP2087E: Integration node 'TESTNODE_as1' was unable to process the internal configuration message.
The entire internal configuration message failed to be processed successfully.
Use the messages following this message to determine the reasons for the failure. If the problem cannot be resolved after reviewing these messages, contact your IBM Support center. Enabling service trace may help determine the cause of the failure.
BIP4041E: Integration server 'default' received an administration request that encountered an exception.
While attempting to process an administration request, an exception was encountered. No updates have been made to the configuration of the integration server.
Review related error messages to determine why the administration request failed.
BIP2402E: (, 1.6) : Syntax error : 'placed'.
The token caused a syntax error.
Correct the syntax of your ESQL expression in node '', around line and column '1.6', then redeploy the message flow.
The task was unsuccessful: The deployment was unsuccessful. Check error messages above for explanation.
------------------------------
Aimen Sattara
------------------------------
Original Message:
Sent: Thu March 18, 2021 06:24 AM
From: Lars Dehli
Subject: Application deployment issue
Hi.
I agree with Pierre.
It doesn't seem like the code you pasted is from the code that is causing the error.
We would need more information to be able to help.
- Screen shot of the flow
- The entire error message
- Sample messages that are sent to the flow - are they all equal?
- Have you verified that the database actually get updated from the first messages you send thru?
------------------------------
Lars Dehli
Original Message:
Sent: Thu March 18, 2021 02:57 AM
From: Pierre Richelle
Subject: Application deployment issue
Hello,
You might have different issues here.
1. From what node are you calling the ESQL code ?
2. Part of you Root tree is propagated. You should call copyMessageHeaders and set the last child of root to your message: XMLNSC....
3. What is the value of record_Id ? Is it correctly set on all your test? I would recommend to use a trace node or a debugger to test.
Note that if you can't use the debugger a good approach is to use trace node and user trace.
------------------------------
Pierre Richelle
IBM Hybrid Cloud Integration Specialists
IBM
+32474681892
Original Message:
Sent: Wed March 17, 2021 01:11 PM
From: Aimen Sattara
Subject: Application deployment issue
PFB code:
CREATE COMPUTE MODULE GetStaticOfferData_Update_DB
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
DECLARE rec_Id integer;
SET rec_Id=InputRoot.XMLNSC.prov_request.record_Id;
SET OutputRoot.XMLNSC.Flow_Status.Status_Code=rec_Id;
UPDATE Database.SCOTT.PROV_ACTION as P set Status=2 where P.record_Id=rec_Id;
-- CALL CopyMessageHeaders();
-- CALL CopyEntireMessage();
RETURN TRUE;
END;
CREATE PROCEDURE CopyMessageHeaders() BEGIN
DECLARE I INTEGER 1;
DECLARE J INTEGER;
SET J = CARDINALITY(InputRoot.*[]);
WHILE I < J DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I = I + 1;
END WHILE;
END;
CREATE PROCEDURE CopyEntireMessage() BEGIN
SET OutputRoot = InputRoot;
END;
END MODULE;
------------------------------
Aimen Sattara
Original Message:
Sent: Wed March 17, 2021 03:46 AM
From: Lars Dehli
Subject: Application deployment issue
Hi Aimen.
I might be wrong - but this look like an ESQL-code issue, and not an MQ issue.
Can you paste your entire ESQL code?
Are all the messages you send identical?
Cheers,
Lars
------------------------------
Lars Dehli
Original Message:
Sent: Mon March 15, 2021 03:36 AM
From: Aimen Sattara
Subject: Application deployment issue
I am working on IBM IIB tool for an integration project.
I have installed MQ and IBM integration toolkit on my local system. I am able to create message flows and deploy them. I am using messaging queues and ESQL for custom computation. Whenever I deploy a message flow, it runs fine on 1st two or three runs, after that I start getting this error in deployment:
BIP2402E: (, 1.9) : Syntax error : 'place'.
The token caused a syntax error.
Correct the syntax of your ESQL expression in node '', around line and column '1.9', then redeploy the message flow.
I have checked on internet but couldn't find any resolution. Why it works once or twice but then stops working after 2-3 runs?
------------------------------
Aimen Sattara
------------------------------