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

Query of HR table does not work when run from server

 10 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
sfischer
Basic Member Send Private Message
Posts: 9
Basic Member
7/20/2009 7:08 PM
Hello,

I am building a flow using the delivered Action Approve service.  In the flow I have a query to pull the manager code from the Employee table.  When I run the query via Designer with the "Run on Server" not checked, all of the queries in the flow work.  However when I run on the server, or from PA52, I get the message:

Error connecting to http://sferww02.corpo.rec...=CSV&DELIM=~&delim=~ with user PFADMIN Query string

I thought that PFADMIN does not have security to run the query, but when I run another query that accesses the RQ tables, it works.

Any advice would be appreciated!
Thanks,
Sheila
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
7/20/2009 7:28 PM
That error usually indicates a security violation. Your PFAdmin user may have access to RQ tables but not HR tables. The easiest way to check this is to log into PF Designer as the PFAdmin user and check to see if you can run your Query there.

In PF 9 the Lawson user runs the WorkUnit tasks (Queries and AGS calls) - you must still be 8.03 if PFAdmin is running your WorkUnit.
David Williams
Deleted User
New Member Send Private Message
Posts: 0
New Member
7/20/2009 8:17 PM
It's the user defined in the bpm.properties that runs processflow in 9.0, same as it did in 8.0.3.
sfischer
Basic Member Send Private Message
Posts: 9
Basic Member
7/21/2009 4:32 PM
Thanks so much for your responses. I asked our security person to make sure PFAdmin has access to all tables, and he said that user was originally disabled and had no access, but he has given it query access to all tables. I retied the flow and get the same error message. The error message indicates PFADMIN is the user...is the username case sensitive?

Thanks,
Deleted User
New Member Send Private Message
Posts: 0
New Member
7/21/2009 4:52 PM
the id is case sensitive (UNIX) and must match the LDAP entry.
Michael Thedford
Advanced Member Send Private Message
Posts: 19
Advanced Member
7/21/2009 4:56 PM
What ever user that you have configured for processflow should/must have access to all tables for your flows to work properly. There are times when the flow may need to add/change/delete fields and/or records.
sfischer
Basic Member Send Private Message
Posts: 9
Basic Member
7/21/2009 5:30 PM
Thank you all for you responses - our security admin said that he gave PFadmin read data access for all tables, and that the user is PFADMIN in the active directory.

I tested again and can query and AP table within the same flow, but get the same response with the HR table. Do you think the problem could be related to the query?

Thanks,
Sheila
David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
7/21/2009 5:50 PM
If you can run the Query in PF Designer then I think it should work on the server. Did you try logging into PF Designer as PFADMIN and test it from there? Sometimes you see the errors better that way.
David Williams
John Henley
Send Private Message
Posts: 3351
7/21/2009 6:01 PM
If you *only* have problems with HR queries, it's probably HR09 security.
Thanks for using the LawsonGuru.com forums!
John
sfischer
Basic Member Send Private Message
Posts: 9
Basic Member
7/21/2009 6:07 PM
Hi David,

I just logged in as PFADMIN and ran the query (not on the server) and it ran fine. I logged in as PFADMIN as the ProcessFlow Web users (not the IOS user).

Thanks,
sfischer
Basic Member Send Private Message
Posts: 9
Basic Member
7/29/2009 2:40 PM
Hi,

Just to close this out - thanks, everyone for your help - I tried a few things, and I'm not sure which one solved the problem, but the queries can execute. Here is what I did: 1) set up PFADMIN on HR09 security, deleted and re-added the query, re-uploaded the query to the server.

-Sheila