MQSeries.net :: View topic - Conversion problem in database select in WMB6

Magnus_A · Posted: Tue Jul 11, 2006 5:35 am Post subject:

Hi!

I got a problem with conversion when issuing a select statement in my broker.

The broker environment looks like this:

- WMB 6.0.0.1
- WMQ 6.0.0
- DB2 8.2

Running on Win 2003 Server Enterprise Edition

Both WMQ and the DB uses CCSID 1252. A column in the DB contains the value Ã¶ (HEX d6). When the broker gets the resultset from the DB it tries to convert it and doesn't succeed. For some reason the broker tries to convert it using CCSID 1208, I do not know where this value is coming from, could it be from the user that runs the broker service?

I'm also attaching some parts of errorlogs and traces that might help in understanding my problem.

ExceptionList:
(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbComputeNode.cpp'
(0x03000000):Line = 464
(0x03000000):Function = 'ImbComputeNode::evaluate'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'Test#FCMComposite_1_3'
(0x03000000):Label = 'Test.Compute'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Caught exception and rethrowing'
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp'
(0x03000000):Line = 589
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'Test#FCMComposite_1_3'
(0x03000000):Label = 'Test.Compute'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2488
(0x03000000):Text = 'Error detected, rethrowing'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.Test_Compute.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '10.3'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'SET OutputRoot.XML.OUTPUTDATA.SFA0DUAL[ ] = DEFAULTPASSTHRU('SELECT PIN, NUMMER,VLO,INH, INHA, INHP, INHP FROM DUAL WHERE SPIN = ?', SPIN);'
)
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S600_P\src\CommonServices\ImbConverter.cpp'
(0x03000000):Line = 516
(0x03000000):Function = 'ImbConverterCPP::internalToUnicode'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2135
(0x03000000):Text = 'Unconvertable character'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'd6'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '414c564553204dd6424c455220414b544945424f4c414720202020202020202020202020'
)
(0x01000000):Insert = (
(0x03000000):Type = 2
(0x03000000):Text = '1208'
)
)
)
)
);

2006-07-11 14:31:13.227107 3608 UserTrace BIP2537I: Node 'Test.Compute': Executing statement ''SET OutputRoot.XML.OUTPUTDATA.SFA0DUAL[ ] = DEFAULTPASSTHRU('SELECT PIN, NUMMER,VLO,INH, INHA, INHP, INHP FROM DUAL WHERE SPIN = ?', SPIN);'' at ('.Test_Compute.Main', '10.3').

2006-07-11 14:31:13.227128 3608 UserTrace BIP2538I: Node 'Test.Compute': Evaluating expression ''DEFAULTPASSTHRU('SELECT PIN, NUMMER,VLO,INH, INHA, INHP, INHP FROM DUAL WHERE SPIN = ?', SPIN)'' at ('.Test_Compute.Main', '10.60').

2006-07-11 14:31:15.391616 3608 UserTrace BIP2539I: Node 'Test.Compute': Evaluating expression ''SPIN'' at ('.Test_Compute.Main', '10.235'). This resolved to ''SPIN''. The result was '''5561335984'''.

2006-07-11 14:31:15.391648 3608 UserTrace BIP2544I: Node 'Test.Compute': Executing database SQL statement ''SELECT PIN, NUMMER,VLO,INH, INHA, INHP, INHP FROM DUAL WHERE SPIN = ?'' derived from ('.Test_Compute.Main', '10.60'); expressions ''SPIN''; resulting parameter values '''5561335984'''.

2006-07-11 14:31:15.398173 3608 UserTrace BIP2562I: Node 'Test.Compute': Assigning a list to ''OutputRoot.XML.OUTPUTDATA.SFA0DUAL[]''.

2006-07-11 14:31:15.398595 3608 UserTrace BIP2231E: Error detected whilst processing a message in node 'Test.MQInput'.
The message broker detected an error whilst processing a message in node 'Test.MQInput'. The message has been augmented with an exception list and has been propagated to the node's failure terminal for further processing.
See the following messages for details of the error.

2006-07-11 14:31:15.398607 3608 RecoverableException BIP2230E: Error detected whilst processing a message in node 'Test.Compute'.
The message broker detected an error whilst processing a message in node 'Test.Compute'. An exception has been thrown to cut short the processing of the message.
See the following messages for details of the error.

2006-07-11 14:31:15.398616 3608 RecoverableException BIP2488E: ('.Test_Compute.Main', '10.3') Error detected whilst executing the SQL statement ''SET OutputRoot.XML.OUTPUTDATA.SFA0DUAL[ ] = DEFAULTPASSTHRU('SELECT PIN, NUMMER,VLO,INH, INHA, INHP, INHP FROM DUAL WHERE SPIN = ?', SPIN);''.
The message broker detected an error whilst executing the given statement. An exception has been thrown to cut short the SQL program.
See the following messages for details of the error.

2006-07-11 14:31:15.398631 3608 RecoverableException BIP2135E: Source character ''d6'' in field ''414c564553204dd6424c455220414b544945424f4c414720202020202020202020202020'' cannot be converted to unicode from codepage '1208'.
The source character is an invalid code point within the given codepage.
Correct the application that generated the message.

If there's anyone who has the slightest idea what my problem is please say so, I would really appreciate it.

... Magnus_A
_________________
To be able to cut corners with a full throttle you have to believe that you're riding a one-way road.