| Author |
Message
|
| SDS |
 Posted: Sun Aug 07, 2011 9:27 pm Post subject: error not logging in database when mapping fails at RCD node |
 |
|
Apprentice
Joined: 13 Jun 2011
Posts: 47
|
In case of any transformation failure in the RCD node in a msgflow ,the error is not logged into the Database (Error_Log table). The code is failing into the following Highlighted area in ***** marks.
| Code: |
IF (EXISTS(InputLocalEnvironment.Destination.HTTP[])) THEN
CREATE LASTCHILD OF outRef NAME 'MessageId' VALUE COALESCE(InputBody.MessageId,InputLocalEnvironment.Destination.HTTP.RequestIdentifier);
CREATE LASTCHILD OF outRef NAME 'CorrelId' VALUE '';
CREATE LASTCHILD OF outRef NAME 'InputQueue' VALUE 'HTTP';
ELSE
*****CREATE LASTCHILD OF outRef NAME 'MessageId' VALUE COALESCE(InputRoot.MQRFH2.usr.MessageId,InputBody.MessageId,InputRoot.MQMD.MsgId);*****
CREATE LASTCHILD OF outRef NAME 'CorrelId' VALUE InputRoot.MQMD.CorrelId;
CREATE LASTCHILD OF outRef NAME 'InputQueue' VALUE InputRoot.MQMD.SourceQueue;
END IF; |
Please help me to resolve the issue. it's URGENT!!!  |
|
| Back to top |
|
 |
