Conversion exception trace output
Use a Trace node to produce details of exceptions that occur when a conversion (CAST) exception is detected.
The following figure shows an extract of the output that might be generated by a Trace node that has the Pattern property set to a value that represents a structure that includes the exception list tree.
The exception shown occurred when a conversion (CAST) exception was detected.
ExceptionList = (
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S000_D\src\DataFlowEngine\ImbComputeNode.cpp'
(0x3000000)Line = 402
(0x3000000)Function = 'ImbComputeNode::evaluate'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = 'acd8f35d-e700-0000-0080-b78796c5e70d'
(0x3000000)Label = 'esql_13485_check_defect.Compute1'
(0x3000000)Text = 'Caught exception and rethrowing'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)RecoverableException = (
(0x3000000)File = 'F:\build\S000_D\src\DataFlowEngine\ImbRdl\ImbRdlTypeCast.cpp'
(0x3000000)Line = 163
(0x3000000)Function = 'SqlTypeCast::evaluate'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Error casting from %3 to %4'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2521
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '12'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '28'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'CHARACTER'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'INTEGER'
)
(0x1000000)ConversionException = (
(0x3000000)File = 'F:\build\S000_D\src\CommonServices\ImbUtility.cpp'
(0x3000000)Line = 195
(0x3000000)Function = 'imbWcsToInt64'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Invalid characters'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2595
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'fred'
)
)
)
)
)