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
          venkatesh.pujari Venkatesh Pujari (Inactive) created issue -
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Field Original Value New Value
          Link This issue blocks WT-10195 [ WT-10195 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Attachment DateFormatIssue.png [ 59932 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          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.

          		 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
          Permalink
          vishal.bajad Vishal Bajad (Inactive) logged work - 06/Sep/17 02:31 PM
          • Time Spent:
            2h
             

            Analysis and understanding business logic

          vishal.bajad Vishal Bajad (Inactive) made changes -
          Remaining Estimate 0h [ 0 ]
          Time Spent 2h [ 7200 ]
          Worklog Id 77170 [ 77170 ]
          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 !
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208)
          Original Estimate 0h [ 0 ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Code Reviewed By Jaideep Vinchurkar [ 11908 ]
          Dev Due Date 08/Sep/2017
          Developer Vishal Bajad [ vishal.bajad ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Assignee Vishal Bajad [ vishal.bajad ] Jaideep Vinchurkar [ jaideep.vinchurkar ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Status Open [ 1 ] In Development [ 10007 ]
          Permalink
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) logged work - 07/Sep/17 10:29 AM
          • Time Spent:
            0.5h
             
            <No comment>
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Code Review Date 07/Sep/2017
          Item State Parent values: Development(10200)Level 1 values: Ready for Review(10208) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          Sprint WT Sprint 36 - Bugs [ 84 ]
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Time Spent 2h [ 7200 ] 2.5h [ 9000 ]
          Worklog Id 77352 [ 77352 ]
          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
          jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
          Assignee Jaideep Vinchurkar [ jaideep.vinchurkar ] Vishal Bajad [ vishal.bajad ]
          Permalink
          vishal.bajad Vishal Bajad (Inactive) logged work - 07/Sep/17 02:11 PM
          • Time Spent:
            2h
             

            Analysis , understanding business logic and unit testing.

          vishal.bajad Vishal Bajad (Inactive) made changes -
          Time Spent 2.5h [ 9000 ] 4.5h [ 16200 ]
          Worklog Id 77482 [ 77482 ]
          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)
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Assignee Vishal Bajad [ vishal.bajad ] Venkatesh Pujari [ venkatesh.pujari ]
          vishal.bajad Vishal Bajad (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          khandu.kshirsagar Khandu Kshirsagar (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)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          Permalink
          venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 18/Sep/17 12:09 PM
          • Time Spent:
            10m
             

            Testing on Stage

          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
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 4.5h [ 16200 ] 4h 40m [ 16800 ]
          Worklog Id 79267 [ 79267 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
          satyap Satya made changes -
          Labels View_History
          satyap Satya made changes -
          Environment_New LB [ 18444 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
          Permalink
          venkatesh.pujari Venkatesh Pujari (Inactive) logged work - 14/Mar/18 09:04 AM
          • Time Spent:
            10m
             
            <No comment>
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Resolution Bug Fixed [ 10402 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          venkatesh.pujari Venkatesh Pujari (Inactive) made changes -
          Time Spent 4h 40m [ 16800 ] 4h 50m [ 17400 ]
          Worklog Id 108219 [ 108219 ]
          Transition Time In Source Status Execution Times
          Jaideep Vinchurkar (Inactive) made transition -
          Open In Development
          		10d 11m 1
          Vishal Bajad (Inactive) made transition -
          In Development In LB Testing
          		1d 1h 53m 1
          Venkatesh Pujari (Inactive) made transition -
          In LB Testing Stage Testing
          		10d 57m 1
          Venkatesh Pujari (Inactive) made transition -
          Stage Testing In Production Testing
          		176d 20h 55m 1
          Venkatesh Pujari (Inactive) made transition -
          In Production Testing Production Complete
          		5m 49s 1
          Venkatesh Pujari (Inactive) made transition -
          Production Complete Closed
          		2s 1

            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