In our organization we are having unusually long run times when running an AP136 (takes anywhere from 5 to 20 hours, depending on what parameters are used). AP database is quite large about 92 million records. We are running LSF 9 and SQL server 2005.
Lawson Support suggested we run the CTP 58954 patch to resolve this issue. This patch took 5 days to run in our test environment, we are now evaluating if it is worth it to run it in our production environment.
Have any of you had similar performance issues with your AP136 reports? Also have any of you applied the CTP 58954 patch and if so, was there a noticable performance increase?
Hi,
I have worked with multiple Lawson clients that experienced AP136 performance problems after upgrading to the 9.0 application. The CTP you referenced did resolve the performance issue.
What do you mean when you say it took 5 days to run the CTP in your test environment? Can you provide additional details?
Brad
The patch did a dbreorg. The dbreorg ran for long periods of time on both the APDISTRIB and APINVOICE tables (both over 90 million records).