I am getting this error when installing a package from a zip file. Version is the same on both environments.
Can anyone help?
---------------
2019-08-27 13:37:14,773 Error occurred while installing data "SysModuleInWorkplace_SectionInWorkplaceManager_5571a41693f046ef9151be49e0712fdb" in package "PHouse". UId fb8f774a-de40-4cdd-af79-439a47fd674a: Instruction UPDATE conflicting with restriction of FOREIGN KEY "FKzsdkQT9ykYN0M2E4ZQ7LhuV0WI". Conflict has occurred on database "V2SalesEnterpriseENU_2429462_0402", table "dbo.SysWorkplace", column 'Id'.
The instruction was cancelled.
UPDATE [dbo].[SysModuleInWorkplace] WITH(ROWLOCK)
SET
[ModifiedOn] = CONVERT(DATETIME, '2019-08-27 13:37:14.752', 121),
[ModifiedById] = '{410006E1-CA4E-4502-A9EC-E54D922D2C00}',
[SysWorkplaceId] = '{3749FDEF-D713-4A76-B3A0-D9219C90951D}',
[SysModuleId] = '{E46F78BF-682E-46F1-9E14-FF174498069C}'
WHERE
[Id] = '{5571A416-93F0-46EF-9151-BE49E0712FDB}'
2019-08-27 13:37:14,910 Terrasoft.Common.DbOperationException:
Like
We see that the SysModuleInWorkplace data are bound to the package.
It's not a good approach to attach the SysModuleInWorkplace data and other UI configuration data to the package.
We recommend binding only data that are necessary for working newly developed functionality to the package .
All things which don't need changes in the code should be applied directly in the production environment.
Please unbind SysModuleInWorkplace_SectionInWorkplaceManager_5571a41693f046ef9151be49e0712fdb data from the package and try to install the package again.
Alina Kazmirchuk,
I have deleted the dependency on Workplace and created a new zip file, using the "Export packages to archive" option.
Now when I try to install the package I get the message
"Failed to create the configuration backup. Installation failed. Configuration has not changed."
and the log follows:
---
2019-08-28 14:36:36,848 Loading file: PHouse_19.08.28_14.35.01.zip 100%
2019-08-28 14:36:37,344 Configuration backup started.
2019-08-28 14:36:37,399 Loading packages from archive
2019-08-28 14:36:39,282 Package "PHouse" loaded
2019-08-28 14:36:39,282 Loading packages from database
2019-08-28 14:36:45,256 Loading packages from database
2019-08-28 14:36:49,473 Configuration backup successfully created.
---
Ricardo Bigio,
Unfortunately, there is no enough information to find out the root cause of the issue. Could you please share the entire logs about the package installation.
Please try to install this package on the new trial site. If installation is successful, then probably the environment causes the issue.
Alina Kazmirchuk,
I have just found the cause of the failure in the installation. There was a permission missing in the target environment, in the IIS server level handler mappings. It is working now. Thank you very much for your assistance.
Ricardo Bigio,
So the SysModuleInWorkplace data binding still in the package. Please remove it and try again.
Eugene Podkovka,
I have just found the cause of the failure in the installation. There was a permission missing in the target environment, in the IIS server level handler mappings. It is working now. Thank you very much for your assistance.