Author |
Message
|
djeripo |
Posted: Fri Apr 30, 2004 11:43 am Post subject: Exception at Output Node |
|
|
 Master
Joined: 25 Jan 2004 Posts: 225
|
Hi,
I am transforming a tds into cwf . I kept trace nodes for failure at transformation as well as at the output node . No exception is thrown at transformation but at the output node trace an exception is thrown saying 'Message Id not in CWF File' .
This is my error log .Can somebody point out my fault .
Root
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'DK563VG0QC001'
(0x3000000)MessageType = 'ABC.OUTPUT.CBCPBK.MESSAGE.V001'
(0x3000000)MessageFormat = 'CWF'
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = FALSE
(0x3000000)CreationTime = GMTTIMESTAMP '2004-04-30 19:09:16.070'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'ABC.contact admin.DURGA.MQSIINPUT.QL'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Format = ' '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 0
(0x3000000)MsgId = X'414d51204d51323144455620202020204087c3a5206f1201'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'MQ '
(0x3000000)UserIdentifier = 'req '
(0x3000000)AccountingToken = X'16010515000000972da9007356104a8031ee565a31010000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = ' '
(0x3000000)PutDate = DATE '2004-04-30'
(0x3000000)PutTime = GMTTIME '19:09:16.070'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x100001D)MRM = (
(0x300000B)PIT_RECORD_TYPE = 'MNPS'
(0x1000013)PIT_COCODE_POLNO = (
(0x300000B)PIT_COMPANY_CODE = 'UC'
(0x300000B)PIT_POLICY_NUMBER = '8014985'
)
(0x1000013)PIT_RECORD_GROUP001 = (
(0x1000013)PIT_POLICY_RECORD = (
(0x1000013)PIT_INSURED_ANNUITANT = (
(0x1000013)PIT_IA_DOB = (
(0x300000B)PIT_IA_BIRTH_CC = ' '
(0x300000B)PIT_IA_BIRTH_YY = ' '
(0x300000B)PIT_IA_BIRTH_MM = ' '
(0x300000B)PIT_IA_BIRTH_DD = ' '
)
(0x300000B)PIT_IA_AGE = '033'
(0x300000B)PIT_IA_SEX = 'F'
(0x300000B)PIT_IA_RESIDENT_STATE = 'MO'
)
(0x1000013)PIT_ISSUE_DATE = (
(0x300000B)PIT_ISSUE_CC = '19'
(0x300000B)PIT_ISSUE_YY = '98'
(0x300000B)PIT_ISSUE_MM = '04'
(0x300000B)PIT_ISSUE_DD = '30'
)
(0x300000B)PIT_POLICY_STATUS = '0'
(0x300000B)PIT_PLAN_CODE = 'K A97 00 '
(0x300000B)PIT_VAL_FORM_CODE = ' '
(0x300000B)PIT_DEATH_BEN_OPT = '1'
(0x1000013)PIT_PERMANENT_FIELDS = (
(0x300000B)PIT_INIT_FACE_AMT = 0
(0x1000013)PIT_CONVERSION_DATA = (
(0x1000013)PIT_CONVERSION_DATE = (
(0x300000B)PIT_CONV_CC = 0
(0x300000B)PIT_CONV_YY = 0
(0x300000B)PIT_CONV_MM = 0
(0x300000B)PIT_CONV_DD = 0
)
(0x300000B)PIT_CONVERTED_POLNO = ''
(0x300000B)PIT_CONVERSION_CODE = ''
)
)
(0x1000013)PIT_CLAIM_SYSTEM_FIELDS = (
(0x300000B)PIT_TERMINATION_CODE = ''
(0x1000013)PIT_STATUS_CHANGE_DATE = (
(0x300000B)PIT_STSCHG_CC = 0
(0x300000B)PIT_STSCHG_YY = 0
(0x300000B)PIT_STSCHG_MM = 0
(0x300000B)PIT_STSCHG_DD = 0
)
)
)
)
)
)
ExceptionList
(
(0x1000000)RecoverableException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbDataFlowNode.cpp'
(0x3000000)Line = 536
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmMQOutputNode'
(0x3000000)Name = '44ced627-fc00-0000-0080-edf4a4526066'
(0x3000000)Label = 'ABC.contact admin.V001.ABC.contact admin.OUTPUT'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)ParserException = (
(0x3000000)File = '/build/S210_P/src/MTI/MTIforBroker/MtiImbParser2/MtiImbParser.cpp'
(0x3000000)Line = 1112
(0x3000000)Function = 'MtiImbParser::refreshBitStreamFromElements - 9 par'
(0x3000000)Type = 'ComIbmMQInputNode'
(0x3000000)Name = '15c1b812-fc00-0000-0080-edf4a4526066'
(0x3000000)Label = 'ABC.contact admin.V001.EYZ.contact admin.INPUT'
(0x3000000)Text = 'ImbRecoverableException caught from worker when attempting to write out the bitstream.'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 5286
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'ABC.contact admin.CBCPBK.OUTPUT.V001'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '1'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'CWF'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'ABC.OUTPUT.CBCPBK.MESSAGE.V001'
)
(0x1000000)ParserException = (
(0x3000000)File = '/build/S210_P/src/cpi/pwf/cwf/cwfworker.cpp'
(0x3000000)Line = 290
(0x3000000)Function = 'CWFWorker::write'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'CWF General Error'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 5167
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '0'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'CWFWorker::write'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'UNDEFINED'
)
(0x1000000)ParserException = (
(0x3000000)File = '/build/S210_P/src/cpi/pwf/cwf/cwfworker.cpp'
(0x3000000)Line = 278
(0x3000000)Function = 'CWFWorker::write'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Message Id not in CWF File'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 5180
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '0'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'CWFWorker::write'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'DK563VG0QC001'
)
)
)
)
)
) |
|
Back to top |
|
 |
