• Search Forums
    Advanced Search
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
New Poster
New Poster
Congrats on posting!
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
0
liked by Members
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...
0
liked by Members
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
New Poster
New Poster
Congrats on posting!
1/19/2011 2:36 PM
That is nice. Mine also runs for 10 minutes.