[WT-11598] Employee SS mode -> Server error on confirmation statement page - Workterra Jira

Details

Type: Bug
Status: Resolution Setting
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: None
Labels:
- Enrollment_workflow

Environment:

Stage
Bug Type:
Functional
Bug Severity:
Medium
Module:
BenAdmin - Customization
Reported by:
Harbinger
Company:
All Clients/Multiple Clients
Item State:
Stage QA - On Hold
Sprint:
WT Sprint 39 - Bugs

Description

Company -> Elite staffing, Wacker Neuson corporation
1)Login with partner
2)Select company -> Add Employee
3)Traverse EE workflow
4)Go to beneficiary page -> Assign beneficiary
5)Click on continue -> System throws server error

Please note : For above mentioned companies this issue occur only once. Checked with 2,3 employee workflow its worked fine

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

Ben.jpg
214 kB
02/Nov/17 02:00 PM
Confirmation.jpg
223 kB
02/Nov/17 02:00 PM
Error.jpg
163 kB
13/Oct/17 10:37 AM
StageError.jpg
117 kB
19/Oct/17 10:43 AM

Issue Links

is duplicated by

WT-11845 Server error observed on load of confirmation statement in Employee Self Serve Mode.

Closed

WT-11949 Multiple clients getting server errors before confirmation page

Resolved

Activity

Ascending order - Click to sort in descending order

Permalink

Jyotibala Pardeshi (Inactive) logged work - 13/Oct/17 08:45 AM

Time Spent:

4h

Analysis and debugging of the issue.
tried to reproduced on local environment.
Internal discussion with Jayshree.

Jayshree Nagpure (Inactive) created issue - 13/Oct/17 10:35 AM

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 13/Oct/17 10:36 AM

Error Log :

ErrorID : 0
ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation
ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput)
TargetSite: System.String GetData(ValueObjects.BenAdminControllerWebTierEntity)

Show

Jayshree Nagpure (Inactive) added a comment - 13/Oct/17 10:36 AM Error Log : ErrorID : 0 ErrorSource : ControllerAppTier.GetData->BenAdminControllerAppTier.GetData->Confirmation.GetData->Confirmation.GetEmployeeAndConfirmationInformation->Confirmation.GetFormBuilderRightsForConfirmation ErrorMessage: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.GetData(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity) at WORKTERRA.ControllerAppTier.GetData(Int32 intProjectsId, String strInput) TargetSite: System.String GetData(ValueObjects.BenAdminControllerWebTierEntity)

Jayshree Nagpure (Inactive) made changes - 13/Oct/17 10:36 AM

Field	Original Value	New Value
Assignee	Satya [ ID10004 ]	Swapnil Pandhare [ swapnil.pandhare ]

Jayshree Nagpure (Inactive) made changes - 13/Oct/17 10:37 AM

Priority

Medium [ 3 ]

High [ 2 ]

Jayshree Nagpure (Inactive) made changes - 13/Oct/17 10:37 AM

Attachment

