MQSeries.net :: View topic - Unresolved Database tab;e

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Unresolved Database tab;e

Goto page 1, 2 Next

Unresolved Database tab;e

« View previous topic :: View next topic »

Author

Message

wbiman

Posted: Thu Sep 30, 2004 10:55 am Post subject: Unresolved Database tab;e

Voyager

Joined: 13 Jul 2004
Posts: 84

Hi Friends,

I am trying to use compute node to query database in WBIMB V5 environment. I am getting "Unresolvable database table reference Database.STUDENT" error message in editor. I have already declared data source in compute node properties.

I am trying to execute following ESQL.....

SET OutputRoot.XML.InputMessage.Class =
( SELECT count(*) FROM Database.STUDENT AS T);

Do I need do anything else

Please help

siliconfish

Posted: Thu Sep 30, 2004 11:01 am Post subject:

Master

Joined: 12 Aug 2002
Posts: 203
Location: USA

Try using the schema name.

jefflowrey

Posted: Thu Sep 30, 2004 11:01 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

You need to "Select Count (T.*) from Database.STUDENT as T" instead of what you have.
_________________
I am *not* the model of the modern major general.

wbiman

Posted: Thu Sep 30, 2004 12:04 pm Post subject: Pls Help

Voyager

Joined: 13 Jul 2004
Posts: 84

It doesn't work

...can you suggest anything else I am missing

Thanks for your help

siliconfish

Posted: Thu Sep 30, 2004 12:10 pm Post subject:

Master

Joined: 12 Aug 2002
Posts: 203
Location: USA

Check ur Event log and post the error messages,

jefflowrey

Posted: Thu Sep 30, 2004 12:11 pm Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Is STUDENT the name of the TABLE, or the name of the Database?

What database are you using?

Are you seeing this code at compile time or runtime?
_________________
I am *not* the model of the modern major general.

wbiman

Posted: Thu Sep 30, 2004 12:34 pm Post subject: Database

Voyager

Joined: 13 Jul 2004
Posts: 84

Hi,

I am getting following error message ,....in message log
-------------------------------------------

ADM2004E The Event Monitor "DB2DETAILDEADLOCK" was not activated because there
was not enough storage space in the database monitor heap. To remedy this
problem, increase the MON_HEAP_SZ DBM configuration parameter and restart the
instanc

----------------------------------------------------

How can I solve this problem ...steps ...

STUDENT is table under WBI_TEST Database

thanks for your help
I

siliconfish

Posted: Thu Sep 30, 2004 12:38 pm Post subject:

Master

Joined: 12 Aug 2002
Posts: 203
Location: USA

Quote:

increase the MON_HEAP_SZ DBM configuration parameter and restart the
instanc

I think the solution is already mentioned here. Please contact your DBA to increase the heap size.

jefflowrey

Posted: Thu Sep 30, 2004 12:40 pm Post subject: Re: Database

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

wbiman wrote:

In the DB2 Control Center, right click on your Database Instance, and select Configure Parameters. Then increase the number listed for MON_HEAP_SZ.

But that's likely an unrelated problem.
_________________
I am *not* the model of the modern major general.

wbiman

Posted: Fri Oct 01, 2004 5:55 am Post subject:

Voyager

Joined: 13 Jul 2004
Posts: 84

you were right increasing heap size doesn't helped anything...i am still facing same problem.....

Do I need to make any connection for database .......

or any alias .....

kirani

Posted: Fri Oct 01, 2004 5:57 am Post subject:

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

I hope you have defined an ODBC connection to your DB.
_________________
Kiran

IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

wbiman

Posted: Fri Oct 01, 2004 5:59 am Post subject:

Voyager

Joined: 13 Jul 2004
Posts: 84

Hi kiran,

I checked again ....and tested ODBC connection is there .............

i don't know what i am missing .........i don't see any problem in log also

thanks

mgk

Posted: Fri Oct 01, 2004 6:21 am Post subject:

Padawan

Joined: 31 Jul 2003
Posts: 1642

If you are running on windows check that your ODBC Connection / Datasource is defined in the system DSN tab, NOT the user DSN tab. Also check your you can connect to the DB using the configure option with the correct user id and pwd.

Cheers,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

kirani

Posted: Fri Oct 01, 2004 6:41 am Post subject:

Jedi Knight

Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA

Can you post your ExceptionList here?
_________________
Kiran

IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries

Posted: Fri Oct 01, 2004 7:30 am Post subject:

Padawan

Joined: 27 Mar 2003
Posts: 1564
Location: Hartford, CT.

There's no ExceptionList as the "error" wbiman is receiving is in the toolkit editor, not during run-time execution.

Quote:

I am getting "Unresolvable database table reference Database.STUDENT" error message in editor.

It's not an error message, it's a warning.

From the WBIMB Information Center:

Quote:

This warning indicates that definitions for the database tables have not been imported into the project

Display posts from previous:

Goto page 1, 2 Next

Page 1 of 2

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Unresolved Database tab;e

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