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
Lawson S3 HR/Payroll/Benefits
PR140 Sporadic Runtimes
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
252
Members:
0
Total:
252
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
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
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 HR/Payroll/Benefits
PR140 Sporadic Runtimes
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Randall
Veteran Member
Posts: 44
4/17/2013 3:27 PM
Hi all,
In August 2012, we upgrade to Apps 9.0.1.7 and Environment 9.0.1.9. During testing, we noticed our PR140 run time went from around 45 minutes before the upgrade, to 2.5 hours. We opened a ticket with Lawson and they suggested re-indexing the PAYDEDUCTN table. We did that in testing and it seemed to work, bringing our run time down to 35 minutes.
Since then, we've noticed the same spike in time sporadically. Our PR140 will run around 35-40 minutes without re-indexing each bi-weekly Payroll, and sometimes several bi-weekly Payrolls in a row, then will have an off day and run for at least an hour and a half, sometimes getting back into the 2.5 hour range.
Last Wednesday, we re-indexed the same PAYDEDUCTN table. Our bi-weekly Payroll yesterday ran again for 2.5 hours.
Has anyone else experienced this? We've had several tickets open with Lawson and their only suggestion has been to re-index the PAYDEDUCTN table. Now that re-indexing didn't work this time around, it's definitely something else.
The kicker is that we never had this issue before upgrading to 9.0.1.7 apps. I was curious if anyone else experienced this and if you've found a solution, what it was. The only other post I've seen regarding this was back on 8.1 apps, without a solution posted.
I appreciate any help that any of you might have.
Thanks,
Randall
Lee
Posts: 37
4/17/2013 4:06 PM
Review your .cfg file for the PR140 - the original settings may no longer be appropriate for your growing data structure. Review the PR140 for the tables it touches and re-set the config file to better utilize your memory and capacity on your system. Last resort - update your system to allow it to be able to handle your growth. The process takes a little tuning on a test system (preferable method) if you can.
Randall
Veteran Member
Posts: 44
4/17/2013 7:52 PM
Thanks Lee. I've passed the info along to our system guys. I probably know enough about the configuration files to be dangerous, but I'm sure they know a lot more about them. I appreciate your response.
Kelly H
Veteran Member
Posts: 167
4/23/2013 11:21 PM
Very interesting. We have some similar issues with the run time on some of our payroll close jobs. I am no longer in payroll so not as familar with what jobs, etc. But I am going to share this with the team!
Shaun
New Member
Posts: 2
7/9/2013 11:51 AM
Did anyone one figure this out? We are having similar issues with PR140 and TA170
You are not authorized to post a reply.