Company: Link Technologies
Case No: L12578. Project: 13.03: LinkSOFT version 13.03
Logged By: Vineshwar Prasad (Edge Business Solutions) on 16 Sep 2021 12:59PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 20.00 (Weight: 20.00)
Version: 13.03.1019
Assigned To: Sanjay (Link Technologies)
Circulation: Sanjay, Sitla, Vineshwar Prasad
Resolve By: Tuesday, 19 October 2021 10:28 PM [1162 days since logged date]
Status: Closed
Subject: User cannot Approve TNA Timesheet for ''Normal Hours''. We get a Conversion Error in the Event Logs.
Summary:    
1. Problem Details

User cannot Approve TNA Timesheet for ''Normal Hours''. Every time the Approve button is clicked, nothing happens and a message is updated in the event logs

2. Error Message (Include screenshot of the error)

--- Event Log ---

LT_ESS_Time_StatusChangeValidation
Conversion failed when converting the varchar value 'H' to data type int.

3. Environment Details

Version - 13.03.0917.GA
Audit Notes:Edited by sanjay on 19/10/21 09:53. Edited by sanjay on 19/10/21 09:53. Edited by sitla on 18/10/21 16:28. 
18 Oct 202104:28PM Comment 1 by Sitla (Edge Business Solutions) ETC was changed from 17/09/2021 to 18/10/2021
18 Oct 202104:39PM Comment 2 by Sitla (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 19-10-2021 10:28 PM Notes: Edited by sanjay on 19/10/21 09:54. Edited by sitla on 18/10/21 16:48. ETC extended from: 18/10/2021 to 19/10/2021

Hi Sanjay, 

We have done the setup on QA3 and below are the details:

  1. Server: LINKQA4\CP1
  2. Database Name: CLIENT-COKE-LINKSOFT
  3. Version: 13.03.0917.GA
  4. Link to Browse: http://linkqa3/linksoft

Steps to Reproduce Issue;

  1. Navigate to Time Approval Menu
  2. Filter Record TSID 149237
  3. Select Record and Approve
  4. Processing in Progress with no effect
  5. Log is updated with this message: "Cannot change the status to Approved. Reason: Conversion failed when converting the varchar value 'H' to data type int."
Note: Username "admin" has been added as an approver in this workflow "PRODUCTION INDIRECT - Engineering TNA" 

18 Oct 202106:35PM Comment 3 by Sanjay (Link Technologies) Assigned To: Sitla (Edge Business Solutions) Followup Date: 18-10-2021 10:50 PM Time Taken: 6.00 Notes: Edited by sanjay on 19/10/21 09:57. 

Hi Sitla, the cause of the issue is that the Time Entry has Invalid Start and End Dates in the table. The entries seem to be coming from the Biometric system, but I need to investigate this further.

Table 1 below which has the invalid Dates.

Table 1 - Entries with invalid Start and End dates

TSIDUserNameEntryDateTimeStartTimeEndDurationDescription
1491881884392021-10-16 08:02:10H:02 AMH:01 PM4.51NULL
1493431889602021-10-14 08:07:02H:07 AMH:09 PM8 


18 Oct 202106:43PM Comment 4 by Sitla (Edge Business Solutions) This comment has been removed
19 Oct 202109:39AM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-10-2021 02:42 PM Time Taken: 6.00

Hi Vineshwar, we have found the issue with the time conversion from Timesheet to Time Entry.

The issue is caused by the incorrect use of Time Conversion. The correction is in Update 13.03.1019 which can be download from this link.

This update includes data correction for time entries created with the incorrect Time values.


19 Oct 202109:53AM Comment 6 by Sanjay (Link Technologies) Case L12578 added to project 13.03
19 Oct 202110:05AM Comment 7 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-10-2021 04:03 PM Time Taken: 4.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.11.1019 and Patch 13.03.1019

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

  1. Correct usage for Time conversion when creating Time Entry Records

3. Affected Areas:

  1. TNA Import Timesheets into Time Entry.

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 Completed.


19 Oct 202110:44AM Comment 8 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 19-10-2021 04:42 PM Time Taken: 4.00
The following tests were performed:

Table 1 - Test Results
#Test Case DetailsPass/FailComments
 1Approve Timesheet Entry to create Time Entry
Pass
Time entries created with correct Time value

Environment Details

  1. OS version: Win10
  2. Application version: 13.03.1019
  3. Setup on:
    1. Server: LinkQA4
    2. Database: DEMO-LinkSOFT
    3. LinkSOFT URL: HTTP://10.0.0.14/CLIENT-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: L12578 in the subject line of all emails regarding this issue.

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