WORKTERRAProject Type: software

WORKTERRA

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

WT:- Company level :- View history for Plandesign Eligibility Rules displaying server error

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Medium
    • Resolution: Bug Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
    • Environment:
      QA
    • Bug Type:
      Functional
    • Bug Severity:
      Medium
    • Level:
      Partner
    • Module:
      BenAdmin - Customization
    • Reported by:
      Harbinger
    • Item State:
      Stage QA - Production Deployment on Hold
    • Browser:
      Google Chrome
    • Sprint:
      WT Sprint 36 - Bugs

      Description

      Steps:-
      1] Log onto LB site
      2] Search and select For QA ASML For Hspl company
      3] Click on View History on company level
      4] Enter valid date range , select document type as Benefits and select Plandesign Eligibility Rules from Document Sub Type and click on Search button

      Actual Result:-
      Server error is displayed on click of Search button

      Error Log is as below:-

      ErrorID : 0
      ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CompanyCollection.GetGlobalHistoryInformationCollection->CompanyCollection.CreateDataForGlobalHistory->CompanyCollection.CheckPageModification
      ErrorMessage: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.

      Please find the attached screen shot it seems to be an issue with the date format

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          vishal.bajad Vishal Bajad (Inactive) added a comment - - edited

          Hi All ,

          Please find details as below ,

          Concern : View history for Plan design Eligibility Rules displaying server error

          Cause : This issues is because of converting date to "MM/DD/YYYY" format. if Date format selected "DD/MM/YYYY" or "YYYY/MM/DD" on Partner/Broker User Information screen , this type should be handled while converting to "MM/DD/YYYY"

          Correction : We have provided code fix and its under review.

          Impacted Area : Date format on Company level view history page will show as per customization on Partner/Broker User Information screen but data processing we consider default ( "MM/DD/YYYY" ) Date format.

          Test Scenario:
          We have Checked with all default date format ( MM/DD/YYYY , YYYY/MM/DD , DD/MM/YYYY)

          Admin Login: Home -> Company home ->view history

          • From Date : Provided , To Date : Provided - > Result : Pass
          • From Date : Not Provided, To Date : Provided - > Result : Pass
          • From Date : Provided , To Date : Not Provided - > Result : Pass
          • From Date : Not Provided, To Date : Not Provided - > Result : Pass

          Partner Login: Home -> Company home ->view history

          • From Date : Provided , To Date : Provided - > Result : Pass
          • From Date : Not Provided, To Date : Provided - > Result : Pass
          • From Date : Provided , To Date : Not Provided - > Result : Pass
          • From Date : Not Provided, To Date : Not Provided - > Result : Pass

          Affected Files :

          • \Web\Web Projects\WORKTERRA\Areas\UserDetails\Models\ViewHistory\AddHistoryCriteriaModel.cs

          Jaideep Vinchurkar Please have a review.

          Thanks !

          Show
          vishal.bajad Vishal Bajad (Inactive) added a comment - - edited Hi All , Please find details as below , Concern : View history for Plan design Eligibility Rules displaying server error Cause : This issues is because of converting date to "MM/DD/YYYY" format. if Date format selected "DD/MM/YYYY" or "YYYY/MM/DD" on Partner/Broker User Information screen , this type should be handled while converting to "MM/DD/YYYY" Correction : We have provided code fix and its under review. Impacted Area : Date format on Company level view history page will show as per customization on Partner/Broker User Information screen but data processing we consider default ( "MM/DD/YYYY" ) Date format. Test Scenario : We have Checked with all default date format ( MM/DD/YYYY , YYYY/MM/DD , DD/MM/YYYY) Admin Login: Home -> Company home ->view history From Date : Provided , To Date : Provided - > Result : Pass From Date : Not Provided, To Date : Provided - > Result : Pass From Date : Provided , To Date : Not Provided - > Result : Pass From Date : Not Provided, To Date : Not Provided - > Result : Pass Partner Login: Home -> Company home ->view history From Date : Provided , To Date : Provided - > Result : Pass From Date : Not Provided, To Date : Provided - > Result : Pass From Date : Provided , To Date : Not Provided - > Result : Pass From Date : Not Provided, To Date : Not Provided - > Result : Pass Affected Files : \Web\Web Projects\WORKTERRA\Areas\UserDetails\Models\ViewHistory\AddHistoryCriteriaModel.cs Jaideep Vinchurkar Please have a review. Thanks !
          Hide
          Permalink
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment -

          Good to LB Check-in

          Show
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) added a comment - Good to LB Check-in
          Hide
          Permalink
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment -

          Hi Vishal Bajad,

          Verified this issue on Stage on AFI For Hspl company. Now no server error is displayed on View History for Plan Design Eligibility Rules.

          Thanks,
          Venkatesh

          Show
          venkatesh.pujari Venkatesh Pujari (Inactive) added a comment - Hi Vishal Bajad , Verified this issue on Stage on AFI For Hspl company. Now no server error is displayed on View History for Plan Design Eligibility Rules. Thanks, Venkatesh

            People

            Assignee:
            venkatesh.pujari Venkatesh Pujari (Inactive)
            Reporter:
            venkatesh.pujari Venkatesh Pujari (Inactive)
            Developer:
            Vishal Bajad (Inactive)
            QA:
            Venkatesh Pujari (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Dev Due Date:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 0h
                0h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 4h 50m
                4h 50m