Company: Link Technologies
Case No: L09131. Project: 09.40: LinkSOFT Version 9.4
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 23 Feb 2018 02:01PM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 8.50 (Weight: 8.50)
Version: 9.496.1128
Assigned To: Sanjay (Link Technologies)
Circulation: Aarti Pooja Gayaneshwar, Alvis, Development, Rashna, Sanjay
Resolve By: Saturday, 24 February 2018 12:00 AM [2253 days since logged date]
Status: Closed
Subject: System does not create GL csv file in the new integration system
Summary:    

Bula Alvis,

Testing of the csv file has been performed in the client database but the system did not output the file.

Refer to steps below: 

  1. Upgrade NFA backup
  2. Configured the following in ESS:
    • Activated: GLJournalFile
    • Enabled processes: ESS026 & SYS009
  3. Created FTN pay in Linksoft
  4. Updated Pay
  5. csv file did not output
  6. Error: Could not find stored procedure 'LT_CUSTOM_GeneralLedgerJournal_FileData_NationalFireAuthority'. 

Environment Details:

  1. QA: 3
  2. DB: CLIENT-NFA-LINKSOFT
  3. V: 9.2.4.0.000

Refer to image below:

Figure 1: GL Setup


Figure 2: Event Log


Audit Notes:
23 Feb 201802:42PM Comment 1 by Alvis (Link Technologies) Case 9131 added to project 8.3
23 Feb 201802:50PM Comment 2 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 23-02-2018 02:50 PM Time Taken: 0.50
Resolved procedure name issue in BETA5

25 Feb 201807:27PM Comment 3 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 26-02-2018 12:00 AM Time Taken: 0.50

Dear Alvis,

Unable to test this case as the GL file is not putting in the demo environment. Reference case: 9135, subject: GL file is not generating in demo database.

Regards
Aarti


26 Feb 201808:39AM Comment 4 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 26-02-2018 08:39 AM Time Taken: 1.00

Hi Aarti,

I have verified this and the file is created in my environment. Can you re-install your applications and try again.

regards
Alvis


26 Feb 201804:45PM Comment 5 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Alvis (Link Technologies) Followup Date: 27-02-2018 12:00 AM Time Taken: 3.00

Hi Alvis,

I have tested this in Beta 925, but the status of the file is still "In Progress"

Environment Details:

  1. Application QA: 3
  2. DB: QA4
  3. DB Name: CLIENT-NFA-LINKSOFT

Configuration:

  1. WebFile: 
    • EnableReportEmailScheduler" value="No" 
    • EnableIntegrationScheduler" value="Yes" 
  2. ESS:
    • Activated: GLJournalFile
    • Enabled processes: ESS026 & SYS009

  • All processes are running
  • There is no error message in regards to this in Event Log
Refer to image below: FMIS Integration:



27 Feb 201808:45AM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-02-2018 08:45 AM Time Taken: 1.00

The issue was caused by the time taken for the process to extract file data. This process was taking about 3 minutes to complete which resulted in the timeout in the application.

To resolve this, we have refactored the process to improve performance in the output file and increased the timeout to 300 seconds. This timeout can be changed on the web.config ~> "DataConnectionCommandTimeout" .

Please UAT this in beta6.


27 Feb 201810:09AM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 27-02-2018 10:09 AM Time Taken: 1.00

System tests completed. The following were verified:

  1. Created a new FTN pay
  2. Verified GL integration report and updated missing GL account codes on paycode maintenance
  3. Updated pay and verified GL Journal entries
  4. Verified CSV file and checked format to be in line with NFA customization.

regards
Alvis


27 Feb 201801:44PM Comment 8 by Sanjay (Link Technologies) Assigned To: Rashna (Edge Business Solutions) Followup Date: 27-02-2018 01:44 PM
Hi Rashna, please proceed with UAT using 9.2.6 (Beta 6) 

28 Feb 201808:38AM Comment 9 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 28-02-2018 12:00 AM Time Taken: 1.50
Hi Sanjay,

This case has been tested, please find test plan below:

No

Plan

Status

1

Created Pay and Generated File in version 8007.23

PASS

2

File Generated successfully

PASS

3

Upgraded database to 926

PASS

4

Hosted ESS and configured:
- Activated: GLJournalFile
- Enabled processes: ESS026 & SYS009

PASS

5

Created Pay and Updated successfully

PASS

6

File Generated successfully

PASS

7

Compared both the files – no variance found

PASS

 


Environment Details:

  1. Before Upgrade:
    • QA: 3
    • DB: CLIENT-NFA-LINKSOFTB4Upgrade
    • V: 8007.23 
  2. After Upgrade:
  • QA: 4
  • DB: CLIENT-NFA-LINKSOFT
  • DB: 4
  • V: 926 
The files are attached to this case.

Please review

Regards
Aarti Gayaneshwar


28 Feb 201812:59PM Comment 10 by Alvis (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 28-02-2018 12:59 PM
Thanks Aarti.

09 Oct 201908:14AM Comment 11 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
Attachments:
General Documents - Case: 9131:AfterUpgrade.csv
BeforeUpgrade.csv
If you have any queries regarding this support incident, please email admin@linktechnologies.com.au and include the Case No: L09131 in the subject line of all emails regarding this issue.

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