Please check the screen shot.

Hi Jaideep,

Althgough employees have been blown out from Wheaton, Can you please check error log & schedule to fix this?

Thanks & Regards,
Satya Prakash

I found below log on stage of Nobry's login,

ErrorID : 0
ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->SAUtilityToolBox.Delete->SAUtilityToolBox.DeleteEmployeesAndDependents
ErrorMessage: The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information.

Wheaton is having 15400 + employees. It is clear from above log that this is a performance related issue.
I deleted all employees using SA Utility yesterday with out any error. Of Course, I have deleted employees class by class so max count of employees at a time was 7863. I do get browser time for this count but no error occurred.

In project simple, we are re-vamping SA utility, We can move this ticket to project simple for considaration.

Can we move this to project Simple?

CC: Samir,Sachin KhandgeSaurabh Sablaka

Amruta Lohiya

Hi Samir,

Can you please include this in performance point with project simple?

Thanks & Regards,
Satya Prakash

Hi Avnish,

Can we plan this optimization point with Nitish? Please schedule in next week & share dev due date.

In case help required with query, Indraprakash Tiwari will help.

Regards,
Satya Prakash

Cc: Vijay Siddha Samir Jaideep Vinchurkar Rakesh Roy

Hi Prasad,
Please find below 3Cs:

Concern: Not able to delete all employees through SA Utility
Cause:Delete query deletes only 3000 employees and if employee is more than 3000 it gives server error.
Correction: We have handled the above condition and resolved the issue.
Please verify the same.

Thanks,
Nitish Wadnere.
Cc: Avnish YadavJyoti Mayne

Environment: LB
Company: Employee 1941
No. of employees: 3640

Partner login > BenAdmin > SA Utility > Employee Delete > Select all employees > Server error

Please check the screen capture and error for the same.

Hi Priya Dhamande,

As per attached error log "FK_pm.EmployeeRecognitions_dbo.Employee_ID" constraint are the conflict occurred on table "pm.EmployeeRecognitions", column 'EmployeeId'.

This issue is an environment issue so could you please assign this to Ashwin Wankhede for further action.

Thanks,
Avnish Y

CC-- Hrishikesh Deshpande,Rakesh Roy,Satya

Hi Ashwin Wankhede,

As per above comment assiging jira to you.

Also, the error is appearing for deleting one or multiple employee.

Error log for the issue are attached with jira.

Prasad Pise Hrishikesh Deshpande

Hi Khandu Kshirsagar,

Can you please give Wheaton from production to LB for testing this issue.

Please assign the issue back to me once the company is taken down.

Avnish Yadav Ashwin Wankhede

Thanks

Hi Priya Dhamande,

Company Wheaton moved from prod to LB and created new copy as "Wheaton Fransican Healthcare" on LB.

Please check and do let me know if any issue.

Ashwin Wankhede,Avnish Yadav

Hi Avnish / Khandu,

I am getting attached error while searching the employee on SA utility for Wheaton Company. So, unable to check the deletion issue.

Can you please look into the same.

Thanks,
Priya

Hi Priya Dhamande,

I tried exact same scenario on LB as mentioned and deleted single as well as multiple
records with different employee status like Terminated,Active.

In both of the cases, all records get deleted successfully.No any server error occurs.

Please see below screenshots.

Thanks & regards,
Shailendra Honrao

cc:Jyoti Mayne

Environment: LB
Company: Wheation Fransion Healthcare
SA Utility

Amount of employees deleted were 8350

The issue of getting server error while deleting large amount of employees is resolved on LB.

This is verified and screem capture for the same is attached with jira.

So, moving jira on Stage.

Environment: Stage
Company: Wheation Fransion Healthcare for hspl
Login: Partner
SA Utility

Scenario:
1. tested for 2 employees
2. tested for 4000+ employees

For both cases employees got deleted without any error. So, moving jira on production.

Hi Amit Thorve,

This issue has been fixed and deployed on Production. Let me know in case you have any issue in this.

Thanks,
Hrishikesh.