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
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
    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
      Gary Davies
      Veteran Member
      Posts: 248
      Veteran 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
        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,
          Gary Davies
          Veteran Member
          Posts: 248
          Veteran Member
          7/21/2009 4:52 PM
            the id is case sensitive (UNIX) and must match the LDAP entry.
            Michael Thedford
            Advanced Member
            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
              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
                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
                  Posts: 3353
                  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
                    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
                      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