Error.jpg [ 64433 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 13/Oct/17 10:39 AM

CC; Rakesh Roy Prasad Pise Satya Sachin Hingole Hrishikesh Deshpande

Show

Jayshree Nagpure (Inactive) added a comment - 13/Oct/17 10:39 AM CC; Rakesh Roy Prasad Pise Satya Sachin Hingole Hrishikesh Deshpande

Jayshree Nagpure (Inactive) made changes - 13/Oct/17 10:43 AM

Link

This issue relates to OE-360 [ OE-360 ]

Hide

Permalink

Swapnil Pandhare (Inactive) added a comment - 13/Oct/17 11:14 AM

CC : Sheetal Bodhale
Hi Jyotibala Pardeshi ,

Please check this on prioirty.

Thanks,
Swapnil P.

Show

Swapnil Pandhare (Inactive) added a comment - 13/Oct/17 11:14 AM CC : Sheetal Bodhale Hi Jyotibala Pardeshi , Please check this on prioirty. Thanks, Swapnil P.

Swapnil Pandhare (Inactive) made changes - 13/Oct/17 11:14 AM

Assignee

Swapnil Pandhare [ swapnil.pandhare ]

Jyotibala Pardeshi [ jyotibala ]

Jyotibala Pardeshi (Inactive) made changes - 13/Oct/17 11:22 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Jyotibala Pardeshi (Inactive) made changes - 13/Oct/17 11:22 AM

Developer		Jyotibala Pardeshi [ jyotibala ]
Item State		Parent values: Development(10200)Level 1 values: In Analysis(10204)
Sprint		WT Sprint 39 - Bugs [ 90 ]

Jyotibala Pardeshi (Inactive) made changes - 16/Oct/17 06:24 AM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: In Progress(10206)

Jyotibala Pardeshi (Inactive) made changes - 16/Oct/17 08:46 AM

Remaining Estimate		0h [ 0 ]
Time Spent		4h [ 14400 ]
Worklog Id		85207 [ 85207 ]

Sheetal Bodhale (Inactive) made changes - 16/Oct/17 10:26 AM

Time Spent	4h [ 14400 ]	4.5h [ 16200 ]
Worklog Id		85247 [ 85247 ]

Sheetal Bodhale (Inactive) made changes - 16/Oct/17 01:21 PM

Time Spent	4.5h [ 16200 ]	5h [ 18000 ]
Worklog Id		85316 [ 85316 ]

Permalink

Jyotibala Pardeshi (Inactive) logged work - 16/Oct/17 02:29 PM

Time Spent:

3h

Debugging and Analysis.
Tried to reproduced the issue.
Restored the comapny from Stage.
Tried Classwise OE and OE with caching setting, not able to reproduced the issue.

Jyotibala Pardeshi (Inactive) made changes - 16/Oct/17 02:31 PM

Time Spent	5h [ 18000 ]	8h [ 28800 ]
Worklog Id		85334 [ 85334 ]

Hide

Permalink

Jyotibala Pardeshi (Inactive) added a comment - 16/Oct/17 02:48 PM

Hi Jayshree Nagpure,

We are not able to reproduced the issue on Elit Staffing after restoring it on the local environment.
We have tried Classwies OE and OE workflow.

We will try it for another companies and will update the status accordingly.
Let us know if you will get this issue for another companies.

Thanks and Regards,
Jyotibala P.

CC: Satya,Swapnil Pandhare, Sheetal Bodhale

Show

Jyotibala Pardeshi (Inactive) added a comment - 16/Oct/17 02:48 PM Hi Jayshree Nagpure , We are not able to reproduced the issue on Elit Staffing after restoring it on the local environment. We have tried Classwies OE and OE workflow. We will try it for another companies and will update the status accordingly. Let us know if you will get this issue for another companies. Thanks and Regards, Jyotibala P. CC: Satya , Swapnil Pandhare , Sheetal Bodhale

Permalink

Sheetal Bodhale (Inactive) logged work - 16/Oct/17 10:25 PM

Time Spent:

0.5h

company download
copied to local
discussion with jyotibala

Permalink

Sheetal Bodhale (Inactive) logged work - 17/Oct/17 01:20 AM

Time Spent:

0.5h

Scenario discussion with Jyoti
Stored procedure anlaysis

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 19/Oct/17 10:43 AM

Hi Jyotibala Pardeshi,

We got again this issue on stage (Date- 19 oct 2017)
Company - ASML for hspl

Error log is same as above

cc : Rakesh Roy Prasad Pise Satya Swapnil Pandhare Sheetal Bodhale

Show

Jayshree Nagpure (Inactive) added a comment - 19/Oct/17 10:43 AM Hi Jyotibala Pardeshi , We got again this issue on stage (Date- 19 oct 2017) Company - ASML for hspl Error log is same as above cc : Rakesh Roy Prasad Pise Satya Swapnil Pandhare Sheetal Bodhale

Jayshree Nagpure (Inactive) made changes - 19/Oct/17 10:43 AM

Attachment

StageError.jpg [ 65042 ]

Permalink

Jyotibala Pardeshi (Inactive) logged work - 24/Oct/17 05:26 AM

Time Spent:

3h

Internal discussion with Sudhir, Rakesh, Vijayendra, Nandu and Sonali.
Debugging and analysis of the issue.

Jyotibala Pardeshi (Inactive) made changes - 24/Oct/17 05:26 AM

Time Spent	8h [ 28800 ]	11h [ 39600 ]
Worklog Id		85938 [ 85938 ]

Jyotibala Pardeshi (Inactive) made changes - 24/Oct/17 06:03 AM

Assignee

Jyotibala Pardeshi [ jyotibala ]

Sudhir Kalikate [ sudhir.kalikate ]

Sudhir Kalikate (Inactive) made changes - 25/Oct/17 04:26 AM

Developer

Jyotibala Pardeshi [ jyotibala ]

Sudhir Kalikate [ sudhir.kalikate ]

Permalink

Sudhir Kalikate (Inactive) logged work - 25/Oct/17 07:47 AM

Time Spent:

7h

Analysis and procedure changes.

Sudhir Kalikate (Inactive) made changes - 25/Oct/17 11:25 AM

Company		All Clients/Multiple Clients [ 18434 ]
Dev Due Date		25/Oct/2017
Original Estimate		0h [ 0 ]

Sudhir Kalikate (Inactive) made changes - 25/Oct/17 01:16 PM

Item State

Parent values: Development(10200)Level 1 values: In Progress(10206)

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Permalink

Sudhir Kalikate (Inactive) logged work - 26/Oct/17 07:46 AM

Time Spent:

8h

Code changes and unit testing for multiple employees.

Sudhir Kalikate (Inactive) made changes - 26/Oct/17 02:16 PM

Code Reviewed By		Swapnil Pandhare [ 11900 ]
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)

