MQSeries.net :: View topic

WBI_User21 · Posted: Wed Jun 04, 2008 7:44 am Post subject:

Hi ,
I am trying to remove the element from the atomic row.But I am ending up with the exception which says :
-----------------------------------------------------------------------------
BIP2503
Invalid shared variable operation.
Severity
20 : Error
Explanation
An SQL statement has attempted an operation involving shared variables which is outside the range permitted. You cannot move (by using DETACH/ATTACH) a subtree from one shared variable to another. You cannot use functions with side effects to change shared variables when the expression invoking the function also operates on shared variables.
Response
Correct the logic of the ESQL program and re-deploy the message flow.

--------------------------------------------------------------------------------

The piece of code which is causing the exception is :
SharedMutex2:BEGIN ATOMIC
X: WHILE i < MaxConn DO
SET storeCookie.cookieList[i] = storeCookie.cookieList[i+1];
SET i = i + 1;
END WHILE X;
END;

The italisized line above throws the exception. There was no such error when executed in 6.0.0.1 version of MB. This exception occured when this piece of code was executed in 6.0.0.7.
Please share your view points on these.
-------------------