[WT-11319] Stage Marquette - SA Utility - Delete - Getting Server error - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Critical
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
- SA_Utility

Environment:

Stage
Bug Type:
Functional
Bug Severity:
Critical
Level:

Partner
Module:
BenAdmin - Customization
Reported by:
Harbinger
Item State:
Stage QA - On Hold

Description

Getting server error on Employee delete -

Company - Marquette

ErrorID : 0
ErrorSource : ControllerAppTier.Delete->BenAdminControllerAppTier.Delete->SAUtilityToolBox.Delete->SAUtilityToolBox.DeleteEmployeesAndDependents
ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_pm.RaisedEventBuilder_dbo.Employee_ID". The conflict occurred in database "MarquetteTransportation_1310", table "dbo.RaisedEventBuilder", column 'EmployeeID'.
The statement has been terminated.
StackTrace: at WORKTERRA.BenAdmin.BenAdminControllerAppTier.Delete(BenAdminControllerWebTierEntity objBenAdminControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.Delete(Int32 intProjectsId, String strInput)
TargetSite: System.String Delete(ValueObjects.BenAdminControllerWebTierEntity)

Attachments

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

Attachments

Screenshot (172).png
06/Mar/18 09:00 AM
145 kB
Priya Dhamande

Issue Links

duplicates

WT-11417 Intrepid USA - SA Utility- Server error on employee delete.

Closed

WT-11515 COB - SA Utility Not Deleting Employees

Resolved

is duplicated by

WT-11491 Charleys - please delete test members

Closed

relates to

NF-5148 Marquette - SA Utility - Delete - Getting Server error

Production Complete

Activity

Ascending order - Click to sort in descending order

Hrishikesh Deshpande (Inactive) created issue - 27/Sep/17 11:13 AM

Rakesh Roy (Inactive) made changes - 04/Oct/17 09:26 AM

Field	Original Value	New Value
Link		This issue duplicates ~~WT-11417~~ [ ~~WT-11417~~ ]

Hrishikesh Deshpande (Inactive) made changes - 04/Oct/17 09:30 AM

Assignee

Jaideep Vinchurkar [ jaideep.vinchurkar ]

Swapnil Pandhare [ swapnil.pandhare ]

Hrishikesh Deshpande (Inactive) made changes - 05/Oct/17 05:57 AM

Priority

High [ 2 ]

Highest [ 1 ]

Hrishikesh Deshpande (Inactive) made changes - 05/Oct/17 05:57 AM

Bug Severity

Critical [ 16701 ]

Blocker [ 16700 ]

Hrishikesh Deshpande (Inactive) made changes - 05/Oct/17 05:58 AM

Bug Severity

Blocker [ 16700 ]

Critical [ 16701 ]

Swapnil Pandhare (Inactive) made changes - 05/Oct/17 09:44 AM

Assignee

Swapnil Pandhare [ swapnil.pandhare ]

Sudhir Kalikate [ sudhir.kalikate ]

Sudhir Kalikate (Inactive) made changes - 06/Oct/17 10:48 AM

Status

Open [ 1 ]

In Development [ 10007 ]

Sudhir Kalikate (Inactive) made changes - 06/Oct/17 01:04 PM

Remaining Estimate		16h [ 57600 ]
Original Estimate		16h [ 57600 ]

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

Remaining Estimate	16h [ 57600 ]	13h [ 46800 ]
Time Spent		3h [ 10800 ]
Worklog Id		83649 [ 83649 ]

Sudhir Kalikate (Inactive) made changes - 06/Oct/17 01:20 PM

Remaining Estimate	13h [ 46800 ]	10h [ 36000 ]
Time Spent	3h [ 10800 ]	6h [ 21600 ]
Worklog Id		83665 [ 83665 ]

Khandu Kshirsagar (Inactive) made changes - 09/Oct/17 11:05 AM

Item State

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

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

Assignee

Sudhir Kalikate [ sudhir.kalikate ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Hrishikesh Deshpande (Inactive) made changes - 09/Oct/17 11:47 AM

Item State

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

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Hrishikesh Deshpande (Inactive) made changes - 09/Oct/17 11:47 AM

Remaining Estimate	10h [ 36000 ]	9.5h [ 34200 ]
Time Spent	6h [ 21600 ]	6.5h [ 23400 ]
Worklog Id		83884 [ 83884 ]

Hrishikesh Deshpande (Inactive) made changes - 09/Oct/17 11:47 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hrishikesh Deshpande (Inactive) made changes - 09/Oct/17 11:48 AM

Production Due Date		11/Oct/2017
Stage Due Date		10/Oct/17 [ 2017-10-10 ]

Vinayak Kulkarni (Inactive) made changes - 09/Oct/17 03:27 PM

Link

This issue duplicates ~~WT-11515~~ [ ~~WT-11515~~ ]

Swapnil Pandhare (Inactive) made changes - 10/Oct/17 07:06 AM

Developer

Sudhir Kalikate [ sudhir.kalikate ]

Jaideep Vinchurkar (Inactive) made changes - 10/Oct/17 09:31 AM

Link

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

Khandu Kshirsagar (Inactive) made changes - 10/Oct/17 10:16 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)

Sudhir Kalikate (Inactive) made changes - 10/Oct/17 10:16 AM

Code Reviewed By		Swapnil Pandhare [ 11900 ]
Item State	Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)	Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Hrishikesh Deshpande (Inactive) made changes - 10/Oct/17 12:20 PM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Akshay Mukkawar (Inactive) made changes - 10/Oct/17 12:48 PM

