Hello

 

When I try to create the package for certification and adding ProductCore as a dependency, the following error appears: 

 


 

 

 

This error happens with every dependency that I try to add to a new package, I deleted some old packages before  but I can´t pinpoint the exact issue.

 

How do I solve this? Thanks in advance 

Like 2

Like

2 comments

Hello,

This error occurs because the data is not bound to the shown in the screenshot objects: "SysModuleEntity". Please follow the described steps to bind data and solve the error:

1. Create a "Data" element in your package. Example in screenshot below.

2. Select the SysModuleEntity object. Example in screenshot below.

3. On the "Bound Data" tab, add the id specified in the error. Example in screenshot below.


4. Save changes


Best regards,
Malika
 

Malika,

Thank you for your help!

Show all comments

I'm getting below error while installing "SMPageRefresh",

The INSERT statement conflicted with the FOREIGN KEY constraint "FKYru8eiQRBeFoEfawvRwKSlCy2o". The conflict occurred in database "SaEENU_5379138_0529", table "dbo.SysCulture", column 'Id'.

Kindly let me know how to proceed further.  

Like 0

Like

1 comments

Hello,

 

Please contact the developer of this connector directly at support@solutionsmetrix.com for further assistance with this matter.

 

Best regards,

Yuliya

Show all comments

I am restoring a package that I have saved from and into a Creatio trial, the following error seems to be stopping the restore:

2023-02-20 21:59:01,063 Error occurred while installing data "SysModuleInWorkplace_SectionInWorkplaceManager_bb810449aaee4db7bc12146d8b56d702" in package "Certification". UId 3a8e404f-99ee-453b-97e9-1485c6cb3bbe: 23503: insert or update on table "SysModuleInWorkplace" violates foreign key constraint "FKiEw0PrrAuIapzcrL01PohOXeFM"
UPDATE "public"."SysModuleInWorkplace"

At this point all I have done is create two sections and a workplace.  I have disabled the Freedom UI interface.

 

I have been saving the project incrementally and it is the same error twelve saved packages further on.

Like 0

Like

1 comments

Dear Gareth,

 

Thanks for your question.



To find the root cause of the issue, could you please contact us at support@creatio.com

 

Thanks in advance!

 

Best regards,

Anastasiia

Show all comments

Hello community,

 

I got an error while installed package from DEV to PRE environment. The error in the log showed as below. Please advise what was wrong and what should I do?

Thank you in advance!

2023-02-13 10:24:54,107 Lookup values "SysModuleEdit_SysModuleEditManager_3060a5b7123046008292d2ff391eca00" from package "Dynasafe1" installed
2023-02-13 10:24:54,170 Error occurred while installing data "SysModuleEdit_SysModuleEditManager_2e6d095fc4d0489e85718fd9726cd018" in package "Dynasafe1". UId c3395037-7ea2-4919-a3bf-75881b2dd66f: 23503: insert or update on table "SysModuleEdit" violates foreign key constraint "FKfswQzuMwAT8Bnlby6UilfQqmU"
UPDATE "public"."SysModuleEdit"
SET
	"ModifiedOn" = TO_TIMESTAMP('2023-02-13 10:24:54.154', 'YYYY-MM-DD HH24:MI:SS.FF3'),
	"ModifiedById" = '{410006E1-CA4E-4502-A9EC-E54D922D2C00}',
	"SysModuleEntityId" = '{45417B49-B9B2-4255-893D-F1FB10103294}'
WHERE
	"Id" = '{2E6D095F-C4D0-489E-8571-8FD9726CD018}'
2023-02-13 10:24:54,201 Terrasoft.Common.DbOperationException: 23503: insert or update on table "SysModuleEdit" violates foreign key constraint "FKfswQzuMwAT8Bnlby6UilfQqmU" ---> Npgsql.PostgresException: 23503: insert or update on table "SysModuleEdit" violates foreign key constraint "FKfswQzuMwAT8Bnlby6UilfQqmU"
   at Npgsql.NpgsqlConnector.<DoReadMessage>d__157.MoveNext()

 

Like 0

Like

1 comments

Hello,



The package installation issue is caused by the fact that the elements "SysModuleEdit_SysModuleEditManager_2e6d095fc4d0489e85718fd9726cd018" from the Dynasafe1 package have bindings to non-existent data.



The "SysModuleEdit_SysModuleEditManager_2e6d095fc4d0489e85718fd9726cd018" element contains the binding ID 45417B49-B9B2-4255-893D-F1FB10103294 of the SysModuleEntity object (SysModuleEntityId column), but the SysModuleEntity table does not contain this ID.

Show all comments

Hello All,

 

I am trying to compile my system and its throwing an error. 

 

 

Can someone assist.

 

Regards

Sivanesan S

 

 

Like 0

Like

1 comments

Hello,

 

In the code of the UsrAccountInfoByTypeConverter you are trying to use the GetTypedColumnValue method in 81, 85 and 87 line and it's done incorrectly. You need to debug the code of the UsrAccountInfoByTypeConverter and check why the error is returned there (this should be related with types usage and columns from which data should be retrieved).

Show all comments

Hello community,

 

We tried to update an existing package and we are facing the error System.ArgumentException: Application with name "" already exists.



