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
Infor Global HR (GHR)
Mass transaction upload - TM to S3 interface
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Raju
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5205
People Online:
Visitors:
285
Members:
0
Total:
285
Online Now:
New Topics
Lawson S3 HR/Payroll/Benefits
Post Tax Benefit Plan Table
11/14/2024 9:16 PM
Hi, totally new to Laswon. I have a repor
Lawson S3 Procurement
ED501 Error: Map 850 not supported by /law/c15vda/lawson/test10/edi/bin/laws_out_91
11/12/2024 3:47 PM
Tried runnning ED501 and getting the atathced erro
Lawson Smart Office
Error
11/6/2024 9:54 PM
When I try to enroll a retiree in 72.1 health plan
Infor CloudSuite
Syteline: New Data Maintenance Wizard (Error) Need help
11/1/2024 4:39 PM
Hi, I need help with an error on syteline while us
Infor ERP (Syteline)
Syteline: New Data Maintenance Wizard (Error) Need help
11/1/2024 4:24 PM
Hi, I need help with an error on syteline while us
Dealing with Lawson / Infor
Implementing Lawson v10 with Cerner Surginet, Case Cart Picking, and Quick Adds for the OR
10/29/2024 4:20 PM
Hi Everyone, I am wondering if there is any org
Lawson S3 HR/Payroll/Benefits
Canada Tax Calculation (Federal and Provincial) Issue
10/23/2024 5:00 AM
Initially, we had problem with CPP2 calculation is
Lawson S3 HR/Payroll/Benefits
CA Section 125 401k Plan
10/22/2024 10:13 PM
Does anyone have any recommendations on how to fac
S3 Systems Administration
Running AC120 deleted records from ACMASTER table
10/22/2024 3:40 PM
We recently ran the AC120 as normal and somehow it
Lawson S3 Procurement
RQ13 Approval Info
10/17/2024 2:12 PM
When a Requisition is approved on RQ13, what table
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1369
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Human Capital Management
Infor Global HR (GHR)
Mass transaction upload - TM to S3 interface
Please
login
to post a reply.
9 Replies
1
Subscribed to this topic
45 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
bearcat32
Basic Member
Posts: 12
9/11/2014 11:24 PM
What is your approach to uploading mass transactions (ie Merit or pay rate changes) into TM and having them reflect in S3? After a few tests it seems the delivered flows take hours/days to simply interface the data to the LT holding tables. There has to be a more efficient solution.
Thanks for any advice.
Srini Rao
Veteran Member
Posts: 149
9/12/2014 1:13 AM
Hello, Last week we processed 9700 pay rate change transactions and it took 53 minutes to export to LT11.
You check couple of things...
1. Change process flow's log levels to "No Debug"
2. Check out if you have any user exists on Lt11.
Woozy
Veteran Member
Posts: 709
9/12/2014 1:11 PM
The interface is really the best and only option that won't cause headaches down the road.
Srini Rao is absolutely correct. I'm guessing you have logging turned on, which greatly decreases performance. We keep logging completely off for all of our batch flows unless there is something very specific we are troubleshooting - and then only with a very small batch.
We do turn on some logging for short duration single record flows - i.e. Action flows - so that we track what happened in each event.
Good Luck!
bearcat32
Basic Member
Posts: 12
9/12/2014 3:32 PM
Thank you both very much for your responses.
If I may ask a few additional questions in terms of your process.
*Do you use spreadsheet designer to load the actual pay rates to TM or another utility?
*Do you commit the data to TM in batches (e.g 1,000 at a time) or in a single load (e.g. all 9,700 transactions at once)?
*Do you use process immediately for these or do you run the export flows to interface all the records under one work unit?
Thanks again!
Woozy
Veteran Member
Posts: 709
9/12/2014 5:11 PM
In our case, we generally use LSD when we need to do these loads. Sometimes we do them all at once, and sometimes we break them up - but this is usually because of the data source or calculation differences rather than performance reasons. It isn't unusual for us to upload 5000+ records at once with LSD, and we frequenly do tens of thousands - though it is very slow.
Our TM to S3 interface runs on a schedule twice-a-day, and we generally don't run it manually, even for these types of processes. We just let the interface process pick up whatever is available when it runs.
Srini Rao
Veteran Member
Posts: 149
9/12/2014 5:44 PM
We uploaded 9700 records in two batches. After uploading we schedule LT101 and export flow.
bearcat32
Basic Member
Posts: 12
9/12/2014 5:52 PM
Thanks Kelly.
In terms of benchmarking could you give a ballpark figure on how long 10,000 records would take you to upload via LSD
as well as how long it would take for 10,000 records to interface to S3 from TM via the export flows? We are getting varying definitions of "slow"
so trying to ascertain what other clients are experiencing.
Hope to see you @ Inforum!
Woozy
Veteran Member
Posts: 709
9/12/2014 6:06 PM
Unfortunately, I really don't know. I'm on the development side, so I'm not the one doing the uploads or running the interface.
I know the upload speed really depends on how many fields, which business classes, etc. I think we generally see LSD uploads of 1-5 records per second, but it could be significantly slower if the server is busy or if the upload is "wide" or complicated. By "slow" I mean slow in comparison to real batch processing engines like SQL.
On the TM to S3 interface side, when we do a mass pay change it may cause the interface to run for several hours instead of a few minutes. Again, I can't really give you a good estimate. Sorry.
Woozy
Veteran Member
Posts: 709
9/12/2014 6:09 PM
By the way - unfortunately we won't be at Inforum this year. We were planning to be going live with our upgrade to LMRK/TM 10 this weekend. However, that has now been bumped out to next month. Lots to do.
Have fun anyway! Say "hi" to everyone for me.
Peter O
Veteran Member
Posts: 69
1/19/2015 6:19 PM
I see this thread is old, but thought I would add my two cents anyways regarding how we perform merits/uploads:
-We use LSD for transactions that are approx 10,000 records which will take a few hours. It depends on if we're doing an upload during peak utilization as well.
-Merits are generally done with LSD as well, but anything that is done semi-regularly we develop into an IPA flow and run it which generally gives us better time (depending on the transactions).
-Our Exports generally take only take a few minutes and we schedule them to run daily (anywhere from a few hundred ~1000 transactions)
-We had the issue with exports taking a very long time as well (hours to days), but found that the issue was that our debugging was wide open (as stated above) - once we turned that off, our exports would run in a few hours for mass exports and a few minutes for the daily transactions.
Please
login
to post a reply.