-
Type:
Enhancement
-
Status: Closed
-
Priority:
High
-
Resolution: Done
-
Component/s: Performance
-
Labels:None
-
Module:Platform - Performance
-
Reported by:Support
-
Item State:Production Complete
-
Issue Importance:Must Have
We came across this SP "OES_SP_ResetExpireSessionsLogins" while checking for ASP State session issues. This SP is called inside "DeleteExpiredSessions" SP of ASPState db that clears out the expired sessions at interval of 1 minute.
The logic inside this SP checks for active user flags across all production companies which might take considerable time in execution. We need to visit this StoredProc and analyse the activity & time taken every time it executes.
- relates to
-
-
- New Request
-
| Field | Original Value | New Value |
|---|---|---|
| Rank | Ranked higher |
| Summary | Need to check for OES_SP_ResetExpireSessionsLogins performance | Query Performance - OES_SP_ResetExpireSessionsLogins |
| Item State | Parent values: Development(10200)Level 1 values: In Analysis(10204) | Parent values: LB QA(10201) |
| Assignee | Saurabh Sablaka [ saurabh.sablaka ] | Rashmita Dudhe [ rashmita.dudhe ] |
| Item State | Parent values: LB QA(10201) | Parent values: LB QA(10201)Level 1 values: In Testing(10210) |
| Status | New Request [ 10029 ] | Pending for Approval [ 10002 ] |
| Status | Pending for Approval [ 10002 ] | Approved for Development [ 10003 ] |
| Status | Approved for Development [ 10003 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Code Reviewed By | Vijayendra Shinde [ 11901 ] |
| QA | Rashmita Dudhe [ rashmita.dudhe ] |
Verified On LB Environment for
Login / Logout, Multiple Login
For Admin, Partner, SA, Employee.
Multiple login from same browser
Multiple login from different browser.
Multiple login from Mobile Device & Web application
Not showing Multiple login Error message for multiple login.
Working Fine as expected.
| 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) |
| 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) |
| Comment |
[ Verified on Mobile device for Partner, Admin, Employee Working fine as expected ] |
| Assignee | Rashmita Dudhe [ rashmita.dudhe ] | Saurabh Sablaka [ saurabh.sablaka ] |
| Item State | Parent values: LB QA(10201)Level 1 values: Re-open(10212) | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) |
| Assignee | Saurabh Sablaka [ saurabh.sablaka ] | Rashmita Dudhe [ rashmita.dudhe ] |
Verified On Stage Environment for
Login / Logout, Multiple Login
For Admin, Partner, SA, Employee.
Multiple login from same browser
Multiple login from different browser.
Not showing Multiple login Error message for multiple login.
Working Fine as expected.
Not able to test on mobile device stage login failed.
| Item State | Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) |
Verified On Production Environment for
Login / Logout, Multiple Login
For Admin, Partner, Employee.
Multiple login from same browser
Multiple login from different browser.
Not showing Multiple login Error message for multiple login.
Working Fine as expected.
Testing in progress for mobile device
| Attachment | Sceanrio_New.xls [ 20742 ] |
Rashmita Dudhe Status and item state is not matching, please update the current status.
| Status | Local Testing [ 10200 ] | Reopen in Local [ 10018 ] |
| Status | Reopen in Local [ 10018 ] | In Development [ 10007 ] |
| Status | In Development [ 10007 ] | Local Testing [ 10200 ] |
| Status | Local Testing [ 10200 ] | Pending for Stage Approval [ 10300 ] |
| Status | Pending for Stage Approval [ 10300 ] | Approved for Stage [ 10030 ] |
| Status | Approved for Stage [ 10030 ] | Stage Testing [ 10201 ] |
| Status | Stage Testing [ 10201 ] | Pending for Production Approval [ 10301 ] |
| Status | Pending for Production Approval [ 10301 ] | Approved for production [ 10034 ] |
| Status | Approved for production [ 10034 ] | Production Testing [ 10202 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Production Testing [ 10202 ] | Production Complete [ 10028 ] |
| Item State | Parent values: Stage QA(10202)Level 1 values: In Testing(10214) | Parent values: Production Complete(10222) |
| Status | Production Complete [ 10028 ] | Closed [ 6 ] |
| Transition | Time In Source Status | Execution Times |
|---|
|
29d 20h 55m | 1 |
|
13s | 1 |
|
1s | 1 |
|
11d 19m | 1 |
|
9s | 1 |
|
5s | 2 |
|
18s | 1 |
|
2s | 1 |
|
1s | 1 |
|
4s | 1 |
|
2s | 1 |
|
2s | 1 |
|
13s | 1 |
|
1m 46s | 1 |
Changes done: We have removed call of this Stored Proc from ASP State - Delete session. This code block was required to avoid Multiple Login error message when user has logged out and still session remain active in any scenario. Now that we do not have blocking for Multiple login as per client's request this call can be removed.
Please verify basic scenarios for Login / Logout, Multiple Login & SSO (if possible) for all user roles.
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