8.0 | Community Creatio

17:40 Mar 14, 2023

Dear Creatio,

I am stuck on loading screen for a while now. Existing tabs still work but opening new tabs or refreshing a tab gives me a forever loading screen with Creatio 8 Atlas.

Yours sincerely,

Pascal

1 comments

Anastasiia Zhuravel

12:06 Mar 15, 2023

Hello Pascal,

If it's your on-site instance we'd suggest to try to restart the site/IIS. If it's cloud instance, please contact the support team at support@creatio.com for further investigation, additionally I'd suggest to provide the team with detailed screenshots of the error you have.

Best regards,

Anastasiia

Show all comments

Some business processes cannot be cancelled. The parent process has already been cancelled.

Pascal

17:25 Mar 14, 2023

Dear Creatio,

I apparently ran out of memory. The parent process gave an error, I cancelled this process and all sub processes cancelled automatically, except for about 20 processes. Status is Running, unable to cancel since the parent needs to be cancelled first, but the parent has already been cancelled.

Yours sincerely,

Pascal

1 comments

Anastasiia Zhuravel

11:27 Mar 15, 2023

Hello Pascal,

We'd suggest to first stop the process execution and then try to delete it.

Please let us know if the issue persists.

Best regards,

Anastasiia

Show all comments

Oliver Crowe

16:12 Mar 14, 2023

I made a post before which didnt get any replies than to contact Creatio support which doesnt provide support for this, any help would be appreciated

1 comments

Bogdan

16:20 Mar 14, 2023

Hello Oliver,

Please, re-install Microsoft Visual C++ 2010:

https://www.microsoft.com/en-us/download/details.aspx?id=26999

Show all comments

Error with Json library

LAVIGNE Vincent

13:05 Mar 14, 2023

Hello Community,

I have a PrestaShop website to allow my important customers to simplify their hardware orders.

I am therefore in the process of developing a webservice to interface the two systems, the exchange of data being done in Json format.

The first feasibility tests were done in version 7.18.5 of Creatio with libraries

Newtonsoft.Json
Newtonsoft.Json.Linq
System.Web.Script

We have now moved to a new phase on a Creatio 8.0.5 and the USING of these libraries now cause problems when compiling...

Have you encountered this anomaly before?

Do you have examples of Json deserialization code with other libraries?

Thank you in advance for your help.

Vincent

5 comments

Mykhailo Zeleniuk

17:00 Mar 17, 2023

Greetings,

We have checked the information with our R&D team and it is as follows:

Newtonsoft.Json;

Newtonsoft.Json.Linq;

Both of these should work with no problem with the new versions of Creatio, but

System.Web.Script

Needs some adjustments from your side, since you have an on-site system.

The adjustments are as follows:

Within the file \Terrasoft.WebApp\Terrasoft.Configuration\Terrasoft.Configuration.Dev.csproj

Within this section: <ItemGroup Label=".NET references">

You should add this reference <Reference Include="System.Web.Extensions" />

And correctly use the beforementioned libraries (Newtonsoft.Json; Newtonsoft.Json.Linq;) in C# schemas

LAVIGNE Vincent

18:28 Mar 23, 2023

Hello Mykhailo Zeleniuk,

Right now, my code is very simple (see screenshot), so I'm bothered by the compilation error...

Especially since the same code worked in version 7.18.5.

Someone would have examples of Json deserialization code with other libraries than Newtonsoft ?

Thanks

Vincent

Oleg Drobina

12:25 Mar 27, 2023

LAVIGNE Vincent,

I did an example of a webservice that returns a JSON string result using only System; and System.Text.Json. The code is below:

namespace Terrasoft.Configuration.UsrCustomServiceNamespace
{
    using System;
	using System.Text.Json;
    using System.ServiceModel;
    using System.ServiceModel.Web;
    using System.ServiceModel.Activation;
    using Terrasoft.Core;
    using Terrasoft.Web.Common;
    using Terrasoft.Core.Entities;
 
 
 
	public class SerializedObject
	{
		public string FirstPart { get; set; }
		public string SecondPart { get; set; }
		public string ThirdPart { get; set; }
	}
 
