MQSeries.net :: View topic

balaji83it · Posted: Thu Apr 16, 2009 3:30 am Post subject:

Hello All,

Iam using a mapping node to map an XML message to DB table. Iam getting the following exception.

ExceptionList
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbDataFlowNode.cpp
Line:INTEGER:957
Function:CHARACTER:ImbDataFlowNode::createExceptionList
Type:CHARACTER:ComIbmMQInputNode
Name:CHARACTER:Classifier_Flow#FCMComposite_1_1
Label:CHARACTER:Classifier_Flow.MQInput
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Node throwing exception
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbComputeNode.cpp
Line:INTEGER:464
Function:CHARACTER:ImbComputeNode::evaluate
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:Classifier_Flow#FCMComposite_1_9.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:Classifier_Flow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2230
Text:CHARACTER:Caught exception and rethrowing
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp
Line:INTEGER:602
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:Classifier_Flow#FCMComposite_1_9.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:Classifier_Flow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:.IBM_WBIMB_Classifier_Flow_Mapping.MAIN
Insert
Type:INTEGER:5
Text:CHARACTER:3.1
Insert
Type:INTEGER:5
Text:CHARACTER:Classifier_Flow_Mapping(InputRoot, InputLocalEnvironment);
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlRoutine.cpp
Line:INTEGER:548
Function:CHARACTER:SqlRoutine::invoke
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:Classifier_Flow#FCMComposite_1_9.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:Classifier_Flow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2934
Text:CHARACTER:Error occured in procedure
Insert
Type:INTEGER:5
Text:CHARACTER:Classifier_Flow_Mapping
RecoverableException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp
Line:INTEGER:586
Function:CHARACTER:SqlStatementGroup::execute
Type:CHARACTER:ComIbmComputeNode
Name:CHARACTER:Classifier_Flow#FCMComposite_1_9.ComIbmMapping#FCMComposite_1_1
Label:CHARACTER:Classifier_Flow.Mapping.ComIbmCompute
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2488
Text:CHARACTER:Error detected, rethrowing
Insert
Type:INTEGER:5
Text:CHARACTER:.Classifier_Flow_Mapping
Insert
Type:INTEGER:5
Text:CHARACTER:72.2
Insert
Type:INTEGER:5
Text:CHARACTER:INSERT INTO Database.ISCSA.ISCSA_USER.FTX_STATE_DEST ( FTX_STATE_DEST_ID, PROC_STATUS, TRANS_TYPE, TRANS_REC_TYPE, PYMT_TRANS_REF, BANK_ID, BANK_NAME, BANK_ACCT, BANK_ACCT_TYPE, ACCT_PYMT_REF, SWIFT_CDE, INTL_BANK_ACCT_NUM, ROUTE_NUM, DEST_CTRY_ID, DEST_AMT, DEST_AMT_DECIMAL, DEST_ISO_CRNCY_CDE, EFF_DT_TM, CREATEDDT ) VALUES ('100', '1', #sr2.(XMLNSC.Field)TransactionType, #sr2.(XMLNSC.Field)TransactionRecordType, #sr2.(XMLNSC.Field)PaymentTransactionReference, #sr2.DestinationAccount.Account.(XMLNSC.Field)BankID, #sr2.DestinationAccount.Account.(XMLNSC.Field)BankName, #sr2.DestinationAccount.Account.(XMLNSC.Field)BankAccount, #sr2.DestinationAccount.Account.(XMLNSC.Field)BankAccountType, #sr2.DestinationAccount.Account.(XMLNSC.Field)AccountPaymentReference, #sr2.DestinationAccount.Account.(XMLNSC.Field)SWIFTBIC, #sr2.DestinationAccount.Account.(XMLNSC.Field)IBAN, #sr2.DestinationAccount.Account.(XMLNSC.Field)RoutingNumber, #sr2.DestinationAccount.Account.(XMLNSC.Field)CountryCode, #sr2.(XMLNSC.Field)Amount, #sr2.(XMLNSC.Field)AmountDecimal, #sr2.(XMLNSC.Field)CurrencyCode, #sr2.(XMLNSC.Field)EffectiveDateTime, CURRENT_TIMESTAMP )
DatabaseException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbOdbc.cpp
Line:INTEGER:323
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2321
Text:CHARACTER:Root SQL exception
Insert
Type:INTEGER:2
Text:CHARACTER:-1
DatabaseException
File:CHARACTER:F:\build\S610_P\src\DataFlowEngine\ImbOdbc.cpp
Line:INTEGER:438
Function:CHARACTER:ImbOdbcHandle::checkRcInner
Type:CHARACTER:
Name:CHARACTER:
Label:CHARACTER:
Catalog:CHARACTER:BIPv610
Severity:INTEGER:3
Number:INTEGER:2322
Text:CHARACTER:Child SQL exception
Insert
Type:INTEGER:5
Text:CHARACTER:HY096
Insert
Type:INTEGER:2
Text:CHARACTER:0
Insert
Type:INTEGER:5
Text:CHARACTER:[Microsoft][ODBC Driver Manager] Information type out of range

When I look at the following statement from the exception trace,

INSERT INTO Database.ISCSA.ISCSA_USER.FTX_STATE_DEST ( TRANS_TYPE ) VALUES (CAST(#sr1.(XMLNSC.Field)TransactionType AS CHARACTER) )

in the above statement ISCSA_USER is my schema name and ISCSA is my physical data model name. Here ISCSA should not come in the statement.

It should be "Database.ISCSA_USER.FTX_STATE_DEST"

So what should be done to remove this. Any ideas, please share.

Thanks
Balaji