Missam |
Posted: Fri Apr 30, 2004 11:49 am Post subject: |
|
|
Chevalier
Joined: 16 Oct 2003 Posts: 424
|
CWFWorker:: Writer Exception
May be the Output Tree doesn't match the Message you defined
User Trace Debug the flow and find out where exactly it's failing. |
|
Back to top |
|
 |
jefflowrey |
Posted: Sat May 01, 2004 4:51 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002 Posts: 19981
|
"Message ID Not in CWF" to me means that either your messaage set does not have an ID of 'DK563VG0QC001', or the message set named 'DK563VG0QC001' does not have a message named 'ABC.OUTPUT.CBCPBK.MESSAGE.V001' _________________ I am *not* the model of the modern major general. |
|
Back to top |
|
 |
djeripo |
Posted: Sat May 01, 2004 5:35 pm Post subject: |
|
|
 Master
Joined: 25 Jan 2004 Posts: 225
|
Thanks for your responses Sam & Jeff .You were right My Message type was not matching . I overcame that problem . Now Im facing a different problem . As I said I was transforming a TDS to CWF Cobol Copy book,
I have three decimal values coming in the input data of lengths 11(VariableDecimalPoint 2),5(VariableDecimalPoint 2),5(VariableDecimalPoint 4) and I have equivalent Elements in my Output MessageSet with same length and VariableDecimalPoints.
For some reason I could not declare the elements at TDS as Decimal with respective VariableDecimaPoints .Its throwing up an error ,
"BIP1950E: Invalid value (-1) for property (Precision) on tab (TDS) in message repository resource (Element, abcde).
An error has been detected when creating or updating a message repository resource (Element, abcde). The value (-1), for property (Precision) on tab (TDS) is not valid.
Change the value and retry the operation. "
(This is not my real problem)
So, In the Input Messageset I declared those three elements as strings and was casting them to decimal something like this,
SET "OutputRoot"."MRM"."PIT_RECORD_GROUP001"."PIT_POLICY_RECORD"."PIT_FACE_AMOUNT" =
CAST("InputBody"."EYZ.RECORD_MAIN_ELEMENT.V001"[J]."EYZ.POLICY_ELEMENT.V001"."PLCY_FACE_AMOUNT" AS DECIMAL(11,2));
The real problem starts here , If the input data is zeros for all those 3 input values It is working great . But, when the data is something other than zeros , in the transformation failure trace node it is failing with the following exception ,
Root
(
(0x1000000)Properties = (
(0x3000000)MessageSet = 'DR563VG0Q6001'
(0x3000000)MessageType = 'EYZ.INPUT.MESSAGE.V001'
(0x3000000)MessageFormat = 'TDS'
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Transactional = TRUE
(0x3000000)Persistence = FALSE
(0x3000000)CreationTime = GMTTIMESTAMP '2004-05-02 01:21:32.730'
(0x3000000)ExpirationTime = -1
(0x3000000)Priority = 0
(0x3000000)ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x3000000)ReplyProtocol = 'MQ'
(0x3000000)Topic = NULL
)
(0x1000000)MQMD = (
(0x3000000)SourceQueue = 'EYZ.QUASAR.DURGA.MQSIINPUT.QL'
(0x3000000)Transactional = TRUE
(0x3000000)Encoding = 546
(0x3000000)CodedCharSetId = 437
(0x3000000)Format = ' '
(0x3000000)Version = 2
(0x3000000)Report = 0
(0x3000000)MsgType = 8
(0x3000000)Expiry = -1
(0x3000000)Feedback = 0
(0x3000000)Priority = 0
(0x3000000)Persistence = 0
(0x3000000)MsgId = X'414d51204d51323144455620202020204087c3a52072fc03'
(0x3000000)CorrelId = X'000000000000000000000000000000000000000000000000'
(0x3000000)BackoutCount = 0
(0x3000000)ReplyToQ = ' '
(0x3000000)ReplyToQMgr = 'MQ21DEV '
(0x3000000)UserIdentifier = 'req27939 '
(0x3000000)AccountingToken = X'16010515000000972da9007356104a8031ee565a31010000000000000000000b'
(0x3000000)ApplIdentityData = ' '
(0x3000000)PutApplType = 11
(0x3000000)PutApplName = ' '
(0x3000000)PutDate = DATE '2004-05-02'
(0x3000000)PutTime = GMTTIME '01:21:32.730'
(0x3000000)ApplOriginData = ' '
(0x3000000)GroupId = X'000000000000000000000000000000000000000000000000'
(0x3000000)MsgSeqNumber = 1
(0x3000000)Offset = 0
(0x3000000)MsgFlags = 0
(0x3000000)OriginalLength = -1
)
(0x100001B)MRM = (
(0x1000013)EYZ.RECORD_MAIN_ELEMENT.V001 = (
(0x1000013)EYZ.POLICY_ELEMENT.V001 = (
(0x300000B)COMPANY_CODE = 'UO'
(0x300000B)CONTRACT_NUMBER = '8012643'
(0x300000B)PLCY_INSURED_DOB = ' '
(0x300000B)PLCY_INSURED_AGE = 73
(0x300000B)PLCY_INSURED_SEX = 'F'
(0x300000B)PLCY_RESIDENT_STATE = 'KS'
(0x300000B)PLCY_ISSUE_DATE = '19971007'
(0x300000B)PLCY_CONTRACT_STATUS = '0'
(0x300000B)PLCY_PLAN_CODE = 'K A95 00 '
(0x300000B)PLCY_DISTRIBUTION_CODE = 'B'
(0x300000B)PLCY_FACE_AMOUNT = '12345678901'
(0x300000B)PLCY_RATE_CLASS_INDICATOR = 'N'
(0x300000B)PLCY_RATEUP_PERCENT = '00000'
(0x300000B)PLCY_RISK_CLASS = 'PN'
(0x300000B)PLCY_FLAT_EXTRA_DURATION = 0
(0x300000B)PLCY_FLAT_EXTRA_PREMIUM = '00000'
(0x300000B)PLCY_DEATH_BENEFIT_OPTION = '1'
)
)
)
)
ExceptionList
(
(0x1000000)RecoverableException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbDataFlowNode.cpp'
(0x3000000)Line = 536
(0x3000000)Function = 'ImbDataFlowNode::createExceptionList'
(0x3000000)Type = 'ComIbmComputeNode'
(0x3000000)Name = 'b97fd527-fc00-0000-0080-edf4a4526066'
(0x3000000)Label = 'EYZ.QUASAR.V001.TRANS.MSG.COBOLCPBK'
(0x3000000)Text = 'Node throwing exception'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2230
(0x1000000)RecoverableException = (
(0x3000000)File = '/build/S210_P/src/DataFlowEngine/ImbRdl/ImbRdlTypeCast.cpp'
(0x3000000)Line = 194
(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 = '159'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '2'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'CHARACTER'
)
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = 'DECIMAL'
)
(0x1000000)RecoverableException = (
(0x3000000)File = '/build/S210_P/src/CommonServices/ImbDecimal.cpp'
(0x3000000)Line = 534
(0x3000000)Function = 'convertDecimal'
(0x3000000)Type = ''
(0x3000000)Name = ''
(0x3000000)Label = ''
(0x3000000)Text = 'Can't cast decimal value to specified precision and scale'
(0x3000000)Catalog = 'WMQIv210'
(0x3000000)Severity = 3
(0x3000000)Number = 2598
(0x1000000)Insert = (
(0x3000000)Type = 5
(0x3000000)Text = '12345678901'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '11'
)
(0x1000000)Insert = (
(0x3000000)Type = 2
(0x3000000)Text = '2'
)
)
)
)
)
I even tried changing the element to float from decimal thinking decimal may not be supporting a length of 11 ,but no luck
Any help on this would be greatly appreciated ! |
|
Back to top |
|
 |
