MQSeries.net :: View topic - Issue with Shared Variable -- Resolved

wraymore · Posted: Wed Jul 02, 2008 9:14 am Post subject:

WMB6.0.2 Toolkit
WMB6.0.0.6 Runtime
AIX5.3.#

In a simple message flow - Input node; Compute Node; Output Node

I am wanting to use a shared variables to keep an incremented index value and to keep some counters.

I have declared the Shared Variables in the ESQL outside the Compute odule:

DECLARE phnIndex SHARED INTEGER 1;
DECLARE msgCnt SHARED INTEGER 0;
DECLARE totPageCnt SHARED INTEGER 0;
DECLARE tot3PageCnt SHARED INTEGER 0;
CREATE COMPUTE MODULE XMLMessage_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN BEGIN

Within the ESQL I reference the variables as any other variable:

SET msgCnt = msgCnt + 1;

CASE phnIndex
WHEN 1 THEN
SET OutTriadDestInfo.triadNS:DeviceId = phnNbr1;
WHEN 2 THEN
SET OutTriadDestInfo.triadNS:DeviceId = phnNbr2;
WHEN 3 THEN
SET OutTriadDestInfo.triadNS:DeviceId = phnNbr3;
ELSE
SET OutTriadDestInfo.triadNS:DeviceId = phnNbr4;
END CASE;

SET phnIndex = phnIndex + 1;

IF phnIndex > 4 THEN
SET phnIndex = 1;
END IF;

CASE msgCnt
WHEN 400 THEN
SET OutTriadDestInfo.triadNS:DeviceId = phnNbrA;
SET phnIndex = 1;
WHEN 800 THEN
SET OutTriadDestInfo.triadNS:DeviceId = phnNbrA;
SET phnIndex = 1;
WHEN 1200 THEN
SET OutTriadDestInfo.triadNS:DeviceId = phnNbrB;
SET phnIndex = 1;
WHEN 1600 THEN
SET OutTriadDestInfo.triadNS:DeviceId = phnNbrB;
SET phnIndex = 1;
END CASE;

SET pageCnt = OutTriadPayload.triadNS:Payload[1].(XMLNSC.Attribute)pages;

IF pageCnt = 3 THEN
SET tot3PageCnt = tot3PageCnt + pageCnt;
END IF;

SET totPageCnt = totPageCnt + pageCnt;
SET Environment.ScratchPad.PageCnt = totPageCnt;
SET Environment.ScratchPad.ThreePageCnt = tot3PageCnt;
SET Environment.ScratchPad.MsgCnt = msgCnt;

In the message flow User Defined Properties Tab, I have added the four items listed above.

I have built a *.bar file that contains the messageflow.cfm and have verified that the initial values are as above.

However when I deploy the bar file, I receive the following errors:

BIP4055E: (.DBSchemaQualifier, 1.1) : User defined attribute must specify an initial value expression.
User defined attributes must either be given an initial value on the DECLARE statement or be given a value at deploy time.
Set the value of the User Defined Attribute at deploy time.

BIP4001E: Syntax error in SQL statements in node XMLMessage.Compute'.
The configuration failed due to errors in the SQL statement text. See the following messages for details of the error
The following error messages will give specific details of the location and nature of the error. Check and correct the syntax of the SQL statements and redeploy.

I have tried removing the initial values from the Declare statement and set them in the Message Floe Editor User Defined Properties Tab. I have tried setting the values to something totally different in the bar file, but still keep getting the same response. Can anyone provide me some guidance.