    [ServiceContract]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Required)]
    public class UsrCustomService: BaseService
    {
 
		private SystemUserConnection _systemUserConnection;
        private SystemUserConnection SystemUserConnection
		{
            get
			{
                return _systemUserConnection ?? (_systemUserConnection = (SystemUserConnection)AppConnection.SystemUserConnection);
            }
        }
 
	[OperationContract]
        [WebInvoke(Method = "GET", RequestFormat = WebMessageFormat.Json, BodyStyle = WebMessageBodyStyle.Wrapped,
        ResponseFormat = WebMessageFormat.Json)]
        public string ReturnCustomResult(string param1, string param2, string param3)
		{
			var objectToSerialize = new SerializedObject
            {
                FirstPart = param1,
                SecondPart = param2,
                ThirdPart = param3,
            };
			string jsonString = JsonSerializer.Serialize(objectToSerialize);
			return jsonString;
		}
	}
}

As a result calling this endpoint http://localhost:1026/0/ServiceModel/UsrCustomService.svc/ReturnCustomR… returned this result:

{"ReturnCustomResultResult":"{\"FirstPart\":\"test1\",\"SecondPart\":\"test2\",\"ThirdPart\":\"test3\"}"}

So you can this approach on your side as well.

Oleg Drobina

12:27 Mar 27, 2023

And the test was performed in 8.0.6 full bundle application (sales + marketing + service) MS SQL.

LAVIGNE Vincent

16:34 Mar 27, 2023

Hello Oleg Drobina,

Thank you very much for your answer, I will try to adapt your example code to my case.

Indeed, I want to retrieve a JSON which is in the body of the HTTP request, so do more of a "Deserialize" request.

If you have an example of code in this way too, I am interested.

Thanks

Vincent

Show all comments

Help Setting Up Process Activities

tom

12:33 Mar 14, 2023

Hi,

I'm looking for some guidance on setting up a process.

I want the process to run once per week, reading all Activities where the start date is <= Yesterday and the field (Result) is not filled in.

Then I want the process to send 1 E-mail to the organiser listing the records that need the results field completing.

I'm relatively new to processes and sub processes so any guidance would be really appreciated.

1 comments

Anastasiia Zhuravel

11:24 Mar 15, 2023

Hello Tom,

You can design your business process to run once a week with a help of "[Start timer] event" element, more detailed information is available on our Academy:

https://academy.creatio.com/docs/user/bpm_tools/process_elements_refere…

Best regards,

Anastasiia

Show all comments

8.0

Placeholder in section list page

Korni Manideep Reddy

11:55 Mar 14, 2023

Hi Community,

Can we add some default text to columns when column value is empty? just like placeholders in input field.

Thank you in advance.

Regards,

Manideep

1 comments

Mira Dmitruk

13:10 Mar 14, 2023

Hello,

Pease note that you can set a default value for a column in the configuration section. Find the object where this column is located, open the settings of the column and specify its default value there:

Alternatively, you can build a business process that will run automatically upon creating a record and will fill in the value of the needed column if it's empty.

Show all comments

Ml_model

Sales_Creatio

8.0

ML Models : opportunity scoring

Patrice-ABPost

10:14 Mar 14, 2023

Hello,

lately, I had a look at the ML models and wonder why the opportunity scoring remains at zero since the scoring widget was added :

The OOB ML Model (Predictive Opportunity Scoring) stop with this error :

Can't automatically determine type for expression(s): StartDateLastStage. Generated query: SELECT [O].[Id], [O].[CreatedOn], [OIS].[StartDateLastStage], [O].[TypeId], [O].[StageId], [O].[AccountId], [O].[CategoryId], [O].[MoodId], [O].[IsPrimary], [O].[PartnerId], [O].[Budget], [O].[Amount], [O].[SourceId], [O].[ResponsibleDepartmentId], [O].[LeadTypeId], [A].[OwnershipId], [A].[IndustryId], [A].[TypeId] [AccountTypeId], [A].[AccountCategoryId], [A].[EmployeesNumberId], [A].[AnnualRevenueId], DATEDIFF(DAY, [O].[CreatedOn], [OIS].[CloseDate]) [DaysInFunnel], DATEDIFF(DAY, [OIS].[StartDateLastStage], [OIS].[CloseDate]) [DaysInLastStage], ( SELECT COUNT(*) FROM [dbo].[OpportunityContact] [OC] WITH(NOLOCK) WHERE [OC].[OpportunityId] = [O].[Id]) [OpportunityContactsNumber], ( SELECT COUNT(*) FROM [dbo].[Contact] [C] WITH(NOLOCK) WHERE [A].[Id] = [C].[AccountId]) [AccountContactsNumber], ( SELECT COUNT(*) FROM [dbo].[Lead] [L] WITH(NOLOCK) WHERE [L].[CreatedOn] < [OIS].[CloseDate] AND [L].[QualifiedAccountId] = [A].[Id]) [AccountLeadsTotalNumber], ( SELECT COUNT(*) [cnt] FROM [dbo].[Activity] [Act] WITH(NOLOCK) INNER JOIN [dbo].[ActivityResult] [Ar] WITH(NOLOCK) ON ([Act].[ResultId] = [Ar].[Id]) WHERE [Act].[OpportunityId] = [O].[Id] AND [Ar].[Id] = @P1 AND [Act].[TypeId] = '{E3831DEC-CFC0-DF11-B00F-001D60E938C6}') [OpportunityMeetingsTotal], ( SELECT COUNT(*) [cnt] FROM [dbo].[Activity] [Act] WITH(NOLOCK) INNER JOIN [dbo].[ActivityResult] [Ar] WITH(NOLOCK) ON ([Act].[ResultId] = [Ar].[Id]) WHERE [Act].[OpportunityId] = [O].[Id] AND [Ar].[Id] = @P2 AND [Act].[TypeId] = '{E1831DEC-CFC0-DF11-B00F-001D60E938C6}') [OpportunityCallsTotal], ( SELECT COUNT(*) [cnt] FROM [dbo].[Activity] [Act] WITH(NOLOCK) INNER JOIN [dbo].[ActivityResult] [Ar] WITH(NOLOCK) ON ([Act].[ResultId] = [Ar].[Id]) WHERE [Act].[AccountId] = [O].[AccountId] AND [Act].[CreatedOn] < [OIS].[CloseDate] AND [Ar].[Id] = @P3 AND [Act].[TypeId] = '{E3831DEC-CFC0-DF11-B00F-001D60E938C6}') [AccountMeetingsTotal], ISNULL(( SELECT DATEDIFF(DAY, MAX([Act].[StartDate]), [OIS].[CloseDate]) [cnt] FROM [dbo].[Activity] [Act] WITH(NOLOCK) WHERE [Act].[AccountId] = [O].[AccountId] AND [Act].[TypeId] = '{E3831DEC-CFC0-DF11-B00F-001D60E938C6}'), 0) [AccountDaysToLastMeeting], ( SELECT COUNT(*) [cnt] FROM [dbo].[Activity] [Act] WITH(NOLOCK) INNER JOIN [dbo].[ActivityResult] [Ar] WITH(NOLOCK) ON ([Act].[ResultId] = [Ar].[Id]) WHERE [Act].[AccountId] = [O].[AccountId] AND [Act].[CreatedOn] < [OIS].[CloseDate] AND [Ar].[Id] = @P4 AND [Act].[TypeId] = '{E1831DEC-CFC0-DF11-B00F-001D60E938C6}') [AccountCallsTotal], ISNULL(( SELECT DATEDIFF(DAY, MAX([Act].[StartDate]), [OIS].[CloseDate]) [cnt] FROM [dbo].[Activity] [Act] WITH(NOLOCK) WHERE [Act].[AccountId] = [O].[AccountId] AND [Act].[TypeId] = '{E1831DEC-CFC0-DF11-B00F-001D60E938C6}'), 0) [AccountDaysToLastCall], ( SELECT COUNT(*) [cnt] FROM [dbo].[Activity] [Act] WITH(NOLOCK) INNER JOIN [dbo].[ActivityResult] [Ar] WITH(NOLOCK) ON ([Act].[ResultId] = [Ar].[Id]) WHERE [Act].[AccountId] = [O].[AccountId] AND [Act].[CreatedOn] < [OIS].[CloseDate] AND [Ar].[Id] = @P5 AND [Act].[TypeId] = '{E2831DEC-CFC0-DF11-B00F-001D60E938C6}') [AccountEmailsTotal], ISNULL(( SELECT DATEDIFF(DAY, MAX([Act].[StartDate]), [OIS].[CloseDate]) [cnt] FROM [dbo].[Activity] [Act] WITH(NOLOCK) WHERE [Act].[AccountId] = [O].[AccountId] AND [Act].[TypeId] = '{E2831DEC-CFC0-DF11-B00F-001D60E938C6}'), 0) [AccountDaysToLastEmail] FROM [dbo].[Opportunity] [O] WITH(NOLOCK) INNER JOIN ( SELECT MAX([OS].[StartDate]) [StartDateLastStage], MAX([OS].[DueDate]) [CloseDate], [OS].[OpportunityId] [OpportunityId] FROM [dbo].[OpportunityInStage] [OS] WITH(NOLOCK) GROUP BY [OS].[OpportunityId]) [OIS] ON ([OIS].[OpportunityId] = [O].[Id]) LEFT OUTER JOIN [dbo].[Account] [A] WITH(NOLOCK) ON ([O].[AccountId] = [A].[Id]) WHERE [O].[StageId] IN ('{60D5310C-5BE6-DF11-971B-001D60E938C6}', '{A9AAFDFE-2242-4F42-8CD5-2AE3B9556D79}', '{736F54FD-E240-46F8-8C7C-9066C30AFF59}') ORDER BY [O].[CreatedOn] DESC

