MQSeries.net :: View topic

sachinramesh · Posted: Thu Apr 24, 2008 1:37 am Post subject: Database Exception

Hi

I had code which says
SET Environment.Variables.id_val[] = PASSTHRU('SELECT nextVAL FOR id_val FROM sysibm.sysdummy1')
SET IN_TEMP_ID=CAST(Environment.Variables.id_val[1]."1" AS INTEGER)

When i am executing the flow i am getting an exception at this point and it says

<Error>
<ExceptionList>
<RecoverableException>
<File>F:\build\S500_P\src\DataFlowEngine\ImbDataFlowNode.cpp</File>
<Line>558</Line>
<Function>ImbDataFlowNode::createExceptionList</Function>
<Type>ComIbmComputeNode</Type>
<Name>CUP_SOL_TO_UNIFY_TMM_MF#FCMComposite_1_3</Name>
<Label>CUP_SOL_TO_UNIFY_TMM_MF.Insert</Label>
<Text>Node throwing exception</Text>
<Catalog>BIPv500</Catalog>
<Severity>3</Severity>
<Number>2230</Number>
<RecoverableException>
<File>F:\build\S500_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp</File>
<Line>158</Line>
<Function>SqlStatementGroup::execute</Function>
<Type>ComIbmComputeNode</Type>
<Name>CUP_SOL_TO_UNIFY_TMM_MF#FCMComposite_1_3</Name>
<Label>CUP_SOL_TO_UNIFY_TMM_MF.Insert</Label>
<Text>Error detected, rethrowing</Text>
<Catalog>BIPv500</Catalog>
<Severity>3</Severity>
<Number>2488</Number>
<Insert>
<Type>5</Type>
<Text>.CUP_SOL_TO_UNIFY_TMM_MF_Insert.main</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>187.3</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>SET Environment.Variables.id_val[ ] = PASSTHRU('SELECT nextVAL FOR id_val FROM sysibm.sysdummy1')</Text>
</Insert>
<RecoverableException>
<File>F:\build\S500_P\src\DataFlowEngine\ImbRdl\ImbRdlExternalDb.cpp</File>
<Line>280</Line>
<Function>SqlExternalDbStmt::executeStmt</Function>
<Type>ComIbmComputeNode</Type>
<Name>CUP_SOL_TO_UNIFY_TMM_MF#FCMComposite_1_3</Name>
<Label>CUP_SOL_TO_UNIFY_TMM_MF.Insert</Label>
<Text>The following error occurred during execution of an SQL statement</Text>
<Catalog>BIPv500</Catalog>
<Severity>3</Severity>
<Number>2519</Number>
<Insert>
<Type>5</Type>
<Text>.CUP_SOL_TO_UNIFY_TMM_MF_Insert.main</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>187.40</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>CUDB</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>SELECT nextVAL FOR id_val FROM sysibm.sysdummy1</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text></Text>
</Insert>
<DatabaseException>
<File>F:\build\S500_P\src\DataFlowEngine\ImbOdbc.cpp</File>
<Line>213</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Text>Root SQL exception</Text>
<Catalog>BIPv500</Catalog>
<Severity>3</Severity>
<Number>2321</Number>
<Insert>
<Type>2</Type>
<Text>-1</Text>
</Insert>
<DatabaseException>
<File>F:\build\S500_P\src\DataFlowEngine\ImbOdbc.cpp</File>
<Line>366</Line>
<Function>ImbOdbcHandle::checkRcInner</Function>
<Type></Type>
<Name></Name>
<Label></Label>
<Text>Child SQL exception</Text>
<Catalog>BIPv500</Catalog>
<Severity>3</Severity>
<Number>2322</Number>
<Insert>
<Type>5</Type>
<Text>42S02</Text>
</Insert>
<Insert>
<Type>2</Type>
<Text>-204</Text>
</Insert>
<Insert>
<Type>5</Type>
<Text>[IBM][CLI Driver][DB2/NT] SQL0204N "DB2ADMIN.ID_VAL" is an undefined name. SQLSTATE=42704 </Text>
</Insert>
</DatabaseException>
</DatabaseException>
</RecoverableException>
</RecoverableException>
</RecoverableException>
</ExceptionList>
<ERROR1>2322</ERROR1>
<Path>InputExceptionList.*[1].*[LAST].*[LAST].*[LAST].*[LAST].*[LAST].*[LAST].*[LAST]</Path>
<MessageAtFailure>
<Properties>
<MessageSet>E40FOHK07I001</MessageSet>
<MessageType>SOL_TMM</MessageType>
<MessageFormat>TDS</MessageFormat>
<Encoding>546</Encoding>
<CodedCharSetId>437</CodedCharSetId>
<Transactional>TRUE</Transactional>
<Persistence>FALSE</Persistence>
<CreationTime>2008-04-23 06:27:10.950</CreationTime>
<ExpirationTime>-1</ExpirationTime>
<Priority>0</Priority>
<ReplyIdentifier>000000000000000000000000000000000000000000000000</ReplyIdentifier>
<ReplyProtocol>MQ</ReplyProtocol>
<Topic></Topic>
</Properties>
<MQMD>
<SourceQueue>CUP.SOL_TO_UNIFY.TMM.INPUTQ</SourceQueue>
<Transactional>TRUE</Transactional>
<Encoding>546</Encoding>
<CodedCharSetId>437</CodedCharSetId>
<Format> </Format>
<Version>2</Version>
<Report>0</Report>
<MsgType>8</MsgType>
<Expiry>-1</Expiry>
<Feedback>0</Feedback>
<Priority>0</Priority>
<Persistence>0</Persistence>
<MsgId>414d5120495353514d20202020202020365308482000a401</MsgId>
<CorrelId>000000000000000000000000000000000000000000000000</CorrelId>
<BackoutCount>0</BackoutCount>
<ReplyToQ> </ReplyToQ>
<ReplyToQMgr>ISSQM </ReplyToQMgr>
<UserIdentifier>ramesh </UserIdentifier>
<AccountingToken>160105150000008aa7323ffa4f0c2f07e53b2bf303000000000000000000000b</AccountingToken>
<ApplIdentityData> </ApplIdentityData>
<PutApplType>11</PutApplType>
<PutApplName>s\ramesh\Desktop\rfhutil.exe</PutApplName>
<PutDate>2008-04-23</PutDate>
<PutTime>06:27:10.950</PutTime>
<ApplOriginData> </ApplOriginData>
<GroupId>000000000000000000000000000000000000000000000000</GroupId>
<MsgSeqNumber>1</MsgSeqNumber>
<Offset>0</Offset>
<MsgFlags>0</MsgFlags>
<OriginalLength>-1</OriginalLength>
</MQMD>
<MRM>
<TMM_RECORD>
<SchemeType>"STPR" </SchemeType>
<ClaimType>"NF" </ClaimType>
<Company>"H" </Company>
<StartDate>21/04/08 </StartDate>
<EndDate>20/05/08 </EndDate>
<StartJCActivity>"2008/05" </StartJCActivity>
<ActivityCode>"E8A1021" </ActivityCode>
<Description>"Monday 2 Sunday- Buy Ponds Flawless White day cream 50gms & get a Ponds Oil Control Face wash 100ml Free........" </Description>
<ProductLevel>3 </ProductLevel>
<Code>"BPCF,BPDA" </Code>
<Scope_Branch>"4" </Scope_Branch>
<Branch_Budget_Amount>0.06</Branch_Budget_Amount>
<Discount>0</Discount>
<Umbrella>"U" </Umbrella>
<UmbrellaPercentage>100</UmbrellaPercentage>
<Category>"BB02,BB02" </Category>
<Channel>"KA" </Channel>
<BrandVariant>"BPCF,BPDA" </BrandVariant>
<DropActivity>"A" </DropActivity>
<DIVISION>"HLL"</DIVISION>
</TMM_RECORD>
</MRM>
</MessageAtFailure>
<TimeStamp>2008-04-23 11:58:32.903</TimeStamp>
</Error>

I am using the database CUDB which has a DSN "CUDB" and connects with "db2admin" and "db2admin"

Can any one tell me what could be the reason .