| Subject: | Application Times Out when trying to allocate payment from Customer Profile |
| Summary: | Issue We have upgraded OTG to version 12.42.0526. When the user does the below steps to allocate payment, the link web application times out. Steps to reproduce: - Log into LinkWeb
- Navigate to Customer Profile>>Payments Tab
- Expand a payment. The system will time out after few seconds.
Figure 1.1. Snapshot of the Timeout Message
|
| Audit Notes: | Edited by sanjay on 14/07/21 13:41. Edited by sanjay on 14/07/21 13:40. Edited by sanjay on 14/07/21 13:40. |
| 22 Jun 2021 | 08:11AM Comment 1 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 22-06-2021 12:10 PM Time Taken: 1.00 |
| Hi Vineet, we dpnyt have access to the environment details you provided. Can you upload OTGL database to our FTP so I can have a look |
|
| 23 Jun 2021 | 03:30PM Comment 2 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 23-06-2021 07:19 PM Time Taken: 7.00 |
| Hi Vineet, we have downloaded the HQ and Sigatoka databases and restored this into QA4 to verify the issue. Important Note:
We noticed that the HQ database had over 100 temporary tables created by a user. These tables indicate that someone is doing "table updates" on the production environment. This poses a high risk to database integrity and can result in severe malfunctions. Also, not these tables are taking a lot of space causing unnecessarily large backup sizes. Please discuss this with OTG and remove all temporary backup tables. Also, we strongly object to doing direct database updates on the production environment. |
|
| 23 Jun 2021 | 04:43PM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-06-2021 07:30 PM Time Taken: 11.00 |
| PART A - Development work for this case has been completed. 1. The change will be available in version:12.43 and 12.42 2. The following changes were made(Include Database object names, Program classes, and any other relevant information): resolved the issue by streamlining the Invoice view.
3. Affected Areas: - Customer Profile - Payments Tab
4. The issue was caused by: - Insufficient joins in PInvoices view table
5. Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT |
|
| 25 Jun 2021 | 03:59PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-06-2021 07:57 PM Time Taken: 1.00 |
| Test Server Details: - Server: LinkQA4
- DB: CLIENT-OTGL-LinkSOFT-Sigatoka, CLIENT-OTGL-LinkSOFT-HQ
|
|
| 01 Jul 2021 | 09:56AM Comment 5 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 03-07-2021 10:00 AM Time Taken: 0.75 |
| Bula Guys
I have tested this on the OTG database. The issue has been resolved. I was able to add payment lines and allocate payments as well for a few customers on this OTG HQ Database at QA4. The web is no longer timing out in version 12.42.0624 Regards
Vineet |
|
| 07 Jul 2021 | 08:47AM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 07-07-2021 12:31 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 | - Log into LinkWeb
- Navigate to Customer Profile>>Payments Tab
- Add a payment.
Payment should be added without errors
| Pass
|
Environment Details - OS version: Windows Server 2012
- Application version: 12.43.0706GA
- Setup: Demo
- Server : 10.0.0.14
- Database: CLIENT-OTGL-LinkSOFT-HQ
Next Step: - For Closure
|
|
| 14 Jul 2021 | 01:40PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 14-07-2021 05:39 PM Time Taken: 1.00 |
| Thanks, Rashna |
|
| 14 Jul 2021 | 01:40PM Comment 8 by Sanjay (Link Technologies) Case L12290 added to project 12.44 |