MQSeries.net :: View topic - Broker logs shows error for executing the SQL code

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker logs shows error for executing the SQL code

Broker logs shows error for executing the SQL code

« View previous topic :: View next topic »

Author

Message

chris boehnke

Posted: Tue Jun 05, 2007 5:09 am Post subject: Broker logs shows error for executing the SQL code

Partisan

Joined: 25 Jul 2006
Posts: 369

Hi,
I am getting an error in Broker logs while executing this part of the code in Compute node(MapToBLOB): 'SET OutputRoot.BLOB.BLOB = BITSTREAM(InputBody);'.

The Broker logs shows: Jun 5 08:57:55 BROKER02 WebSphere Broker v6002[20775]: (BK1.EG5)[1213209520]BIP2488E: (SOASchema.ServiceF
anInMF_MapToBLOB.Main, 6.3) Error de
tected whilst executing the SQL statement 'SET OutputRoot.BLOB.BLOB = BITSTREAM(InputBody);'. : BK1.39b21bd8-1201-0
000-0080-8d7b4cd8401e: /build/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp: 589: SqlStatementGroup::execute: Co
mIbmComputeNode: SOASchema/ServiceFanInMF#FCMComposite_1_14

This code is working fine but the broker log is filling with this error whenever a message is passed through FaIn flow. It is becoming very difficult to search for an actual error as most of the logs in Broker log are related to "'SET OutputRoot.BLOB.BLOB = BITSTREAM(InputBody);".

Please suggest how can we correct this problem.

Thanks

chris boehnke

Posted: Tue Jun 05, 2007 5:11 am Post subject: Re: Broker logs shows error for executing the SQL code

Partisan

Joined: 25 Jul 2006
Posts: 369

chris boehnke wrote:

Sorry the SQL statement in the Compute node is

SET OutputRoot."BLOB"."BLOB" = BITSTREAM(InputBody);

jefflowrey

Posted: Tue Jun 05, 2007 5:19 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Please don't use the BITSTREAM function.

Use ASBITSTREAM instead.
_________________
I am *not* the model of the modern major general.

chris boehnke

Posted: Tue Jun 05, 2007 6:50 am Post subject:

Partisan

Joined: 25 Jul 2006
Posts: 369

jefflowrey wrote:

Please don't use the BITSTREAM function.

Use ASBITSTREAM instead.

Thanks Jeff.

I used the ASBITSTREAM function and it is working fine.

Earlier the code was: SET OutputRoot."BLOB"."BLOB" = BITSTREAM(InputBody);

and now I replaced the above code with the below one

SET OutputRoot."BLOB"."BLOB" = ASBITSTREAM(InputRoot.BLOB CCSID InputRoot.Properties.CodedCharSetId);

Thanks.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Broker logs shows error for executing the SQL code

Jump to:

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

Protected by Anti-Spam ACP