Remaining Estimate	9.5h [ 34200 ]	8.5h [ 30600 ]
Time Spent	6.5h [ 23400 ]	7.5h [ 27000 ]
Worklog Id		84148 [ 84148 ]

Sudhir Kalikate (Inactive) made changes - 10/Oct/17 01:15 PM

Remaining Estimate	8.5h [ 30600 ]	7.5h [ 27000 ]
Time Spent	7.5h [ 27000 ]	8.5h [ 30600 ]
Worklog Id		84171 [ 84171 ]

Hrishikesh Deshpande (Inactive) made changes - 10/Oct/17 01:19 PM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

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

Hrishikesh Deshpande (Inactive) made changes - 10/Oct/17 02:12 PM

Remaining Estimate	7.5h [ 27000 ]	6.5h [ 23400 ]
Time Spent	8.5h [ 30600 ]	9.5h [ 34200 ]
Worklog Id		84211 [ 84211 ]

Akshay Mukkawar (Inactive) made changes - 11/Oct/17 05:59 AM

Remaining Estimate	6.5h [ 23400 ]	5.5h [ 19800 ]
Time Spent	9.5h [ 34200 ]	10.5h [ 37800 ]
Worklog Id		84148 [ 84148 ]

Akshay Mukkawar (Inactive) made changes - 11/Oct/17 06:00 AM

Remaining Estimate	5.5h [ 19800 ]	5h [ 18000 ]
Time Spent	10.5h [ 37800 ]	11h [ 39600 ]
Worklog Id		84250 [ 84250 ]

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

Item State

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

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Rakesh Roy (Inactive) made changes - 12/Oct/17 06:08 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Khandu Kshirsagar (Inactive) made changes - 12/Oct/17 10:36 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

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

Hrishikesh Deshpande (Inactive) made changes - 12/Oct/17 11:29 AM

Item State

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

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Hrishikesh Deshpande (Inactive) made changes - 12/Oct/17 11:29 AM

Remaining Estimate	5h [ 18000 ]	4.5h [ 16200 ]
Time Spent	11h [ 39600 ]	11.5h [ 41400 ]
Worklog Id		84500 [ 84500 ]

