Hi Jaideep,

Can you please get this fixed with Platform team?

Regards,
Satya Prakash

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

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

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

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.

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

Thank you Hrishikesh Deshpande!

Veronica Blanco

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)

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