Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Human Capital Management
Infor Global HR (GHR)
IPD Error
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
LindseyC
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5183
People Online:
Visitors:
222
Members:
0
Total:
222
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Infor Global HR (GHR)
IPD Error
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Sameera
Advanced Member
Posts: 30
1/16/2014 11:04 AM
Getting the following error when trying to connect to the 'SQL Query' node in IPD, Any idea to sort this issue ?
SQL Ver - SQL 2008 R2
Activity started: Start (Run Id: 1)
Executing Start Activity...
Variables in Process:
Activity completed: Start
Activity started: SQLQuery1540 (Run Id: 1)
SQL Query SQLQuery1540: Query string SELECT * FROM LTM2.EMPLOYEE
SQL SQLQuery1540: Using JDBC connection String Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver, URL: jdbc:sqlserver://BI3-LTMTEST:1433;databaseName=LTM, User: LTMuser
SQL Query SQLQuery1540: Query string SELECT * FROM LTM2.EMPLOYEE
SQLQuery1540_RETURN_MSG = SQL SQLQuery1540: JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver not found in classpath. Please add jdbc driver to Lawson Process Server classpath.
SQLQuery1540_RETURN_CODE = -1
Variables in Process:
lastReturnMessage = SQL SQLQuery1540: JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver not found in classpath. Please add jdbc driver to Lawson Process Server classpath.
lastErrorCode = 1
lastOutputData = java.lang.Exception: SQL SQLQuery1540: JDBC Driver com.microsoft.jdbc.sqlserver.SQLServerDriver not found in classpath. Please add jdbc driver to Lawson Process Server classpath.
at com.lawson.bpm.processflow.workFlow.flowGraph.FgSQL.executeQuery(FgSQL.java:455)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgaSQLQuery.startActivity(FgaSQLQuery.java:115)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgActivity.execute(FgActivity.java:742)
at com.lawson.bpm.processflow.workFlow.flowGraph.FgProcess.run(FgProcess.java:2178)
at com.lawson.bpm.designer.runtime.LocalFlowRunner.run(Unknown Source)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
lastInformationCode = -1
Thanks
Sameera
Srini Rao
Veteran Member
Posts: 148
1/16/2014 1:00 PM
Why you are using the SQL Query node? I prefer to use Landmark Transaction node.
Woozy
Veteran Member
Posts: 709
1/16/2014 2:48 PM
Sameera - Based on the error, it appears that IPA can't find the driver in the classpath. If you are running the flow locally in IPA designer, you need to point to the driver on your local machine via Designer preferences under "External Jars". If you are running it on the server, you need to make sure the drivers are included in the server classpath - unfortunately, I can't guide you on the server side stuff.
Srini Rao - I use SQL extensively in my flows, particularly flows that are "batch" rather than "action" related. SQL provides much greater performance and flexibility when using multiple tables with complex join relationships, and it is possible to perform logic within the query itself rather than querying the data and then manipulating with javascript. The filter functionality within Landmark nodes is painful and can be deadly slow in some cases. I use Landmark nodes if I am querying a single business class, performing an update, or querying for derived fields that are difficult to duplicate using SQL. It's just a matter of determining which node works best for the situation.
Sameera
Advanced Member
Posts: 30
1/17/2014 6:09 AM
Hi Srini
Thanks for the reply. I also prefer to use SQL node because of the flexibility compared to Transaction node
Thanks
Sameera
Sameera
Advanced Member
Posts: 30
1/17/2014 6:20 AM
Hi Kelly
Thanks a lot for the info. I also agree with you regarding the SQL node. It's very easy to work with it.
I tried following discussion & it works for me.
https://www.lawsonguru.co...low/ipa-sqlqry-node/
(refer document shared by Dave Lis)
Thanks
Sameera
You are not authorized to post a reply.