Hi Creatio community,

Where are the logs of batch query calls stored in Creatio? I need to implement a notification logic that triggers every time a batch query is processed in Creatio.

 

Kind regards

Like 0

Like

1 comments

Hello!

 

Such information you can find in your IIS logs, which by default are stored in %SystemDrive%\inetpub\logs\LogFiles

 

If you need, you can set up your own path:

https://learn.microsoft.com/en-us/iis/manage/provisioning-and-managing-…

Show all comments

Hello

 

I'm trying to make the approval comment field mandatory for a DCM. The idea is that  the approval cannot be approved or rejected if a comment hasn't been added to the section. That is, all approvals need to have a comment added to them.

 

I try to marked the comment as obligatory in the object "Basevisa" but it didnt work. 

 

Any idea how can I make the comment mandatory. 

 

Thank you 

 

 

 

Like 1

Like

1 comments

Hello Laura,

 

In classic UI there are two approaches: either one provided here (but don't forget to disable the AcceptApprovalWithoutComment system setting) or creating a replacing view module for the PreconfiguredApprovalPage and add this code:

define("PreconfiguredApprovalPage", [],
	function() {
		return {
			attributes: {},
			methods: {
				save: function() {
					const approvalComment = this.get("Comment");
					if (approvalComment.length > 0) {
						this.callParent(arguments);
					} else {
						Terrasoft.showErrorMessage("Comment is mandatory");
					}
				}
			},
			diff: /**SCHEMA_DIFF*/ [] /**SCHEMA_DIFF*/
		};
	});

As for the Freedom UI - as was mentioned here and here - this is not avialable in Freedom UI as for now. I will notify our R&D team about your question to prioritize the task to develop the logic for them.

Show all comments

i try to deploy creatio in linux vmware but i cannot login in the login page when make a succesfull login attempt got comeback to login page again in the console i get this some kind error message can you guys help me

 Failed to resolve type Terrasoft.Core.QueryExecutionRules.IQueryRuleApplier
 
Autofac.Core.DependencyResolutionException: An exception was thrown while activating Terrasoft.Core.QueryExecutionRules.QueryRuleApplier -> Terrasoft.Core.QueryExecutionRules.QueryRuleApplyLogger -> Terrasoft.Core.QueryExecutionRules.QueryRuleApplyLogRepository -> λ:Terrasoft.Core.UserConnection.

 

Like 0

Like

1 comments

Hello!
 

To resolve this issue, please submit a request via email to support@creatio.com.

What we need from you:

  1. Website logs.
  2. Binary files (if possible).
  3. An anonymized copy of the database (if it's a default database and doesn't contain sensitive data, please provide it).


Thank you for reaching out! We’ll be happy to assist you!

Show all comments

Trying to create new Reminding with link to Call or Contact collection objectby oData4 request. Is it possible?
With Action collection everything fine. But with Call (or Contact) collection Id request only red point appears near bell symbol, but list of remindings is empty.

Like 0

Like

2 comments

Hello!

 

If you mean create remindings with link to specific record. You actually can manage something like this with the business process by adding notifications with an edit page element. And then trigger this process by odata.

Kyrylo Atamanenko,

Thank you, Kyrylo

I mean, which collection UId from the list of {{BaseURI}}/0/odata/SysSchema should be specified in the "SysEntitySchemaId" field in the POST request  {{BaseURI}}/0/odata/Reminding in order to create a notification not bound to an Action, but Contact or Call? Is it possible to create this kind of notification without changing the default configuration of Creatio?

Show all comments

Hi, I have a problem when I first start the Creatio application. I followed the instructions shown in the training and after logging in to the application (the login window appears correctly) I get a blank page and in the logs (Temp/Creatio/D1Dev/Log//Error.log) I see an error:


2025-02-18 09:51:32,298 [1] ERROR IIS APPPOOL\D1Dev Terrasoft.Core.SchemaManagerProvider InitializeConfigurationFromDI - Could not initialize manager provider configuration from DI
System.ArgumentNullException: Value cannot be null.
Parameter name: provider
  at System.ThrowHelper.Throw(String paramName)
  at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetServices[T](IServiceProvider provider)
  at Terrasoft.Core.SchemaManagerProvider.InitializeConfigurationFromDI()
2025-02-18 09:51:32,698 [1] ERROR IIS APPPOOL\D1Dev Terrasoft.Core.SchemaManagerProvider InitializeConfigurationFromDI - Could not initialize manager provider configuration from DI
System.ArgumentNullException: Value cannot be null.
Parameter name: provider
  at System.ThrowHelper.Throw(String paramName)
  at Microsoft.Extensions.DependencyInjection.ServiceProviderServiceExtensions.GetServices[T](IServiceProvider provider)
  at Terrasoft.Core.SchemaManagerProvider.InitializeConfigurationFromDI()

 

These are screenshot of the blan page with the console and network tabs logs

Like 0

Like

1 comments

Hello,

We have received the results of the research from our development team:

The error “Terrasoft.Core.SchemaManagerProvider InitializeConfigurationFromDI” occurs only at the start of the application, because at this point the DI provider (which is a fairly new functionality in Creatio for back-end engines) is not initialized. This exception is caught, recorded only in the log file, and does not affect the program's operation. You can ignore this message.

Our developers have also opened an issue to fix this behavior in future releases of Creatio.

​​​​​​​Please advise, does the problem recur all the time or is this your first time logging in?

When installing an application, by default the first login always takes a long time to load, as the site needs to fetch all the data. Upon further logins to the site, it loads faster.

 

Show all comments

Hello everyone,

I'm working on a custom duration validator in Creatio, but I'm running into an issue where the function returns invalidMessage before the validation logic completes.

Here’s a simplified version of my function:

durationValidator: function(){
                var invalidMessage="";
                var name=this.get("UsrNameLookup").value ?? null;
                var currentDuration=this.get("UsrDurationMinute");
                if(!name){
                    return;
                }
                var esqDuration = this.Ext.create("Terrasoft.EntitySchemaQuery", {
               rootSchemaName: "UsrPerformances"
           });
                esqDuration.addColumn("UsrDurationMinute");
                // var groupFilters = this.Ext.create("Terrasoft.FilterGroup");
                
                var totalDuration = 0;
                if(this.isAddMode()){
                    var nameFilter = this.Terrasoft.createColumnFilterWithParameter(this.Terrasoft.ComparisonType.EQUAL, "UsrNameLookup", name);
                // groupFilters.addItem(filterId);
                esqDuration.filters.add("esqFirstFilter",nameFilter);
                    esqDuration.getEntityCollection(function(result) {
                   if (!result.success) {
                       this.showInformationDialog("Request error");
                       return;
                   } else {
                       result.collection.each(function(item) {
                               totalDuration += item.get("UsrDurationMinute");
                           }
                       );
 
                   }
                   totalDuration += currentDuration;
                        console.log(totalDuration);
                   this.Terrasoft.SysSettings.querySysSettingsItem("UsrMaximumDuration", function(maxDuration) {
                       // console.log("td"+totalDuration);
                       if (totalDuration > maxDuration) {
                            this.set("Numbervalue", false);
                           this.showInformationDialog("No more than " + maxDuration + " total performances duration is allowed.");
                            invalidMessage= "No more than " + maxDuration + " total performances duration is allowed.";
                            return{
                                invalidMessage: invalidMessage
                            };
                       } 
                        else {
                            this.set("Numbervalue", true);
                            invalidMessage="";
                            return{
                                invalidMessage: invalidMessage
                            };
                       }
                   }, this);
 
               }, this);
                }else{
                    console.log("else");
                    var nameFilter = this.Terrasoft.createColumnFilterWithParameter(this.Terrasoft.ComparisonType.EQUAL, "UsrNameLookup", name);
                
                
                    var idFilter = this.Terrasoft.createColumnFilterWithParameter(this.Terrasoft.ComparisonType.NOT_EQUAL, "Id", this.get("Id"));
                    esqDuration.filters.logicalOperation = Terrasoft.LogicalOperatorType.AND;
                    esqDuration.filters.add("esqFirstFilter",nameFilter);
                    esqDuration.filters.add("esqSecondFilter", idFilter);
                    esqDuration.getEntityCollection(function(result) {
                   if (!result.success) {
                       this.showInformationDialog("Request error");
                       return;
                   } else {
                       result.collection.each(function(item) {
                               totalDuration += item.get("UsrDurationMinute");
                           }
                       );
                       // console.log("i am running");
                       // let prevduration=this.get("UsrprevDuration");
                       // console.log("previous duration"+ prevduration);
                       totalDuration += currentDuration;
 
                   }
                    console.log(totalDuration);
                   this.Terrasoft.SysSettings.querySysSettingsItem("UsrMaximumDuration", function(maxDuration) {
                       // console.log("td"+totalDuration);
                       if (totalDuration > maxDuration) {
                            this.set("Numbervalue", false);
                           this.showInformationDialog("No more than " + maxDuration + " total performances duration is allowed minutes.");
                            invalidMessage="No more than " + maxDuration + " total performances duration is allowed.";
                            return{
                                invalidMessage: invalidMessage
                            };
                       } else {
                           this.set("Numbervalue", true);
                            invalidMessage="";
                            return{
                                invalidMessage: invalidMessage
                            };
                       }
                   }, this);
 
               }, this);
            
                    
            }
                console.log(invalidMessage);
                return{
                                invalidMessage: invalidMessage
                            };
                },
 
 
The console.log(invalidMessage); statement always prints an empty string.
  • The function returns <strong>invalidMessage</strong> before the asynchronous operations (getEntityCollection and querySysSettingsItem) complete.
  • As a result, validation messages do not appear correctly.
Like 0

Like

4 comments

Jerome BERGES,

Thanks for answering, I tried different approach like this https://academy.creatio.com/docs/8.x/dev/development-on-creatio-platform/getting-started/first-app/develop-application/step-3-add-page-validation and it works.

Is there any i can perform same validation on detail of some custom page.

Darshan Dev Prajapat,

The problem with the article you linked to and what you're trying to accomplish is that you're using asynchronous methods inside the validator, which won't work with a synchronous validation method since the validation method will return before you've retrieved the asynchronous results. You need to switch to the asyncValidate (see link provided by Jerome) in order to use asynchronous methods (such as EntitySchemaQuery, SysSettings retrieval, etc).

The main difference in the article you linked to and your code is that the article performs the ESQ outside of the validator, when the onEntityInitialized fires, not inside the validator (which is what you're doing). To do asynchronous operations like ESQ (and using SysSettings) you need to use the asyncValidate method.

Ryan

Ryan Farley,


Thanks for the detailed explanation. I am using onEntityInitialized for validation, and it is working for me. However, I would like to know if there is a way to perform the same validation where this performance detail is being used, such as on a custom page.

 

Show all comments

Greetings!

 

Have noticed that field BlindCopyRecipient in Activity is not being populated when receving an email, that was send using bcc field and specifying an email address that is configured for synchronization.  However email is synchronized and showing correctly in communication panel. Is it a bug or feature?

 

Like 1

Like

1 comments
Best reply

Hello, 

Such behavior is indeed reproduced when the recipients of the email are in the BCC field. If the "To" and "CC" fields are empty, and the recipients are in BCC, this behavior is expected. 

Logic behind how the BCC field works:
The BCC field in the letter is seen only by the sender, and only in the sent email folder. This behavior is based on the message data transfer logic at the email server level; the recipient in the blind copy does not have access to view the list in the BCC field. None of the recipients will see the blind copy (even if you send it to yourself). Therefore, the BCC field in Creatio will be filled in only in two cases: - the letter was sent from our system, and while sending, you need to specify the recipients in this field. - the letter was synchronized from the sent letters folder. In other cases, the BCC field in Creatio will be empty. Since for these emails, recipients were not specified in the "To" and "CC" fields, only in BCC, which according to the logic of the field's operation, we do not see, there is a situation where the email is synchronized, but there are no recipients. Please note that Creatio cannot influence this behavior in any way, as we only synchronize the email from the mail server with the same parameters as the parameters of this email. Since the "To", "CC", "BCC" fields are empty in Outlook itself, they will also be empty in Creatio. 

Best regards,
Ivan

Hello, 

Such behavior is indeed reproduced when the recipients of the email are in the BCC field. If the "To" and "CC" fields are empty, and the recipients are in BCC, this behavior is expected. 

Logic behind how the BCC field works:
The BCC field in the letter is seen only by the sender, and only in the sent email folder. This behavior is based on the message data transfer logic at the email server level; the recipient in the blind copy does not have access to view the list in the BCC field. None of the recipients will see the blind copy (even if you send it to yourself). Therefore, the BCC field in Creatio will be filled in only in two cases: - the letter was sent from our system, and while sending, you need to specify the recipients in this field. - the letter was synchronized from the sent letters folder. In other cases, the BCC field in Creatio will be empty. Since for these emails, recipients were not specified in the "To" and "CC" fields, only in BCC, which according to the logic of the field's operation, we do not see, there is a situation where the email is synchronized, but there are no recipients. Please note that Creatio cannot influence this behavior in any way, as we only synchronize the email from the mail server with the same parameters as the parameters of this email. Since the "To", "CC", "BCC" fields are empty in Outlook itself, they will also be empty in Creatio. 

Best regards,
Ivan

Show all comments

Hi,

 

I am using '8.2.1.5446_Studio_Softkey_MSSQL_ENU' build package for local Creatio development. I can login and use only a few App buttons (precisely speaking Creatio AI dashboards, Creatio AI setup, Studio homepage and UI management). But, for other App buttons (like Lookup, Webhooks, Users, System Settings, etc.), an empty page loads. I am attaching a screenshot for reference. Can you please help me to resolve this issue?

 

When I do 'Inspect', I see a bunch of errors like -

Failed to load resource: the server responded with a status of 404 (Not Found)Understand this error -configuration/2ccc1a4cd18a5baa438a5dda5d9c513aen-US/SectionModuleV2.js:1
 
Refused to execute script from 'http://localhost/KP_App/0/configuration/2ccc1a4cd18a5baa438a5dda5d9c513aen-US/SectionModuleV2.js' because its MIME type ('text/html') is not executable, and strict MIME type checking is enabled.
 
user: Supervisor/7f3b869f-34f3-4f20-ab4d-7480a5fdf647
 file: http://localhost/KP_App/0/Shell/8096.22ae89967ffcf264.js
 line: 97
 column: 16846
 message: Uncaught Error: Script error for "SectionModuleV2"
http://requirejs.org/docs/errors.html#scripterror 
 date: Fri Feb 14 2025 16:55:22 GMT+0000 (Coordinated Universal Time)
 stack: Error: Script error for "SectionModuleV2"
http://requirejs.org/docs/errors.html#scripterror
    at makeError (http://localhost/KP_App/core/hash/requirejs/require.js?v=482289676:168:17)
    at HTMLScriptElement.onScriptError (http://localhost/KP_App/core/hash/requirejs/require.js?v=482289676:1742:36)
    at xt.invokeTask (http://localhost/KP_App/0/Shell/8096.22ae89967ffcf264.js:97:7571)
    at mt.runTask (http://localhost/KP_App/0/Shell/8096.22ae89967ffcf264.js:97:2530)
    at zt.invokeTask [as invoke] (http://localhost/KP_App/0/Shell/8096.22ae89967ffcf264.js:97:8718)
    at qe (http://localhost/KP_App/0/Shell/8096.22ae89967ffcf264.js:97:16333)
    at bt (http://localhost/KP_App/0/Shell/8096.22ae89967ffcf264.js:97:16678)
    at HTMLScriptElement.ct (http://localhost/KP_App/0/Shell/8096.22ae89967ffcf264.js:97:16980)
Like 2

Like

3 comments

Hello,

Please contact support team at support@creatio.com and provide more details of the issue along with an access or the logs to the site where it occurs to proceed with the investigation.

Hey, did this issue get resolved?

 

Yes, to fix this issue, please follow these steps: 
1) Run one of the scripts 
2) Compile the system. 
After that, you can re-enable "Development in the file system" and the problem should no longer occur. 

Show all comments

I need to convert a decimal field into words for a report template. Can this be done with a formula or does it have to be a script?

Like 0

Like

2 comments

I have created a script to turn integers into words and it keeps compiling with errors.

 

heres the script:

 

using System;
using System.Text;
using Terrasoft.Core;
using Terrasoft.Core.Entities;
using Terrasoft.Core.Process;

public class ConvertCurrencyToTextTask : ProcessUserTask
{
   // ✅ Constructor
   public ConvertCurrencyToTextTask(ProcessExecutingContext context) : base(context) { }

   // ✅ Main execution method (Runs when the Script Task is triggered)
   public override bool CompleteExecuting(UserConnection userConnection)
   {
       try
       {
           // ✅ Retrieve the requested amount from the process parameter
           decimal requestedAmount = Get("DfcReqAmt");

           // ✅ Retrieve the dynamically fetched record ID
           Guid recordId = Get("Id");

           // ✅ Convert the numeric amount to words
           string convertedText = ConvertToWords(requestedAmount);

           // ✅ Store the result in the output parameter
           Set("DfcRequestedAmountText", convertedText);

           // ✅ Update the record in the FinApplication object
           UpdateRecord(userConnection, recordId, convertedText);
       }
       catch (Exception ex)
       {
           throw new Exception("Error in ConvertCurrencyToTextTask: " + ex.Message);
       }

       
   }

   // ✅ Converts numbers to words (DYNAMIC)
   private string ConvertToWords(long number)
   {
       if (number == 0)
           return "Zero";

       if (number < 0)
           return "Negative " + ConvertToWords(Math.Abs(number));

       string words = "";
       int thousandIndex = 0;

       while (number > 0)
       {
           if (number % 1000 != 0)
           {
               words = ConvertHundreds(number % 1000) + Thousands[thousandIndex] + " " + words;
           }
           number /= 1000;
           thousandIndex++;
       }

       return words.Trim();
   }

   // ✅ Converts hundreds, tens, and ones
   private string ConvertHundreds(long number)
   {
       string words = "";

       if (number >= 100)
       {
           words += Ones[number / 100] + " Hundred ";
           number %= 100;
       }

       if (number >= 10 && number <= 19)
       {
           words += Teens[number - 10] + " ";  // ✅ Corrected indexing for Teens
       }
       else
       {
           words += Tens[number / 10] + " ";
           words += Ones[number % 10] + " ";
       }

       return words.Trim();
   }

   // ✅ Updates the record with the converted text
   private void UpdateRecord(UserConnection userConnection, Guid recordId, string convertedText)
   {
       if (recordId == Guid.Empty) // ✅ Ensures ID is valid before updating
           throw new Exception("Record ID is empty, cannot update record.");

       var entitySchema = userConnection.EntitySchemaManager.GetInstanceByName("FinApplication");
       var entity = entitySchema.CreateEntity(userConnection);

       if (entity.FetchFromDB(recordId))
       {
           entity.SetColumnValue("DfcRequestedAmountText", convertedText);
           entity.Save();
       }
   }

   // ✅ Number arrays (DYNAMIC)
   private readonly string[] Ones = { "", "One", "Two", "Three", "Four", "Five", "Six", "Seven", "Eight", "Nine" };
   private readonly string[] Teens = { "Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen" };
   private readonly string[] Tens = { "", "", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety" };
   private readonly string[] Thousands = { "", "Thousand", "Million", "Billion", "Trillion" };
} // ✅ Class correctly closed

 

 

return true; // ✅ Ensures method completes properly
 

 

 

 

these are the errors I am getting:

 

DfcProcess_25a93f1.DfcLoans.cs    Identifier expected    CS1001    34
DfcProcess_25a93f1.DfcLoans.cs    Identifier expected    CS1001    33
DfcProcess_25a93f1.DfcLoans.cs    Identifier expected    CS1001    35
DfcProcess_25a93f1.DfcLoans.cs    Type or namespace definition, or end-of-file expected    CS1022    151
DfcProcess_25a93f1.DfcLoans.cs    } expected    CS1513    36
DfcProcess_25a93f1.DfcLoans.cs    Identifier expected    CS1001    32
DfcProcess_25a93f1.DfcLoans.cs    Identifier expected    CS1001    36

 

Not sure what is missing as far as syntax goes, all bracket appear to be in place.

 

Appreciate the help in advance.

 

 

 

 

Like 1

Like

4 comments

Hi,

 

The error is related to the business proceess DfcProcess_25a93f1. Can you share a source code for the business process, not the user task you shared? You can get the source code of the business process here:

There was no source code?

Hello,
 

In this case, do you perform development on a local environment?

If so, could you search for the schema in the {rootAppFolder}\Terrasoft.WebApp\Terrasoft.Configuration\Pkg\DfcLoans\Autogenerated\Src\DfcProcess_25a93f1.DfcLoans.cs directory?

You can also find the location of the file that causes compilation errors if you look at the application logs (Build.log) for the day of compilation and errors.

Show all comments