Error log:-
ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetReviewChangesCollection->CollectionManager.GetReviewChangesforAnyModeOtherThanQECollection
ErrorMessage: Invalid column name 'AbsoluteBasophilis'.

We have analyzed this error log and observed the following:

Concern:
Server error on Pending queue page

Cause:
There are 4 records inserted in Employee_Healthdate_Intermediate table, which has inconsistent table structure. This is causing error while creating dynamic query on Pending queue & Review changes page.

Correction:
This table has been added for 'Wellness' module integration with WORKTERRA. Need to make the table structure consistent.

WORKAROUND: Either 2 employee data present in Employee_Healthdata_Intermediate need to be removed, or healthdata pending customization need to be updated.

Need to schedule this with Wellness team.

Thanks & Regards,
Satya Prakash

Rakesh RoyVijay SiddhaSamir

We have fixed this issue for SMUHSD.

@rakesh: Can we please verify this for mentioned company.

Vijay Siddha: As mitigation plan for this issue, we need to scan Wellness tables to ensure correct table structures are present for all columns in Main, Intermediate & History tables.

Thanks & Regards,
Satya Prakash

Satya Rakesh Roy Samir
Satya - please add efforts needed to scan and fix this for one company? and total how many companies we have?

thanks
Vijay

Hi Vijay,

I have fixed this for one company. Please find attached DDL script used for this purpose.Wellness_JIRA3250_DDL_Script.sql

For making this script generic & scanning other wellness companies, will require around 4 hours of efforts. Indra can guide to make script consistent for wellness tables.

Thanks & Regards,
Satya Prakash

Verified on LB using company 'For QA LB Austin Ind'. Observed server error on 'Search' in “Pending Queue” page. Hence reopening.

HI Rajendra Joshi,

Can you please share the error logs of this issue.

Regards,
Surender Kumar

Verified on LB using company 'For QA LB Austin Ind'. Observed server error on 'Search' in “Pending Queue” page. Error log and screen shot attached as per request.

Rajendra Joshi
Error is not there. Can you please check again?

Checked and error is coming

See error log:-

ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetReviewChangesForEmployee
ErrorMessage: Incorrect syntax near 'UNION'.

Hi Rakesh Roy,

Solution for this issue has been deployed on LB. Please find details below

Thanks and Regards,
:: Umesh Kadam

CC : Amruta Lohiya

Not getting server error.

Verified on stage with ASML for hspl. Server error observed on selecting Search button on Pending Queue screen. PFA screen shot.

Verified on stage using below companies. Here, server error is not observed.
DC
Austin for HSPL
Utah Valley University For HSPL
MATT

But it is observed on ASML for HSPL only as mentioned above.

Hi Rajendra Joshi,

Please find below our analysis.

Thanks and Regards,
:: Umesh Kadam

CC : Amruta Lohiya

Verified on Stage using company ASML for HSPL. The server error issue is resolved now. Search functionality is working correctly.

Verified on Production using company City of Lake worth for HSPL and EBS Exchange. Above issue is resolved now.