MQSeries.net :: View topic - WBIMB Rethrowing user exception

waugh · Posted: Tue Aug 31, 2004 4:45 am Post subject: known problem

Trace after i throw a user exception.

code i am using.
--------------------------------------------------
DECLARE ExceptionMsg CHAR;

SET ExceptionMsg = 'Zero Records Returned, Combination ' || MYST ||', '|| MYUS || ' Document Type Does Not Exist';

THROW USER EXCEPTION VALUES (ExceptionMsg);

--------------------------------------------------
Broker failing to PARSE TEXT ELEMENT IN INSERT SEGMENT BELOW...
there is a unicode 0X0 between THROW and EXCEPTION. if i remove three spaces in between and put in one space, it works fine. When i debug i see 'THROW ' for that element in toolkit, when it spits out i see full text.
'THROW EXCEPTION VALUES( ExceptionMsg);'
--------------------------------------------------

<Insert>
<Type>5</Type>
<Text>THROW EXCEPTION VALUES( ExceptionMsg);</Text>
</Insert>
<UserException>
<File>F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlThrowExceptionStatements.cpp</File>
<Line>164</Line>
<Function>SqlThrowExceptionStatement::execute</Function>
<Type>ComIbmComputeNode</Type>
<Name>MSGFLOW_SAPBOXML_TO_ADVXML_PTD_ASYNC#FCMComposite_1_12</Name>
<Label>MSGFLOW_SAPBOXML_TO_ADVXML_PTD_ASYNC.CPT.DB.LOOKUPS</Label>
<Text>User Generated SQL 'USER' exception</Text>
<Catalog>BIPv500</Catalog>
<Severity>1</Severity>
<Number>2951</Number>
<Insert>
<Type>5</Type>
<Text>'Zero Records Returned, Combination CRT, CAN Document Type Does Not Exist'</Text>
</Insert>
</UserException>

------------------------------------
if u look at the trace, there's 3 CHARACTERS between THROW and EXCEPTION, 2 SPACES AND A NULL.

-----------------------------------

'F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp'
)
(0x01000000):Line = (
(0x02000000): = 158
)
(0x01000000):Function = (
(0x02000000): = 'SqlStatementGroup::execute'
)
(0x01000000):Type = (
(0x02000000): = 'ComIbmComputeNode'
)
(0x01000000):Name = (
(0x02000000): = 'MSGFLOW_SAPBOXML_TO_ADVXML_PTD_ASYNC#FCMComposite_1_12'
)
(0x01000000):Label = (
(0x02000000): = 'MSGFLOW_SAPBOXML_TO_ADVXML_PTD_ASYNC.CPT.DB.LOOKUPS'
)
(0x01000000):Text = (
(0x02000000): = 'Error detected, rethrowing'
)
(0x01000000):Catalog = (
(0x02000000): = 'BIPv500'
)
(0x01000000):Severity = (
(0x02000000): = 3
)
(0x01000000):Number = (
(0x02000000): = 2488
)
(0x01000000):Insert = (
(0x01000000):Type = (
(0x02000000): = 5
)
(0x01000000):Text = (
(0x02000000): = '.MSGFLOW_SAPIDOCXML_TO_ADVXML_FINDFORMATUSINGDB.FindFormat'
)
)
(0x01000000):Insert = (
(0x01000000):Type = (
(0x02000000): = 5
)
(0x01000000):Text = (
(0x02000000): = '26.5'
)
)
(0x01000000):Insert = (
(0x01000000):Type = (
(0x02000000): = 5
)
(0x01000000):Text = (
(0x02000000): = 'THROW EXCEPTION VALUES( ExceptionMsg);'
)
)
(0x01000000):UserException = (
(0x01000000):File = (
(0x02000000): = 'F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlThrowExceptionStatements.cpp'
)
(0x01000000):Line = (
(0x02000000): = 164
)
(0x01000000):Function = (
(0x02000000): = 'SqlThrowExceptionStatement::execute'
)
(0x01000000):Type = (
(0x02000000): = 'ComIbmComputeNode'
)
(0x01000000):Name = (
(0x02000000): = 'MSGFLOW_SAPBOXML_TO_ADVXML_PTD_ASYNC#FCMComposite_1_12'
)
(0x01000000):Label = (
(0x02000000): = 'MSGFLOW_SAPBOXML_TO_ADVXML_PTD_ASYNC.CPT.DB.LOOKUPS'
)
(0x01000000):Text = (
(0x02000000): = 'User Generated SQL 'USER' exception'
)
(0x01000000):Catalog = (
(0x02000000): = 'BIPv500'
)
(0x01000000):Severity = (
(0x02000000): = 1
)
(0x01000000):Number = (
(0x02000000): = 2951
)
(0x01000000):Insert = (
(0x01000000):Type = (
(0x02000000): = 5
)
(0x01000000):Text = (
(0x02000000): = ''Zero Records Returned, Combination CRT, CAN Document Type Does Not Exist''
)
)
)

ANYBODY KNOW FROM WHERE I AM GETTING THIS NULL IN BETWEEN?