MQSeries.net :: View topic - >[IBM][CLI Driver] CLI0112E Error in assignment.

mbguy · Posted: Thu Jul 16, 2009 8:52 am Post subject:

Hi all,
i am working on Mb runtime 6.1.0.4 and toolkit 6.1.0.2 and MQ 7
i had a problem when loading some data in the morning..
it is going to errorq saying "Error in Assignment ",so i tried to reload it after sometime then it has worked fine.

but i want to know the reason why it has not loaded first time..
why was the broker behaving in a strange way .
do anyone have any idea on this

below is the Exception i am getting when loading for the first time.

<Error><ExceptionList><RecoverableException><File>/build/S610_P/src/DataFlowEngine/ImbComputeNode.cpp</File><Line>464</Line><Function>ImbComputeNode::evaluate</Function><Type>ComIbmComputeNode</Type><Name>CUP_EGIR_TO_UNIFY_MF#FCMComposite_1_3</Name><Label>CUP_EGIR_TO_UNIFY_MF.Validate</Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2230</Number><Text>Caught exception and rethrowing</Text><RecoverableException><File>/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp</File><Line>602</Line><Function>SqlStatementGroup::execute</Function><Type>ComIbmComputeNode</Type><Name>CUP_EGIR_TO_UNIFY_MF#FCMComposite_1_3</Name><Label>CUP_EGIR_TO_UNIFY_MF.Validate</Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2488</Number><Text>Error detected, rethrowing</Text><Insert><Type>5</Type><Text>.CUP_EGIR_TO_UNIFY_MF_Validate.Main</Text></Insert><Insert><Type>5</Type><Text>379.4</Text></Insert><Insert><Type>5</Type><Text>PROPAGATE TO TERMINAL 'out1' FINALIZE DEFAULT DELETE DEFAULT;</Text></Insert><RecoverableException><File>/build/S610_P/src/DataFlowEngine/ImbComputeNode.cpp</File><Line>464</Line><Function>ImbComputeNode::evaluate</Function><Type>ComIbmComputeNode</Type><Name>CUP_EGIR_TO_UNIFY_MF#FCMComposite_1_4</Name><Label>CUP_EGIR_TO_UNIFY_MF.DBInsert</Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2230</Number><Text>Caught exception and rethrowing</Text><RecoverableException><File>/build/S610_P/src/DataFlowEngine/ImbRdl/ImbRdlStatementGroup.cpp</File><Line>586</Line><Function>SqlStatementGroup::execute</Function><Type>ComIbmComputeNode</Type><Name>CUP_EGIR_TO_UNIFY_MF#FCMComposite_1_4</Name><Label>CUP_EGIR_TO_UNIFY_MF.DBInsert</Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2488</Number><Text>Error detected, rethrowing</Text><Insert><Type>5</Type><Text>.CUP_EGIR_TO_UNIFY_MF_DBInsert.Main</Text></Insert><Insert><Type>5</Type><Text>332.6</Text></Insert><Insert><Type>5</Type><Text>UPDATE Database.TBL_CU_INVOICE_HEADER_DETAILS SET TOTAL_CS = ..., INV_GROSS_AMOUNT = ..., TOTAL_TAX_AMOUNT = ..., TOTAL_DISC_AMT_1 = ..., TOTAL_DISC_AMT_2 = ..., TOTAL_DISC_AMT_3 = ..., TOTAL_DISC_AMT_4 = ..., INV_AMOUNT = ..., NO_OF_NORMAL_SKU_ROWS = ..., NO_OF_FRMS_SKU_ROWS = ... WHERE ...</Text></Insert><DatabaseException><File>/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>330</Line><Function>ImbOdbcHandle::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2321</Number><Text>Root SQL exception</Text><Insert><Type>2</Type><Text>-1</Text></Insert><DatabaseException><File>/build/S610_P/src/DataFlowEngine/ImbOdbc.cpp</File><Line>446</Line><Function>ImbOdbcHandle::checkRcInner</Function><Type></Type><Name></Name><Label></Label><Catalog>BIPv610</Catalog><Severity>3</Severity><Number>2322</Number><Text>Child SQL exception</Text><Insert><Type>5</Type><Text>22005</Text></Insert><Insert><Type>2</Type><Text>-99999</Text></Insert><Insert><Type>5</Type><Text>[IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005</Text></Insert></DatabaseException></DatabaseException></RecoverableException></RecoverableException></RecoverableException></RecoverableException></ExceptionList><ERROR1>2322</ERROR1><Path>InputExceptionList.*[1].*[LAST].*[LAST].*[LAST].*[LAST].*[LAST].*[LAST].*[LAST].*[LAST]</Path><MessageAtFailure><Properties><MessageSet>CUP_EGIR_INPUT</MessageSet><MessageType>{}:EGIR_RECORD</MessageType><MessageFormat>TDS</MessageFormat><Encoding>273</Encoding><CodedCharSetId>819</CodedCharSetId><Transactional>TRUE</Transactional><Persistence>TRUE</Persistence><CreationTime>2009-07-15 23:30:08.780</CreationTime><ExpirationTime>-1</ExpirationTime><Priority>0</Priority><ReplyIdentifier>000000000000000000000000000000000000000000000000</ReplyIdentifier><ReplyProtocol>MQ</ReplyProtocol><Topic></Topic><ContentType></ContentType><IdentitySourceType></IdentitySourceType><IdentitySourceToken></IdentitySourceToken><IdentitySourcePassword></IdentitySourcePassword><IdentitySourceIssuedBy></IdentitySourceIssuedBy><IdentityMappedType></IdentityMappedType><IdentityMappedToken></IdentityMappedToken><IdentityMappedPassword></IdentityMappedPassword><IdentityMappedIssuedBy></IdentityMappedIssuedBy></Properties><MQMD><SourceQueue>CUP.EGIR_TO_UNIFY.INPUTQ</SourceQueue><Transactional>TRUE</Transactional><Encoding>273</Encoding><CodedCharSetId>819</CodedCharSetId><Format> </Format><Version>2</Version><Report>0</Report><MsgType>8</MsgType><Expiry>-1</Expiry><Feedback>0</Feedback><Priority>0</Priority><Persistence>1</Persistence><MsgId>414d5120495353514d202020202020204a541c94202c9528</MsgId><CorrelId>000000000000000000000000000000000000000000000000</CorrelId><BackoutCount>0</BackoutCount><ReplyToQ> </ReplyToQ><ReplyToQMgr>ISSQM</ReplyToQMgr><UserIdentifier> </UserIdentifier><AccountingToken>0000000000000000000000000000000000000000000000000000000000000000</AccountingToken><ApplIdentityData> </ApplIdentityData><PutApplType>6</PutApplType><PutApplName>java </PutApplName><PutDate>2009-07-15</PutDate><PutTime>23:30:08.780</PutTime><ApplOriginData> </ApplOriginData><GroupId>000000000000000000000000000000000000000000000000</GroupId><MsgSeqNumber>1</MsgSeqNumber><Offset>0</Offset><MsgFlags>0</MsgFlags><OriginalLength>-1</OriginalLength></MQMD>