Company: Link Technologies
Case No: L12897. Project: 14.80: LinkSOFT Version 14.80 - June 2023
Logged By: Vineet (Link Business Solutions) on behalf of Sanjay (Link Technologies) on 17 May 2023 01:51PM
Priority: High
Product: Point of Sale
Group: Software Defect
Time Taken: 9.50 (Weight: 16.00)
Assigned To: Sanjay (Link Technologies)
Circulation: Development, Sanjay, Vineet
Resolve By: Thursday, 25 May 2023 10:22 PM [509 days since logged date]
Status: Closed
Subject: "Customer Fleet Charges" Report gives error when filtered by "Customer Category"
Summary:    
Section A. Describe what the issue is about. Include Error Message (and screenshots (600px x 800px 100kb max size)

When generating the Customer Fleet Charges report using the dates and Customer Category filter, the below error message is displayed. We have tried both PDF and Crystal Report.

Note this error is not given when the Customer Category is left as blank.

Error
Error in File 730-7-CustomerFleetCharges 12164_14312_{9E4CA64A-8A6C-40D8-BC59-44F849AD59C6}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 245 ]

Section B. Relevant History Information: Any information relevant to this issue.

This is happening in the below environment

Server: LINKQA4\CP1
Database: CLIENT-XXXX-LinkSOFT-HQ
Hosted on: Http://10.0.0.18/Linksoft
User: Admin
PW: Standard Password

Section C. The issue can be reproduced by performing the following steps:

This issue is happening on the OTGL database when generated using the below report filters

Date From: 01/02/2023
Date To: 01/02/2023
Customer Category: Mobil

Click on the Pdf option or View Crystal option and the error message will pop up. The same is recorded in the event log

    Audit Notes:Edited by sanjay on 26/05/23 09:07. Edited by sanjay on 23/05/23 13:31. Edited by sanjay on 23/05/23 13:31. Edited by sanjay on 17/05/23 13:51. 
    17 May 202301:51PM Comment 1 by Sanjay (Link Technologies) Case L12897 added to project 14.80
    17 May 202302:12PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 17-05-2023 07:51 PM Time Taken: 5.00 Notes: ETC extended from: 17/05/2023 to 17/05/2023
    PART A - Development work for this case has been completed.

    1. The change will be available in version: 14.80

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

    1. Resolved coding issue where the Customer Type was not cast to the correct data type

    3. Affected Areas:

    1. Customer Fleet Report

    4. The issue was caused by:

    1. Programming Error

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


    19 May 202308:15AM Comment 3 by Vineet (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-05-2023 02:14 PM Time Taken: 0.50
    Bula

    We have tested this on the below setup and confirm this issue has been resolved.

    Server: LINKQA4\CP1
    DB: CLIENT-OTGL-LinkSOFT-HQ
    Host: 10.0.0.18\Linksoft

    Thanks
    Vineet Ram


    25 May 202304:29PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 25-05-2023 10:22 PM Time Taken: 4.00 Notes: ETC extended from: 17/05/2023 to 25/05/2023
    The following tests were performed:

    Test Setup Instructions:
    1. Use OTGL Setup
    Table 1 - Test Results
    NoTest CaseExpected ResultPass/FailComments
    1Generate report "Customer Fleet Charges" using parameters:
    Date From: 01/02/2023
    Date To: 01/02/2023
    Customer Category: Mobil
    Report displays with correct data
    Pass

    2



    Environment Details

    1. OS version: Win11
    2. Application version: 14.80
    3. Setup on:
      1. Server: LinkQA4
      2. Database: LinkSOFT
      3. LinkSOFT URL: HTTP://LinkQA4/LinkSOFT
    4. Login Details: Standard username and password for user "admin"

    Next Step: Closure


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

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