New Features 2017Project Type: software

New Features 2017

Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-5155

Running a census report and receiving a server encountered internal error

    Details

    • Type: Bug
    • Status: Stage Testing
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      Others
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Employee
    • Module:
      BenAdmin - Report
    • Reported by:
      Client
    • Company:
      All Clients/Multiple Clients
    • Item State:
      Stage QA - Stage Deployed
    • Issue Importance:
      Must Have
    • UAT For:
      UI Refresh

      Description

      Hello,
      The CE was trying to run a Census Report on DC Taylor Co and when I click directly on the Census Report so that I can edit the report I am receiving Server encountered internal error. I click ok and then it shows me a window that says Return to Home Page.


      This is also happening to Oceanside. Please advise

      Please ref: CT-2763

        Attachments

        1. WT-11524.jpg
          70 kB
          Parmeshwar Jumbad
        2. WT-11524 (c7d08351-2f9a-41be-afa4-8b8442169869).jpg
          70 kB
          Parmeshwar Jumbad
        3. report issue.png
          47 kB
          Prajakta Belhe

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. WT-11524 Running a census report and receiving a server encountered internal error

          • Medium - Has the potential to affect progress.
          • Closed

            Activity

            Ascending order - Click to sort in descending order
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) created issue -
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Field Original Value New Value
            Assignee Nidhi Kaul [ nidhi.kaul ] Prasanna Karlekar [ prasanna ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Link This issue relates to WT-11524 [ WT-11524 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Description Hello,
            The CE was trying to run a Census Report on DC Taylor Co and when I click directly on the Census Report so that I can edit the report I am receiving Server encountered internal error. I click ok and then it shows me a window that says Return to Home Page.
             !image-2017-10-09-15-22-27-008.png|thumbnail!

            This is also happening to Oceanside. Please advise

            Please ref: CT-2763             		Hello,
            The CE was trying to run a Census Report on DC Taylor Co and when I click directly on the Census Report so that I can edit the report I am receiving Server encountered internal error. I click ok and then it shows me a window that says Return to Home Page.


            This is also happening to Oceanside. Please advise

            Please ref: CT-2763
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment WT-11524.jpg [ 68434 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Description Hello,
            The CE was trying to run a Census Report on DC Taylor Co and when I click directly on the Census Report so that I can edit the report I am receiving Server encountered internal error. I click ok and then it shows me a window that says Return to Home Page.


            This is also happening to Oceanside. Please advise

            Please ref: CT-2763             		Hello,
            The CE was trying to run a Census Report on DC Taylor Co and when I click directly on the Census Report so that I can edit the report I am receiving Server encountered internal error. I click ok and then it shows me a window that says Return to Home Page.

             !WT-11524.jpg|thumbnail!
            This is also happening to Oceanside. Please advise

            Please ref: CT-2763
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Attachment WT-11524 (c7d08351-2f9a-41be-afa4-8b8442169869).jpg [ 68435 ]
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            [~parmeshwar.jumbade]
            Is this for a missed check-in?

            Jyoti Agrawal

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - [~parmeshwar.jumbade] Is this for a missed check-in? Jyoti Agrawal
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Yes Nidhi Kaul, This is from list of missed check-in into UI refresh branch.

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Yes Nidhi Kaul , This is from list of missed check-in into UI refresh branch.
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            The related ticket WT-11524 is not in production yet. Is there a reason we are taking this up?

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - The related ticket WT-11524 is not in production yet. Is there a reason we are taking this up?
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            Hi Nidhi Kaul

            The changes we have done to resolve this issue. same changes need to merge into new UI refresh branch. That's the only reason we have taking this up.

            CC: Prasanna Karlekar Jyoti Agrawal

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - Hi Nidhi Kaul The changes we have done to resolve this issue. same changes need to merge into new UI refresh branch. That's the only reason we have taking this up. CC: Prasanna Karlekar Jyoti Agrawal
            prasanna Prasanna Karlekar (Inactive) made changes -
            Assignee Prasanna Karlekar [ prasanna ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207)
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            This JIRA marked as On-Hold due to WT-11524 is not deployed on production.

            CC: Prasanna Karlekar Gaurav Sodani

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - This JIRA marked as On-Hold due to WT-11524 is not deployed on production. CC: Prasanna Karlekar Gaurav Sodani
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            [~parmeshwar.jumbade]
            Please go ahead and fix this since it is a bug.

            Nidhi.

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - [~parmeshwar.jumbade] Please go ahead and fix this since it is a bug. Nidhi.
            nidhi.kaul Nidhi Kaul (Inactive) made changes -
            Issue Importance Good To Have [ 11802 ] Must Have [ 11800 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: On Hold(10207) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment -

            For more details (i.e. 3C's, Affected areas, Tested scenarios, etc.) please refer main JIRA i.e. WT-11524.

            CC: Prasanna Karlekar Gaurav Sodani

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - For more details (i.e. 3C's, Affected areas, Tested scenarios, etc.) please refer main JIRA i.e. WT-11524 . CC: Prasanna Karlekar Gaurav Sodani
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sachin Hingole [ sachin.hingole ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 27/Dec/17 05:22 AM
            • Time Spent:
              1.5h
               

              Code check-in into UI refresh development & code-map branch

            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 1.5h [ 5400 ]
            Worklog Id 97956 [ 97956 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Permalink
            Prajakta.belhe Prajakta Belhe (Inactive) logged work - 28/Dec/17 08:10 AM
            • Time Spent:
              0.5h
               

              testing

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Attachment report issue.png [ 70920 ]
            Hide
            Permalink
            Prajakta.belhe Prajakta Belhe (Inactive) added a comment - - edited

            Reopening this issue. Not working as expected on CodeMap. Please refer attached screenshot.

            Checked this on For QA-El Camino Hospital-Azure company since Oceanside and DC Taylor not available on CodeMap

            CC- Sachin Hingole

            Show
            Prajakta.belhe Prajakta Belhe (Inactive) added a comment - - edited Reopening this issue. Not working as expected on CodeMap. Please refer attached screenshot. Checked this on For QA-El Camino Hospital-Azure company since Oceanside and DC Taylor not available on CodeMap CC- Sachin Hingole
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Status Local Testing [ 10200 ] Reopen in Local [ 10018 ]
            Hide
            Permalink
            nidhi.kaul Nidhi Kaul (Inactive) added a comment -

            Prajakta Belhe
            Why is this assigned to Sachin if this is reopened?

            Sachin Hingole

            Show
            nidhi.kaul Nidhi Kaul (Inactive) added a comment - Prajakta Belhe Why is this assigned to Sachin if this is reopened? Sachin Hingole
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Assignee Sachin Hingole [ sachin.hingole ] Parmeshwar Jumbad [ parmeshwar.jumbade ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Status Reopen in Local [ 10018 ] In Development [ 10007 ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: Development(10200)Level 1 values: In Analysis(10204)
            Hide
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited

            Hi Prajakta Belhe,

            This issue not related to our fixes.

            Below are the 3Cs:
            Concern: Query execution failed for data-set during report processing.
            Cause: Incorrect database object schema for view (i..e OES_VIEW_Employee_AffidavitData) was present into DB for this company.
            Correction: Corrected view (i.e. OES_VIEW_Employee_AffidavitData) schema for this company.

            Sheetal Bodhale,
            Could you please find out root cause why this is formed as incorrect? There was a one column (i..e with name test2211) selected in view but same column was not available into DB main table used in view. It seems that column has been deleted from main table after view creation.

            Note: For now i have removed problematic column from view for this company. I will share original view definition (i.e. original & updated schema) with you via separate email.

            CC: Prasanna Karlekar Gaurav Sodani

            Show
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) added a comment - - edited Hi Prajakta Belhe , This issue not related to our fixes. Below are the 3Cs : Concern : Query execution failed for data-set during report processing. Cause : Incorrect database object schema for view (i..e OES_VIEW_Employee_AffidavitData) was present into DB for this company. Correction : Corrected view (i.e. OES_VIEW_Employee_AffidavitData) schema for this company. Sheetal Bodhale , Could you please find out root cause why this is formed as incorrect? There was a one column (i..e with name test2211) selected in view but same column was not available into DB main table used in view. It seems that column has been deleted from main table after view creation. Note: For now i have removed problematic column from view for this company. I will share original view definition (i.e. original & updated schema) with you via separate email. CC: Prasanna Karlekar Gaurav Sodani
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Assignee Parmeshwar Jumbad [ parmeshwar.jumbade ] Sheetal Bodhale [ sheetal.bodhale ]
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) made changes -
            Time Spent 1.5h [ 5400 ] 4.25h [ 15300 ]
            Worklog Id 98511 [ 98511 ]
            Prajakta.belhe Prajakta Belhe (Inactive) made changes -
            Time Spent 4.25h [ 15300 ] 4.75h [ 17100 ]
            Worklog Id 98556 [ 98556 ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            Permalink
            parmeshwar.jumbad Parmeshwar Jumbad (Inactive) logged work - 30/Dec/17 06:58 AM
            • Time Spent:
              2.75h
               

              Issue Analysis & Internal discussion with Prasanna
              Fix issue for company & JIRA update

            khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Assignee Sheetal Bodhale [ sheetal.bodhale ] Swapnil Pandhare [ swapnil.pandhare ]
            sachin.hingole Sachin Hingole (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
            Assignee Swapnil Pandhare [ swapnil.pandhare ]
            Transition Time In Source Status Execution Times
            Parmeshwar Jumbad (Inactive) made transition -
            Open In Development
            		32d 21h 51m 1
            Prajakta Belhe (Inactive) made transition -
            In LB Testing Reopen in Local
            		1d 5h 57m 1
            Parmeshwar Jumbad (Inactive) made transition -
            Reopen in Local In Development
            		18h 6m 1
            Sachin Hingole (Inactive) made transition -
            In Development In LB Testing
            		1d 47m 2
            Sachin Hingole (Inactive) made transition -
            In LB Testing Stage Testing
            		26d 2h 37m 1

              People

              Assignee:
              Unassigned
              Reporter:
              parmeshwar.jumbad Parmeshwar Jumbad (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4.75h
                  4.75h