Help understand this failed package upload.

I would appreciate some help understanding this error log. It was produced while trying to upload a package from dev environment to test. Some causes I think could be the package dependencies. The dev enviroment had some weird packages, and I had jerry rig some dependencies because it didn't have the normal dependencies you'd expect. This could relate to a possible issue of different versions on the environments. Any help is appreciated thanks.

2019-12-23 19:28:40,468 Lookup values "SysModuleEdit_SysModuleEditManager_5111a5b8e17f4275a6ce8a590774005d" from package "dmePhase1" installed
2019-12-23 19:28:40,484 Lookup values "SysModuleEdit_SysModuleEditManager_5e09b0b853e74b638b82d20ad05bba85" from package "dmePhase1" installed
2019-12-23 19:28:40,500 Lookup values "SysModuleEdit_SysModuleEditManager_6864a8cb79694e57b55bc29ccf3fa785" from package "dmePhase1" installed
2019-12-23 19:28:40,515 Lookup values "SysModuleEdit_SysModuleEditManager_6a24bfd1cbcf43769f262646a4800c37" from package "dmePhase1" installed
2019-12-23 19:28:40,531 Lookup values "SysModuleEdit_SysModuleEditManager_881ca9be465144bb847c480a1f5213e2" from package "dmePhase1" installed
2019-12-23 19:28:40,562 Lookup values "SysModuleEdit_SysModuleEditManager_ad94d21302524889a132b12015686e17" from package "dmePhase1" installed
2019-12-23 19:28:40,578 Lookup values "SysModuleEdit_SysModuleEditManager_c458e5d7411841828bb819a3360a9b84" from package "dmePhase1" installed
2019-12-23 19:28:40,609 Lookup values "SysModuleEdit_SysModuleEditManager_d5e3b74abf074f4fa5e11a906a435a28" from package "dmePhase1" installed
2019-12-23 19:28:40,625 Lookup values "SysModuleInWorkplace_SectionInWorkplaceManager_327a754f2cfd462eb549b8ef2d237720" from package "dmePhase1" installed
2019-12-23 19:28:40,640 Error occurred while installing data "SysModuleInWorkplace_SectionInWorkplaceManager_4deced996e9545cf8cb2b8d339dd886f" in package "dmePhase1". UId 8728cf34-ca7f-4ee6-99a4-89fc81b5bc46: The UPDATE statement conflicted with the FOREIGN KEY constraint "FKzsdkQT9ykYN0M2E4ZQ7LhuV0WI". The conflict occurred in database "062683-crm-bundle", table "dbo.SysWorkplace", column 'Id'.
The statement has been terminated.
UPDATE [dbo].[SysModuleInWorkplace] WITH(ROWLOCK)
SET
	[ModifiedOn] = CONVERT(DATETIME, '2019-12-23 19:28:40.640', 121),
	[ModifiedById] = '{410006E1-CA4E-4502-A9EC-E54D922D2C00}',
	[SysWorkplaceId] = '{BC68B7DF-F456-40BA-93C6-1D804F6236DA}',
	[SysModuleId] = '{79567E4A-9076-4EE1-80B3-27917B9D8FF7}'
WHERE
	[Id] = '{4DECED99-6E95-45CF-8CB2-B8D339DD886F}'
2019-12-23 19:28:40,656 Terrasoft.Common.DbOperationException: The UPDATE statement conflicted with the FOREIGN KEY constraint "FKzsdkQT9ykYN0M2E4ZQ7LhuV0WI". The conflict occurred in database "062683-crm-bundle", table "dbo.SysWorkplace", column 'Id'.
The statement has been terminated. ---> System.Data.SqlClient.SqlException: The UPDATE statement conflicted with the FOREIGN KEY constraint "FKzsdkQT9ykYN0M2E4ZQ7LhuV0WI". The conflict occurred in database "062683-crm-bundle", table "dbo.SysWorkplace", column 'Id'.
The statement has been terminated.

 

Like 0

Like

1 comments

Hello!

This issue indicates that either SysWorkplace does not exist in your package and when system tries to add section to workplace it face this issue. Make sure that you are binding SysWorkplace to your package and it is installed before package installation. You can read more about binding data here: https://academy.creatio.com/documents/technic-sdk/7-15/binding-data-packages

Best regards,

Angela

Show all comments