| cvag |
| Posted: Sun Aug 07, 2011 10:03 pm Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
Hi SDS,
what is the exception? |
|
| Back to top |
|
|
| SDS |
| Posted: Sun Aug 07, 2011 10:13 pm Post subject: |
|
|
Apprentice
Joined: 13 Jun 2011
Posts: 47
|
The exception list is given below:
| Code: |
RecoverableException
File:CHARACTER:F:\build\S000_P\src\DataFlowEngine\ImbDataFlowNode.cpp
Line:INTEGER:1073
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:TLOG_OR/BJS_ACE_TLOG_OR#FCMComposite_1_10.ACE/ETTP_ACE__PRE_TRANSFORM#FCMComposite_1_1
Label:CHARACTER:TLOG_OR.BJS_ACE_TLOG_OR.ACE_PreTransformProcessing.ACE Pre Transform Processing
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
RecoverableException
File:CHARACTER:F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp
Line:INTEGER:611
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:TLOG_OR/BJS_ACE_TLOG_OR#FCMComposite_1_10.ACE/ETTP_ACE__PRE_TRANSFORM#FCMComposite_1_1
Label:CHARACTER:TLOG_OR.BJS_ACE_TLOG_OR.ACE_PreTransformProcessing.ACE Pre Transform Processing
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:ACE.ETTP_ACE__POSLOG_V21_PRE_TRANSFORM_Compute.Main
Insert
Type:INTEGER:5
Text:CHARACTER:14.3
Insert
Type:INTEGER:5
Text:CHARACTER:GetAcePreTransformParameters(theInputRoot, theOutputRoot, theEnvironment);
RecoverableException
File:CHARACTER:F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlRoutine.cpp
Line:INTEGER:550
Function:CHARACTER:SqlRoutine::invoke
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:TLOG_OR/BJS_ACE_TLOG_OR#FCMComposite_1_10.ACE/ETTP_ACE__PRE_TRANSFORM#FCMComposite_1_1
Label:CHARACTER:TLOG_OR.BJS_ACE_TLOG_OR.ACE_PreTransformProcessing.ACE Pre Transform Processing
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2934
Text:CHARACTER:Error occured in procedure
Insert
Type:INTEGER:5
Text:CHARACTER:GetAcePreTransformParameters
RecoverableException
File:CHARACTER:F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp
Line:INTEGER:611
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:TLOG_OR/BJS_ACE_TLOG_OR#FCMComposite_1_10.ACE/ETTP_ACE__PRE_TRANSFORM#FCMComposite_1_1
Label:CHARACTER:TLOG_OR.BJS_ACE_TLOG_OR.ACE_PreTransformProcessing.ACE Pre Transform Processing
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:ACE.GetAcePreTransformParameters
Insert
Type:INTEGER:5
Text:CHARACTER:12.2
Insert
Type:INTEGER:5
Text:CHARACTER:SET theOutputRoot.MRM.CustomerSpecificData.TLogType = 'TLOGRAW';
RecoverableException
File:CHARACTER:F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlFieldRef.cpp
Line:INTEGER:2064
Function:CHARACTER:SqlFieldReference::navigateAbsoluteToParentOfFirst
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:TLOG_OR/BJS_ACE_TLOG_OR#FCMComposite_1_10.ACE/ETTP_ACE__PRE_TRANSFORM#FCMComposite_1_1
Label:CHARACTER:TLOG_OR.BJS_ACE_TLOG_OR.ACE_PreTransformProcessing.ACE Pre Transform Processing
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:2498
Text:CHARACTER:Navigation error
Insert
Type:INTEGER:5
Text:CHARACTER:ACE.GetAcePreTransformParameters
Insert
Type:INTEGER:5
Text:CHARACTER:12.6
Insert
Type:INTEGER:2
Text:CHARACTER:3
ParserException
File:CHARACTER:F:\build\S000_P\src\MTI\MTIforBroker\MtiImbParser2\MtiImbParser.cpp
Line:INTEGER:736
Function:CHARACTER:MtiImbParser::parseRightSibling
Type:CHARACTER:ComIbmMQInputNode
Name:CHARACTER:TLOG_OR/BJS_ACE_TLOG_OR#FCMComposite_1_15
Label:CHARACTER:TLOG_OR.BJS_ACE_TLOG_OR.ACETLOG_INPUT
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:5285
Text:CHARACTER:ImbRecoverableException caught from worker->parseNext.
Insert
Type:INTEGER:5
Text:CHARACTER:ETTP_TLOG_messages_IBM_ACE
Insert
Type:INTEGER:2
Text:CHARACTER:10638
Insert
Type:INTEGER:5
Text:CHARACTER:TLOGRAW
Insert
Type:INTEGER:5
Text:CHARACTER:/Transaction/TransactionRecord13/TenderAmount
ParserException
File:CHARACTER:F:\build\S000_P\src\cpi\pwf\nxd\nxdworker.cpp
Line:INTEGER:462
Function:CHARACTER:NXDWorker::parseNext
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:5421
Text:CHARACTER:TDS General Error
Insert
Type:INTEGER:5
Text:CHARACTER:Transaction
Insert
Type:INTEGER:5
Text:CHARACTER:/Transaction/[CHOICE](4 of unbounded)/TransactionRecord13/Negative
Insert
Type:INTEGER:2
Text:CHARACTER:94
ParserException
File:CHARACTER:F:\build\S000_P\src\cpi\pwf\nxd\nxdsimpletype.cpp
Line:INTEGER:474
Function:CHARACTER:NXDSimpleType::checkObserveELementLength
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPmsgs
Severity:INTEGER:3
Number:INTEGER:5451
Text:CHARACTER:Element data is longer than required by the model
Insert
Type:INTEGER:5
Text:CHARACTER:531^Negative
Insert
Type:INTEGER:5
Text:CHARACTER:Decimal
Insert
Type:INTEGER:2
Text:CHARACTER:1
Insert
Type:INTEGER:2
Text:CHARACTER:94
Insert
Type:INTEGER:2
Text:CHARACTER:3
|
The exception was created intentionally to receive the error at error database but it is throwing error for the line :
| Code: |
| CREATE LASTCHILD OF outRef NAME 'MessageId' VALUE COALESCE(InputRoot.MQRFH2.usr.MessageId,InputBody.MessageId,InputRoot.MQMD.MsgId) |
While checking I saw that If I delete "InputBody.MessageId" part from the above line, the code is running fine. But if I replace it with InputRoot.MRM.MessageId that is also giving error & control comes back to Throw node. Please let me know how can I resolve the issue. |
|
| Back to top |
|
|
| cvag |
| Posted: Sun Aug 07, 2011 10:28 pm Post subject: |
|
|
Centurion
Joined: 17 Mar 2008
Posts: 127
|
This is not the problem with the statement.
It clearly showing as Parser Exception
Issue is with the element value assigning.
| Code: |
Element data is longer than required by the model
/Transaction/TransactionRecord13/TenderAmount
|
Check the element and its value against the messagedefinition. |
|
| Back to top |
|
|
| SDS |
| Posted: Sun Aug 07, 2011 10:33 pm Post subject: |
|
|
Apprentice
Joined: 13 Jun 2011
Posts: 47
|
parser exception was created intentionally to check whether it is getting logged in Error Database or not.
I need to log this error in the database error table. |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Sun Aug 07, 2011 10:49 pm Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
On the input node, what is the parser Options-->Parse Timing set to?
IMHO, I think you are seeing the effect of 'On Demand' parsing.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
|
|
