-
Type:
Bug
-
Status: Production Complete
-
Priority:
Critical
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: Wellness
-
Labels:None
-
Module:BenAdmin - Enrollment
-
Reported by:Support
-
Item State:Production Complete
-
Issue Importance:Must Have
-
Sprint:Bugs-Must Fix- Pilot July2016
While doing some testing under the administrator (adminsmhsd, Password@1), I received a server error message when I clicked “Search” on the “Pending Queue” page.
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
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
Vijay Siddha (Inactive)
added a comment - 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.
Rajendra Joshi (Inactive)
added a comment - Verified on LB using company 'For QA LB Austin Ind'. Observed server error on 'Search' in “Pending Queue” page. Hence reopening. 
surender kumar (Inactive)
added a comment - 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 (Inactive)
added a comment - 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
| Concern | Received a server error message when I clicked “Search” on the “Pending Queue” page. |
| Cause | Check for UNION at the end of query was missed |
| Correction | I've made code change to check and remove UNION at the end of the query |
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.
Rajendra Joshi (Inactive)
added a comment - 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.
Rajendra Joshi (Inactive)
added a comment - 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.
| Concern | For ASML for HSPL, 'Search' on the 'Pending Queue' was not working. |
| Cause | AdditionalTextbox field named 'one' was added in 'Demographics' form using 'Form Builder' page, and was mapped to wrong column (i.e. 'one113242', shown in screenshot) |
| Correction | This is data issue and re-saving of the form using 'Form Builder' page will resolve this issue. I've done the same on 'ASML for HSPL' for now. |
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.
Rajendra Joshi (Inactive)
added a comment - 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.
Rajendra Joshi (Inactive)
added a comment - Verified on Production using company City of Lake worth for HSPL and EBS Exchange. Above issue is resolved now.
Error log:-
ErrorID : 0
ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetReviewChangesCollection->CollectionManager.GetReviewChangesforAnyModeOtherThanQECollection
ErrorMessage: Invalid column name 'AbsoluteBasophilis'.