Sudhir Kalikate (Inactive) made changes - 26/Oct/17 02:16 PM

Assignee

Sudhir Kalikate [ sudhir.kalikate ]

Jayshree Nagpure [ jayshree.nagpure ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 27/Oct/17 03:48 AM

Hi Sudhir Kalikate,

Could you please share 3c and and assign to me once its deloyed

Thanks,

cc : Rakesh Roy Prasad Pise Swapnil Pandhare

Show

Jayshree Nagpure (Inactive) added a comment - 27/Oct/17 03:48 AM Hi Sudhir Kalikate , Could you please share 3c and and assign to me once its deloyed Thanks, cc : Rakesh Roy Prasad Pise Swapnil Pandhare

Jayshree Nagpure (Inactive) made changes - 27/Oct/17 03:49 AM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Sudhir Kalikate [ sudhir.kalikate ]

Hide

Permalink

Sudhir Kalikate (Inactive) added a comment - 27/Oct/17 08:56 AM - edited

3C's for Issue
Concern :
Employee SS mode -> Server error on confirmation statement page.
Cause :
Caused by EDS Optimization changes. Data was fetching twice in Cache tables.
Correction :
We have made changes in stored procedure to fetch data from cache table correctly

Show

Sudhir Kalikate (Inactive) added a comment - 27/Oct/17 08:56 AM - edited 3C's for Issue Concern : Employee SS mode -> Server error on confirmation statement page. Cause : Caused by EDS Optimization changes. Data was fetching twice in Cache tables. Correction : We have made changes in stored procedure to fetch data from cache table correctly

Khandu Kshirsagar (Inactive) made changes - 27/Oct/17 11:07 AM

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)

Hide

Permalink

Sudhir Kalikate (Inactive) added a comment - 27/Oct/17 11:08 AM

LB deployed.

Show

Sudhir Kalikate (Inactive) added a comment - 27/Oct/17 11:08 AM LB deployed.

