| Subject: | Valuation is taking a long time in large databases with large number of transactions |
| Summary: | 1. Problem Details The valuation is not completing on the OTG Database. Pending for the Month of May onwards. POS014 is running every minute and POS 012 is running every 4 hours
2. Error Message (Include screenshot of the error) 
3. Environment Details | Server Name: | 10.0.0.14\CP1 | | Database name: | CLIENT-OTGL-LinkSOFT-HQ | | Application Hosted on: | 10.0.0.14 | | Login User ID/Password: | admin\admin | | Client Operating System: | | | Browser version (if Applicable): | |
|
| Audit Notes: | Edited by sanjay on 05/07/21 10:28. Edited by sanjay on 02/07/21 16:56. |
| 02 Jul 2021 | 04:55PM Comment 1 by Sanjay (Link Technologies) Case L12303 added to project 12.43 |
| 02 Jul 2021 | 04:58PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 02-07-2021 10:56 PM Time Taken: 9.00 |
| Hi Vineet, we have found a few ways we can improve the performance of the valuation process. We will implement these changes in 12.43 before attempting to transform this to 12.42. We hope to have this completed by COB Monday 5th July. |
|
| 05 Jul 2021 | 09:48AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 05-07-2021 02:31 PM Time Taken: 26.00 |
| We have done some performance tuning on the valuation process. Below are notes based on OTGL data for HQ: - Added "Estimated time to complete" and "Remaining time" so the user can see progress details
- Index Tuning performed on Valuation data extraction
- Streamlined data extraction for valuation calculation
- Use Primary keys instead of composite keys for search
Calculation Timing: - Dataset: Inventory items: 87,000. Transactions ~> 400,000. Database Size: 99.32. Total Transactions: > ~ 300,000,000
- Server SPecs: VM 8 VCPU on 16GB RAM. This server is shared and is used by consultants for support.
- Compute 1 item's - Average Time taken: .5 second
- Compute 1000 items ~ 500 seconds
- The expected time for Valuation for all items for a month based on the above is: 15 hours
The change will be available in versions 12.43.0705 onwards |
|
| 05 Jul 2021 | 10:28AM Comment 4 by Sanjay (Link Technologies) ETC was changed from 03/07/2021 to 03/07/2021 |
| 07 Jul 2021 | 09:03AM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 07-07-2021 02:51 PM Time Taken: 1.00 |
| QA Results Tests carried out according to requirements specified on the case header Test Results Summary Table 1 - Summarised list of issues | No | Test Description | Pass/Fail | | 1 | - Added "Estimated time to complete" and "Remaining time" so the user can see progress details
Enable, valuation, and validate that the user is able to review progress. The valuation should complete within the estimated time | Pass 
|
Environment Details - OS version: Windows Server 2012
- Application version: 12.43.0706GA
- Setup: Demo
- Server : 10.0.0.14
- Database: DEMO-LINKSOFT and CLIENT-OTGL-LinkSOFT-HQ
Next Step: - For Closure
|
|
| 07 Jul 2021 | 01:18PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 07-07-2021 07:17 PM Time Taken: 1.00 |
| Thanks Rashna |
|