ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database Exception

Post new topic  Reply to topic
 Database Exception « View previous topic :: View next topic » 
Author Message
sachinramesh
PostPosted: Thu Apr 24, 2008 1:37 am    Post subject: Database Exception Reply with quote

Disciple

Joined: 20 Feb 2007
Posts: 170

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 .
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Thu Apr 24, 2008 1:43 am    Post subject: Re: Database Exception Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

sachinramesh wrote:
<Text>[IBM][CLI Driver][DB2/NT] SQL0204N "DB2ADMIN.ID_VAL" is an undefined name. SQLSTATE=42704 </Text>

...


Can any one tell me what could be the reason .


It could be the reason in the exception text - I'm just guessing.

Does your DBA know your flow connects as DB2Admin? I suppose if that's the password as well security's not his top concern.....
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sachinramesh
PostPosted: Thu Apr 24, 2008 2:08 am    Post subject: Re: Database Exception Reply with quote

Disciple

Joined: 20 Feb 2007
Posts: 170

Vitor wrote:
sachinramesh wrote:
<Text>[IBM][CLI Driver][DB2/NT] SQL0204N "DB2ADMIN.ID_VAL" is an undefined name. SQLSTATE=42704 </Text>

...


Can any one tell me what could be the reason .


It could be the reason in the exception text - I'm just guessing.

Does your DBA know your flow connects as DB2Admin? I suppose if that's the password as well security's not his top concern.....



I am working on my local machine,there is no DBA .I had created the database "CUDB" and it conects using "db2admin" and "db2admin".


and one more problem is that i tried to alter my data source userid and password using mqsisetdbparms brkname -n CUDB -u ramesh -p Uni123

but now my database is connecting using both my old and also new uid/pwds

why is it so i can't delete the old uid/pwd
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Thu Apr 24, 2008 2:12 am    Post subject: Re: Database Exception Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

sachinramesh wrote:
i tried to alter my data source userid and password using mqsisetdbparms brkname -n CUDB -u ramesh -p Uni123

but now my database is connecting using both my old and also new uid/pwds

why is it so i can't delete the old uid/pwd


Have you tried to delete the old one? What happened when you tried it (error codes, etc)? Running mqsisetdbparms twice will create two sets of credentials.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sachinramesh
PostPosted: Thu Apr 24, 2008 2:31 am    Post subject: Re: Database Exception Reply with quote

Disciple

Joined: 20 Feb 2007
Posts: 170

Have you tried to delete the old one? What happened when you tried it (error codes, etc)? Running mqsisetdbparms twice will create two sets of credentials.[/quote]


Now i tried to delete the datasource
mqsisetdbparms brkname -n CUDB -d
it says successful command completion.
My doubt is my CUDB dsn is connecting using two uids and pwds now how wud i delete the old one when there is no option for the uid and pwd in the command mqsisetdbparms brkname -n CUDB -d, and is there any location that my uid and pwd will be stored.
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Thu Apr 24, 2008 3:01 am    Post subject: Re: Database Exception Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

sachinramesh wrote:
My doubt is my CUDB dsn is connecting using two uids and pwds now how wud i delete the old one when there is no option for the uid and pwd in the command mqsisetdbparms brkname -n CUDB -d


It deletes everything associated with the datasource. Recreate it with the "right" credentials.

sachinramesh wrote:
is there any location that my uid and pwd will be stored.


You said this was on your local machine, so I assume Windows, and therefore probably stored in the registry somewhere. Everything else seems to be in there.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
sachinramesh
PostPosted: Thu Apr 24, 2008 3:17 am    Post subject: Re: Database Exception Reply with quote

Disciple

Joined: 20 Feb 2007
Posts: 170

Vitor wrote:
sachinramesh wrote:
My doubt is my CUDB dsn is connecting using two uids and pwds now how wud i delete the old one when there is no option for the uid and pwd in the command mqsisetdbparms brkname -n CUDB -d


It deletes everything associated with the datasource. Recreate it with the "right" credentials.

sachinramesh wrote:
is there any location that my uid and pwd will be stored.


You said this was on your local machine, so I assume Windows, and therefore probably stored in the registry somewhere. Everything else seems to be in there.




Thanks Vitor i could find the uid/pwd stored in the registry folder
but any help on the exception i had posted above.
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Thu Apr 24, 2008 3:24 am    Post subject: Re: Database Exception Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

sachinramesh wrote:
but any help on the exception i had posted above.


I stand by my earlier comment, that the reason in the exception text is pretty conclusive.
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
AkankshA
PostPosted: Thu Apr 24, 2008 3:35 am    Post subject: Re: Database Exception Reply with quote

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

sachinramesh wrote:

Now i tried to delete the datasource
mqsisetdbparms brkname -n CUDB -d
it says successful command completion.
.


have u tried mqsisetdbparms with the second set of credentials...

does it still throw the exception...

u mite want 2 restart the flow.. might not be necessary but does no harm either
_________________
Cheers
Back to top
View user's profile Send private message Visit poster's website
sachinramesh
PostPosted: Thu Apr 24, 2008 4:10 am    Post subject: Re: Database Exception Reply with quote

Disciple

Joined: 20 Feb 2007
Posts: 170

AkankshA wrote:
sachinramesh wrote:

Now i tried to delete the datasource
mqsisetdbparms brkname -n CUDB -d
it says successful command completion.
.


have u tried mqsisetdbparms with the second set of credentials...

does it still throw the exception...

u mite want 2 restart the flow.. might not be necessary but does no harm either



Yes it is still throwing the exception .
i had two compute nodes in the flow
when using the second set of credentials
it is throwing exception in the first compute node saying RAMESH.table is not a defined name.
Using the first set of credentials it is throwing the exception at 2nd compute node which is posted above .
Is there anything to do with the db view,as SYSIBM.SYSDUMMY1 is a view created when creating the database .
I am only using this view in the second compute node.
Back to top
View user's profile Send private message Send e-mail
Vitor
PostPosted: Thu Apr 24, 2008 4:14 am    Post subject: Re: Database Exception Reply with quote

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

sachinramesh wrote:
Is there anything to do with the db view,as SYSIBM.SYSDUMMY1 is a view created when creating the database .


Unlikely - IMHO it's more to do with the fact the items you're trying to access don't exist in the schemas you're supplying! Or more accurately not supplying.

(As the error text indicates!)
_________________
Honesty is the best policy.
Insanity is the best defence.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Database Exception
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.