[WT-9306] CLONE - Cloning Company results in server error - Workterra Jira

Details

Type: Bug
Status: Closed
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: Onboard
Labels:
None

Environment:

Stage
Bug Type:
Functional
Bug Severity:
Medium
Module:
Platform
Reported by:
Support
Item State:
Production Complete - Closed

Description

Hello,

I attempted to clone a company and received a message showing a server error. I was unable to clone. Please review and correct this issue.

In addition, please clone "Long" in stage and name the new company "Onboard Test Case". Please give access to myself, Robyn Adkison, Chitra Rao, Monika Demla, Ryan Sapp, Gary Cunningham, Amanda Hagan, Kylee Reeves, Jamela Sandridge and Amannda Johnson.

Thank you,
Veronica Blanco

Attachments

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

Attachments

26-04-2017_(WT-9306).patch
5 kB
28/Apr/17 06:52 AM
27-04-2017(WT-9306)_LB.txt
0.3 kB
28/Apr/17 06:53 AM

Issue Links

clones

WT-9298 Cloning Company results in server error

Resolved

Activity

Ascending order - Click to sort in descending order

Rakesh Roy (Inactive) created issue - 24/Apr/17 09:20 AM

Rakesh Roy (Inactive) made changes - 24/Apr/17 09:20 AM

Field	Original Value	New Value
Link		This issue clones ~~WT-9298~~ [ ~~WT-9298~~ ]

Rakesh Roy (Inactive) made changes - 24/Apr/17 09:20 AM

Assignee

Rakesh Roy [ rakeshr ]

Satya [ ID10004 ]

Rakesh Roy (Inactive) made changes - 24/Apr/17 09:21 AM

Account Executive

Veronica Blanco [ veronica.blanco ]

Rakesh Roy (Inactive) made changes - 24/Apr/17 09:23 AM

Issue Type	Support Activity [ 10301 ]	Bug [ 1 ]
Support Task Type	Customization [ 11204 ]
Workflow	WT_Support [ 39879 ]	WT_Defects [ 39880 ]

Hide

Permalink

Satya added a comment - 25/Apr/17 04:40 AM

Hi Jaideep,

Can you please get this fixed with Platform team?

Regards,
Satya Prakash

Show

Satya added a comment - 25/Apr/17 04:40 AM Hi Jaideep, Can you please get this fixed with Platform team? Regards, Satya Prakash

Satya made changes - 25/Apr/17 04:40 AM

Assignee

Satya [ ID10004 ]

Jaideep Vinchurkar [ jaideep.vinchurkar ]

Hide

Permalink

Satya added a comment - 25/Apr/17 04:55 AM

Hi Saurabh,

As discussed, can you please get this issue fixed?

Below is error log:
ErrorID : 0
ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.CloneCompany->Company.DeleteEmployeeDetails
ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_EmployeeSource_EmployeeID". The conflict occurred in database "OnboardTest24Apr2017_13032", table "dbo.EmployeeSource", column 'EmployeeID'.
The DELETE statement conflicted with the REFERENCE constraint "FK_EmployeeSource_EmployeeID". The conflict occurred in database "OnboardTest24Apr2017_13032", table "dbo.EmployeeSource", column 'EmployeeID'.

Regards,
Satya Prakash

Cc: Vijay Siddha Jaideep Vinchurkar Samir Rakesh Roy

Show

Satya added a comment - 25/Apr/17 04:55 AM Hi Saurabh, As discussed, can you please get this issue fixed? Below is error log: ErrorID : 0 ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.CloneCompany->Company.DeleteEmployeeDetails ErrorMessage: The DELETE statement conflicted with the REFERENCE constraint "FK_EmployeeSource_EmployeeID". The conflict occurred in database "OnboardTest24Apr2017_13032", table "dbo.EmployeeSource", column 'EmployeeID'. The DELETE statement conflicted with the REFERENCE constraint "FK_EmployeeSource_EmployeeID". The conflict occurred in database "OnboardTest24Apr2017_13032", table "dbo.EmployeeSource", column 'EmployeeID'. Regards, Satya Prakash Cc: Vijay Siddha Jaideep Vinchurkar Samir Rakesh Roy

Satya made changes - 25/Apr/17 04:55 AM

Assignee

Jaideep Vinchurkar [ jaideep.vinchurkar ]

Saurabh Sablaka [ saurabh.sablaka ]

Satya made changes - 25/Apr/17 04:55 AM

Component/s

OnBoard [ 10001 ]

Saurabh Sablaka (Inactive) made changes - 25/Apr/17 05:07 AM

Assignee

Saurabh Sablaka [ saurabh.sablaka ]

Sushodhan Vaishampayan [ sushodhan.vaishampayan ]