djeripo |
Posted: Sat May 01, 2004 11:07 pm Post subject: |
|
|
 Master
Joined: 25 Jan 2004 Posts: 225
|
In my previous post I was missing some information ,
My Element PIT_FACE_AMOUNT in the output message set is declared as follows
PhysicalType ExtendedDecimal
Lengthcount 11
Length Units Bytes
Signed Yes
Signed Orientation Included Trailing
Byte Alignement 1 Byte
VirtualDecimal Point 2
In my input message set that element is defined as string,
Im casting that in the following way
SET "OutputRoot"."MRM"."PIT_RECORD_GROUP001"."PIT_POLICY_RECORD"."PIT_FACE_AMOUNT" =
CAST("InputBody"."EYZ.RECORD_MAIN_ELEMENT.V001"[J]."EYZ.POLICY_ELEMENT.V001"."PLCY_FACE_AMOUNT" AS DECIMAL(11,2) CCSID 437 );
That is throwing an convert exception
Please correct where I am going wrong .
Thanks in advacnce |
|
Back to top |
|
 |
fschofer |
Posted: Sun May 02, 2004 11:22 am Post subject: |
|
|
 Knight
Joined: 02 Jul 2001 Posts: 524 Location: Mainz, Germany
|
Hi,
if you want to cast to a decimal(11,2) you need a string like '123456789.01'. The String '12345678901' is to long.
Greetings
Frank |
|
Back to top |
|
 |
djeripo |
Posted: Mon May 03, 2004 1:40 pm Post subject: |
|
|
 Master
Joined: 25 Jan 2004 Posts: 225
|
Thanks Frank .It worked . I concatenated a '.' using substring and did a cast. I was under the impression that when we
cast( AS Decimal(x,y)) MQSI is going to take care of that . |
|
Back to top |
|
 |
|