Sudhir Kalikate (Inactive) made changes - 27/Oct/17 11:08 AM

Assignee

Sudhir Kalikate [ sudhir.kalikate ]

Jayshree Nagpure [ jayshree.nagpure ]

Niteen Surwase (Inactive) made changes - 28/Oct/17 08:15 AM

Link

This issue is duplicated by ~~WT-11845~~ [ ~~WT-11845~~ ]

Sudhir Kalikate (Inactive) made changes - 30/Oct/17 07:46 AM

Time Spent	11h [ 39600 ]	19h [ 68400 ]
Worklog Id		87360 [ 87360 ]

Sudhir Kalikate (Inactive) made changes - 30/Oct/17 07:48 AM

Time Spent	19h [ 68400 ]	26h [ 93600 ]
Worklog Id		87363 [ 87363 ]

Jayshree Nagpure (Inactive) made changes - 31/Oct/17 06:20 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Jayshree Nagpure (Inactive) made changes - 31/Oct/17 06:20 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Jayshree Nagpure (Inactive) made changes - 31/Oct/17 06:21 AM

Production Due Date		08/Nov/2017
Stage Due Date		2/Nov/17 [ 2017-11-02 ]

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 31/Oct/17 08:55 AM

Verified on LB
Company - For QA Caiso for hspl

Verified EE selfserve mode
Verified beneficiary and confirmation statement page.
No server error Found

Marking item state as Ready for Stage

Thanks,
Jayshree

cc : Rakesh Roy Prasad Pise

Show

Jayshree Nagpure (Inactive) added a comment - 31/Oct/17 08:55 AM Verified on LB Company - For QA Caiso for hspl Verified EE selfserve mode Verified beneficiary and confirmation statement page. No server error Found Marking item state as Ready for Stage Thanks, Jayshree cc : Rakesh Roy Prasad Pise

Jayshree Nagpure (Inactive) made changes - 31/Oct/17 08:55 AM

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)

Permalink

Jayshree Nagpure (Inactive) logged work - 31/Oct/17 12:40 PM

Time Spent:

1.5h

Testing on LB

Jayshree Nagpure (Inactive) made changes - 31/Oct/17 12:40 PM

Time Spent	26h [ 93600 ]	27.5h [ 99000 ]
Worklog Id		88281 [ 88281 ]

Satya made changes - 01/Nov/17 11:42 PM

Labels

Enrollment_workflow

Khandu Kshirsagar (Inactive) made changes - 02/Nov/17 08:30 AM

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)

Jayshree Nagpure (Inactive) made changes - 02/Nov/17 01:58 PM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Hide

Permalink

Jayshree Nagpure (Inactive) added a comment - 02/Nov/17 02:00 PM

Verified on Stage
Company - Southland for hspl

Verified EE selfserve mode
Verified beneficiary and confirmation statement page.
No server error Found
Marking item state as Ready for Production

Thanks,
Jayshree

Show

Jayshree Nagpure (Inactive) added a comment - 02/Nov/17 02:00 PM Verified on Stage Company - Southland for hspl Verified EE selfserve mode Verified beneficiary and confirmation statement page. No server error Found Marking item state as Ready for Production Thanks, Jayshree

Jayshree Nagpure (Inactive) made changes - 02/Nov/17 02:00 PM

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)

Jayshree Nagpure (Inactive) made changes - 02/Nov/17 02:00 PM

Attachment

Confirmation.jpg [ 66669 ]

Permalink

Jayshree Nagpure (Inactive) logged work - 02/Nov/17 02:01 PM

Time Spent:

0.5h

Stage testing

Jayshree Nagpure (Inactive) made changes - 02/Nov/17 02:01 PM

Attachment

Ben.jpg [ 66670 ]

Jayshree Nagpure (Inactive) made changes - 02/Nov/17 02:01 PM

Time Spent	27.5h [ 99000 ]	28h [ 100800 ]
Worklog Id		88878 [ 88878 ]

