MQSeries.net :: View topic - 'Invalid Character' Problem

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 » 'Invalid Character' Problem

'Invalid Character' Problem

« View previous topic :: View next topic »

Author

Message

gecs

Posted: Fri Sep 04, 2009 9:26 am Post subject: 'Invalid Character' Problem

Acolyte

Joined: 14 Nov 2007
Posts: 58

Hi everybody, I have an interesting problem to test my flow.
The first time it works correctly, but after the second time appears next error:

Quote:

Exception ex = ( ['MQROOT' : 0x121810390]
(0x01000000:Name):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbDataFlowNode.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 957 (INTEGER)
(0x03000000:NameValue):Function = 'ImbDataFlowNode::createExceptionList' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'MB/CTNA/MF_MB_CONSTARJETANOAFILv1_REQ#FCMComposite_1_27' (CHARACTER)
(0x03000000:NameValue):Label = 'MB.CTNA.MF_MB_CONSTARJETANOAFILv1_REQ.GetCtasNoAfiliadas' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2230 (INTEGER)
(0x03000000:NameValue):Text = 'Node throwing exception' (CHARACTER)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 602 (INTEGER)
(0x03000000:NameValue):Function = 'SqlStatementGroup::execute' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'MB/CTNA/MF_MB_CONSTARJETANOAFILv1_REQ#FCMComposite_1_27' (CHARACTER)
(0x03000000:NameValue):Label = 'MB.CTNA.MF_MB_CONSTARJETANOAFILv1_REQ.GetCtasNoAfiliadas' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2488 (INTEGER)
(0x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'MB.CTNA.MF_MB_CONSTARJETANOAFILv1_REQ_GetCtasNoAfiliadas.Main' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '149.5' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'setMessageProperties(C_MESSAGESET_ID, C_MESSAGETYPE_VP28_REQ, C_MESSAGEFORMAT_CWF1);' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlRoutine.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 548 (INTEGER)
(0x03000000:NameValue):Function = 'SqlRoutine::invoke' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'MB/CTNA/MF_MB_CONSTARJETANOAFILv1_REQ#FCMComposite_1_27' (CHARACTER)
(0x03000000:NameValue):Label = 'MB.CTNA.MF_MB_CONSTARJETANOAFILv1_REQ.GetCtasNoAfiliadas' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2934 (INTEGER)
(0x03000000:NameValue):Text = 'Error occured in procedure' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'setMessageProperties' (CHARACTER)
)
(0x01000000:Name ):RecoverableException = (
(0x03000000:NameValue):File = '/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 602 (INTEGER)
(0x03000000:NameValue):Function = 'SqlStatementGroup::execute' (CHARACTER)
(0x03000000:NameValue):Type = 'ComIbmComputeNode' (CHARACTER)
(0x03000000:NameValue):Name = 'MB/CTNA/MF_MB_CONSTARJETANOAFILv1_REQ#FCMComposite_1_27' (CHARACTER)
(0x03000000:NameValue):Label = 'MB.CTNA.MF_MB_CONSTARJETANOAFILv1_REQ.GetCtasNoAfiliadas' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2488 (INTEGER)
(0x03000000:NameValue):Text = 'Error detected, rethrowing' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'MB.CTNA.MF_MB_CONSTARJETANOAFILv1_REQ_GetCtasNoAfiliadas.setMessageProperties' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = '5.3' (CHARACTER)
)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'SET OutputRoot.Properties.MessageSet = setName;' (CHARACTER)
)
(0x01000000:Name ):ConversionException = (
(0x03000000:NameValue):File = '/build/S610_P/src/CommonServices/ImbUtility.cpp' (CHARACTER)
(0x03000000:NameValue):Line = 436 (INTEGER)
(0x03000000:NameValue):Function = 'imbWcsToInt64' (CHARACTER)
(0x03000000:NameValue):Type = '' (CHARACTER)
(0x03000000:NameValue):Name = '' (CHARACTER)
(0x03000000:NameValue):Label = '' (CHARACTER)
(0x03000000:NameValue):Catalog = 'BIPv610' (CHARACTER)
(0x03000000:NameValue):Severity = 3 (INTEGER)
(0x03000000:NameValue):Number = 2595 (INTEGER)
(0x03000000:NameValue):Text = 'Invalid characters' (CHARACTER)
(0x01000000:Name ):Insert = (
(0x03000000:NameValue):Type = 5 (INTEGER)
(0x03000000:NameValue):Text = 'MS_MB_CTNAv1_REQRESP' (CHARACTER)
)
)
)
)
)
)

according to what I understand about it, the exception is thrown by the procedure "setMessageProperties", this one does the following:

Code:

