| Subject: | FMIS Integration queue does not open for large volume transactions |
| Summary: | 1. Problem Details XXXXX Supermarket's database is set up on QA4 and POS-Web is hosted. The integration has been enabled, however, the FMIS Integration Queue always times out. Timeout duration has been more than 48 hours on XXXXX's machine. 3. Environment Details | Server Name: | QA4 | | Database name: | CLIENT-XXXXX-LINKSOFT | | JIWA Database name: | CLIENT-XXXXX-JIWA | | POS-WEB Address | http://localhost/POS-XXXXX/ |
4. Relevant History Information
The issue can be reproduced by performing the following: - Login to POS-Web
- Navigate to Point of Sale -> FMIS Integration Queue
- The screen times out
|
| Audit Notes: | |
| 07 May 2018 | 03:54PM Comment 1 by Alvis (Link Technologies) Case 9273 added to project 09.4 |
| 07 May 2018 | 04:07PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 07-05-2018 04:07 PM Time Taken: 1.00 |
| Development work for this case has been completed. The change will be available in version: 9.4 and 9.3.3.0.005 1. The following changes were made(Include Database object names, Program classes and any other relevant information):| - Added indexes to AR-Sales order table
2. The issue was caused by: - Missing indexes in the AR-Sales order extraction
3. Next Step - UAT
Note: An individual patch for version 9.33 is available for UAT from this link.
|
|
| 09 May 2018 | 10:56AM Comment 3 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 09-05-2018 10:56 AM Time Taken: 1.00 |
| System test completed. Verified the following: - Upgraded extra supermarket database to version 9.4.1.0 beta 2
- Opened POS FMIS integration Queue - Pass
- Opened AR sales order View - pass
regards
Alvis |
|
| 10 May 2018 | 02:57PM Comment 4 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 11-05-2018 12:00 AM Time Taken: 1.00 |
| Hi Alvis, Extra Supermarket was not upgraded. Error existed while upgrading. Error: See the attached error log.
Test Environment - Version 9400. Beta 2
- Database - CLIENT-EXTRA-CASE9273 on QA4
- Application on QA1
- OS - Windows 7
Thanks Rashna
|
|
| 14 May 2018 | 03:20PM Comment 5 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 14-05-2018 03:20 PM Time Taken: 1.00 |
| Hi Rashna, The error log it seems that the Extra supermarket database has orphan entries in the Kit items table. Data for these entries need to be corrected before upgrading. You can use the query before to identify these entries. select * FROM LBS_KIT_ITEM WHERE PART_NO not in (Select PART_NO from lbs_inventory)
regards
Alvis |
|
| 16 May 2018 | 12:50PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 17-05-2018 12:00 AM Time Taken: 1.00 |
| Hi Sanjay, This case has been successfully tested. Documentation is not required for the case. Test Environment - Version 9400 Beta 2
- LINK DB - LINKSOFT-EXTRA-CASE9273 on QA4
- JIWA DB - CLIENT-EXTRA-JIWA9273
- OS - Windows 7
Test Plan - Enable integration and review the "FMIS Integration Queue". There should not be any errors. - Pass
- Users should be able to move to pages with on the screen - Pass
Figure 1: FMIS Integration 
|
|
| 16 May 2018 | 03:45PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 16-05-2018 03:45 PM |
| Thanks Rashna |
|
| 09 Oct 2019 | 08:14AM Comment 8 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019 |