• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Run flow locally with SQL Query [Solved]

 5 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
redluv
Basic Member Send Private Message
Posts: 11
Basic Member
5/31/2011 2:53 PM
Hello,

When I attempt to run a flow not on server that contains a SQL Query node, I get this message:

  Flows that use  SQL Query nodes must be run on the server.
  Please use the "Run on Server" option.

I'm in PFI Designer 9.0.1.6.  Tried against two different servers.

From the documentation and other posts here it seems that I should be able to run locally but I found nothing searching for this message in the KB.  I copied my jdbc driver .jar file to C:\Program Files\Lawson Software\ProcessFlow901\lib and entered jdbc connect info on the Designer login screen.

Any help would be appreciated.

Thanks.
RandyM
Basic Member Send Private Message
Posts: 9
Basic Member
5/31/2011 3:24 PM
For this version of PFI, you should try making a simplified directory for your .jar file. like C:\jars. and include it in the cass path.
redluv
Basic Member Send Private Message
Posts: 11
Basic Member
5/31/2011 5:22 PM
Thanks for the reply.  I have done as you suggested and made sure the classpath environment variable is set correctly to no avail.

The error message I get seems to suggest that it is not possible to run the flow locally.  I would have expected a different message if the jdbc driver could not be located.  In your experience does this error message typically indicate a jdbc driver problem?
Goober
Basic Member Send Private Message
Posts: 17
Basic Member
5/31/2011 5:40 PM
I have never had luck with running locally.  Just run it remotely.  You do not have to upload it to run it remotely.
RandyM
Basic Member Send Private Message
Posts: 9
Basic Member
5/31/2011 5:47 PM
I have run some flows locally but eventually added nodes that do not work locally.  Probably the SQL Query node like you are using; so I too have been running all flows on the server now.
redluv
Basic Member Send Private Message
Posts: 11
Basic Member
5/31/2011 6:20 PM
I upgraded to the newest Eclipse based version of PFI Designer and now I have no problem running flows with SQL Query nodes locally.  Just needed to add the jdbc jar file under Window > Preferences > External Jars.