CREATE PROCEDURE setMessageProperties(IN setName CHAR, IN typeName CHAR, IN formatName CHAR) BEGIN
   SET OutputRoot.Properties.MessageSet = setName;
   SET OutputRoot.Properties.MessageType = typeName;
   SET OutputRoot.Properties.MessageFormat = formatName;
   SET OutputRoot.Properties.Encoding = 785;
   SET OutputRoot.Properties.CodedCharSetId = C_CCSID_EBCDIC;
END;

and the parameters are:

Code:

CALL setMessageProperties(C_MESSAGESET_ID, C_MESSAGETYPE_VP28_REQ, C_MESSAGEFORMAT_CWF1);

where:

Code:

DECLARE C_MESSAGESET_ID CONSTANT CHARACTER 'MS_MB_CTNAv1_REQRESP';
DECLARE C_MESSAGETYPE_VP28_REQ CONSTANT CHARACTER 'mVP28CWFRq';
DECLARE C_MESSAGEFORMAT_CWF1 CONSTANT CHARACTER 'CWF1';

if someone has had this problem ... help me.. please

regards.

rekarm01

Posted: Sat Sep 05, 2009 2:00 pm Post subject: Re: 'Invalid Character' Problem

Grand Master

Joined: 25 Jun 2008
Posts: 1415

One or more of the following, in no particular order, might clear up the problem:

update the toolkit
restart the toolkit with "-clean" option
clean the message flow and message set projects (Project -> Clean)
delete the relevant projects from the workspace, (do not remove files), and reimport them
create a new workspace and import the relevant projects there

Remove deployed children from the execution group, rebuild and redeploy the relevant barfile(s), and test if the problem persists.

gecs

Posted: Mon Sep 07, 2009 8:26 am Post subject:

Acolyte

Joined: 14 Nov 2007
Posts: 58

Hi rekarm01, thanks for your advice

.

I did what you recommended me, but same error occurs when I tested for second time

.

regards.

rekarm01

Posted: Mon Sep 07, 2009 1:03 pm Post subject: Re: 'Invalid Character' Problem

Grand Master

Joined: 25 Jun 2008
Posts: 1415

gecs wrote:

Code:

DECLARE C_MESSAGESET_ID CONSTANT CHARACTER 'MS_MB_CTNAv1_REQRESP';

Is this the correct value for message set id? It normally looks more like an UUID, (for example, something like 'DHCJOEG072001').

Add a Trace node before the Compute node to display the contents of ${Root}. Enable a debug-level usertrace to more closely examine how the message flow populates Root.Properties before the ESQL procedure call.

gecs

Posted: Tue Sep 08, 2009 7:02 am Post subject: Re: 'Invalid Character' Problem

Acolyte

Joined: 14 Nov 2007
Posts: 58

rekarm01 wrote:

gecs wrote:

Code:

DECLARE C_MESSAGESET_ID CONSTANT CHARACTER 'MS_MB_CTNAv1_REQRESP';

Is this the correct value for message set id? It normally looks more like an UUID, (for example, something like 'DHCJOEG072001').

Hi rekarm01, I know from version 6.1 this can be Message Set Id (Hexa) or also the Message Set Name. In the other hand, I tested with both and occurs the same error.

regards.

gregop

Posted: Tue Sep 08, 2009 7:25 am Post subject:

Voyager

Joined: 24 Nov 2006
Posts: 81

I found a similar problem with 6.1.0.4. on AIX

Jul 20 15:32:24 spwebapp1 user:err|error WebSphere Broker v6104[1294396]: (WMBBRT7.Services)[3119]BIP2595E: Error casting character string 'CWF' to an integer. : WMBBRT7.32e4fe5e-2201-0000-0080-b25f3dfa7438: /build/S610_P/src/CommonServices/ImbUtility.cpp: 436: imbWcsToInt64: :

This occurred occasionally on code

Set OutputRoot.Properties.MessageFormat = 'CWF';

There is an iFix available from IBM.

Related APAR:

http://www-01.ibm.com/support/docview.wss?rs=849&context=SSKM8N&dc=DB550&uid=swg1IC61512&loc=en_US&cs=UTF-8&lang=en&rss=ct849websphere

gecs

Posted: Tue Sep 08, 2009 8:56 am Post subject:

Acolyte

Joined: 14 Nov 2007
Posts: 58

gregop wrote:

I found a similar problem with 6.1.0.4. on AIX

Related APAR:

http://www-01.ibm.com/support/docview.wss?rs=849&context=SSKM8N&dc=DB550&uid=swg1IC61512&loc=en_US&cs=UTF-8&lang=en&rss=ct849websphere

Hi "gregop", that page is over a windows component. Not AIX.

Regards.

jbanoop

Posted: Tue Sep 08, 2009 11:17 am Post subject:

Chevalier

Joined: 17 Sep 2005
Posts: 401
Location: SC

Quote:

Enable a debug-level usertrace .

Why dont you post the valid piece of the user trace.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » 'Invalid Character' Problem

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