Company: Link Technologies
Case No: L09180. Project: 09.40: LinkSOFT Version 9.4
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 06 Mar 2018 08:44AM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 1.75 (Weight: 1.75)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Sanjay
Resolve By: Wednesday, 07 March 2018 12:00 AM [2215 days since logged date]
Status: Closed
Subject: Process failed on Server: Name: FMIS Payroll Integration.
Summary:    

Hi Sanjay,

I have the following settings in Payroll & ESS:

ESS:

  1. Integration - Integration Setup:
    • GLJournalFile - is inactive
  2. Processes are disabled:
    • ESS026 - FMIS Payroll Integration. Used to compute payroll journals and send to General Ledger and Accounts Payable
    • SYS009 - Perform all integration tasks. This includes General Ledger Journal, Sales Order and Creditor Invoice
Payroll: Updated payrun 12

The following error was discovered in Event Log: 

"NT SERVICE\SQLSERVERAGENT LT_PAY_FMISIntegrationControl_Process LINKQA4 Error Conversion failed when converting from a character string to uniqueidentifier."

Log Message: Conversion failed when converting from a character string to uniqueidentifier.
Resolution:
Resolution Date:
Log Data:
Custom Field Text 1:
Custom Field Text 2:
Custom Field Text 3:
Custom Field Number 1:
Custom Field Number 2:
Custom Field Number 3:
Custom Field Definition:

Environment Details for New database:
Server: 10.0.0.14
Database: LINKSOFT_NEW

Kindly advise how this is occuring.

Regards
Aarti

Audit Notes:
06 Mar 201808:30AM Comment 1 by Alvis (Link Technologies) Case 9180 added to project 9.2
06 Mar 201808:44AM Comment 2 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 06-03-2018 08:44 AM Time Taken: 1.00

Hi Aarti,

The error has been resolved. It was caused by the function that gets the Pay FMIS control status.

Please verify in beta9.

regards
Alvis


06 Mar 201809:48AM Comment 3 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-03-2018 12:00 AM Time Taken: 0.75
QA Results
Step 1 - Developer will perform test based on test cases provided
Step 2 - Product expert to complete Product QA based on test cases.

Test cases are provided on the case header before the case is approved for development.

Test Results Summary

Table 1 - Summarised list of issues
NoTest Description Pass/Fail 
1
GL is inactivePASS
2
GL processes inactivePASS
3
Pay Updated successfullyPASS
4
No error in event log in regards to FMIS
PASS

Environment Details for New database:

Server: 10.0.0.14
Database: LINKSOFT_NEW

Kindly review.

Thanks
Aarti


    06 Mar 201809:58AM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 06-03-2018 09:58 AM
    Thanks Aarti

    09 Oct 201908:14AM Comment 5 by Sanjay (Link Technologies) Quality control status: Pass. QC Not required - This case was created before quality check was implemented in version 11 on 30/06/2019
    If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09180 in the subject line of all emails regarding this issue.

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