WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-3250

Received a server error message when I clicked “Search” on the “Pending Queue” page.

    Details

    • 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

      Description

      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.

        Attachments

        1. 07_04_2016_13_15_20_979_1_3.txt
          3 kB
        2. 07_20_2016_12_21_25_406_1_3.txt
          3 kB
        3. Pass.png
          Pass.png
          243 kB
        4. Pending Queue_Server error_ASML.png
          Pending Queue_Server error_ASML.png
          200 kB
        5. Pending Queue_Server error.png
          Pending Queue_Server error.png
          200 kB
        6. screenshot-1.png
          screenshot-1.png
          248 kB
        7. Server Error_Pending Queue.png
          Server Error_Pending Queue.png
          227 kB
        8. Server Error_Pending Queue.png
          Server Error_Pending Queue.png
          208 kB
        9. Wellness_JIRA3250_DDL_Script.sql
          3 kB

          Activity

          Ascending order - Click to sort in descending order
          rakeshr Rakesh Roy (Inactive) created issue -
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

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

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Error log:- ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetReviewChangesCollection->CollectionManager.GetReviewChangesforAnyModeOtherThanQECollection ErrorMessage: Invalid column name 'AbsoluteBasophilis'.
          satyap Satya made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Development [ 10007 ]
          Hide
          Permalink
          satyap Satya added a comment -

          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

          Show
          satyap Satya added a comment - 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
          satyap Satya made changes -
          Assignee Satya [ ID10004 ] Vijay Siddha [ vijays ]
          satyap Satya made changes -
          Component/s Wellness [ 10005 ]
          Component/s BenAdmin [ 10000 ]
          satyap Satya made changes -
          Module Parent values: BenAdmin(10100)Level 1 values: EDS(10108) Parent values: BenAdmin(10100)Level 1 values: Enrollment(10107)
          Hide
          Permalink
          satyap Satya added a comment -

          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

          Show
          satyap Satya added a comment - Rakesh Roy Vijay Siddha Samir 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
          vijays Vijay Siddha (Inactive) made changes -
          Assignee Vijay Siddha [ vijays ] Satya [ ID10004 ]
          Hide
          Permalink
          vijays 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

          Show
          vijays 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
          satyap Satya made changes -
          Attachment Wellness_JIRA3250_DDL_Script.sql [ 20802 ]
          Hide
          Permalink
          satyap Satya added a comment -

          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

          Show
          satyap Satya added a comment - 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
          satyap Satya made changes -
          Dev Estimates 4
          satyap Satya made changes -
          Assignee Satya [ ID10004 ] Vijay Siddha [ vijays ]
          satyap Satya made changes -
          Assignee Vijay Siddha [ vijays ] Surender Kumar [ surender.kumar ]
          surender.kumar surender kumar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          surender.kumar surender kumar (Inactive) made changes -
          Assignee Surender Kumar [ surender.kumar ] Rajendra Joshi [ rajendraj ]
          satyap Satya made changes -
          Sprint Bugs-Must Fix- Pilot July2016 [ 16 ]
          satyap Satya made changes -
          Rank Ranked higher
          rajendraj Rajendra Joshi (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          deepalit Deepali Tidke (Inactive) made changes -
          Production Due Date 07/Jul/2016
          Stage Due Date 6/Jul/16 [ 2016-07-06 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Attachment Server Error_Pending Queue.png [ 21217 ]
          Attachment 07_04_2016_13_15_20_979_1_3.txt [ 21218 ]
          Hide
          Permalink
          rajendraj 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.

          Show
          rajendraj 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.
          rajendraj Rajendra Joshi (Inactive) made changes -
          Assignee Rajendra Joshi [ rajendraj ] Surender Kumar [ surender.kumar ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          rajendraj Rajendra Joshi (Inactive) made changes -
          Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
          satyap Satya made changes -
          Status Reopen in Local [ 10018 ] In Development [ 10007 ]
          satyap Satya made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: In Progress(10206)
          satyap Satya made changes -
          Dev Due Date 08/Jul/2016
          Hide
          Permalink
          surender.kumar surender kumar (Inactive) added a comment -

          HI Rajendra Joshi,

          Can you please share the error logs of this issue.

          Regards,
          Surender Kumar

          Show
          surender.kumar surender kumar (Inactive) added a comment - HI Rajendra Joshi , Can you please share the error logs of this issue. Regards, Surender Kumar
          surender.kumar surender kumar (Inactive) made changes -
          Assignee Surender Kumar [ surender.kumar ] Rajendra Joshi [ rajendraj ]
          surender.kumar surender kumar (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          Hide
          Permalink
          rajendraj 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.

          Show
          rajendraj 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.
          rajendraj Rajendra Joshi (Inactive) made changes -
          Attachment 07_20_2016_12_21_25_406_1_3.txt [ 22223 ]
          Attachment Server Error_Pending Queue.png [ 22224 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Assignee Rajendra Joshi [ rajendraj ] Surender Kumar [ surender.kumar ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: Re-open(10212)
          surender.kumar surender kumar (Inactive) made changes -
          Status Reopen in Local [ 10018 ] In Development [ 10007 ]
          surender.kumar surender kumar (Inactive) made changes -
          Dev Due Date 08/Jul/2016 05/Aug/2016
          satyap Satya made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Re-open(10212) Parent values: Development(10200)Level 1 values: In Progress(10206)
          jyoti.mayne Jyoti Mayne made changes -
          Assignee Surender Kumar [ surender.kumar ] Umesh Kadam [ umesh.kadam ]
          jyoti.mayne Jyoti Mayne made changes -
          Dev Due Date 05/Aug/2016 15/Aug/2016
          jyoti.mayne Jyoti Mayne made changes -
          Dev Due Date 15/Aug/2016 16/Aug/2016
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Dev Due Date 16/Aug/2016 17/Aug/2016
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Dev Due Date 17/Aug/2016 22/Aug/2016
          Hide
          Permalink
          umesh.kadam Umesh Kadam (Inactive) added a comment -

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

          Show
          umesh.kadam Umesh Kadam (Inactive) added a comment - Rajendra Joshi Error is not there. Can you please check again?
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Assignee Umesh Kadam [ umesh.kadam ] Rajendra Joshi [ rajendraj ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Attachment screenshot-1.png [ 24821 ]
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

          Checked and error is coming

          See error log:-

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

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Checked and error is coming See error log:- ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->BenAdminControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetReviewChangesForEmployee ErrorMessage: Incorrect syntax near 'UNION'.
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rajendra Joshi [ rajendraj ] Umesh Kadam [ umesh.kadam ]
          gokul.sonawane Gokul Sonawane (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          Hide
          Permalink
          umesh.kadam Umesh Kadam (Inactive) added a comment -

          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

          Show
          umesh.kadam Umesh Kadam (Inactive) added a comment - 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
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Assignee Umesh Kadam [ umesh.kadam ] Rakesh Roy [ rakeshr ]
          Code Reviewed By Neelam Yangal [ 11911 ]
          Dev Due Date 22/Aug/2016 24/Aug/2016
          Developer Umesh Kadam [ umesh.kadam ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Attachment Pass.png [ 25047 ]
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

          Not getting server error.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Not getting server error.
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          rakeshr Rakesh Roy (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Rakesh Roy [ rakeshr ] Rajendra Joshi [ rajendraj ]
          gokul.sonawane Gokul Sonawane (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          Hide
          Permalink
          rajendraj 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.

          Show
          rajendraj 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.
          rajendraj Rajendra Joshi (Inactive) made changes -
          Attachment Pending Queue_Server error.png [ 25614 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Attachment Pending Queue_Server error.png [ 25615 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Attachment Pending Queue_Server error.png [ 25614 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Attachment Pending Queue_Server error_ASML.png [ 25617 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Resolution Unresolved [ 10200 ]
          Status Stage Testing [ 10201 ] Reopen in Stage [ 10023 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Re-open(10216)
          rajendraj Rajendra Joshi (Inactive) made changes -
          Assignee Rajendra Joshi [ rajendraj ] Umesh Kadam [ umesh.kadam ]
          Hide
          Permalink
          rajendraj 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.

          Show
          rajendraj 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.
          Hide
          Permalink
          umesh.kadam Umesh Kadam (Inactive) added a comment -

          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

          Show
          umesh.kadam Umesh Kadam (Inactive) added a comment - 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
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Assignee Umesh Kadam [ umesh.kadam ] Rajendra Joshi [ rajendraj ]
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Dev Due Date 24/Aug/2016 30/Aug/2016
          umesh.kadam Umesh Kadam (Inactive) made changes -
          Dev Due Date 30/Aug/2016 24/Aug/2016
          Hide
          Permalink
          rajendraj 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.

          Show
          rajendraj 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.
          rajendraj Rajendra Joshi (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Re-open(10216) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          rajendraj Rajendra Joshi (Inactive) made changes -
          Status Reopen in Stage [ 10023 ] In Development [ 10007 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          satyap Satya made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          Hide
          Permalink
          rajendraj 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.

          Show
          rajendraj 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.
          rajendraj Rajendra Joshi (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production Complete(10222)
          rajendraj Rajendra Joshi (Inactive) made changes -
          Resolution Unresolved [ 10200 ] Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          rajendraj Rajendra Joshi (Inactive) made changes -
          Assignee Rajendra Joshi [ rajendraj ] Rakesh Roy [ rakeshr ]
          Transition Time In Source Status Execution Times
          Satya made transition -
          Open In Development
          		3h 32m 1
          Rajendra Joshi (Inactive) made transition -
          In LB Testing Reopen in Local
          		9d 8h 47m 2
          surender kumar (Inactive) made transition -
          Reopen in Local In Development
          		17d 19h 39m 2
          Rajendra Joshi (Inactive) made transition -
          Stage Testing Reopened in Stage
          		4s 1
          Rajendra Joshi (Inactive) made transition -
          Reopened in Stage In Development
          		19h 42m 1
          Rajendra Joshi (Inactive) made transition -
          In Development In LB Testing
          		30d 3h 21m 4
          Rajendra Joshi (Inactive) made transition -
          In LB Testing Stage Testing
          		5d 18h 27m 2
          Rajendra Joshi (Inactive) made transition -
          Stage Testing In Production Testing
          		13d 2h 35m 1
          Rajendra Joshi (Inactive) made transition -
          In Production Testing Production Complete
          		8m 8s 1

            People

            Assignee:
            rakeshr Rakesh Roy (Inactive)
            Reporter:
            rakeshr Rakesh Roy (Inactive)
            Account Executive:
            Evan Tuckey (Inactive)
            Developer:
            Umesh Kadam (Inactive)
            QA:
            Rajendra Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Pre-Prod Due Date:
              Production Due Date: