Package install failed- Object is invalid. Extended properties are not permitted
Hi community!
We have moved our package from one environment with lowest creatio version (7.16) to environment with highest version (creatio atlas).
Some objects were not installed properly and we received error:
Error "Object is invalid. Extended properties are not permitted on 'dbo.UsrGeneralViewFile.FKcCbW9f8n8IYIlNxWjlw0Vi1Gqc', or the object does not exist." occurred when updating schema structure. SQL script text: "EXEC [dbo].[sp_addextendedproperty] N'TS.ActionType', N'ForeignKey', N'SCHEMA', N'dbo', N'TABLE', N'UsrGeneralViewFile', N'CONSTRAINT', N'FKcCbW9f8n8IYIlNxWjlw0Vi1Gqc'"
Any suggestions how to resolve it?
Hello Yana,
We strongly recommend to transfer packages between sites with the same build (products) and versions to avoid any errors.
It's hard to identify the root cause of the issue with no access to the system. But based on the shared information, I may assume that the issue is related to the lookup column that has no "Do not control integrity" option enabled in its settings and the issue occurs as the database structure for the object cannot be successfully updated while installing the package. I'd suggest to check it and as well fully generate and compile the system, and also resolve possible generation / compilation errors.
If the issue persists despite the provided recommendations, please contact support team via support@creatio.com to proceed with investigation.
Best regards,
Anastasiia