Subject: | Transactions is in the "Integration Que" with status "Order Detail lines are incomplete. Possible reason: waiting for replication" |
Summary: | 1. Problem Details (South Pacific Recordings Pte Ltd) Ranjani advised that there are few Transactions from POS that they cannot locate in MYOB. Refer to below transaction;
- WHRC0000124
- The transaction was created in HQ on 08/10/2020.
- We checked the "Transaction Report", the details of the order are in the report.
- WHRC0000125
2. Environment Details
- Version - 12.44.0713GA
- Database - CLIENT-SPR-LINKSOFT
- Serevr - QA4
- URL - https://10.0.0.13/LinkSOFT
- Login - admin/Linkfiji123
|
Audit Notes: | Edited by sanjay on 23/07/21 11:44. Edited by sanjay on 23/07/21 08:18. Edited by sanjay on 23/07/21 08:08. Edited by sanjay on 23/07/21 08:08. Edited by rashna on 22/07/21 13:23. Edited by rashna on 22/07/21 12:35. |
15 Jul 2021 | 02:51PM Comment 1 by Vineshwar (Edge Business Solutions) Assigned To: Vineshwar (Edge Business Solutions) Followup Date: 16-07-2021 04:44 PM Time Taken: 1.00 Notes: ETC extended from: 16/07/2021 to 16/07/2021 |
| Bula Team,
We did a Team Viewer meeting with Ranjani and worked on the case. The following was done; - Verified the Invoices in LinkSOFT mentioned in case header
- Invoices were created correctly in LinkSOFT
- Invoices were created at Warehouse Location (HQ Server)
- Invoices could not be located under Integration -> Sales Order View
We verified the menu Point of Sales -> Integration Queue and found the invoices with the Status as "Order Detail lines are incomplete. Possible reason: waiting for replication".
We have advised Rajani that we will get our technical team to diagnose this issues. We will advise once we get an update.
Regards Vineshwar Prasad |
|
22 Jul 2021 | 01:26PM Comment 2 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 23-07-2021 01:23 PM Time Taken: 1.00 |
| As per the development meeting with Sanjay, Alvis, Vinesh, Sitla, and Rashna - Rewrite the case with a clear issue.
- Provide the database with a log of transactions mentioned in the case header.
Thanks Rashna |
|
23 Jul 2021 | 08:07AM Comment 3 by Sanjay (Link Technologies) Case L12334 added to project 12.50 |
23 Jul 2021 | 08:15AM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-07-2021 10:08 AM Time Taken: 9.00 |
| We had a look through the code and found a possible reason this could happen. The Invoice header has a TransactionCompleteMarker that calculates a value based on all relevant tables. this marker is incorrect when a transaction is modified after the original transaction is created. For example, if a Credit sale is performed, the transaction marker has a value. This marker changes if an account payment is made. This will cause a " waiting for replication" message as the markers are different and the system suspects the transaction is INCOMPLETE PART A - Development work for this case has been completed. 1. The change will be available in version:12.50.0723
2. The following changes were made(Include Database object names, Program classes, and any other relevant information): - Do not take into account changes made after the transaction is saved. THerefore account payments are treated as a separate transaction
3. Affected Areas: - Replication of transactions that can have multiple effects, e.g. Credit Sale Payments, Layby Payments
4. The issue was caused by: - Programming error
5. Notes: 6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
23 Jul 2021 | 08:18AM Comment 5 by Sanjay (Link Technologies) ETC was changed from 16/07/2021 to 16/07/2021 |
12 Aug 2021 | 12:55PM Comment 6 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 13-08-2021 02:48 PM Time Taken: 2.00 |
|
The following tests were performed: Table 1 - Test Results
# | Test Case Details | Pass/Fail | Comments | 1 | - Create replication from with HQ and a Branch
| Pass | | 2 | - Process the following transactions in the Branch
- Deleted transaction.
- Cash Sales
- Credit Sale
- Credit Sales with Partial Payment
| Pass | | 3 | - Process the following transactions in the HQ
- Deleted transaction.
- Cash Sales
- Credit Sale
- Credit Sales with Partial Payment
| Pass | | 4 | - Validate that the transactions in 2 above are replicated and marked as completed under "Linkweb-POS-Integration" in HQ.
- Validate that the transactions in above are marked as completed under "Link web-POS-Integration" in HQ.
| Pass | | Environment Details - OS version:
- Application version: 12.50.0723GA
- Setup on:
- Server:LinkQA4
- Database: LINKSOFT-HQ and LINKSOFT-B1
- LinkSOFT URL: HTTP://10.0.0.13/LinkWEB-HQ and HTTP://10.0.0.13/LinkWEB-B1
- Login Details: Standard username and password for user "admin"
Next Step: - Vineshwar to upload the latest SPR database and create a separate case for testing on the client database.
- This case can be closed as UAT in the standard database has passed.
|
|
12 Aug 2021 | 05:01PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-08-2021 07:01 PM Time Taken: 1.00 |
| Thanks Rashna |
|