Company: Link Technologies
Case No: L12223. Project: 12.40: LinkSOFT Version 12.40 - 12.41
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 13 Apr 2021 11:20AM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 2.00 (Weight: 2.00)
Version: 12.40
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay
Resolve By: Wednesday, 14 April 2021 11:59 PM [1107 days since logged date]
Status: Closed
Subject: Unable to generate Customer Fleet Transaction Listing - Error: Thread was being aborted.
Summary:    
PART A - Issue Details
1. Details

Unable to generate Customer Fleet Transaction Listing - Error: Thread was being aborted.

We executed the below and its running for 20 mins now but no results

exec "LINKSOFT-OTGL-Training"."dbo"."LT_POS_RPT_CustomerFleetTransactionListing";1 {ts '2020-10-01 10:48:12'}, {ts '2021-04-13 10:48:12'}, '501164', '', '', '', '', '', '', '', 'admin', '1001'

go


2. Error Message (Include screenshots of error)

On the OTGL TEST HQ Server, we generated the Customer Fleet Transaction Listing with the below filters:

  1. Transaction Date From 01/10/2020
  2. Transaction Date To 06/04/20201
  3. Customer: 501164
  4. Click on View PDF

After reaching approx. 400 seconds, LinkWeb logs out and throws this error message: Thread was being aborted. 

The report when viewed in Crystal, does not display anything at all.

3. Environment Details
Server Name: LINKTESTHQ 
Database name: LINKSOFT-OTGL-Training 
Application Hosted on: 
Login User ID/Password: Admin/ 12
Client Operating System: 
Version: LinkSOFT - 12.32.0409.GA 

4. Relevant History Information

5. The issue can be reproduced by performing the following:

6. Next Step: 

-----------------------------------------------------------
Instructions - Important notes for System Issue

  1. The subject line should be clear and concise
  2. The case header should have a clear explanation of requirements with examples where possible
  3. Test plan and Pass/Fail scenarios
Audit Notes:Edited by aarti on 21/04/21 11:46. Edited by alvis on 20/04/21 13:11. Edited by alvis on 20/04/21 13:10. Edited by alvis on 13/04/21 11:20. Edited by aarti on 13/04/21 08:58. 
13 Apr 202111:20AM Comment 1 by Alvis (Link Technologies) Case L12223 added to project 11.4
13 Apr 202111:23AM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 13-04-2021 05:20 PM Time Taken: 0.50
PART A - Development work for this case has been completed.

1. The change will be available in version:12.40.0413

2. The following changes were made(Include Database object names, Program classes, and any other relevant information):

  1. Refactored the report data extraction to improve performance. Changes include removing the extra check for existence for deleted transactions. In version 12.32 we changed the order status to "VOID" when all lines are deleted.

3. Affected Areas:

  1. Customer Fleet Transaction Report

4. The issue was caused by:

  1. Performance improvement

5. Notes: 
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

----------------------

PART B - Development Reference (Place descriptor for objects changed):

1. Changes implemented was according to the approved design (Y/N):

2. Other relevant notes:

------------------------

Instructions:
Before Development is started, ensure the following is ready:
1. The case has a clear definition of the issue or change required
2. A test plan is in place
3. Change has been approved by Sanjay

Note:
a. System Test is performed by development in the "Finalised" Development environment (http://linktechnologies.com.au/dev-linksoft-{version}
b. UAT is performed using the installation provided

20 Apr 202101:10PM Comment 3 by Alvis (Link Technologies) Case L12223 added to project 12.4
20 Apr 202101:15PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 20-04-2021 07:11 PM Time Taken: 0.50
QA Results
Tests carried out according to requirements specified on the case header

Test Results Summary

Table 1 - Summarised list of issues
NoTest DescriptionPass/Fail
1Generate Customer Fleet Transaction Listing ReportPass

Environment Details

  1. OS version: Windows Server 2012
  2. Application version: 12.40.0420
  3. Setup: Demo
  4. Server : 10.0.0.10
  5. Database: DEV-LINKSOFT-124

Next Step: 

  1. For UAT

    20 Apr 202102:16PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 20-04-2021 08:13 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
    NoTest DescriptionPass/Fail
    1Generate the "Customer Fleet Transaction Listing" report for all customers. Validate that the report is generated in a timely mannerPass

    Environment Details

    1. OS version: Windows Server 2012
    2. Application version: 12.40.0149RC1
    3. Setup: Demo
    4. Server : 10.0.0.14
    5. Database: LINKSOFT-DEMO-124

    Next Step: 

    1. For Closure

      21 Apr 202111:46AM Comment 6 by Aarti Pooja Gayaneshwar (Link Business Solutions) ETC was changed from 14/04/2021 to 14/04/2021
      21 Apr 202101:10PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 21-04-2021 07:10 PM
      Thanks Rashna

      If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L12223 in the subject line of all emails regarding this issue.

      Document size: 16.0 KB
      For call complaints, please contact the Managing Director of the company using this form.