Is it a known issue ? did i miss something ?

Best regards

Patrice

4 comments

Best reply

Gleb

13:57 Mar 14, 2023

Hello Patrice,

it seems like you added some data to the model which cannot be correctly proccessed. There is a chance it was a column with the type "Date" which cannot be operated automatically.

To fix this, you need to delete the "StartDateLastStage" column from the request for the machine learning model.

Regards,

Gleb.

Gleb

13:57 Mar 14, 2023

Hello Patrice,

it seems like you added some data to the model which cannot be correctly proccessed. There is a chance it was a column with the type "Date" which cannot be operated automatically.

To fix this, you need to delete the "StartDateLastStage" column from the request for the machine learning model.

Regards,

Gleb.

Patrice-ABPost

14:42 Mar 14, 2023

Hi Gleb,

thanks for your answer.

in "Advanced tools for adding columns", i deleted the StartDateLastStage part in the sql query :

the model works now.

Though I'm not sure what happened, as the model is a OOB one which was not modified from our side.

Best regards

Patrice

Gleb

15:28 Mar 14, 2023

Patrice-ABPost,

thnks for letting me know.

I will pass this information to the dev team so they can take a look.

Regards,

Gleb.

Patrice-ABPost

18:46 Mar 14, 2023

mmh, after all it does not seems to work so well :

the model testing is ok, but when using [Predict data] process element, an error occur, i must have messed up the model.

Maybe i should start from a fresh new model, or maybe use the 7.14.0 version of the model, which is available in the model collection.

