| Author |
Message
|
| madi |
 Posted: Wed Aug 09, 2006 8:01 am Post subject: [Solved]CCSID error |
 |
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
Hi All
I am getting this error in the logs about the CCSID in InputRoot.Properties
| Quote: |
Aug 9 10:05:06 wmqux101 WebSphere Broker v6001[24710]: [ID 702911 user.error] (WMQPQM01_BK.WMQPQM01_EG02)[30]BIP2488E: (.Service_batchXML_Populate_Inoc.Mai
n, 103.4) Error detected whilst executing the SQL statement 'SET OutputRoot.XMLNS.serviceTransaction.batch.batchXML.(XML.CDataSection)*:* = '<?xml version="1
.0" encoding="UTF-8"?><!DOCTYPE Transaction SYSTEM "' || DTDname || '.dtd">' || CAST(ASBITSTREAM(InputRoot.XML.(XML.Element)Transaction OPTIONS FolderBitStre
am) AS CHARACTER CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding);'. : WMQPQM01_BK.d09ed64e-0801-0000-0080-cd54623ae8d8: /bu
ild/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp: 589: SqlStatementGroup::execute: ComIbmComputeNode: TRB_TRIGGER_FLOW#FCMComposite_1_15
Aug 9 10:05:06 wmqux101 WebSphere Broker v6001[24710]: [ID 702911 user.error] (WMQPQM01_BK.WMQPQM01_EG02)[30]BIP2906E: (.Service_batchXML_Populate_Inoc.Main
, 103.176) : The data type NULL is not a valid data type for parameter CCSID of the CAST statement. This parameter should be of data type INTEGER. The value
passed was NULL. : WMQPQM01_BK.d09ed64e-0801-0000-0080-cd54623ae8d8: /build/S600_P/src/DataFlowEngine/ImbRdl/ImbRdlTypeCast.cpp: 173: SqlTypeCast::evaluate:
ComIbmComputeNode: TRB_TRIGGER_FLOW#FCMComposite_1_15
|
The flow has been working fine until this morning when the broker was upgraded to 6.0 from 5.0
we did not have this problem when we upgraded dev,test and stage environments
this is only happening in production 
this is the peice of code that is bombing
| Code: |
SET OutputRoot.XMLNS.serviceTransaction.batch.batchXML.(XML.CDataSection) = '<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE Transaction SYSTEM "'|| DTDname || '.dtd">' || CAST(ASBITSTREAM(InputRoot.XML.(XML.Element)Transaction OPTIONS FolderBitStream) AS CHARACTER
CCSID InputRoot.Properties.CodedCharSetId ENCODING InputRoot.Properties.Encoding); |
It says CCSID is passed as NULL!!
can anyone tell me why this could happen
--madi
Last edited by madi on Thu Aug 10, 2006 6:16 am; edited 1 time in total |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Wed Aug 09, 2006 1:00 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you tried InputRoot.MQMD instead of InputRoot.Properties ?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| madi |
| Posted: Wed Aug 09, 2006 1:08 pm Post subject: |
|
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
Well this has working in Prod like forever now ............ do u think the upgrade had something to do with this??
--madi |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Aug 09, 2006 1:22 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Don't know. Depends where in the flow you do this.
If right after the input node (before any message modifications) I would expect to check the MQMD. Down the flow the Properties might be more accurate.
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| madi |
| Posted: Thu Aug 10, 2006 6:10 am Post subject: |
|
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
this is happening because of a propagate in front of this node!!
I thought when you say propagate; it deletes everything in the OutputRoot but leaves InputRoot intact
that was the case in 5.0 but when it was upgraded to 6.0 this changed and InputRoot also was getting cleared hence the other node down the lane could not find the InputRoot.Properties from the secong message propagated......
oh well ...... fixed it by doing delete none!!
thanks for your help fjb_saper
--madi |
|
| Back to top |
|
|
|
|
