Hi Vineet

I have closed Period 12 for Year 2024 at 9.30 am for company 1001. It's 3.30 pm now and I still can't access most of the important forms in Linksoft.

1. Employee maintenance form,
2. Leave allocations
3. Leave Accrual Reports

This has seriously affected my days work

Bula Team

The following tasks were completed on a copy of the backup on our internal servers as per the development request.

1. I have applied the patch LinkSOFT_15.51.241212 although there weren't any performance changes in it.
2. I have built the indexes. These were missing on Timesheet Staging and Timesheet Batch Archive table. These were not built automatically when the rebuild process was executed so we had to do it manually.
3. The database has been backed up on QA5 as XXX\Client-GFI-Linksoft-IndexedUpgraded03012025.bak
4. Rollover start time 11:43 am FIJI Time. This was monitored for 45 minutes and only 50 employees were rolled over

We relayed the same to our development team again. It was noted audit was set on the below tables.

1. HR_LEAVE_HIST
2. LT_HRM_Leave_Accrual
3. HR_EMP_LEAVE.

During the rollover, we update the above tables to add new leave accruals for all leaves which have one-time accruals as 'Yes'. We also update the year for all leave that has not been taken and paid. All this information for the 1200 plus staff was being passed through audit which took a longer time. The workaround and quick fix for this was to remove audits from the above tables from the Audit Setup menu. Once this was done, the rollover was completed in 40 minutes. This has been highlighted to our development team. They have advised that since the database size on production is over 285GB it would be related to resourcing issue on the server. However, we did highlight that this was not an issue in version 10 and since no audit changes has been made, it should be seamless in version 15 as well. 

Our development team will allocate time to see what can be done for GFI.

Note: GFI rollover took 11 hours to complete on the production database without removing the audits. The month-end rollover process is not an issue for GFI. This takes less then 5 minutes.

---Skype Conversation with the development team--

---End of Skype Conversation--

Thanks
Vineet Ram

Specifications are as follows:

1. Database size: 290GB (D:\MSSQL\Backup\Client-GFI-Linksoft-BeforeEOY2024.bak)
2. Database Specs: 4 VCPU 2GHz with 8GB RAM
3. Number of Employees: 1228
4. Number of Active Leave Codes: 285

Period Close Results.

1. When Audit triggers are enabled, Year End takes 6 hours (See figure 2)
2. When Audit triggers are disabled on Payroll tables, the Year End process takes 11 minutes. (See figure 1)

Investigation Notes:

1. Based on the server specs, we are satisfied with the time taken to roll over 1228 employees with 285 Leave codes in 11 minutes
2. Time taken when audit triggers are enabled cannot be improved as Audit is a Disk and Processor intensive exercise
3. We disable all Payroll Functions during "Year End" as employee records are being rolled into the new year and users should not be performing any tasks during this time

Conclusion:

1. Perform Year End as an Overnight task to minimize interference
2. Since year end process is done once a year, you can DISABLE payroll triggers during the Year End task, however, Option 1 above is preferred.

Figure 1 - Event Log. When Audit triggers are disabled on Payroll tables, the Year End process takes 11 minutes.

Figure 2 - Event Log. When Audit triggers are enabled, Year End takes 6 hours