Company: Link Technologies
Case No: L12082. Project: 12.30: LinkSOFT Version 12.30
Logged By: Sanjay (Link Technologies) on behalf of Alvis (Link Technologies) on 09 Nov 2020 10:21AM
Priority: High
Product: Framework
Group: Enhancement
Time Taken: 6.00 (Weight: 8.00)
Version: 12.30
Assigned To: Sanjay (Link Technologies)
Circulation: Alvis, Development, Rashna, Sanjay
Resolve By: Saturday, 14 November 2020 11:59 PM [1256 days since logged date]
Status: Closed
Subject: Database utility - Improve Validations when creating databases
Summary:    
Database utility - create a new database.
Prevent users from entering a "." dot in the database name.
Dots in the DB name causes errors in generating crystal reports.
Audit Notes:Edited by sanjay on 25/02/21 08:52. Edited by alvis on 07/12/20 13:25. 
07 Dec 202008:31AM Comment 1 by Sanjay (Link Technologies) Case L12082 added to project 12.3
07 Dec 202001:25PM Comment 2 by Alvis (Link Technologies) ETC was changed from 14/11/2020 to 14/11/2020
09 Dec 202002:11PM Comment 3 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 09-12-2020 05:04 PM Time Taken: 4.00

Development work for this case has been completed.

The change will be available in version:12.30.1209

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

  1. Added the following REGEX for DATABASE name validation: ^[\p{L}_][\p{L}\p{N}@$#_]{0,127}$
  2. Max Length is 127 characters
  3. Only some special characters are allowed based on MS docs reference

2. Affected Areas:

  1. Build a new database

3. The issue was caused by:

  1. Added validations

4. Notes
5. Next Step
: UAT

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

Development Reference:


23 Dec 202004:16PM Comment 4 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 23-12-2020 08:13 PM Time Taken: 1.00
System test completed

29 Dec 202001:39PM Comment 5 by Rashna (Edge Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 29-12-2020 05:17 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
1Create a "New" and "Demo" database with the name as "LinkSOFT.2021".  This should not be createdPass
2Create a "New" and "Demo" database with the name as "LinkSOFT_2021".  This should be created
Pass
3Create a "New" and "Demo" database with the name as "LinkSOFT&2021".  This should be created
Pass
4Create a database with the name having 125 characters. This should be created Pass
5Create a database with the name having 128 characters. This should not be created 
Pass

Environment Details

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

Next Step

  1. For Documentation

    29 Dec 202004:00PM Comment 6 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 29-12-2020 07:59 PM
    Documentation is not required.

    04 Jan 202103:24PM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 04-01-2021 07:24 PM
    Thanks Rashna 

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

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