Posted: Mon Nov 12, 2012 5:26 am Post subject: Error while opening Topic Handle - WMB v8.0.0.1
Voyager
Joined: 04 Sep 2012 Posts: 77 Location: UK beyond the meadows of RocknRoll
Hi,
I get an error stating Error while opening topic handle. The same flow works most of the times but fails when the input message comes with data not handled in the specified CCSID.
Heres the full scenario:
Generic flow:
MQInputNode-->Compute node(Determines type of msg and places Q name in target Q field) --> MQOutput node.
The input msg was failing with inconvertable character as we do not copy the mqmd from input. We now copy the mqmd.ccsid and this error does not occur anymore.
2ndflow:
MQInput-->Computenode-->Pubnode
The input message contains – and the ccsid is 1208. when it tries to publish it errors out with Error while opening Topic Handle. For any message that does not have this weird character, it works as expected. Hence the topic/subs setting is correct.
It also shows that the error message is not correct. The BIP number is 2035 which is again not supported in MB8.0.
Any idea on the error and how it can be resolved?
There is another post here where the user solved it with useridentifier field. I am not copying properties or mqmd from the original msg(except ccsid).
Cheers.
_________________ A Colorblind man may appear disadvantaged but he always sees more than just colors...
Joined: 04 Sep 2012 Posts: 77 Location: UK beyond the meadows of RocknRoll
Solution to this problem:
In the first generic flow, after copying the MQMD, set User Identifier to user under which broker service runs. Also change MQ Output Node Property -->Advanced --> Message context-->Set Identity.
Hope this is the right way to do it.
Also any idea on why the old Bip number comes for this error? _________________ A Colorblind man may appear disadvantaged but he always sees more than just colors...
Joined: 04 Sep 2012 Posts: 77 Location: UK beyond the meadows of RocknRoll
Just finalised everything and time to give the full solution we went through.
After we set the user identifier to '' the msg is published. At this point we were still getting an error as unconvertable character.
I am not sure whether the CCSID 1208 was maintained during publish. So we converted the whole XML into BLOB using RCD before publishing and now everything works perfect.
I am not convinced that Pub Sub maintains the CCSID explicitly set in MQMD and rather reverts to system default(819 in our case).
** Not sure how to close this thread** _________________ A Colorblind man may appear disadvantaged but he always sees more than just colors...
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum