| Author |
Message
|
| srailkar |
 Posted: Sat Aug 05, 2006 8:36 am Post subject: BAR file creation Problem: WBIMB Toolkit & BRK 6.0.0.2 |
 |
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
I just applied FP2 to my environment and am having the following problem:
Message flow has ESQL file.
However when I go to create the BAR for it, I get error :
Unable to find function "Main" in module G.... in default broker schema
I have run clean and build several times, check the ESQL properties and the messageflow properties along with the compute node properties, with no success.
Thanks for your help in advance.
SRailkar |
|
| Back to top |
|
 |
| Bill.Matthews |
| Posted: Sat Aug 05, 2006 4:53 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
I have also installed 6.0.0.2 - I have been successful in building a bar file with a msg flow that has esql, mapping and javacomputes..
Did you start by creating a new bar and adding the flow - or did the bar already exist with the flow thre..?
_________________
Bill Matthews |
|
| Back to top |
|
|
| srailkar |
| Posted: Sun Aug 06, 2006 4:54 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
I started with new message flow and tried to create a bar file for the same.
The flow has input node -> compute node which has esql and select on Database -Datasource-> filternode and several output nodes. |
|
| Back to top |
|
|
| srailkar |
| Posted: Sun Aug 06, 2006 5:13 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
The actual error message at createbar is:
Processing file ISI2PMSFlow.msgflow
Failed to add file ISI2PMSFlow.msgflow to archive file
The reference to ESQL module 'esql://routine/#GetPolicy.Main' with function 'Main' cannot be resolved. Ensure the ESQL module exists in the correct schema, and that it contains function 'Main', and try again.
The ESQL level for ISI2PMSFlow.msgflow is undetermined
The esql is present but when I r-click on node and select open esql - a new set of esql is generated.
SR |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Aug 06, 2006 10:19 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Clean the project. Close the project. Open the project. Wait for errors (build of workspace). If errors appear clean the project again. (Sometimes it really means clean any associated message sets).
Once everything looks ok try again.
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Sun Aug 06, 2006 10:22 am Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
| srailkar wrote: |
The actual error message at createbar is:
....
The esql is present but when I r-click on node and select open esql - a new set of esql is generated.
SR |
This is probably the basic problem - the node not being able to open the existing esql ...
You have already stated that a project clean did not help...
Unless shomething very strange happened when you applied FP2, a rstart of eclipse with a -clean would have been performed.. it will have shown up as a ling time with something like "updating toolkit" displayed...
However, something is certainly admiss within the toolkit.
Try the next three suggestions - and if that doesn't work then its time to contact IBM Service and open a PMR (problem report).
1. Open the Compute node Properties and use the Browse button next to the esql module name. My bet is that the existing entry will not show .. so try and find it and reassociate it. If that works, try the add to bar again.
2. Close and Open the message flow project
or 3. Export the project, delete it, reimport the project..
In other words - this is a bit of a mystery to me right now.
_________________
Bill Matthews |
|
| Back to top |
|
|
| srailkar |
| Posted: Mon Aug 07, 2006 10:23 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
After doing what you suggested I am still getting the same errors.
Does anyone know how to ESQL module to the correct schema?
Processing file ISI2PMSFlow.msgflow
Failed to add file ISI2PMSFlow.msgflow to archive file
The reference to ESQL module 'esql://routine/#GetPolicy.Main' with function 'Main' cannot be resolved. Ensure the ESQL module exists in the correct schema, and that it contains function 'Main', and try again.
The ESQL level for ISI2PMSFlow.msgflow is undetermined |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Mon Aug 07, 2006 11:32 am Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
I've sent you a private message with my email address - I'm willing to try your ,essage flow project out on my system.
_________________
Bill Matthews |
|
| Back to top |
|
|
| srailkar |
| Posted: Mon Aug 07, 2006 11:41 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
|
| Back to top |
|
|
| srailkar |
| Posted: Mon Aug 07, 2006 11:59 am Post subject: |
|
|
Apprentice
Joined: 01 Jun 2005
Posts: 37
|
Bill,
Let me know your email and I can sent you the zip package.
SR |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Mon Aug 07, 2006 12:44 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
I've sent you my email address... via the emal button below the postings
_________________
Bill Matthews |
|
| Back to top |
|
|
| Bill.Matthews |
| Posted: Mon Aug 07, 2006 6:21 pm Post subject: |
|
|
Master
Joined: 23 Sep 2003
Posts: 232
Location: IBM (Retired)
|
SR and I are discussing his situation - and once we can come to the final solution - we'll post back here.
_________________
Bill Matthews |
|
| Back to top |
|
|
| GRIFF |
| Posted: Thu Sep 21, 2006 5:11 am Post subject: BAR file creation Problem: WBIMB Toolkit & BRK 6.0.0.2 |
|
|
Acolyte
Joined: 19 Sep 2005
Posts: 64
Location: VA
|
I am having the same problem after applying fixpack 2. Quick question to add to the behavior:
If you right click on a compute and hit properties; the click on browse to find the ESQL module is th pop up box empty? Mine is which is very strange; which would explain why the configmgr can't find the code if the toolkit cannot see it either!?!
Any thoughts? |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Thu Sep 21, 2006 5:13 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Run clean on the project.
Make sure there are no errors in the ESQL.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| GRIFF |
| Posted: Thu Sep 21, 2006 5:16 am Post subject: |
|
|
Acolyte
Joined: 19 Sep 2005
Posts: 64
Location: VA
|
| Thanks for your response but still seeing the same behavior. It is not just the esql module for that flow I am not seeing; nothing comes up in the module list. |
|
| Back to top |
|
|
|
|