Swapnil Pandhare (Inactive) made changes - 02/Nov/17 05:43 PM

Link

This issue is duplicated by ~~WT-11949~~ [ ~~WT-11949~~ ]

Rakesh Roy (Inactive) made changes - 02/Nov/17 06:07 PM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Satya made changes - 04/Nov/17 06:31 AM

Environment_New

Stage [ 18443 ]

Gaurav Sodani (Inactive) made changes - 20/Nov/17 11:55 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Stage QA(10202)Level 1 values: On Hold(10215)

Rakesh Roy (Inactive) made changes - 22/Feb/18 09:50 AM

Production Due Date

08/Nov/2017

05/Mar/2018

Sanjana Jadhav (Inactive) made changes - 05/Mar/18 12:20 PM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Permalink

Sanjana Jadhav (Inactive) logged work - 05/Mar/18 12:22 PM

Time Spent:

0.5h

Verified on production

Hide

Permalink

Sanjana Jadhav (Inactive) added a comment - 05/Mar/18 12:22 PM

Verified on production.
Company: Elite Staffing For HSPL
Verified Employee workflow (OE Workflow).
Verified beneficiary and confirmation statement page.
Working as expected.

Thanks,
Sanjana Jadhav

CC: Prasad Pise Sachin Hingole Rakesh Roy

Show

Sanjana Jadhav (Inactive) added a comment - 05/Mar/18 12:22 PM Verified on production. Company: Elite Staffing For HSPL Verified Employee workflow (OE Workflow). Verified beneficiary and confirmation statement page. Working as expected. Thanks, Sanjana Jadhav CC: Prasad Pise Sachin Hingole Rakesh Roy

Sanjana Jadhav (Inactive) made changes - 05/Mar/18 12:23 PM

Time Spent	28h [ 100800 ]	28.5h [ 102600 ]
Worklog Id		107072 [ 107072 ]

Sanjana Jadhav (Inactive) made changes - 05/Mar/18 12:23 PM

Resolution		Done [ 10000 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Sanjana Jadhav (Inactive) made changes - 05/Mar/18 12:23 PM

Resolution	Done [ 10000 ]
Status	Production Complete [ 10028 ]	Closed [ 6 ]

Sachin Hingole (Inactive) made changes - 26/Apr/18 03:22 AM

Resolution		Done [ 10000 ]
Status	Closed [ 6 ]	Resolution Setting [ 11616 ]

Transition	Time In Source Status	Execution Times

Jyotibala Pardeshi (Inactive) made transition - 13/Oct/17 11:22 AM

Open

In Development

46m 16s

Jayshree Nagpure (Inactive) made transition - 31/Oct/17 06:20 AM

In Development

In LB Testing

17d 18h 58m

Rakesh Roy (Inactive) made transition - 02/Nov/17 06:07 PM

In LB Testing

Stage Testing

2d 11h 46m

Sanjana Jadhav (Inactive) made transition - 05/Mar/18 12:20 PM

Stage Testing

In Production Testing

122d 19h 13m

Sanjana Jadhav (Inactive) made transition - 05/Mar/18 12:23 PM

In Production Testing

Production Complete

2m 22s

Sanjana Jadhav (Inactive) made transition - 05/Mar/18 12:23 PM

Production Complete

Closed

Sachin Hingole (Inactive) made transition - 26/Apr/18 03:22 AM

Closed

Resolution Setting

51d 13h 58m

People

Assignee:: Jayshree Nagpure (Inactive)

Reporter:: Jayshree Nagpure (Inactive)

Developer:: Sudhir Kalikate (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 13/Oct/17 10:35 AM

Updated:: 26/Apr/18 03:22 AM

Resolved:: 26/Apr/18 03:22 AM

Dev Due Date:: 25/Oct/2017

Pre-Prod Due Date:: 02/Nov/2017

Production Due Date:: 05/Mar/2018

Time Tracking

Estimated:

Remaining:

Logged:

28.5h