| Subject: | Timeout error message appears when loading Approval Workflow from menu "Approval Workflow -> User Workflow" |
| Summary: | 1. Problem Details
A timeout error message appears when loading Approval Workflow from the menu "Approval Workflow -> User Workflow"
2. Error Message (screenshot of the error)
3. Environment Details
- Version - 15.40.240816.GA
|
| Audit Notes: | Edited by sanjay on 04/09/24 16:13. Edited by sanjay on 02/09/24 16:54. Edited by sanjay on 02/09/24 16:45. |
| 28 Aug 2024 | 04:23PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 29-08-2024 04:20 PM Time Taken: 1.00 Notes: ETC extended from: 28/08/2024 to 29/08/2024 |
| Bula Team,
The following diagnosis has been made;- Verified the same in the copy of the Database in our internal environment however the error message doesn't appear
- Verified the same in the Training Database onsite however the error message doesn't appear
We will get our technical team to assist further.
Regards
Vineshwar Prasad |
|
| 30 Aug 2024 | 04:33PM Comment 2 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 06-09-2024 04:16 PM Time Taken: 2.00 Notes: ETC extended from: 29/08/2024 to 06/09/2024 |
| Teams meeting with Development;
Connected onsite and performed the following;- Verified Data View - "SYS - Index Fragmentation"
- Tables related to Workflows had a Fragmentation Percentage of 99%
- Ran the Process SYS008 - Rebuild Index. Rebuild and Reorganise is currently Enabled
- Verified Data View - "SYS - Index Fragmentation"
- Tables related to Workflows had a Fragmentation Percentage of 99%
- Navigate to "Workflow -> User Workflow" and select the Workflow Name. Issue remains
- Disabled Reorganise and Enabled Rebuild from Process SYS008 - Rebuild Index
- Ran the Process SYS008 - Rebuild Index
- Verified Data View - "SYS - Index Fragmentation"
- Tables related to Workflows had a Fragmentation Percentage of 99%
- Navigate to "Workflow -> User Workflow" and select the Workflow Name. Issue remains
- Disabled Rebuild and Enabled Reorganise from Process SYS008 - Rebuild Index
- Ran the Process SYS008 - Rebuild Index
- Verified Data View - "SYS - Index Fragmentation"
- Tables related to Workflows had a Fragmentation Percentage of less than 10%
- Navigate to "Workflow -> User Workflow" and select the Workflow Name. Issue remains
We will need a copy of the current Database to diagnose this internally.
Next Step - Get a current Database copy from the client |
|
| 02 Sep 2024 | 11:35AM Comment 3 by Sitla (Edge Business Solutions) Assigned To: Vineshwar Prasad (Edge Business Solutions) Followup Date: 03-09-2024 11:30 AM Notes: Edited by sanjay on 02/09/24 12:14. Edited by sitla on 02/09/24 12:14. ETC extended from: 06/09/2024 to 03/09/2024 |
| Hi Sanjay, A backup has been placed on the QA1 Machine. Drive: Staff (\LINKNAS) (Z:)>Client Backups>Reddy Group File Name: LINKSOFT_20240830183410160.bak Please kindly restore.
Sitla |
|
| 02 Sep 2024 | 04:36PM Comment 4 by Sanjay (Link Technologies) Case L13067 added to project 15.50 |
| 02 Sep 2024 | 04:54PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 04-09-2024 08:45 PM Time Taken: 8.00 Notes: ETC extended from: 02/09/2024 to 04/09/2024 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 15.50 and LinkSOFT Patch 15.40.240902P 2. The following changes were made (Include Database object names, Program classes, and any other relevant information): - Removed "Inactive Users' from Workflow selection list
- Added a utility that will cleanup all company workflow items where users have been made inactive
3. Affected Areas: - Menu "Company Administration ~> Approval Workflow"
4. The issue was caused by: - In menu "Company Administration ~> Approval Workflow", "User Workflow" tab, The "List of users Not in the selected Workflow" was including "Inactive Users"
- In the case of Reddy Group, there were over 4100 users of which > 3500 users were inactive. This combined with the large number of workflow items was causing a timeout issue.
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
PART B - Development Reference (Place descriptor for objects changed):
- This patch removes"Inactive Users" from workflow list. This is a timne consuming exercise so please allow more time when applying this patch.
- In all cases, remember to apply this patch when all users are logged off. You can do this by turning off the application pool.
|
|
| 04 Sep 2024 | 04:16PM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-09-2024 08:13 PM Time Taken: 4.00 |
| The following changes have been added: - When an "Approval Workflow" is added/edited, we add a "Background Process" that performs the following tasks:
- Removes entries relating to users that have been "Deactivated"
- Removes entries for any company that has been deleted
- Add's new entries for new Companies
|
|
| 05 Sep 2024 | 04:41PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 11-09-2024 08:40 PM Time Taken: 2.00 |
| Verified that when a new Approval is created, the background process cleans up users listed in "Not in the list" collection. |
|