| Author |
Message
|
| Robert |
 Posted: Thu Oct 23, 2003 8:03 am Post subject: Warnings in taskbar in WBI Message Broker Toolkit |
 |
|
Apprentice
Joined: 22 Aug 2002
Posts: 46
Location: Quebec, Canada
|
Hi,
I have installed WBI MB V5.0 Fixpack1 with WMQ 5.3 CSD04 on WinXP and I am experimenting problems when attempting to build the XML_Airline sample that is
with the samples. I have problems accessing database resources within the WBI Toolbox in the ESQL statements.
The WBI Toolkit returns warnings that are displayed on the tasklist window.
The DB/2 8.1 FP2 database RESERVDB exists, the tables XMLPASSENGERTB and XMLFLIGHTTB are created and accessible through DB/2 Command.
The ODBC entry for RESERVDB is created and the connection has been tested.
The properties of the Database node in the message flow has the data source set to RESERVDB.
Same problem with de Compute Nodes. It seems that I can't access any database information from the Development Perspective in the workbench.
I tried to add the schema name (which is RPELLET in my case) after the Database keyword in the Database and Compute Nodes and it changed nothing.
I tried the same sample with MQSI 2.1 and it worked like a charm!
...
...
...
WHILE J<=TotalRequest DO
SET Environment.ListOfReservations.Info[J]=
THE(SELECT T.CLASSTYPE, T.FLIGHTNO, T.FLIGHTDATE
FROM Database.XMLPASSENGERTB AS T
WHERE T.RESERVATIONNO = InputBody.CancelReservation.ListOfReservations.ReservationNumber[J]);
...
...
...
The error reported on the tasks window are:
Unresolvable database table reference Database.XMLPASSENGERTB.
Unresolvable database table reference T.CLASSTYPE.
Unresolvable database table reference T.FLIGHTNO.
Unresolvable database table reference T.FLIGHTDATE.
...
Any information on how to resolve the warning messages on the task window will be appreciated.
Thanks.
Robert Pelletier |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Thu Oct 23, 2003 8:34 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Does the user you are running the Workbench under have all the necessary permissions to the databases and tables?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| Robert |
| Posted: Thu Oct 23, 2003 8:51 am Post subject: |
|
|
Apprentice
Joined: 22 Aug 2002
Posts: 46
Location: Quebec, Canada
|
Thanks for your answer.
Yes, the user (rpellet) is the same used for all my activities, database creation, workbench development, running Config Mgr, Broker, MQ setup, etc.
This user has local administrator rights on the XP Machine and is locally logged on. (Not on an NT Domain). |
|
| Back to top |
|
|
| JLRowe |
| Posted: Thu Oct 23, 2003 9:14 am Post subject: |
|
|
Yatiri
Joined: 25 May 2002
Posts: 664
Location: South East London
|
There are numerous problems with spurious 'Invalid message field reference' type warnings which are due to be fixed in CSD02 (I hope). If the errors are real then they are caught at deploy time, or runtime (obviously).
Eclipse lets you define database's, schema's and table's in the workspace, it may be complaining that these do not exist. Try creating the references and see if it still complains.
New-->Data-->Database/Schema/Table
Please post back as I have the same problem. |
|
| Back to top |
|
|
| Robert |
| Posted: Thu Oct 23, 2003 12:18 pm Post subject: |
|
|
Apprentice
Joined: 22 Aug 2002
Posts: 46
Location: Quebec, Canada
|
Thanks Jonathan,
Manually addind the Database, Schema and Table definitions/references fixed the warnings in the taskbar. I am now in the process of testing the message flows and will keep you posted on the outcome of my tests.
As a developer used to work with the database functions/utilities provided with WSAD 5.x, I feel a bit left behind functionally speaking with the WBI Toolkit.
Robert |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Thu Dec 04, 2003 12:57 am Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
I've got the same problem, with CSD2. I did create database, schema and table definitions in the same project, but the warning is still there. Any ideas?
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
| Robert |
| Posted: Fri Dec 05, 2003 8:37 am Post subject: |
|
|
Apprentice
Joined: 22 Aug 2002
Posts: 46
Location: Quebec, Canada
|
Hi francois,
The previous posts indicate that you have to create Database, Schema and table definitions manually in order to remove the warnings in the tasks view of the WBI Toolkit.
I found a quicker way to remove the database warnings.
1- From the Data perspective create the Database and Schema.
2- From the Broker Application Development perspective, create a Message Flow Mapping file (even if you don't intend to use any) that refers to your Database/schema.
3- In the Target Mapping section, <right> <click> and select "Add RDB Table Mapping Output"...
And presto! Your Database warnings are gone from your sample message flows without having to define each table/columns...
Hope this helps.
Robert |
|
| Back to top |
|
|
| francoisvdm |
| Posted: Fri Dec 05, 2003 1:02 pm Post subject: |
|
|
Partisan
Joined: 09 Aug 2001
Posts: 332
|
Thanks, my problem is solved!
_________________
If you do not know the answer or you get the urge to answer with "RTFM" or "Search better in this forum", please refrain from doing so, just move on to the next question. Much appreciated.
Francois van der Merwe |
|
| Back to top |
|
|
| Arushi |
| Posted: Fri Jan 19, 2007 5:56 am Post subject: |
|
|
Novice
Joined: 12 Jan 2007
Posts: 21
|
Hi,
I am also facing same problem. What do u mean by step 3 --> In the Target Mapping section, <right> <click> and select "Add RDB Table Mapping Output"... Where do you do this? How do you populate the table with values if you use this method?
Thanks,
Arushi |
|
| Back to top |
|
|
|
|
