Hi,

Our team is working on a project for Creatio 8.1.2 (for Linux and PostgreSQL). We collaborate using filesystem mode and save our changes in a Git repository. When uploading changes to the instance, we first perform the "Update packages from filesystem" operation, followed by "Compile." Our project currently consists of slightly over 30 packages. We have encountered several issues when transferring changes to other instances.

At a certain point, we started experiencing problems with uploading changes to the instances. This is particularly noticeable when creating new instances. After connecting the repository and performing "Update packages from filesystem" for the first time, numerous errors can be observed (by going to the /dev view, then selecting all packages and sorting by status in descending order). These errors include information about a broken constraint, a non-existent column in the database, etc. Following this lead, I hypothesized that during the "Update packages from filesystem" operation, many database connections are opened, exceeding the limit defined in the PostgreSQL configuration. I verified it, and the default max_connections option was set to 100. When I increased it to 300, the problem stopped occurring on newly created instances. However, it seems to me that it should not consume such a large number of connections, and I don't think continuously increasing this number is a good solution as our project grows. Is there any option in Creatio to fix it?

Some changes do not work immediately after being uploaded to a new instance. You need to go into the configuration of the specific element and perform the PUBLISH operation on the target instance. Sometimes (although rarely), the system informs us that a given business process requires re-publishing. More often, however, something doesn't work, and it's hard to know this normally. For example, a query to a web service returns 404, even though it was uploaded to the target instance, and the compilation was performed immediately after the upload. Performing a complete compilation does not solve this problem. I have to go into the class with the given web service and re-publish it. The problem is that whether something works after uploading the changes seems completely random. Sometimes restarting a container with creatio, redis and postgres help, but it's not a rule. We test the changes thoroughly on our own instances, but after uploading the changes to the client's production instance, they may not work. We would really have to perform full regression tests to detect all the problems, and this is cumbersome.

Do any of you have similar problems and know how to deal with them? Thanks in advance for your responses!

Like 4

Like

2 comments

Hi Eryk, 

Thank you for your thorough feedback, looking forward to an answer from Creatio because the phrase "The problem is that whether something works after uploading the changes seems completely random. Sometimes restarting a container with creatio, redis and postgres help, but it's not a rule. We test the changes thoroughly on our own instances, but after uploading the changes to the client's production instance, they may not work. We would really have to perform full regression tests to detect all the problems, and this is cumbersome." is exactly something we struggle with. 


More advanced documentation , training and tutorials from Creatio on how to handle this more effectively, ideally with some tools to avoid full manual regression tests, are more than welcome

Bookmarking this feed. 

Cheers, 

Damien

Dear Eryk,

Many connections are created to optimize the installation process. If this approach doesn't work for you, you can disable specific settings in the application's web.config file, reducing the number of connections.
 

Please disable the following features in the external \web.config:
 

UseAsyncSaveSchemaResourcesInstallation
UseBulkSaveSchemaResourcesInstallation
UseAsyncSchemaCaptionsInstallation
UseAsyncPackageInstallation
 

To do this, open the web.config file, locate the above settings, and set their values to false. The lines should look like this:

 

<add key="UseAsyncSaveSchemaResourcesInstallation" value="false" />
<add key="UseBulkSaveSchemaResourcesInstallation" value="false" />
<add key="UseAsyncSchemaCaptionsInstallation" value="false" />
<add key="UseAsyncPackageInstallation" value="false" />
 

After making these changes, please clear Redis, restart the application, perform a source code generation for all schemas, and compile all actions.
 

For any other issues, please create a support request with Creatio, which requires a more detailed investigation.

Best regards,
Andrii

Show all comments

Hello,

how can we make column non/editable for portal users?

 

We have editable detail and column Requested amount, that should be editable for external users and non-editable for system users.

And column Confirmed amount, that should be editable for system users and non-editable for external users.

 

We use business rules based on calculated attribute (from Terrasoft.isCurrentUserSsp) for pages - it works perfectly. But it doesn't work in editable details

 

Any ideas?

Thank you!

Like 0

Like

4 comments

Hello,

Desired permission set up can be achieved via column permissions in the object permission settings. Step-by-step guide on the column permission set up available on Creatio Academy.

Best regards
Ivan

Ivan Savenko,

Thank you, it can be used, but it doesn't give visual 'lock' for column, only an error after saving.
Besides, column permissions requires to define each column of the object (at least, for the portal), that is not the best approach

I agree, visual locks would help a lot :)

Damien Collot,

especially on portal, where hundreds of users without experience should be provided with clear and easy UI

 

Kind regards,

Vladimir

Show all comments

Hi Community,
Can you provide a snippet example, on how we can hide a Detail (list) if the List contains no data (records)?

Thank you

Sasori

Like 4

Like

3 comments
Best reply

This can only be done with code. A combination of doing some model queries to check for records that would be in the list, then using an attribute bound to the visible property of the list to set as true/false based on the results of the query. 

Using the model to query data: https://customerfx.com/article/querying-data-using-filter-conditions-vi…

Using attributes: https://customerfx.com/article/using-custom-attributes-on-a-creatio-freedom-ui-page/

Using the init to execute the above code when the page loads: https://customerfx.com/article/waiting-for-model-to-be-ready-and-loaded…

Ryan

Hi Community,

Any remark on this one?

This can only be done with code. A combination of doing some model queries to check for records that would be in the list, then using an attribute bound to the visible property of the list to set as true/false based on the results of the query. 

Using the model to query data: https://customerfx.com/article/querying-data-using-filter-conditions-vi…

Using attributes: https://customerfx.com/article/using-custom-attributes-on-a-creatio-freedom-ui-page/

Using the init to execute the above code when the page loads: https://customerfx.com/article/waiting-for-model-to-be-ready-and-loaded…

Ryan

Hello,
 

Unfortunately, this task cannot be implemented using standard methods.

 Ryan has provided helpful recommendations that will assist you with implementation through development methods.
 

Additionally, we have registered a task for the development team to add such functionality in future releases.

Best regards,
Pavlo

Show all comments

Hi Community,

Im trying to download the Notes of a Classic Ui Section, to a Word printable.

The end result in the Word printable is together with the Html Tags. How can we fix this?

Sasori

Like 0

Like

1 comments

Dear Sasori,

 

As of now, it's not possible to correctly display the field with HTML formatting in the printable.  


We registered a query for our R&D team and await a fix in the upcoming versions. 

 

As a workaround suggestion, you can replace the Notes field with a simple text field. I understand that it's missing the format settings and cannot be applied to tables, but it should work for a sentence or two simple comments. 

 

Thank you for making Creatio better!

Show all comments

Hi community,

This is an out of the box problem, because i tried it in a fresh Environment as well.

Here is the issue.

We have the Leads section in the Classic UI, meanwhile the Account section is in the FreedomUI

1-We click to the Account link from the Lead Section:

2- We expect that the Form Page will open since we are not adding a new Account. Instead of the Form Page the MiniPage of the Account opens

3- Status of the Pages established for the account

How can we fix this issue?

Sasor

Like 0

Like

2 comments

Hi Community,

Any update regarding this?

Hello,

 

Please make sure that the "Default page" setting is set to the "Form page" in the Accounts object located in a package that is at the end of the packages hierarchy (it might be in the Custom package). 

This issue might appear if in one of such objects the "Default page" setting is set to "Mini page", which overrides the base settings.

Show all comments

Hello everyone,

I hope you're all well. I need your help.

I'm having a problem using CREATIO to create products that all end in :
insert or update on table ‘ProductPrice’ violates foreign key constraint ‘FK6ZjAW6Pzi2p2Jqy6BQy6n2r0xlY’
Even so, if I refresh the page, the product is created.

Once I get to the order and want to add one of these products, I get another integrity constraint.
Do you have an explanation, or do I have to go through support?
Thank you very much for your help.
Thierry

Like 0

Like

2 comments
Best reply

Hello!

The issue could be caused by a missing Default value within the Base Price List System Setting. Please check this. 

If this does not help, please contact support@creatio.com

Best regards,

Anton

Hello!

The issue could be caused by a missing Default value within the Base Price List System Setting. Please check this. 

If this does not help, please contact support@creatio.com

Best regards,

Anton

Thanks a lot. 

Show all comments

Hello,

 

is it possible to include Feed into global search results?

And/Or filter records by Feed in Section?

 

Thank you.

Vladimir

Like 1

Like

1 comments

Hello!

 

Regarding your first question, please note that at the moment, the feed is not indexed in the global search (the columns 'Message' of the 'CaseMessageHistory' object and the 'Message' of the 'SocialMessage' object). It is not possible to enable the feed in the global search in the current system configuration.

We have received similar inquiries in the past, and a development team has already registered a task to add this functionality. I have attached your request to the task to increase its priority. We will plan how to address this task and strive to develop a suitable mechanism, which will be presented in future Creatio releases.

Regarding your second question, unfortunately, it is impossible since we don't have direct connections between the record and Feed.


Best regards,

Mariia

Show all comments

I am currently developing an application where I need to add a "Sync Data" button to both the Accounts and Contacts sections. This button will trigger a Business Process that needs to work dynamically based on the context from which it is called.
 

The key requirement is to use a single, common Business Process for both Accounts and Contacts. In this process, I need to determine whether the button was clicked from the context of Accounts or Contacts, so the appropriate actions can be taken accordingly.
 

I understand that creating separate Business Processes for Accounts and Contacts could achieve this, but my goal is to have a unified process or function that can be reused across multiple entities.
 

I would greatly appreciate any guidance or suggestions on how to implement this in Creatio.

Thank you in advance for your assistance!

Like 0

Like

1 comments
Best reply

Create a boolean parameter "IsContact"(it's just an example, you could create any parameter ) and pass true if the button is clicked on contact page and false if it's clicked in any other place 

Create a boolean parameter "IsContact"(it's just an example, you could create any parameter ) and pass true if the button is clicked on contact page and false if it's clicked in any other place 

Show all comments

Hello,

 

I am trying running into a problem in my instance where I'm encountering a problem when I publish and compile where I receive a message saying that "One or more errors occurred. Sequence contains more than one matching element"

 

I am unclear as to what this message could be referring to. There error is unclear and I'm unsure as to how to proceed without more information. Has anybody encountered this problem before?

Like 0

Like

3 comments

If it's a compilation error, maybe there is more details in the Compilation errors? In the lookups section, add the "Compilation errors" object to view the contents.

Ryan

Hello Kevin

In my case, the problem was caused by a duplicate lookup object: deleting the duplicate solved the problem.

Jasmine,

Greetings,

The issue may be caused by having two schemas with the same name within one package. Please check this logic.

If this is not the case, kindly submit a support request to support@creatio.com and provide the logs when reproducing the issue, especially if it is on-site.

We will review and offer assistance.

Regards,
Orkhan

Show all comments

Hello Community,

 

       I have created Business Process 1 with three parameters. I can send the GUID from the Form Page, but I also want to pass the SchemaName as a parameter to the Business Process.

 

1] Business Process: ( Process with 3 Parameters: )

 2] Account_FormPage:

How can I send a text value parameter from the Form Page to Process? Can I Send the Multiple Parameters to Business Process? Is there any solution for this?

 

Thanks, 

Ajay K

 

Like 3

Like

4 comments

Hello!

Unfortunately, it is impossible to do it now, but we've registered it in our R&D team backlog for consideration and implementation in future application releases. Thank you for helping us to improve our product.


Thank you!

Hi Andrii,

 

Thank you for your response.

 

I have a question : If I trigger the process from different pages, such as Account_FormPage, Contact_FormPage, or Order_FormPage, is it possible to capture detailed information in the business process flow indicating from which specific page the button was triggered?

 

I'm looking for something similar to how HTTP request header parameters work.

 

Regards,

Ajay K

Hi Ajay,

Unfortunately, when triggering a business process from a button, it's impossible to determine from which specific page the process was initiated using no-code tools. However, we recommend creating a separate business process for each page. This approach lets you know exactly which page the business process was launched from.

Best regards,
Andrii

Hi Andrii Kurta,

 

Thank you for the clarification. I understand that using no-code tools may not allow us.

 

However, I would like to explore whether this can be achieved using code.

 

Could you please guide me on how I might implement a solution using code? Any examples or documentation you can provide would be greatly appreciated.

 

Best regards,

Ajay

Show all comments