System.AggregateException: One or more errors occurred. ---&gt; Terrasoft.Web.Http.Abstractions.HttpException: [InternalServerError] {"responseStatus":{"errorCode":"InternalServerError","message":"Engine: [UsageException] ['CreatedOn']: Column(s) ['CreatedOn']] contain missing values"}} ---&gt; System.Exception: {"responseStatus":{"errorCode":"InternalServerError","message":"Engine: [UsageException] ['CreatedOn']: Column(s) ['CreatedOn']] contain missing values"}}
   --- End of inner exception stack trace ---
   at Terrasoft.Configuration.ML.MLServiceProxy.TransformResponseErrorByStatus(IRestResponse response)
   at Terrasoft.Configuration.ML.MLServiceProxy.Post[T](String methodName, Object requestBody, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Predict[TOut](Guid modelInstanceUId, String methodName, PredictionInput predictionParams, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Predict[TOut](Guid modelInstanceUId, IList`1 dataList, String methodName, DatasetInput defaultPredictionParams, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Score(MLModelConfig model, IList`1 dataList, Boolean predictContributions)
   at Terrasoft.Configuration.ML.MLBaseEntityPredictor`1.Predict(MLModelConfig modelConfig, IList`1 dataList, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.Predict(MLModelConfig model, IList`1 dataList, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.&lt;&gt;c__DisplayClass17_0.&lt;Predict&gt;b__0(IList`1 dataForPrediction)
   --- End of inner exception stack trace ---
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.Predict(MLModelConfig modelConfig, Action`1 chunkPredictedHandler, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictionJob.PredictAndSaveResult(MLModelConfig model, UserConnection userConnection, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictionJob.ProcessModel(UserConnection userConnection, Guid modelId, String filterData, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Core.Process.Configuration.MLDataPredictionUserTask.InternalExecute(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessActivity.RunInCultureScope[T](Func`1 action)
   at Terrasoft.Core.Process.ProcessActivity.ExecuteElement(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessActivity.ExecuteItem(ProcessExecutingContext context)
   at Terrasoft.Core.Process.ProcessFlowElement.Execute(ProcessExecutingContext context)
---&gt; (Inner Exception #0) Terrasoft.Web.Http.Abstractions.HttpException (0x80004005): [InternalServerError] {"responseStatus":{"errorCode":"InternalServerError","message":"Engine: [UsageException] ['CreatedOn']: Column(s) ['CreatedOn']] contain missing values"}} ---&gt; System.Exception: {"responseStatus":{"errorCode":"InternalServerError","message":"Engine: [UsageException] ['CreatedOn']: Column(s) ['CreatedOn']] contain missing values"}}
   at Terrasoft.Configuration.ML.MLServiceProxy.TransformResponseErrorByStatus(IRestResponse response)
   at Terrasoft.Configuration.ML.MLServiceProxy.Post[T](String methodName, Object requestBody, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Predict[TOut](Guid modelInstanceUId, String methodName, PredictionInput predictionParams, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Predict[TOut](Guid modelInstanceUId, IList`1 dataList, String methodName, DatasetInput defaultPredictionParams, Int32 timeoutSec)
   at Terrasoft.Configuration.ML.MLServiceProxy.Score(MLModelConfig model, IList`1 dataList, Boolean predictContributions)
   at Terrasoft.Configuration.ML.MLBaseEntityPredictor`1.Predict(MLModelConfig modelConfig, IList`1 dataList, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.Predict(MLModelConfig model, IList`1 dataList, MLDataPredictionUserTask predictionUserTask)
   at Terrasoft.Configuration.ML.MLBatchPredictor`1.&lt;&gt;c__DisplayClass17_0.&lt;Predict&gt;b__0(IList`1 dataForPrediction)&lt;---

Show all comments

Business Process stops after iterating through thousands of records.

Pascal

16:14 Mar 13, 2023

Dear sir, madam,

I am syncing contacts and orders with their products via a webservice. I am syncing about 100k records. It goes very slow and just stops iterating without an error message. In the execution diagram I see nothing odd. It just hangs on 'Running' and nothing happens.

There are also no logs since there is no error.

What is going wrong and why is it so slow?

1 comments

Artem

16:37 Mar 17, 2023

Hello,

Typically importing vast amounts does take substantial amounts of resources and time it's inevitable.

As for an error, there could be a myriad of possible reasons for it so I would recommend you contact Creatio support so they could take a look.

Just us an email here - support@creatio.com.

Thank you.

Show all comments

Portal Pages in Freedom UI

luis.goncalves@imdigital.pt

14:58 Mar 13, 2023

Hi everyone,

Is it possible to build custom pages and section in freedom UI for Customer Portal users?

Thks,

Luis

1 comments

Mykhailo Zeleniuk

15:32 Mar 14, 2023

Greetings,

Currently, Freedom UI is not support for Customer Portal, but we already have a registered task for the R&D team in regards to this question.

We have linked this post to the beforementioned R&D task to expedite the implementation process.

Show all comments

I cannot find any process logs named 'Case'

Pascal

12:40 Mar 13, 2023

When a status changes on a record I used a case to trigger a business process. However a mistake was made and I need to cancel these business processes (they prompted the user a question).

I cannot cancel them as they are seen as a sub process of 'Case'. I cannot find any process called Case that is running in process logs.

Now I need to open each business process, select parent process, cancel process.

1 comments

Artem

15:02 Mar 14, 2023

Good day,

Basically, the "Case" process is the DCM that is running in your record.

You can manually find the launched processes, go into its parent process and cancel the DCM outright.

Alternatively, you can just move the case stage into the next one (or into the canceled stage) which will finish all of the previous actions.

If you wish to see the DCM in the process log, you can turn on the debug mode of Creatio which will show them in there (please make to turn it off after you are done).

Thank you.

Show all comments

Subscribe to 8.0