Company: Link Technologies
Case No: L12639. Project: 13.12: LinkSOFT version 13.12
Logged By: Aarti Pooja Gayaneshwar (Link Business Solutions) on 12 Nov 2021 11:34AM
Priority: High
Product: Payroll & HR
Group: Software Defect
Time Taken: 9.00 (Weight: 9.00)
Version: 13.12.1116
Assigned To: Development
Circulation: Aarti Pooja Gayaneshwar, Development, Sanjay
Resolve By: Friday, 26 November 2021 12:00 AM [888 days since logged date]
Status: Closed
Subject: Unable to generate the "Applicant Profile Report"

Bula Sanjay

LTA is on LinkSOFT Version - 13.10.1011.GA. When they try to generate the Applicant Profile Report using PDF view, the screen keeps processing (up till 400seconds) but the report does not generate.

I have tried the same on QA8, and the report still takes approx. 260 seconds to load.

Can we improve the performance of this report and also, what can we do at LTA to resolve this issue? We have advised them to use Report Schedule for now.


Audit Notes:Edited by sanjay on 02/12/21 18:06. Edited by aarti on 29/11/21 15:42. Edited by aarti on 25/11/21 07:20. Edited by aarti on 25/11/21 07:20. Edited by aarti on 22/11/21 14:46. Edited by aarti on 17/11/21 08:56. 
22 Nov 202102:46PM Comment 1 by Aarti Pooja Gayaneshwar (Link Business Solutions) ETC was changed from 13/11/2021 to 23/11/2021
25 Nov 202107:20AM Comment 2 by Aarti Pooja Gayaneshwar (Link Business Solutions) ETC was changed from 23/11/2021 to 26/11/2021
29 Nov 202110:30AM Comment 3 by Sanjay (Link Technologies) Assigned To: Aarti Pooja Gayaneshwar (Link Business Solutions) Followup Date: 29-11-2021 04:25 PM Time Taken: 1.00
Hi Aarti, the URL: is not configured on QA8. Please correct and let me know so I can have a look at this issue.

29 Nov 202103:43PM Comment 4 by Aarti Pooja Gayaneshwar (Link Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 30-11-2021 09:42 PM Time Taken: 1.00

Hi Sanjay

I have fixed the link: Updated case header with the same.


02 Dec 202106:06PM Comment 5 by Sanjay (Link Technologies) Case L12639 added to project 13.12
02 Dec 202106:08PM Comment 6 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 03-12-2021 12:06 AM Time Taken: 4.00
PART A - Development work for this case has been completed.

1. The change will be available in version:13.20.1202 and PATCH for 13.12.1202

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

  1. Performance tuned Applicant Profile report for companies with a very large number of users

3. Affected Areas:

  1. Applicant Profile Report

4. The issue was caused by:

  1. Database query optimised for performance

5. Other Relevant Notes
6. Next Step
(Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT

08 Dec 202102:49PM Comment 7 by Sanjay (Link Technologies) Assigned To: Development Followup Date: 08-12-2021 08:48 PM Time Taken: 3.00
Completed UAT on LTA Database.

If you have any queries regarding this support incident, please email and include the Case No: L12639 in the subject line of all emails regarding this issue.

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