Hi Community,

 

I am currently working on Process elements  in Creatio. However, I find that the Save and Publish process with Script Task Element is taking longer time than expected, and I'm looking for ways to speed up this process.

 

Has anyone faced similar challenges and found effective solutions? If so, please share your experiences.

 

Best Regards,

Ajay Kuthe

 

 

Like 1

Like

7 comments
Best reply

Gareth Osler,

You can add the Creatio NuGet package to your local Visual Studio project for the Creatio/Terrasoft references also (without a local install). https://www.nuget.org/packages/CreatioSDK

Ryan

I have the same question, especially with one instance having a compile time of 10 minutes.

 

There is some documentation on using external IDEs here External IDEs | Creatio Academy.

 

The following looks interesting, but I'm not sure if a local Creatio instance is required:

Develop C# code in a custom project | Creatio Academy

Develop C# code in a custom project | Creatio Academy / Write C# code for Creatio in the cloud

If you turn on the option in your package for it to compile to it's own assembly then it should take less time since it's only compiling your package and not the entire system.

Other than that, developing externally using tools such as clio would speed the process up. 

Some of scripts that are used in many processes can be transformed into User task

Some best practices documentation videos, updated / new e-learning courses would be great in order to maximise the development in nocode and in code with Creatio  (video courses which can also show how to maximize the use of different tools like clio etc...) the amount of information at the moment is still disparate and super light. 

To build an assembly the Terrasoft libraries are needed.  A local Creatio install would be needed (unless there is some other way).

 

Gareth Osler,

You can add the Creatio NuGet package to your local Visual Studio project for the Creatio/Terrasoft references also (without a local install). https://www.nuget.org/packages/CreatioSDK

Ryan

Ryan Farley,

 

Following the instructions from Write C# code for Creatio in the cloud I'm getting the following error running Executor.exe

 

.\Executor.exe

Unhandled Exception: System.Net.CookieException: The 'Value'='Lax,.ASPXAUTH' part of the cookie is invalid.
   at System.Net.Cookie.VerifySetDefaults(CookieVariant variant, Uri uri, Boolean isLocalDomain, String localDomain, Boolean set_default, Boolean isThrow)
   at System.Net.CookieContainer.Add(Uri uri, Cookie cookie)
   at Executor.Program.TryLogin(String userName, String userPassword, String authServiceUri)
   at Executor.Program.Login()
   at Executor.Program.Main(String[] args)


The instructions are essentially to build an assembly locally and then I think upload it to the cloud instance using Executor.exe.  It looks as though it is not able to log in to the cloud instance due to an invalid cookie value.  I can't think of  a way round that.

 

[Edit] Apart from upload the assembly manually, would only take a few seconds!

 

[Edit] Could clio CI/CD be used to automate deployment?

 

Show all comments

Hello.

I have a freedom UI FormPage, which may be opened from Business process (Open edit page element). I want to override Cancel button handler in such way that to cancel current business process. I need to know process id (SysProcessLog table) or process element id (SysProcessElementLog table). How could I obtain them in Freedom UI? For example in Classic UI edit page there was dedicated attribute called ProcessData. I looked through request.$context and didn't find anything similar.

 

Creatio version is 8.1.2

Like 0

Like

2 comments

Hello!

 

To find information, you can read the data from SysProcessData, more information which contains the interrelationship between the process instance and the subprocess, the relationship to the process scheme, the relationship to the process scheme element if the instance is a subprocess, and the current status of the process instance. Also, the internal state of the process is a snapshot of the values of the parameters at times when the process elements are executed.

 

Also, this article could be useful:

https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/development-tools/external-ides/examples/develop-c-sharp-code-in-a-custom-project

 

Kyrylo Atamanenko,

Thanks for an answer. But to read all those information I need to know Id of an element being executed. For example in Classic UI it is obtained like 

this. 

const processElementUId = this.get("ProcessData").procElUId;

And the question is there analogue in Freeom UI page?

Show all comments

How do you set a prefix for all schemas? How do you add a new section called "Requests"  with some fields?

Like 0

Like

1 comments

Hello!

 

In system settings search for:

Prefix for schemas and package name

SchemaNamePrefix

 

More detailed information about new section creation can be found in this article: https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/getting-started/first-app/develop-application/create-a-new-section

Another article, that can be useful for you is how to create the custom package:

https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/development-tools/packages/create-a-package

 

Thank you for being an active part of the Creatio community!

Show all comments

How do we resolve this error insert or update the table "UsrSalesInfo" violates foreign key constraints and what is this code "FKEJfjpa4vcAfSKimC9hWFxF6Gxm8" showing in that error

Like 0

Like

1 comments

Hello!

 

The error message you're receiving, "UsrSalesInfo violates foreign key constraints," indicates that there is a problem with a foreign key constraint in your database. Foreign key constraints are rules that enforce referential integrity between tables.

 

The code "FKEJfjpa4vcAfSKimC9hWFxF6Gxm8" you mentioned is a reference to the specific foreign key constraint that's causing the error. It's an automatically generated name for the constraint, commonly used by database management systems.

 

To find out which table is affected by the foreign key constraint violation, you can query the system tables or views provided by your database management system.

An example of a possible script for this task: 

SELECT

    name,

    OBJECT_NAME(parent_object_id) AS referencing_table,

    OBJECT_NAME(referenced_object_id) AS referenced_table

FROM

    sys.foreign_keys

WHERE

    name = 'FKEJfjpa4vcAfSKimC9hWFxF6Gxm8';

 

Hope this helps!

Show all comments

I have locally installed the creatio environment + downloaded the zip archive and setup the email service

 

Install and run Email Listener:

  1. Open the directory to deploy Email Listener on the server dedicated for the service.
  2. Download and unpack the archive that contains the setup files to the directory. Download the archive.
  3. Open the / Creatio Email Listener component directory and run the following command:

docker-compose up -d

 

Executed the above command. I was able to add the email account + other configuration but when I run the diagnostics,  I do face the error as attached, how to resolve it?

 

I tried checking the Email Listener log 

 

2023-12-14 19:18:46,098 [105] WARN NT AUTHORITY\SYSTEM Warn - mailbox account@gmail.com synchronization settings not valid

 

I also do not see any email listed in the notification icon -> Mail.

 

Creatio is able to successfully send Creatio test message email from the diagnostic page.

 

 

2023-12-14 19:13:46,080 [106] DEBUG NT AUTHORITY\SYSTEM DebugFormat - ListenerServiceFailHandler started

2023-12-14 19:13:46,080 [106] DEBUG NT AUTHORITY\SYSTEM DebugFormat - ExchangeListenerManager created

2023-12-14 19:13:46,097 [106] WARN NT AUTHORITY\SYSTEM Warn - mailbox account@gmail.com synchronization settings not valid

2023-12-14 19:13:46,097 [106] DEBUG NT AUTHORITY\SYSTEM DebugFormat - Events subscription for 882c1561-***-****-****-******** mailbox created

2023-12-14 19:13:46,097 [106] DEBUG NT AUTHORITY\SYSTEM DebugFormat - Failover synchronization of account@gmail.com started

2023-12-14 19:13:46,097 [106] WARN NT AUTHORITY\SYSTEM Warn - mailbox account@gmail.com synchronization settings not valid

2023-12-14 19:13:46,097 [106] DEBUG NT AUTHORITY\SYSTEM DebugFormat - Failover synchronization of account@gmail.com initialization ended

2023-12-14 19:13:46,097 [106] DEBUG NT AUTHORITY\SYSTEM DebugFormat - Email synchronization process for 882c1561-***-****-****-******** mailbox created

2023-12-14 19:13:46,097 [106] DEBUG NT AUTHORITY\SYSTEM DebugFormat - ListenerServiceFailHandler ended

File attachments
Like 0

Like

1 comments

Hello,

 

I kindly request your attention to a post where a similar issue was discussed.



https://community.creatio.com/questions/exchange-listeners-806



 It is also crucial to ensure that the release version of the microservice is being used (Please note that to deploy a new version of the microservice, you need to contact Creatio technical support to grant you access to the repository).

 

Regarding the warning "mailbox account@gmail.com synchronization settings not valid," please check that the needed folders are chosen during folder synchronization. (in case you are syncing mails from the folders)



Try stopping the mailbox synchronization in the mailbox settings and restart it by reconfiguring the synchronization parameters.

 

Such issues may arise due to the specifics of deploying the local environment and may depend on other factors.

 

The best way to ensure that everything is configured correctly is to send an email from the system.

If emails are sent and synchronized successfully, you can ignore the error as it is not related to the email sending functionality.

 

Best regards,

Pavlo!

Show all comments

Hello,

Can anyone please help me understand how we can add below aggregate filters in freedom UI dynamic folders filter setup.

“Ideas” with an average [Idea expenses] of more than 5000.

Like 0

Like

1 comments

Hello,

 

You can create a folder and set up conditions for this folder: 

Show all comments

 

Page business rules missing the comparing signs in freedom UI.

Can anyone please help me find this values ?

 

Regards,

Dhrumil

 

Like 2

Like

3 comments

Hello,

 

Unfortunately, there are really no such operators in the current version of the app.

Thank you for your comments, our development team is already aware of this need and is working on its implementation.

 

😲 (For 8.1 ? 🫤)

Damien Collot,

I hope, we will have in 8.1 everything that we had in Classic UI

Show all comments

Good morning

 

When I export to SVG, I cannot use it because cannot read labels. See result here https://prnt.sc/lxuvQOyxDeXV

 

Please help

 

Thanks

Like 0

Like

3 comments

Hello Julio,

 

The issue may occur due to the tool / program with which you are viewing the image. Please try to open it with browser or other available tool.

 

Best regards, 

Anastasiia

Anastasiia Zhuravel,

Thanks Anastasiia,

 

In chrome works, but if I want to add it to an MS Word document to complement documentation, this is what I get, https://prnt.sc/m-Md7Hne7mqq 

 

And if I want to open it on a SVG editor like Inkscape I get this another result, https://prnt.sc/lxuvQOyxDeXV

 

Please help

Regards

Julio

 

Hi Julio,

 

Thank you for informing us! 

We'll register a query for a responsible R&D team to improve the functionality. 



Best regards,

Anastasiia

Show all comments

I have bind column setup and object permission to the package and

I have exported the package from my on-site deployed Creatio.

 

Now I want to export it to my trial instance. I installed the package to the application hub but cannot see the content of that package on the instance where I have imported the package. I have successfully compiled the Creatio configuration too and also logged out of Creatio and logged back in.

Please  suggest me a solution for this problem.

Like 0

Like

3 comments

Hello,

 



Apparently, the system does not look at the "Current Package" setting and will save administrative changes as a copy of an object in the custom package.

Hence why currently there are no OOTB tools to transfer administration settings and this task can be only achieved by means of development.



Information relating to the tables is given below:



- SysAdminUnit (Administration object: users and roles)

- SysUserInRole (Users in roles)

- SysFuncRoleInOrgRole (Functional role into organizational role)

- SysAdminOperation (System operations)

- SysAdminOperationGrantee (Access to system operations)

- SysEntitySchemaOperationRight (Access to objects)

- SysEntitySchemaRecordDefRight (Access to default records)

- SysEntitySchemaColumnRight - (Access to object columns)

- SysAdminUnitGrantedRight - (Delegated)

- SysWorkplace - (User Workplace)

- SysAdminUnitInWorkplace - (Users in the workplace)

- SysModuleInWorkplace - (Section in workplace)

I tried to bind these tables but was unable to do so

Satyam Kumar,

 

Please note that you must have at least basic developer skills to perform this procedure.

To generate queries, you can use tools like Microsoft SQL Server Database Publishing Wizard. The resulting SQL script should be attached to the package (tab - "SQL Scripts").

 

 

Show all comments

Hi,

In the latest release note (https://academy.creatio.com/docs/release/release-notes/808-atlas-release-notes) it was mentionned that SSO with OpenID has been implemented in Creatio. I've started a trial and attempted to set it up, I am unsure about the endpoint that should be entered in the URL field. Has anyone successfully managed to set it up?

Like 0

Like

1 comments

Hello,



As of now the corresponding article about Custom OpenID is still in progress, but it should be available on our Academy soon. 

In the Url field the main endpoint should be specified.

In order to avoid any errors we'd suggest to double-check whether the field is populated with a correct value. 



Should you have any additional questions, please let us know.

Best regards,

Anastasiia

Show all comments