Details

    • Type: Bug
    • Status: Production Complete
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: BenAdmin
    • Labels:
      None
    • Environment:
      Stage
    • Bug Type:
      Functional
    • Bug Severity:
      Critical
    • Level:
      Employee
    • Module:
      BenAdmin - EDS
    • Reported by:
      Support
    • Item State:
      Development - In Analysis
    • Browser:
      IE 11

      Description

      Hi all -

      I'm getting a server error in trying to view history in Stage for multiple employees for EcoATM.

      We are doing a demo for this group tomorrow morning and I really need to make sure everything works seamlessly.

      Thanks!
      Jen

        Attachments

          Issue Links

            Activity

            jennifer.leugers Jennifer Leugers created issue -
            rakeshr Rakesh Roy (Inactive) made changes -
            Field Original Value New Value
            Module Parent values: BenAdmin(10100) Parent values: BenAdmin(10100)Level 1 values: EDS(10108)
            rakeshr Rakesh Roy (Inactive) made changes -
            Component/s BenAdmin [ 10000 ]
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Error log seems to be

            ErrorID : 0
            ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetHistoryInformationCollection->CollectionManager.EnrollmentHistoryCollection
            ErrorMessage: Index and length must refer to a location within the string.
            Parameter name: length
            StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
            at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput)
            TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Error log seems to be ErrorID : 0 ErrorSource : ControllerAppTier.GetCollection->WORKTERRAControllerAppTier.GetData->CollectionManager.GetCollection->CollectionManager.GetHistoryInformationCollection->CollectionManager.EnrollmentHistoryCollection ErrorMessage: Index and length must refer to a location within the string. Parameter name: length StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.GetCollection(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.GetCollection(Int32 intProjectsId, String strInput) TargetSite: System.String GetCollection(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)
            Hide
            rakeshr Rakesh Roy (Inactive) added a comment -

            Other error log :-

            ErrorID : 0
            ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->UserDefinedField.Save->UserDefinedField.UpdateFieldSequence
            ErrorMessage: Invalid column name 'PleasePickfromthe3Options321176'.
            Invalid column name 'FavoriteCity111176'.
            StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
            at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput)
            TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

            Please check this also..

            Show
            rakeshr Rakesh Roy (Inactive) added a comment - Other error log :- ErrorID : 0 ErrorSource : ControllerAppTier.Save->WORKTERRAControllerAppTier.Save->UserDefinedField.Save->UserDefinedField.UpdateFieldSequence ErrorMessage: Invalid column name 'PleasePickfromthe3Options321176'. Invalid column name 'FavoriteCity111176'. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Save(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Save(Int32 intProjectsId, String strInput) TargetSite: System.String Save(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity) Please check this also..
            jaideep.vinchurkar Jaideep Vinchurkar (Inactive) made changes -
            Assignee Vijay Siddha [ vijays ] Vishal Bajad [ vishal.bajad ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status Open [ 1 ] In Development [ 10007 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Item State Parent values: Development(10200)Level 1 values: In Analysis(10204)
            sheetal.bodhale Sheetal Bodhale (Inactive) made changes -
            Remaining Estimate 0h [ 0 ]
            Time Spent 20m [ 1200 ]
            Worklog Id 70029 [ 70029 ]
            Hide
            vishal.bajad Vishal Bajad (Inactive) added a comment - - edited

            Hi ,

            This is because of data corrupted as well as code failure, we have done with data correction and its working fine except Evan Form. mean while we have provided work around and code fix will be deployed on next deployment patch.

            Followings issues were observed and fixed for employee level history ,

            • ErrorMessage: Index and length must refer to a location within the string.
            • ErrorMessage: Invalid column name 'PleasePickfromthe3Options321176'.
            • ErrorMessage: Invalid column name 'FavoriteCity111176'.
            • ErrorMessage: EVAN Form Incorrect syntax near the keyword 'AND'.
            • ErrorMessage: Incorrect syntax near the keyword 'AND'.
            • ErrorMessage: The given key was not present in the dictionary.
            • ErrorMessage: Conversion from type 'DBNull' to type 'String' is not valid.

            Thanks !

            CC : Jaideep Vinchurkar Satya Vijay Siddha

            Show
            vishal.bajad Vishal Bajad (Inactive) added a comment - - edited Hi , This is because of data corrupted as well as code failure, we have done with data correction and its working fine except Evan Form. mean while we have provided work around and code fix will be deployed on next deployment patch. Followings issues were observed and fixed for employee level history , ErrorMessage: Index and length must refer to a location within the string. ErrorMessage: Invalid column name 'PleasePickfromthe3Options321176'. ErrorMessage: Invalid column name 'FavoriteCity111176'. ErrorMessage: EVAN Form Incorrect syntax near the keyword 'AND'. ErrorMessage: Incorrect syntax near the keyword 'AND'. ErrorMessage: The given key was not present in the dictionary. ErrorMessage: Conversion from type 'DBNull' to type 'String' is not valid. Thanks ! CC : Jaideep Vinchurkar Satya Vijay Siddha
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Status In Development [ 10007 ] Local Testing [ 10200 ]
            vishal.bajad Vishal Bajad (Inactive) made changes -
            Assignee Vishal Bajad [ vishal.bajad ] Hrishikesh Deshpande [ hrishikesh.deshpande ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) logged work - 08/Aug/17 01:21 PM
            • Time Spent:
              0.5h
               
              <No comment>
            Hide
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment -

            Hi Jennifer Leugers,

            This issue has been fixed on Stage. View History is working fine for employees.

            but however while testing we have observed additional issue, please find details on issue -

            Issue -

            When Admin Select "From Date" as 01/01/2015 or 01/01/2014 (Any date less than last 2 year) and Search History then system throws server error.
            for this issue we have raised JIRA - WT-10504. We will fix it and get back to you.

            Please let me know in case you need any details from my end.

            Thanks,
            Hrishikesh.

            Show
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - Hi Jennifer Leugers , This issue has been fixed on Stage. View History is working fine for employees. but however while testing we have observed additional issue, please find details on issue - Issue - When Admin Select "From Date" as 01/01/2015 or 01/01/2014 (Any date less than last 2 year) and Search History then system throws server error. for this issue we have raised JIRA - WT-10504 . We will fix it and get back to you. Please let me know in case you need any details from my end. Thanks, Hrishikesh.
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Time Spent 20m [ 1200 ] 50m [ 3000 ]
            Worklog Id 70154 [ 70154 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Local Testing [ 10200 ] Stage Testing [ 10201 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Status Stage Testing [ 10201 ] Production Testing [ 10202 ]
            hrishikesh.deshpande Hrishikesh Deshpande (Inactive) made changes -
            Assignee Hrishikesh Deshpande [ hrishikesh.deshpande ] Jennifer Leugers [ jennifer.leugers ]
            Resolution Done [ 10000 ]
            Status Production Testing [ 10202 ] Production Complete [ 10028 ]
            vishal.bajad Vishal Bajad (Inactive) logged work - 08/Aug/17 02:27 PM
            • Time Spent:
              7h
               

              Data correction and code fix for following issues.
              ErrorMessage: Index and length must refer to a location within the string.
              ErrorMessage: Invalid column name 'PleasePickfromthe3Options321176'.
              ErrorMessage: Invalid column name 'FavoriteCity111176'.
              ErrorMessage: EVAN Form Incorrect syntax near the keyword 'AND'.
              ErrorMessage: Incorrect syntax near the keyword 'AND'.
              ErrorMessage: The given key was not present in the dictionary.
              ErrorMessage: Conversion from type 'DBNull' to type 'String' is not valid.

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Time Spent 50m [ 3000 ] 7h 50m [ 28200 ]
            Worklog Id 70194 [ 70194 ]
            sheetal.bodhale Sheetal Bodhale (Inactive) logged work - 08/Aug/17 10:08 PM
            • Time Spent:
              20m
               

              verified mentioned field data from back end
              save form

            vishal.bajad Vishal Bajad (Inactive) made changes -
            Link This issue relates to WT-10567 [ WT-10567 ]
            satyap Satya made changes -
            Environment_New Stage [ 18443 ]
            Transition Time In Source Status Execution Times
            Vishal Bajad (Inactive) made transition -
            Open In Development
            11h 3m 1
            Vishal Bajad (Inactive) made transition -
            In Development In LB Testing
            6h 27m 1
            Hrishikesh Deshpande (Inactive) made transition -
            In LB Testing Stage Testing
            1h 6m 1
            Hrishikesh Deshpande (Inactive) made transition -
            Stage Testing In Production Testing
            3s 1
            Hrishikesh Deshpande (Inactive) made transition -
            In Production Testing Production Complete
            11s 1

              People

              Assignee:
              jennifer.leugers Jennifer Leugers
              Reporter:
              jennifer.leugers Jennifer Leugers
              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 - 7h 50m
                  7h 50m