Permalink

Sushodhan Vaishampayan (Inactive) logged work - 25/Apr/17 11:55 AM - edited

Time Spent:

6h

Debugging and modifying SP

Sushodhan Vaishampayan (Inactive) made changes - 26/Apr/17 12:04 PM

Status

Open [ 1 ]

In Development [ 10007 ]

Sushodhan Vaishampayan (Inactive) made changes - 26/Apr/17 12:04 PM

Item State

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

Permalink

Sushodhan Vaishampayan (Inactive) logged work - 26/Apr/17 06:56 PM

Time Spent:

2h

Code review and Lb checkin

Sushodhan Vaishampayan (Inactive) made changes - 27/Apr/17 10:25 AM

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)

Sushodhan Vaishampayan (Inactive) made changes - 27/Apr/17 10:26 AM

Code Review Date		27/Apr/2017
Code Reviewed By		Saurabh Sablaka [ 11909 ]

Khandu Kshirsagar (Inactive) made changes - 27/Apr/17 12:24 PM

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)

Sushodhan Vaishampayan (Inactive) made changes - 28/Apr/17 06:52 AM

Attachment

26-04-2017_(WT-9306).patch [ 46497 ]

Sushodhan Vaishampayan (Inactive) made changes - 28/Apr/17 06:53 AM

Attachment

27-04-2017(WT-9306)_LB.txt [ 46498 ]

Sushodhan Vaishampayan (Inactive) made changes - 28/Apr/17 06:55 AM

Remaining Estimate		8h [ 28800 ]
Original Estimate		8h [ 28800 ]

Sushodhan Vaishampayan (Inactive) made changes - 28/Apr/17 06:56 AM

Remaining Estimate	8h [ 28800 ]	2h [ 7200 ]
Time Spent		6h [ 21600 ]
Worklog Id		41802 [ 41802 ]

Sushodhan Vaishampayan (Inactive) made changes - 28/Apr/17 06:56 AM

Remaining Estimate	2h [ 7200 ]	0h [ 0 ]
Time Spent	6h [ 21600 ]	8h [ 28800 ]
Worklog Id		41803 [ 41803 ]

Hide

Permalink

Sushodhan Vaishampayan (Inactive) added a comment - 28/Apr/17 07:01 AM

Hi team,

Following are the details of the issue :

Cause : Some foreign key violations were occuring as the Parent table(referred table) was being truncated without truncating child tables(referring tables) while cloning company.

Correction : The stored procedure was modified to truncate child tables before parent tables.(dbo.OES_SP_ClearEmployeeDetails.StoredProcedure.sql)

Regards
Sushodhan Vaishampayan

Show

Sushodhan Vaishampayan (Inactive) added a comment - 28/Apr/17 07:01 AM Hi team, Following are the details of the issue : Cause : Some foreign key violations were occuring as the Parent table(referred table) was being truncated without truncating child tables(referring tables) while cloning company. Correction : The stored procedure was modified to truncate child tables before parent tables.(dbo.OES_SP_ClearEmployeeDetails.StoredProcedure.sql) Regards Sushodhan Vaishampayan

Sushodhan Vaishampayan (Inactive) made changes - 28/Apr/17 07:01 AM

Assignee

Sushodhan Vaishampayan [ sushodhan.vaishampayan ]

Rakesh Roy [ rakeshr ]

Sushodhan Vaishampayan (Inactive) made changes - 28/Apr/17 07:04 AM

Worklog Id

41802 [ 41802 ]

Sushodhan Vaishampayan (Inactive) made changes - 28/Apr/17 07:04 AM

Worklog Id

41802 [ 41802 ]

Rakesh Roy (Inactive) made changes - 01/May/17 07:52 PM

Assignee

Rakesh Roy [ rakeshr ]

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Rakesh Roy (Inactive) made changes - 01/May/17 07:53 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Hrishikesh Deshpande (Inactive) made changes - 02/May/17 05:55 AM

Remaining Estimate	0h [ 0 ]	4h [ 14400 ]
Original Estimate	8h [ 28800 ]	12h [ 43200 ]

Hrishikesh Deshpande (Inactive) made changes - 02/May/17 05:55 AM

Remaining Estimate	4h [ 14400 ]	3.5h [ 12600 ]
Time Spent	8h [ 28800 ]	8.5h [ 30600 ]
Worklog Id		42632 [ 42632 ]

Hrishikesh Deshpande (Inactive) made changes - 02/May/17 05: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)

Hide

Permalink

Hrishikesh Deshpande (Inactive) added a comment - 02/May/17 05:59 AM

Clone company issue is Fixed on LB. Ready for Stage.

Show

