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

Server Error after ACA_Worxtime_Coverage template Export on code map

    Details

    • Type: Bug
    • Status: Rejected
    • Priority: High
    • Resolution: System Behaviour
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI Refresh
    • Labels:
      None
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Blocker
    • Level:
      Admin
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Company:
      Ashgrove
    • Item State:
      Development - In Analysis
    • Browser:
      Google Chrome

      Description

      Environment - CodeMap

      Company - For QA KinderCare

      Export Template- ACA_Worxtime_Coverage

      Step:-
      1.Login with SA
      2.Navigate to Import/Export
      3.Select Export radio button
      4.Select template - ACA_Worxtime_Coverage
      5.Enter 01/01/2017 – 12/31/2017
      6.Click on Export

      Actual - Server Error populate

      Expected - File should be export

        Attachments

          Activity

          mahendra.mungase Mahendra Mungase (Inactive) created issue -
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Field Original Value New Value
          Link This issue is caused by WT-11873 [ WT-11873 ]
          Hide
          nidhi.kaul Nidhi Kaul (Inactive) added a comment -

          Yogesh Chaudhari
          Please look at this on priority.

          Nidhi.
          Ramya Tantry

          Show
          nidhi.kaul Nidhi Kaul (Inactive) added a comment - Yogesh Chaudhari Please look at this on priority. Nidhi. Ramya Tantry
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          Hope below is error log for this

          ErrorID : 0
          ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ACAExportProcessRowwise.ExportData->ACAExportProcessRowwise.FillDataIntoDataTable
          ErrorMessage: The multi-part identifier "OES_VIEW_ACA_Export_WEFEmployeeEligibility.CoverageStartDate" could not be bound.
          The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.EligibilityEmployeeCost" could not be bound.
          The multi-part identifier "OES_VIEW_ACA_Export_WEFEmployeeEligibility.EventDate" could not be bound.
          The multi-part identifier "OES_VIEW_ACA_Export_WEFEmployeeEligibility.CoverageStartDate" could not be bound.
          The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.EligibilityEmployeeCost" could not be bound.
          The multi-part identifier "OES_VIEW_ACA_Export_WEFEmployeeEligibility.EventDate" could not be bound.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Hope below is error log for this ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->ExecuteExportDTS.ExportData_Isolated->WTIsolatedRoutines.Main->ExecuteExportDTS.ExportData->ACAExportProcessRowwise.ExportData->ACAExportProcessRowwise.FillDataIntoDataTable ErrorMessage: The multi-part identifier "OES_VIEW_ACA_Export_WEFEmployeeEligibility.CoverageStartDate" could not be bound. The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.EligibilityEmployeeCost" could not be bound. The multi-part identifier "OES_VIEW_ACA_Export_WEFEmployeeEligibility.EventDate" could not be bound. The multi-part identifier "OES_VIEW_ACA_Export_WEFEmployeeEligibility.CoverageStartDate" could not be bound. The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.EligibilityEmployeeCost" could not be bound. The multi-part identifier "OES_VIEW_ACA_Export_WEFEmployeeEligibility.EventDate" could not be bound.
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Assignee Yogesh Chaudhari [ yogesh.chaudhari ] Revansiddha Gaur [ revansiddha.gaur ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Attachment NF_5443.png [ 69762 ]
          Hide
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment -

          Hi,

          CONCERN: While exporting gettting an error.
          Error Details:
          Exception : The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.EligibilityEmployeeCost" could not be bound.The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.EligibilityEmployeeCost" could not be bound.

          CAUSE:

          Nothing is deployed on Ui-Refresh against the Jira ID-WT-11873. Testing is going on.

          As our discussion with Nidhi Kaul, we should be checked in to UiRefresh branch only while checking in to production branch the JIRA ID WT-11873. So due to absence of a code against the JIRA ID WT-11873, above exception is throwing. In template, there is mapped the field which functionality belongs to WT-11873.

          CORRECTION: Unmap the field "ACA Export MinimumCostPlan ACA Min Plan Employee Cost" from Spouse/Child sub templates, export functionality will work without breakage.

          Thanks,
          Revan
          CC- Nidhi Kaul, Yogesh Chaudhari,Nandkumar Prabhakar Karlekar, Smita Pawar, Sachin Hingole

          Show
          revansiddha.gaur Revansiddha Gaur (Inactive) added a comment - Hi, CONCERN: While exporting gettting an error. Error Details: Exception : The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.EligibilityEmployeeCost" could not be bound.The multi-part identifier "OES_VIEW_ACA_MinimumCostPlan.EligibilityEmployeeCost" could not be bound. CAUSE: Nothing is deployed on Ui-Refresh against the Jira ID-WT-11873. Testing is going on. As our discussion with Nidhi Kaul , we should be checked in to UiRefresh branch only while checking in to production branch the JIRA ID WT-11873. So due to absence of a code against the JIRA ID WT-11873, above exception is throwing. In template, there is mapped the field which functionality belongs to WT-11873. CORRECTION: Unmap the field "ACA Export MinimumCostPlan ACA Min Plan Employee Cost" from Spouse/Child sub templates, export functionality will work without breakage. Thanks, Revan CC- Nidhi Kaul , Yogesh Chaudhari , Nandkumar Prabhakar Karlekar , Smita Pawar , Sachin Hingole
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Assignee Revansiddha Gaur [ revansiddha.gaur ] Mahendra Mungase [ mahendra.mungase ]
          Resolution System Behaviour [ 10100 ]
          Status In Development [ 10007 ] Rejected [ 10004 ]
          ramya.tantry Ramya Tantry (Inactive) logged work - 11/Dec/17 09:17 AM
          • Time Spent:
            0.5h
             

            Analysis and issue discussion

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 0.5h [ 1800 ]
          Worklog Id 95552 [ 95552 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) made changes -
          Time Spent 0.5h [ 1800 ] 5h [ 18000 ]
          Worklog Id 95649 [ 95649 ]
          smita.pawar Smita Pawar (Inactive) logged work - 11/Dec/17 01:30 PM
          • Time Spent:
            0.5h
             

            Internal discussion

          smita.pawar Smita Pawar (Inactive) made changes -
          Time Spent 5h [ 18000 ] 5.5h [ 19800 ]
          Worklog Id 95674 [ 95674 ]
          revansiddha.gaur Revansiddha Gaur (Inactive) logged work - 11/Dec/17 10:00 PM
          • Time Spent:
            4.5h
             

            Discussion, analysis & reply to the jira.

          Transition Time In Source Status Execution Times
          Revansiddha Gaur (Inactive) made transition -
          Open In Development
          2d 19h 58m 1
          Revansiddha Gaur (Inactive) made transition -
          In Development Rejected
          57m 55s 1

            People

            Assignee:
            mahendra.mungase Mahendra Mungase (Inactive)
            Reporter:
            mahendra.mungase Mahendra Mungase (Inactive)
            Developer:
            Yogesh Chaudhari (Inactive)
            QA:
            Mahendra Mungase (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

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