| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Data Source Parameter on Compute Node |
« View previous topic :: View next topic » |
| Author |
Message
|
| pottas |
 Posted: Tue Feb 07, 2006 3:38 am Post subject: Data Source Parameter on Compute Node |
 |
|
Disciple
Joined: 27 Oct 2005
Posts: 185
Location: South Africa
|
Guys,
I am running WBI6 on Windows XP. I have a flow that has the following nodes:
MQInput --> Compute1 --> Compute2 --> MQOutput
On Node Compute2, I have the Data Source Property set to my Database link. In this node, (Compute2) I do a call to a function in another Broker Schema, passing the {Source} to it.
Because I don't do any Database calls in Compute1, I don't have any setting in this property (Data Source). But when I deploy and run my flow, it fails with an exception:
'Must give a dataSourceName attribute'
If I then add a Data Source to Compute1, it works fine...
It doesn't make sense... only Compute2 does the DB call, but it fails because the Data Source parameter is not set for Compute1??
Can anyone explain?
Thanks in advance |
|
| Back to top |
|
 |
| elvis_gn |
| Posted: Tue Feb 07, 2006 3:58 am Post subject: |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi pottas,
I dont think we will be able to as it is not supposed to happen 
What are u doing(i.e logic) in the compute1 node...maybe that can explain why the error...dont think this could be a bug...yet 
Regards. |
|
| Back to top |
|
|
| pottas |
| Posted: Tue Feb 07, 2006 5:07 am Post subject: |
|
|
Disciple
Joined: 27 Oct 2005
Posts: 185
Location: South Africa
|
Elvis,
I knew it, I knew it... I saw you're online and I knew you will reply, even took a bet with one of my team members... 
OK, in Compute1 I simply have a couple of assignments:
...
SET OutputRoot.MRM.DMasterList.DMaster[cntD].FileID = InputRoot.MRM.Msg[cntDriverList].FileID;
...
that's it, nothing else, except for the standard 'CopyMessageHeaders'.
In Compute2 I have a call to get the next sequence number from a database:
...
DECLARE Source CHARACTER 'MQB_LKUP';
SET OutputLocalEnvironment.Destination.MQ.DestinationData.queueName
= CLV_Utilities.addToMQDestinationList(Source, InputRoot.MQMD.SourceQueue,'DUMMY','DUMMY','HUB.GROUP');
...
and this is where I run into trouble... Compute1 does nothing to a database, Compute2 has the call to the database, but Compute1 complains about the Data Source setting.
Hope it helps. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Feb 07, 2006 5:49 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
I remember a similar quirk in v5. I thought it had been fixed, but maybe not.
It has to do with broker schemas. I think if you move Compute2's ESQL into a different schema than Compute1's ESQL, the problem will go away.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| pottas |
| Posted: Tue Feb 07, 2006 6:05 am Post subject: |
|
|
Disciple
Joined: 27 Oct 2005
Posts: 185
Location: South Africa
|
OK, thanks Jeff. At least there's some explanation for it... not what I wanted, but an explanation anyway. 
Will try what you suggested. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Feb 07, 2006 6:15 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
|
| Back to top |
|
|
| dilse |
| Posted: Thu Feb 09, 2006 12:41 pm Post subject: |
|
|
Master
Joined: 24 Jun 2004
Posts: 270
|
Hi,
I am working on V5. Recently I ran into the same issue, I used two compute nodes in my flow. In that one was using database anothet not but it didn't even return with 'Must give a dataSourceName attribute' error but it came up with some strage error. But when we set the database on the second compute node property, flow started working fine. It didn't even made sense at that time but now it makes some sense after I went through this link. Appreciate guys.
DilSe. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
