Company: Link Technologies
Case No: L12073. Project: 12.20: LinkSOFT Version 12.2
Logged By: Sanjay (Link Technologies) on 30 Nov 2020 03:52PM
Priority: High
Product: Point of Sale
Group: Enhancement
Time Taken: 9.00 (Weight: 9.00)
Version: 12.22.0113
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Rashna, Sanjay
Resolve By: Monday, 07 December 2020 11:59 PM [1242 days since logged date]
Status: Closed
Subject: POS Login Failure Notification Improvements
Summary:    When logging into POS, if the Server name is incorrect, or if the database needs upgrading, the message is not clear.  There s also a "NULL exception" when the database needs upgrading due to configuration changes. 
Audit Notes:Edited by sanjay on 07/12/20 16:57. Edited by alvis on 07/12/20 16:49. Edited by sanjay on 04/12/20 09:50. Edited by sanjay on 30/11/20 15:52. 
30 Nov 202003:50PM Comment 1 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 30-11-2020 07:45 PM Time Taken: 8.00 Notes: Edited by sanjay on 30/11/20 15:51. 

Development work for this case has been completed.

The change will be available in version: 12.2.1201 and 12.30.1201

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

  1. When the application starts, we check the Server availability and we extract the Database configuration values. If either fails, we log the message and prompt the user with a message.
  2. The user is given the option to change the connection details

2. Affected Areas:

  1. POS Login

3. The issue was caused by:

  1. Remove Null exception when logging into POS where the DB needs to be upgraded

4. Notes
5. Next Step
: UAT in 12.2 nd 12.3

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

Development Reference:


30 Nov 202003:52PM Comment 2 by Sanjay (Link Technologies) ETC was changed from 02/12/2020 to 02/12/2020
04 Dec 202004:00PM Comment 3 by Rashna (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 07-12-2020 07:36 PM Time Taken: 1.00 Notes: ETC extended from: 02/12/2020 to 07/12/2020
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
1

Create a database "LINKSOFT-DEMO-1221" on server 10.0.0.13.

In the "Link Technologies - POS.exe.config" file set the database as "LINKSOFT-DEMO". 

Login to LinkPOS

  1. The user should not be able to log in as "LINKSOFT-DEMO" is invalid.
  2. The user should be prompted with a message.
  3. The user should be given the option to change settings
    1. Correct database to "LINKSOFT-DEMO-1221"
    2. Login 

Pass

2

Create a database "LINKSOFT-DEMO-1221" on server 10.0.0.13.

In the "Link Technologies - POS.exe.config" file set the server as "10.0.0.12". 

Login to LinkPOS

  1. The user should not be able to log in as "10.0.0.12" is invalid.
  2. The user should be prompted with a message.
  3. The user should be given the option to change settings
    1. Correct database to "10.0.0.13"
    2. Login 

Pass

  1. Database Connection Setting opens at login.
  2. Message - Unable to connect to the server details.
  3. At close, the message is updated to change settings

Environment Details

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

Next Step

  1. Case to be retested in version 12.30

    07 Dec 202004:50PM Comment 4 by Alvis (Link Technologies) Case L12073 added to project 12.2
    07 Dec 202004:57PM Comment 5 by Sanjay (Link Technologies) ETC was changed from 07/12/2020 to 07/12/2020
    08 Dec 202008:24AM Comment 6 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 08-12-2020 12:23 PM
    Thanks Rashna

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

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