Rakesh Roy (Inactive) made changes - 12/Oct/17 03:26 PM

Resolution		Unresolved [ 10200 ]
Status	Production Testing [ 10202 ]	Reopen in Production [ 10027 ]

Rakesh Roy (Inactive) made changes - 12/Oct/17 03:26 PM

Status

Reopen in Production [ 10027 ]

In Development [ 10007 ]

Rakesh Roy (Inactive) made changes - 12/Oct/17 03:26 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Rakesh Roy (Inactive) made changes - 12/Oct/17 03:56 PM

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Khandu Kshirsagar (Inactive) made changes - 13/Oct/17 10:02 AM

Item State

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

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

Rakesh Roy (Inactive) made changes - 18/Oct/17 06:56 AM

Item State

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

Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)

Khandu Kshirsagar (Inactive) made changes - 31/Oct/17 06:34 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)

Satya made changes - 02/Nov/17 12:19 AM

Labels

SA_Utility

Hrishikesh Deshpande (Inactive) made changes - 02/Nov/17 02:08 PM

Item State

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

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

Hrishikesh Deshpande (Inactive) made changes - 02/Nov/17 02:09 PM

Remaining Estimate	4.5h [ 16200 ]	4h [ 14400 ]
Time Spent	11.5h [ 41400 ]	12h [ 43200 ]
Worklog Id		88880 [ 88880 ]

Gaurav Sodani (Inactive) made changes - 03/Nov/17 09:44 AM

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 06:35 PM

Production Due Date

11/Oct/2017

25/Nov/2017

Gaurav Sodani (Inactive) made changes - 22/Nov/17 10:29 AM

Production Due Date

25/Nov/2017

Sudhir Kalikate (Inactive) made changes - 23/Nov/17 10:08 AM

Link

This issue is cloned by ~~NF-5148~~ [ ~~NF-5148~~ ]

Sudhir Kalikate (Inactive) made changes - 23/Nov/17 10:10 AM

Link

This issue is cloned by ~~NF-5148~~ [ ~~NF-5148~~ ]

Sudhir Kalikate (Inactive) made changes - 23/Nov/17 10:11 AM

Link

This issue relates to ~~NF-5148~~ [ ~~NF-5148~~ ]

Gaurav Sodani (Inactive) made changes - 30/Nov/17 12:27 PM

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

05/Mar/2018

Rakesh Roy (Inactive) made changes - 06/Mar/18 07:43 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Priya Dhamande (Inactive) made changes - 06/Mar/18 09:00 AM

Attachment

Screenshot (172).png [ 74131 ]

Priya Dhamande (Inactive) made changes - 06/Mar/18 09:02 AM

Remaining Estimate	4h [ 14400 ]	3.75h [ 13500 ]
Time Spent	12h [ 43200 ]	12.25h [ 44100 ]
Worklog Id		107175 [ 107175 ]

Priya Dhamande (Inactive) made changes - 06/Mar/18 09:04 AM

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

Priya Dhamande (Inactive) made changes - 06/Mar/18 09:04 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Priya Dhamande (Inactive) made changes - 16/Mar/18 05:36 AM

Remaining Estimate	3.75h [ 13500 ]	3.5h [ 12600 ]
Time Spent	12.25h [ 44100 ]	12.5h [ 45000 ]
Worklog Id		107175 [ 107175 ]

People

Assignee:: Hrishikesh Deshpande (Inactive)

Reporter:: Hrishikesh Deshpande (Inactive)

Developer:: Sudhir Kalikate (Inactive)

QA:: Hrishikesh Deshpande (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 27/Sep/17 11:13 AM

Updated:: 16/Mar/18 05:36 AM

Resolved:: 06/Mar/18 09:04 AM

Pre-Prod Due Date:: 10/Oct/2017

Production Due Date:: 05/Mar/2018

Time Tracking

Estimated:

16h

Remaining:

3.5h

Logged:

12.5h