Hrishikesh Deshpande (Inactive) added a comment - 02/May/17 05:59 AM Clone company issue is Fixed on LB. Ready for Stage.

Permalink

Hrishikesh Deshpande (Inactive) logged work - 02/May/17 05:55 PM

Time Spent:

0.5h

<No comment>

Khandu Kshirsagar (Inactive) made changes - 03/May/17 07:03 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)

Permalink

Hrishikesh Deshpande (Inactive) logged work - 03/May/17 09:48 AM

Time Spent:

1h

-testing

Hide

Permalink

Hrishikesh Deshpande (Inactive) added a comment - 03/May/17 09:48 AM

Hi Veronica Blanco,

This issue is Fixed on Stage. We will move it on Production and update you.

We have not cloned Long Stage Company as there is company already present with name "Onboard Test Case". We have confirmed that all given users have rights to this company.

Let me know in case you need any information on this.

Thanks,
Hrishikesh.

Show

Hrishikesh Deshpande (Inactive) added a comment - 03/May/17 09:48 AM Hi Veronica Blanco , This issue is Fixed on Stage. We will move it on Production and update you. We have not cloned Long Stage Company as there is company already present with name "Onboard Test Case". We have confirmed that all given users have rights to this company. Let me know in case you need any information on this. Thanks, Hrishikesh.

Hrishikesh Deshpande (Inactive) made changes - 03/May/17 09:49 AM

Remaining Estimate	3.5h [ 12600 ]	2.5h [ 9000 ]
Time Spent	8.5h [ 30600 ]	9.5h [ 34200 ]
Worklog Id		42844 [ 42844 ]

Hrishikesh Deshpande (Inactive) made changes - 03/May/17 09:49 AM

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 - 03/May/17 09:49 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Hide

Permalink

Veronica Blanco (Inactive) added a comment - 03/May/17 02:45 PM

Yes, we do have access to the newly cloned company.

Thank you Hrishikesh Deshpande!

Veronica Blanco

Show

Veronica Blanco (Inactive) added a comment - 03/May/17 02:45 PM Yes, we do have access to the newly cloned company. Thank you Hrishikesh Deshpande ! Veronica Blanco

Permalink

Sushodhan Vaishampayan (Inactive) logged work - 03/May/17 05:04 PM - edited

Time Spent:

1h

Stage check in

Sushodhan Vaishampayan (Inactive) made changes - 04/May/17 05:04 AM

Remaining Estimate	2.5h [ 9000 ]	1.5h [ 5400 ]
Time Spent	9.5h [ 34200 ]	10.5h [ 37800 ]
Worklog Id		43053 [ 43053 ]

Sushodhan Vaishampayan (Inactive) made changes - 04/May/17 05:05 AM

Worklog Id

43053 [ 43053 ]

Ashwin Wankhede (Inactive) made changes - 04/May/17 08:12 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)

Permalink

Hrishikesh Deshpande (Inactive) logged work - 08/May/17 07:14 AM

Time Spent:

1.5h

<No comment>

Hrishikesh Deshpande (Inactive) made changes - 08/May/17 07:14 AM

Remaining Estimate	1.5h [ 5400 ]	0h [ 0 ]
Time Spent	10.5h [ 37800 ]	12h [ 43200 ]
Worklog Id		43662 [ 43662 ]

Hrishikesh Deshpande (Inactive) made changes - 08/May/17 07:14 AM

Item State

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

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Hrishikesh Deshpande (Inactive) made changes - 08/May/17 07:14 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Hrishikesh Deshpande (Inactive) made changes - 08/May/17 07:17 AM

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

Hrishikesh Deshpande (Inactive) made changes - 08/May/17 07:17 AM

Item State

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Parent values: Stage QA(10202)

Hrishikesh Deshpande (Inactive) made changes - 08/May/17 07:17 AM

Item State

Parent values: Stage QA(10202)

Parent values: Production QA(10203)Level 1 values: Re-open(10220)

Hide

Permalink

Hrishikesh Deshpande (Inactive) added a comment - 08/May/17 07:18 AM

Hi Sushodhan Vaishampayan,

This is not working on Production.
Getting server error on Company clone.

Log -

