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

Unable to Add Generic Eligibility

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Environment:
      QA
    • Module:
      ACA
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Issue Importance:
      Must Have

      Description

      Company - " City of Redding For HSPL"

      Step:-
      1.Login to application
      2.Search and select company
      3.Navigate to Customizer > Eligibility Rules
      4.Click on Add New
      5.Fill all details (Add Additional Eligibility on SSN ) and click on Save

      Expected - Application should save Generic Eligibility Rule

      Actual - Application did not save Generic Eligibility

      Actual -
      Error Log -
      ErrorID : 0
      ErrorSource : ControllerAppTier.SaveAndGetData->WORKTERRAControllerAppTier.SaveAndGetData->GenericEligibilityRule.Save->GenericEligibilityRule.InsertUpdate_GenericEligibilityRules->GenericEligibilityRule.GetExistingRuleNameForSelectedCriteria
      ErrorMessage: Trying to pass a table-valued parameter with 7 column(s) where the corresponding user-defined table type requires 9 column(s).

        Attachments

          Activity

          mahendra.mungase Mahendra Mungase (Inactive) created issue -
          Show
          mahendra.mungase Mahendra Mungase (Inactive) added a comment - Sachin Hingole Rakesh Roy
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Field Original Value New Value
          Assignee Amruta Lohiya [ amruta.baheti ] Varsha Shejawal [ varsha.shejawal ]
          varsha.shejawal Varsha Shejawal (Inactive) made changes -
          Assignee Varsha Shejawal [ varsha.shejawal ] Vinanti Yadav [ vinanti.yadav ]
          Hide
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - - edited

          Concern : Server error during the adding new GenericEligibilityRule

          Cause :we add two fields in GenericAdditionalCriteria and TVP_AdditionalCriteria. while checking duplicate GenericEligibilityRule we pass AdditionalCriteria Parameter as datatable to OES_UDF_GetDuplicateEligibilityRuleID .But code changes related to that column is not added in code that why error gets displayed.

          Correction : code related to that columns are are added in function which is used to create data table for GenericAdditionalCriteria.

          Show
          vinanti.yadav Vinanti Yadav (Inactive) added a comment - - edited Concern : Server error during the adding new GenericEligibilityRule Cause :we add two fields in GenericAdditionalCriteria and TVP_AdditionalCriteria. while checking duplicate GenericEligibilityRule we pass AdditionalCriteria Parameter as datatable to OES_UDF_GetDuplicateEligibilityRuleID .But code changes related to that column is not added in code that why error gets displayed. Correction : code related to that columns are are added in function which is used to create data table for GenericAdditionalCriteria.
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Assignee Vinanti Yadav [ vinanti.yadav ] Mahendra Mungase [ mahendra.mungase ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          Hide
          mahendra.mungase Mahendra Mungase (Inactive) added a comment -

          We have regressed this issue on LB- City of Redding For HSPL and observed that issue does not exist.Hence closing the same on LB.

          Show
          mahendra.mungase Mahendra Mungase (Inactive) added a comment - We have regressed this issue on LB- City of Redding For HSPL and observed that issue does not exist.Hence closing the same on LB.
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Component/s ACA [ 10004 ]
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          sachin.hingole Sachin Hingole (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: On Hold(10211)
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: On Hold(10211) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          Hide
          mahendra.mungase Mahendra Mungase (Inactive) added a comment -

          Currently it is on Pre Stage and Development team will take decision to deploy on Stage.
          Hence assigning to Vinanti Yadav.She wil assign back to Mahendra Mungase once it deploy on Stage.

          Show
          mahendra.mungase Mahendra Mungase (Inactive) added a comment - Currently it is on Pre Stage and Development team will take decision to deploy on Stage. Hence assigning to Vinanti Yadav .She wil assign back to Mahendra Mungase once it deploy on Stage.
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Assignee Mahendra Mungase [ mahendra.mungase ] Vinanti Yadav [ vinanti.yadav ]
          vinanti.yadav Vinanti Yadav (Inactive) made changes -
          Dev Due Date 30/May/2016
          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Vinanti Yadav Mahendra Mungase What's the plan? Sachin Hingole Amruta Lohiya Vijay Siddha
          rakeshr Rakesh Roy (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)
          rakeshr Rakesh Roy (Inactive) made changes -
          Assignee Vinanti Yadav [ vinanti.yadav ] Mahendra Mungase [ mahendra.mungase ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          Hide
          rakeshr Rakesh Roy (Inactive) added a comment -

          This will deploy on production with generic eligibility component.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - This will deploy on production with generic eligibility component.
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
          satyap Satya made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          Hide
          mahendra.mungase Mahendra Mungase (Inactive) added a comment -

          Company - AH For HSPL

          We have regressed this issue on Production and observed that issue does not exits.Hence closing the same.

          Show
          mahendra.mungase Mahendra Mungase (Inactive) added a comment - Company - AH For HSPL We have regressed this issue on Production and observed that issue does not exits.Hence closing the same.
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Resolution Done [ 10000 ] Fixed [ 1 ]
          Status Production Complete [ 10028 ] Closed [ 6 ]
          mahendra.mungase Mahendra Mungase (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          satyap Satya made changes -
          Environment_New LB [ 18444 ]
          Transition Time In Source Status Execution Times
          Mahendra Mungase (Inactive) made transition -
          Open In Development
          4d 22h 50m 1
          Mahendra Mungase (Inactive) made transition -
          In Development In LB Testing
          4s 1
          Rakesh Roy (Inactive) made transition -
          In LB Testing Stage Testing
          61d 5h 40m 1
          Mahendra Mungase (Inactive) made transition -
          Stage Testing In Production Testing
          35d 11h 38m 1
          Mahendra Mungase (Inactive) made transition -
          In Production Testing Production Complete
          4m 25s 1
          Mahendra Mungase (Inactive) made transition -
          Production Complete Closed
          18s 1

            People

            Assignee:
            mahendra.mungase Mahendra Mungase (Inactive)
            Reporter:
            mahendra.mungase Mahendra Mungase (Inactive)
            Developer:
            Amruta Lohiya
            QA:
            Mahendra Mungase (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date: