Hello,

I created a validation for telephone numbers as explained in this article: Implement the validation of a field value on a page | Creatio Academy
For testing purposes, I added it to the notes field on the contacts form, and it works fine.

However, I want to add the validation to the communications options on the left side of the form.
How do I bind the validation in the viewModelConfigDiff?
Also, only communication options of type "phone number" should be validated.

Thanks,

Robert

Is there a way to implement authentication in an IFrame of my web app inside Creatio using the info of the already signed on user in Creatio?

Hello,

In Creatio Studio, is it possible to give a user permissions to add users to any role, except to the sys administrator or supervisor roles? If so, how?

Thanks,

Jose

Webhook Handler Under High Load Causes Idle Queries and DB Connection Limit Issues

Hi everyone,

I’m currently facing a technical issue with a webhook handler I’ve implemented in Creatio.

Background:

• I have a webhook endpoint that gets called by an external system at a rate of approximately 150 hits per second.
• The Creatio database has a maximum connection limit of 400 connections.

The Problem:

During high load, I observed that the number of open database connections increases rapidly, and some queries are left idle (idle in transaction) even after the handler completes its process.

This leads to:

• Exhaustion of available database connections
• Timeout errors on other operations
• Overall system unresponsiveness

What I’ve Tried So Far:

1. I modified the data access code by changing queries from <strong>ESQ</strong> (EntitySchemaQuery) to direct <strong>Entity</strong> usage.
2. I manually handled database connections by using:
   • using (DBConnection dbConnection = new DBConnection(...)) { ... }
   • Explicit calls to .Close() and .Dispose() on connections to ensure cleanup.

Despite these adjustments, I'm still seeing idle queries accumulating under high load.

My Questions:

1. What could be the possible reasons why queries remain idle even after the handler has completed?
2. Are there any known best practices in Creatio for managing database connections under high request volumes like this?
3. Is there a proper way to ensure <strong>UserConnection</strong> or underlying connections are completely released, especially in high-frequency webhook scenarios?

I would really appreciate any insights, suggestions, or shared experiences that could help resolve this issue.

Thank you in advance!

I need to download a file attached to an object and then upload it to an API that will process it.
I've already tried using Odata, but I always get a 204 error. I also tried creating a web service, but I couldn't. Now I'm trying to convert the file to Base64 using a script task, but I'm still unsuccessful. It's a production environment.

i want download an attached file on Creatio, using this endpoint:
https://miinstance.com/0/odata/ContactFile(f7946070-164d-48d3-8516-c31aff3f1588)/Data
But, don't work, If I consult directly without data, I receive the data, but to add /Data i receive the 204 status, y try with demo instance and works!, but in my production enviroment i always get the 204 status

{
    "@odata.context": "https://astec.creatio.com/0/odata/$metadata#ContactFile/$entity",
    "Id": "cd7641f2-8e9f-00c5-6662-c68f0f2dd298",
    "CreatedOn": "2025-05-16T22:46:30.610332Z",
    "CreatedById": "410006e1-ca4e-4502-a9ec-e54d922d2c00",
    "ModifiedOn": "2025-05-16T22:46:31.525903Z",
    "ModifiedById": "410006e1-ca4e-4502-a9ec-e54d922d2c00",
    "Name": "Abril 2025.pdf",
    "Notes": "",
    "LockedById": "00000000-0000-0000-0000-000000000000",
    "LockedOn": "0001-01-01T00:00:00Z",
    "TypeId": "529bc2f8-0ee0-df11-971b-001d60e938c6",
    "Version": 1,
    "Size": 135896,
    "ProcessListeners": 0,
    "ContactId": "35e409d2-c8fd-4790-9adf-43ff73abfc3e",
    "SysFileStorageId": "65e42805-0e6d-43c9-8784-32b555f08421",
    "FileGroupId": "efbf3a0d-d780-465a-8e4b-8c0765197cfb",
    "Tag": "",
    "TotalSize": 135896,
    "Data@odata.mediaEditLink": "ContactFile(cd7641f2-8e9f-00c5-6662-c68f0f2dd298)/Data",
    "Data@odata.mediaReadLink": "ContactFile(cd7641f2-8e9f-00c5-6662-c68f0f2dd298)/Data",
    "Data@odata.mediaContentType": "application/octet-stream"
}

Hi Community,

I'm currently using the RichText element in a Creatio Freedom UI page to load a static HTML page inside a Tab container. The HTML content is stored in a System Setting, and I retrieve this code at runtime to display it using the RichText editor.

For example, I read the HTML code from a System Setting and then attempt to render the full HTML (including inline styles) in the RichText element.

However, I'm facing an issue where inline styles or custom CSS seem to be stripped out.

Figure 1: Original Design Layout

Figure 2: Current UI Output

Has anyone else encountered this?

Any suggestions would be appreciated.

Thanks in advance!

Below is the link I used, which I followed to a tee. I built the image with changed database string, testing the connections, verified Creatio is running, and still the container fails to start???

https://academy.creatio.com/docs/8.x/setup-and-administration/on-site-deployment/deployment-additional-setup/identity-service/set-up-the-identity-service-instruction#title-2002-6

appsettings.json:

{
  "Logging": {
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "AllowedHosts": "*",
  "AllowedCorsOrigins": "[\"none.com\"]",
  "DbProvider": "Postgres",
  "DatabaseConnectionString": "Server=host.docker.internal;Port=5432;Database=creatio_db;User ID=postgres;password=testpassword123;Timeout=500; CommandTimeout=400;MaxPoolSize=1024;",
  "X509CertificatePath": "openssl.pfx",
  "Clients": "[{\"ClientId\":\"bpmonline-designer\",\"ClientName\":\"Bpmonline designer\",\"Secrets\":[\"665b6f638c2da3ecc5d3a1868eb9352f6e01ee4a\"],\"AllowedGrantTypes\":[\"implicit\",\"client_credentials\"],\"RedirectUris\":[\"http://localhost:4200\",\"http://localhost:4200/lib\",\"http://localhost:4200/lib/\"],\"PostLogoutRedirectUris\":[\"http://localhost:4200\"],\"IdentityTokenLifetime\": 300,\"AccessTokenLifetime\": 3600,\"Properties\": {\"AllowedQueryParameters\": \"[\\\"invitationHash\\\",\\\"targetSubject\\\"]\"},\"AllowedScopes\": [\"register_own_resource\", \"get_resource_list\", \"get_client_info\",\"find_clients\",\"remove_client\",\"update_client\", \"add_registrar_client\", \"IdentityServerApi\"]}]",
  "FeatureManagement": {
    "Full": true
  },
  "DbConnectionRetryOptions": {
    "MaxRetryCount": 5,
    "MaxRetryDelay": 6
  },
  "IgnoreDbCertificateValidation": true,
  "MsSqlCompatibilityLevel": 120
}

The Dockerfile:
 
FROM mcr.microsoft.com/dotnet/aspnet:8.0
 
WORKDIR /app
COPY . ./
 
ENV ASPNETCORE_URLS=http://+:80
EXPOSE 80
ENTRYPOINT ["dotnet", "IdentityService.dll"]

The command I used to run the dotnet8 IdentityService:
 
docker run --env=PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin --env=ASPNETCORE_URLS=http://+:80 --env=DOTNET_RUNNING_IN_CONTAINER=true --env=DOTNET_VERSION=8.0.10 --env=ASPNET_VERSION=8.0.10 --workdir=/app -p 80:80 -d creatio-identity-service:latest

We are currently facing an issue with how incoming calls are handled within Creatio. When an incoming call is received, it is correctly routed to multiple available operator extensions simultaneously, which is expected behavior. However, the problem arises because Creatio is creating multiple call records — one for each operator to whom the call was redirected — even though only one of them actually answers the call.

We have a business process configured that is triggered upon the creation or modification of a record in the "Call" object. This process opens the customer profile page for the operator to assist in providing relevant information during the call.

The issue is that, due to multiple call records being created for the same incoming call, the business process is being triggered for all operators, not just the one who answers the call. As a result, the customer profile page is opening for all operators who received the call notification, which leads to confusion and unnecessary disruption.

Expected Behavior:
Only one call record should be created — specifically for the operator who actually answers the call. Consequently, the customer profile page should open only for that operator, not for everyone whose extension the call was redirected to.

Request:
We would appreciate your guidance or support in resolving this issue, either by adjusting the way call records are created or by providing a method to identify and limit the process execution to only the operator who answers the call.

Hi all,

I'm looking for a reporting tool for Creatio, where i can also use very complex queries. I'm user to work with tools like Microsoft reporting Services or Chrystal reports.  We're working in the cloud, and i don't find a tool that is comparable to those tools.  How do you all create such reports, and run complex queries