ErrorID : 0
ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.CloneCompany->Company.BackupAndRestoreNewCompany
ErrorMessage: Could not find server 'BONANNOSR\BONANNOSR' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Could not find server 'BONANNOSR\BONANNOSR' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Clone(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity)
at WORKTERRA.ControllerAppTier.Clone(Int32 intProjectsId, String strInput)
TargetSite: System.String Clone(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

Show

Hrishikesh Deshpande (Inactive) added a comment - 08/May/17 07:18 AM Hi Sushodhan Vaishampayan , This is not working on Production. Getting server error on Company clone. Log - ErrorID : 0 ErrorSource : ControllerAppTier.Clone->WORKTERRAControllerAppTier.Clone->Company.Clone->Company.CloneCompany->Company.BackupAndRestoreNewCompany ErrorMessage: Could not find server 'BONANNOSR\BONANNOSR' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. Could not find server 'BONANNOSR\BONANNOSR' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers. StackTrace: at WORKTERRA.Shared.WORKTERRAControllerAppTier.Clone(WORKTERRAControllerWebTierEntity objWORKTERRAControllerWebTierEntity) at WORKTERRA.ControllerAppTier.Clone(Int32 intProjectsId, String strInput) TargetSite: System.String Clone(WORKTERRA.Shared.WORKTERRAControllerWebTierEntity)

Hrishikesh Deshpande (Inactive) made changes - 08/May/17 07:18 AM

Assignee

Hrishikesh Deshpande [ hrishikesh.deshpande ]

Sushodhan Vaishampayan [ sushodhan.vaishampayan ]

Sushodhan Vaishampayan (Inactive) made changes - 09/May/17 11:36 AM

Status

Reopen in Production [ 10027 ]

In Development [ 10007 ]

Hide

Permalink

Satya added a comment - 09/May/17 11:46 AM

Hi Hrishikesh,

'Add Company' and 'Clone Company' is not getting used on production. Please test this feature only till stage.

As per our current implementation, company is added/clonned on stage & then moved to production for their go-live.

Regards,
Satya Prakash

Cc: Saurabh Sablaka Samir Rakesh Roy Vijay Siddha Ashwin Wankhede

Show

Satya added a comment - 09/May/17 11:46 AM Hi Hrishikesh, 'Add Company' and 'Clone Company' is not getting used on production. Please test this feature only till stage. As per our current implementation, company is added/clonned on stage & then moved to production for their go-live. Regards, Satya Prakash Cc: Saurabh Sablaka Samir Rakesh Roy Vijay Siddha Ashwin Wankhede

Satya made changes - 09/May/17 11:46 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Satya made changes - 09/May/17 11:46 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Satya made changes - 09/May/17 11:46 AM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Satya made changes - 09/May/17 11:47 AM

Assignee	Sushodhan Vaishampayan [ sushodhan.vaishampayan ]	Hrishikesh Deshpande [ hrishikesh.deshpande ]
Resolution	Unresolved [ 10200 ]	Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Satya made changes - 09/May/17 11:47 AM

Status

Production Complete [ 10028 ]

Closed [ 6 ]

Hrishikesh Deshpande (Inactive) made changes - 09/May/17 11:53 AM

Item State

Parent values: Production QA(10203)Level 1 values: Re-open(10220)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Permalink

Sushodhan Vaishampayan (Inactive) logged work - 09/May/17 05:13 PM

Time Spent:

1h

Discussion with Saurabh Sablaka and trying fixes.

Sushodhan Vaishampayan (Inactive) made changes - 10/May/17 05:14 AM

Time Spent	12h [ 43200 ]	13h [ 46800 ]
Worklog Id		44259 [ 44259 ]

Rakesh Roy (Inactive) made changes - 18/Aug/17 07:59 AM

Bug Severity		Medium [ 16702 ]
Bug Type		Functional [ 15402 ]

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

Environment_New

Stage [ 18443 ]

Transition	Time In Source Status	Execution Times

Sushodhan Vaishampayan (Inactive) made transition - 26/Apr/17 12:04 PM

Open

In Development

2d 2h 43m

Hrishikesh Deshpande (Inactive) made transition - 08/May/17 07:17 AM

In Production Testing

Reopen in Production

3m 13s

Sushodhan Vaishampayan (Inactive) made transition - 09/May/17 11:36 AM

Reopen in Production

In Development

1d 4h 18m

Satya made transition - 09/May/17 11:46 AM

In Development

In LB Testing

5d 7h 59m

Satya made transition - 09/May/17 11:46 AM

In LB Testing

Stage Testing

1d 13h 56m

Satya made transition - 09/May/17 11:46 AM

Stage Testing

In Production Testing

4d 21h 25m

Satya made transition - 09/May/17 11:47 AM

In Production Testing

Production Complete

20s

Satya made transition - 09/May/17 11:47 AM

Production Complete

Closed

People

Assignee:: Hrishikesh Deshpande (Inactive)

Reporter:: Rakesh Roy (Inactive)

Account Executive:: Veronica Blanco (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 24/Apr/17 09:20 AM

Updated:: 04/Nov/17 06:31 AM

Resolved:: 09/May/17 11:47 AM

Code Review Date:: 27/Apr/2017

Time Tracking

Estimated:

12h

Remaining:

Logged:

13h