-
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
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.
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Satya [ ID10004 ] | Vinayak Kulkarni [ vinayak.kulkarni ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Vinayak Kulkarni [ vinayak.kulkarni ] | Satya [ ID10004 ] |
Deepali TidkeHrishikesh Deshpande Please check with Satya for any QA effort if required on this.
| Issue Importance | Must Have [ 11800 ] | |
| Module | Parent values: BenAdmin(10100) | Parent values: Platform(10106) |
| Assignee | Satya [ ID10004 ] | Saurabh Sablaka [ saurabh.sablaka ] |
Hrishikesh,
Please verify this on LB.
Scenarios to check-
Login / Logout
Multiple login
Multiple browser tab login
SSO
| Status | In Progress [ 3 ] | In Test [ 10016 ] |
| Assignee | Saurabh Sablaka [ saurabh.sablaka ] | Hrishikesh Deshpande [ hrishikesh.deshpande ] |
| Issue Type | Support Activity [ 10301 ] | Bug [ 1 ] |
| Status | In Test [ 10016 ] | Local Testing [ 10200 ] |
| Support Task Type | Query Resolution [ 11205 ] | |
| Workflow | WT_Support [ 16748 ] | WT_Defects [ 16864 ] |
| Component/s | Platform [ 10006 ] |
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.
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: LB QA(10201)Level 1 values: Re-open(10212) |
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Assignee | Hrishikesh Deshpande [ hrishikesh.deshpande ] | Saurabh Sablaka [ saurabh.sablaka ] |
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
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: Production Complete(10222)Level 1 values: Closed(10223) |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Production Testing [ 10202 ] |
This issue was fixed and deployed on Production on 24th May 2016
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Production Complete(10222)Level 1 values: Closed(10223) | Parent values: Production Complete(10222) |
| Environment_New | Production [ 18442 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
14m 6s | 1 |
|
3d 13h 51m | 1 |
|
1m 43s | 1 |
|
3h 24m | 1 |
|
7d 5h 27m | 1 |
|
17s | 1 |
|
4s | 1 |
|
2s | 1 |
|
37s | 1 |
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.