How do we overcome this error?

Like 0

Like

1 comments

Hello,

 

The reason could be that the 'IsChanged' attribute of the scheme in the needed package is set to 'true' when it should be 'false'.

Show all comments

Hi,

I'm trying to install the :Data binding tool for Creatio

https://marketplace.creatio.com/app/data-binding-tool-creatio

from a downloaded zip file. But I get installation error:

 

"2022-02-08 11:31:39,427 Error occurred while generating schema source code "SysSettingsSection" in package "GlbDataBinding". UId ffd3e4fe-d38d-4f6c-a20f-690345cee210: Object with UId c37d05e9-7adc-41ce-a34f-e9a600885f5b already added to manager.

2022-02-08 11:31:39,443 System.ArgumentException: Object with UId c37d05e9-7adc-41ce-a34f-e9a600885f5b already added to manager."

 

I'm trying to install it on a fresh demo (8.0.0.5434) instance.

Any idea ?

 

Like 0

Like

1 comments

Hi Eran!



We had no issues with installing this add-on into the current latest version 8.0.0.5476. Could you try installing the add-on once again on the latest version?

Show all comments

During package installation,  message...

 

"Unable to install Schema "Tgnxxxxxxx" into package "Tgn0001", because the element has been modified locally. Resolve the conflict and mark the element as unchanged."

 

... shows when the element has been modified locally. How can I mark the element as unchanged , in order to allow its replacement ?

Like 1

Like

7 comments

Hello Ricardo, 

 

Please be advised that this error is indicating that the Package you are trying to use has been locally changed and was blocked by the system in order to prevent overwriting information.



If after Package importing you receive this error then it means that there was a conflict between the Package and the System.



In this case, we would recommend:

1. Resolving the Package conflict by:

    1.1 Determining if it is safe to overwrite the information.

    1.2 If the information cannot be overwritten, execute a "merge" (for example exporting the scheme to the dev-site and forming a new supply).

    1.3 If overwriting is permitted then you should unlock the Package in its context menu by pressing "Remove "Is modified" from Package elements".

 

2. Restoring the configuration from the automatic backup.

 

Hope this helps!

 

Best regards, 

Anastasiia

Anastasiia Zhuravel,

Thanks for your reply.

Where is the button "Remove "Is modified" from Package elements" located ?

Dear Ricardo,

 

The mentioned value can be found in the properties of the package elements. Open the needed package in the configuration, select the element of the package and open it's properties. 

 

Attaching the corresponding screenshot as well:

 

 

Best regards, 

Anastasiia

Anastasiia Zhuravel,

The package is unlocked, and I am using the right Current package / Prefix / Maintainer, but the "Modified" checkbox is not enabled. Why is that? Could it be because my sites are cloud-based ? 

Anastasiia Zhuravel,

Any clue on this case ?

Regards,

Hi, I am also having the same issue. I'm unable to uncheck the box. Can someone advise?

Lewis Pull,

Did you find a solution? having the same issue now

Thanks

Show all comments

Hi all,

 

We just tried installing our package on our pre-prod environment to test and unfortunately have met an error :

 

2020-10-23 10:24:19,373 System.UnauthorizedAccessException: Access to the path '_MetaInfo.json' is denied.

at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)

at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)

at Terrasoft.Common.IO.FileWrapper.Create(String path)

at Terrasoft.Core.ContentGeneration.ConfigurationMetaInfoFileWriter.Write(ConfigurationMetaInfo configurationMetaInfo, String configurationMetaInfoFilePath)

at Terrasoft.Core.Packages.ConfigurationAssemblyFileStorageTransaction.UpdateConfigurationVersion(Int32 version)

at Terrasoft.Core.Packages.ConfigurationAssemblyFileStorageTransaction.Commit()

at Terrasoft.Core.Packages.WorkspaceBuilder.BuildInternalNetStandard(Boolean force, BuildResultType& buildResultType)

at Terrasoft.Core.Packages.WorkspaceBuilder.Build()

at Terrasoft.Core.AppInstallation.Packages.Operations.SystemPackageOperations.Save(IEnumerable`1 packages, PackageInstallOptions options)

at Terrasoft.Core.AppInstallation.Packages.SystemPackageManager.Save(PackageInstallOptions installOptions)

at Terrasoft.Core.AppInstallation.Packages.AppInstaller.Install(String sourcePath, String destinationPath, PackageInstallOptions installOptions, IInstalledAppInfo installedAppInfo)

at Terrasoft.Core.ServiceModelContract.PackageInstaller.AppInstallerServiceInternal.<>c__DisplayClass9_0.b__0()

at Terrasoft.Core.ServiceModelContract.PackageInstaller.BaseInstallerServiceInternal.InvokeWithLogging[TResult](Func`1 action)

 

Compilation works without errors though.

 

Any ideas how to solve this ? We are on an on-prem version.

 

Thanks and lovely day !

Like 0

Like

2 comments

Dear Amandine,

 

Usually, this error means that IIS user does not have access to all paths Creatio needs to compile the application. Try to provide full access to IIS user and check if it helps by performing full compilation. 

 

Best regards,

Angela

Angela Reyes,

Hi Angela, it was indeed a permission issue, got solved the same day :) Thanks for answering !

Show all comments

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