WORKTERRAProject Type: software

WORKTERRA

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

Server errors in production

    Details

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

      Description

      From UHC - GBAPS

      Can you advise if anything was deployed last night into Production that could be causing issues today? Mandy has received a concerning call from the HR admin who has been experiencing issues herself with server errors and has received calls from many employees experiencing server errors.

      This Client is in the midst of Open Enrollment. Mandy has gone through the site and hasn’t been able to reproduce – however, it does appear this is impacting many. There are questions out to the group to try and troubleshoot to see if maybe old browser etc. but we wanted to report ASAP as again this group is in the midst of OE.

      From EmployBridge

      When I login, this is what
      appears on the screen.

       

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment -

          Samir Satya Saurabh Sablaka Vijayendra Shinde

          Error log is below:

          ErrorID : 0
          ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData->Users.GetData->Users.GetDataForUserID->Users.CheckAdministratorLogin->Users.DeleteSessionIfLoginFromSameDomain->Users.DeleteSession
          ErrorMessage: Invalid object name 'ASPState.dbo.ASPStateTempSessions'.

          Below are the changes done

          ASP state pointed to cluster one and modified SPs accordingly.
          Disable deletion of old session of logged in from same domain by turning off configuration key (comany.dll.config)

          Files modified
          1] Web.config
          2] Company.dll.config
          3] OES_SP_ResetExpireSessionsLogins

          Please investigate.

          Show
          Vinayak.Kulkarni Vinayak Kulkarni (Inactive) added a comment - Samir Satya Saurabh Sablaka Vijayendra Shinde Error log is below: ErrorID : 0 ErrorSource : ControllerAppTier.GetData->WORKTERRAControllerAppTier.GetData->Users.GetData->Users.GetDataForUserID->Users.CheckAdministratorLogin->Users.DeleteSessionIfLoginFromSameDomain->Users.DeleteSession ErrorMessage: Invalid object name 'ASPState.dbo.ASPStateTempSessions'. Below are the changes done ASP state pointed to cluster one and modified SPs accordingly. Disable deletion of old session of logged in from same domain by turning off configuration key (comany.dll.config) Files modified 1] Web.config 2] Company.dll.config 3] OES_SP_ResetExpireSessionsLogins Please investigate.
          Hide
          Permalink
          rakeshr Rakesh Roy (Inactive) added a comment -

          Deepali TidkeHrishikesh Deshpande Please check with Satya for any QA effort if required on this.

          Show
          rakeshr Rakesh Roy (Inactive) added a comment - Deepali Tidke Hrishikesh Deshpande Please check with Satya for any QA effort if required on this.
          Hide
          Permalink
          satyap Satya added a comment -

          Samir
          Hi Saurabh,

          Can you please check below issue for ASP State?

          Thanks & Regards,
          Satya Prakash

          Show
          satyap Satya added a comment - Samir Hi Saurabh, Can you please check below issue for ASP State? Thanks & Regards, Satya Prakash
          Hide
          Permalink
          saurabh.sablaka Saurabh Sablaka (Inactive) added a comment -

          Hrishikesh,

          Please verify this on LB.

          Scenarios to check-
          Login / Logout
          Multiple login
          Multiple browser tab login
          SSO

          Show
          saurabh.sablaka Saurabh Sablaka (Inactive) added a comment - Hrishikesh, Please verify this on LB. Scenarios to check- Login / Logout Multiple login Multiple browser tab login SSO
          Hide
          Permalink
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - - edited

          Scenarios Tested :

          Login / Logout : Pass, User can Login and Logout from system.

          Multiple login : Pass for Partner and Admin Login.
          Issue for Employee Login : System is allows to Login employee on multiple browser.

          Multiple browser tab login : Pass, for Partner Login.
          Issue for Admin Login : When Admin logs into one browser and again Logs into different tab then it Log's in first and then logout from both logins.
          Issue for EE Login : When Employee logs into one browser and again Logs into different tab then system does not prompts message for Previous connections gets logout.

          SSO : N/A Don't have access to use SSO on Local.

          Ready for Stage.

          Show
          hrishikesh.deshpande Hrishikesh Deshpande (Inactive) added a comment - - edited Scenarios Tested : Login / Logout : Pass, User can Login and Logout from system. Multiple login : Pass for Partner and Admin Login. Issue for Employee Login : System is allows to Login employee on multiple browser. Multiple browser tab login : Pass, for Partner Login. Issue for Admin Login : When Admin logs into one browser and again Logs into different tab then it Log's in first and then logout from both logins. Issue for EE Login : When Employee logs into one browser and again Logs into different tab then system does not prompts message for Previous connections gets logout. SSO : N/A Don't have access to use SSO on Local. Ready for Stage.
          Hide
          Permalink
          saurabh.sablaka Saurabh Sablaka (Inactive) added a comment -

          Issue is fixed and deployed on production on 24th May 2016.Below are the 3C's -

          Concern: Server error on production.

          Cause: While reverting ASP State DB server patch, configuration file flag changes were done which impacted the multiple login scenario from same domain. This issue was only for clients on Cluster 2 and Cluster 3 having active login sessions.

          Correction: We have reverted all the changes related to ASP State from production and corrected the configuration file flags for allowing multiple login from same domain. Below mention scenarios are tested on production for both web and mobile.
          To make sure this issue is not repeated in future we have documented the test scenarios and will make sure after any changes to multiple login session module these are tested.

          Verified Scenarios:
          Login & Logout scenarios for all user roles [SA, Admin, Partner/Broker, Employees]
          System access from Mobile Device, Web browser
          SSO login
          Multiple login from same domain
          Multiple login from different domain
          Multiple login from Mobile Device & Web application

          Show
          saurabh.sablaka Saurabh Sablaka (Inactive) added a comment - Issue is fixed and deployed on production on 24th May 2016.Below are the 3C's - Concern: Server error on production. Cause: While reverting ASP State DB server patch, configuration file flag changes were done which impacted the multiple login scenario from same domain. This issue was only for clients on Cluster 2 and Cluster 3 having active login sessions. Correction: We have reverted all the changes related to ASP State from production and corrected the configuration file flags for allowing multiple login from same domain. Below mention scenarios are tested on production for both web and mobile. To make sure this issue is not repeated in future we have documented the test scenarios and will make sure after any changes to multiple login session module these are tested. Verified Scenarios: Login & Logout scenarios for all user roles [SA, Admin, Partner/Broker, Employees] System access from Mobile Device, Web browser SSO login Multiple login from same domain Multiple login from different domain Multiple login from Mobile Device & Web application
          Hide
          Permalink
          saurabh.sablaka Saurabh Sablaka (Inactive) added a comment -

          This issue was fixed and deployed on Production on 24th May 2016

          Show
          saurabh.sablaka Saurabh Sablaka (Inactive) added a comment - This issue was fixed and deployed on Production on 24th May 2016

            People

            Assignee:
            saurabh.sablaka Saurabh Sablaka (Inactive)
            Reporter:
            jennifer.leugers Jennifer Leugers
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: