Author |
Message
|
16legal |
Posted: Sat Jul 13, 2013 6:16 am Post subject: Zero index issue in Message Broker v7 |
|
|
Novice
Joined: 05 Jun 2013 Posts: 21
|
Message Broker v7 onwards does not accept zero index and throws an error 'index should be non zero interger' while deploying the message flow.
Which means an ESQL statement SET OutputRoot.XMLNSC.A.B[0] ='22'; will work in Message Broker v6 but throws a zero index error in Message Broker v7.I googled the issue for a solution and found a link http://www-01.ibm.com/support/docview.wss?uid=swg21509339 which states the error and recommends an approach for a solution.It says
There is an environment variable that will allow the index of zero.
export MQSI_ALLOW_INDEX_ZERO=1
and restart the broker. Then perform a deploy . It should help resolve the deploy error with index 0.
Now i am not sure how do i implement the statement
export MQSI_ALLOW_INDEX_ZERO=1 ??
Could you please suggest? |
|
Back to top |
|
 |
fjb_saper |
Posted: Sat Jul 13, 2013 6:23 am Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20756 Location: LI,NY
|
In windows replace export envvar=value with set envvar=value. You need to do this either in the shell starting the broker or add this in the requisite file see infocenter for the right place.
Have fun  _________________ MQ & Broker admin |
|
Back to top |
|
 |
16legal |
Posted: Sat Jul 13, 2013 6:56 am Post subject: |
|
|
Novice
Joined: 05 Jun 2013 Posts: 21
|
Do i need to set the value in the command prompt ? I have tried it out but it does not seem to be working. |
|
Back to top |
|
 |
zpat |
Posted: Sat Jul 13, 2013 12:33 pm Post subject: |
|
|
 Jedi Council
Joined: 19 May 2001 Posts: 5866 Location: UK
|
Control panel, System, advanced, environment variables. Then restart the broker. |
|
Back to top |
|
 |
kimbert |
Posted: Mon Jul 15, 2013 1:15 am Post subject: |
|
|
 Jedi Council
Joined: 29 Jul 2003 Posts: 5542 Location: Southampton
|
The best way to set an environment variable for message broker / Integration Bus on Windows is:
- Open a command console for broker
- Stop the broker
- create a file in %MQSI_WORKPATH%\common\profiles with extension '.cmd' ( not '.bat' ) and contents 'SET env_var_name=1'
- Start the broker
As far as I'm aware, setting it in Control Panel will not work. Setting it in the console window will only work until the next time you stop and start the broker. |
|
Back to top |
|
 |
Tibor |
Posted: Mon Jul 15, 2013 1:43 am Post subject: |
|
|
 Grand Master
Joined: 20 May 2001 Posts: 1033 Location: Hungary
|
kimbert wrote: |
As far as I'm aware, setting it in Control Panel will not work. |
It is true, if your broker was launched as a service, because a service inherits the environment variables from the parent process (services.exe). This process is started at the early stage of Windows boot process, so its environment can be changed when OS is restarting. |
|
Back to top |
|
 |
|