Prev
Next
Forums Integration / Customization IPA/ProcessFlow

Resource Query Taking a long time to run

 4 Replies
 0 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Steve Martin
Basic Member
Posts: 6
Basic Member
1/12/2011 9:30 PM
    I have created a new PF that is doing a resource query that is running for 'People' so that I can pull data for all users.
    The resource query is taking over 6 hours to run. I don't have any filtering criteria defined since I want data for all users, I also do not have any sort defined.
    There are only around 7300 records that are being returned in the query.
    Any ideas on how I can speed this turtle up??
    Any help will be very much appreciated!!

    We are running PFI 9.0.1.6.

    Thanks!

    David Williams
    Veteran Member
    Posts: 1127
    Veteran Member
    1/12/2011 9:53 PM
      This must be a new bug in Lawson. I have a flow with a ResourceQuery as well and mine does have select criteria. Sometimes when it runs it takes a few seconds and at other times it takes quite a while. I've been canceling my WorkUnit when it happens and then restarting it and the 2nd time it works correctly.
      David Williams
      Shane Jones
      Veteran Member
      Posts: 460
      Veteran Member
      1/14/2011 4:06 AM
        I have an audit flow that does a resource query of all users and even verifies all of the bookmark groups ... Runs for about 1300 users in around 10th minutes.
        Shane Jones
        Tools: HR, Payroll, Benefits, PFI, Smart Office, BSI, Portal and Self-Service
        Systems: Lawson, Open Hire, Kronos, Crystal Reporting, SumTotal Learning
        ** Teach others to fish...
        Steve Martin
        Basic Member
        Posts: 6
        Basic Member
        1/14/2011 8:56 PM
          I finally got this to work much quicker, about 11 mins instead of 6 hours.

          I originally was getting all of the RM information out of my 1st resource query and then getting the remaining identity information out of additional resource queries.

          I changed it so that the 1st query ONLY gets the ID data.
          Then the 2nd query uses that ID to get the other RM data, then continues as it did before using additional queries to get the other identity information.
          JudeBac
          Veteran Member
          Posts: 129
          Veteran Member
          1/19/2011 2:36 PM
            That is nice. Mine also runs for 10 minutes.