Hi,

We need to integrate 3rd party web application with Creatio DataBase using OData4.

Our question is:

How many concurrent connections with the same Creatio user does Creatio system support?

 

Is it OK to set "ApiUser" Creatio user, and use this user to interact with Creatio with LOTS of concurrent  API requests to  Creatio?

 

Thanks,

Eran.

 

Like 0

Like

1 comments

Good day,

 

Sadly, we do not have exact specifications and limits on the number of connections to Creatio.

You should only be limited by the specs of your Redis server that will have to process those connections.

 

We would additionally recommend you use a header of ForceUseSession: true.

Using a system user through whom you will pass the API request should also work fine.

 

Thank you.

Show all comments

Hello!

 

As Homepages have options to add different components, is it possible to add differenct filters (e.g. by Year, by Owner and so on) to different Lists?

 

E.g. we have list of ordered and invoiced products. So, users should have options to filter these lists by predefined fields (Year, Owner)



Thank you for help!

Like 3

Like

1 comments

Hello,

 

Unfortunately, it is not possible to add an option to filter lists on a Homepage.

However, you specify data filtering conditions while setting up a chart as described in this article.



Best regards,

Yuliya Gritsenko

Show all comments

Hello Team,

When I create an address the GPSN and GPSE fields are not updated. THe map although shows the excat location as it should be. Any idea why this can happen ?

Sasori

Like 0

Like

3 comments

Hello, Sasori!

 

Could you please provide more details on how exactly did you add an account address?

Please note that GPS N and GPS E fields will populate only if you add an address manually.

For example, if you add value using import the fields won't be populated automatically.

Also, please try to reproduce the issue again but with an open browser console (press F12 to open it).

There might be errors that could help us find the cause of the issue.

 

Best regards,

Kate

Kate Karpik,

Thank your for the reply Kate.

The Account data and Account adress data are added in the system through integration with third party system via ODATA.

Should the problem exist in this scenario ?

Sasori

Kate Karpik,

From what I can understand the update of the GPS fields is done only when clicking Save (front-end event) in the Account Address.

Is there any way or workaround to update these fields if the Account and its address are created via the OData4 Protocol ?

Show all comments

Dear colleagues

 

If I want to add dynamic links in an email template, I tried to do adding a button to click to product with the URL to open the Web page get from a macro (URL is on a field on contact table), didn’t work, didn't add the tracking tokens, for example:

Normal button:

 "Dynamic" Button:

Any ideas how toe enable adding the tracking tokens to the "Dynamic" Button?

 

Thanks in advance

 

Best regards

Julio Falcón

Like 0

Like

3 comments

Hello Julio,

 

At this moment full macros link will not work for tracking, but there is a workaround with a link+macro tail.

 

So at this point instead of [#Contact.UsrButtonProdID2#] you will proceed with https://www.implementos.cl/[#Contact.UsrButtonProdID2#]?bpmtrackid=4

 

The domain of the website will be the same for the recipients, but the content will be dynamic.

 

Thank you for bringing this issue to our attention. We will consider making this mechanism more user-friendly in future releases.

 

Best Regards,

Dan

 

Thanks to anticipate the solution Dan, I will document it also

 

It appears when Creatio “see“ where must be a URL, a non-URL string, as is the case of a macro, it “think” there aren't any URL to track, and didn’t add the tokens, to complement Dan comment, what I did to solve the problem:

* In images I introduce, on the image address, the first part of the image URL “https://images.ClientWebStore.com/” and add the field using macro to complete the URL with the specific image address, getting something like this in the Image URL: https://images.ClientWebStore.com/[#Contact.UsrImgProdID2#], in the UsrImgProdID2 field I have the rest of the URL, like this "img/1000/HERCAR0005-1.jpg"
 
* For the Product, in Link to Open add “https://www.ClientWebStore.com/” and later the rest of the product URL from the macro, resulting value getting something like this https://www.ClientWebStore.com/[#Contact.UsrButtonProdID2#]  and works as is expected, Creatio add all the expected tokens. In the UsrButtonProdID2 field I have the rest of the URL to open the product page in the store, like "inicio/productos/ficha/gata-hidraulica-32-toneladas-HERCAR0005"

 

IT WORKS! thank you very much!

Show all comments

Hi,

 

From Postman I am calling a REST API by passing some parameters in x-www-form-urlencoded format. Please see the screenshot below : 

 

Header - Content Type - application/x-www-form-urlencoded

 

From Creatio I am using Web service section to call this same API but can't understand how to send these parameters in x-www-form-urlencoded

 

I think I am making mistake in defining the Parameter type of the parameters I am passing.

 

Please help urgently!

Like 1

Like

1 comments

Thank you for your question.



Unfortunately, Creatio does cant parse x-www-form-urlencoded type of requests as of yet.

We have already added this case to an existing development request in order to add this functionality in future releases.



There has been a similar question in our Creatio community in which a possible workaround was proposed.

I will leave a link to it here.

Show all comments

Every time i try to compile , this error shows up ! any solutions please ?

This is ther error in my log file :

2023-02-07 00:32:44,881 [149] ERROR IIS APPPOOL\Creatio Terrasoft.Core.UserConnection OnCurrentUserConnectionChanged - Overwriting UserConnection.Current in the same context is not allowed    at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

   at System.Environment.get_StackTrace()

   at Terrasoft.Core.UserConnection.OnCurrentUserConnectionChanged(AsyncLocalValueChangedArgs`1 args)

   at System.Threading.AsyncLocal`1.System.Threading.IAsyncLocal.OnValueChanged(Object previousValueObj, Object currentValueObj, Boolean contextChanged)

   at System.Threading.ExecutionContext.SetLocalValue(IAsyncLocal local, Object newValue, Boolean needChangeNotifications)

   at Terrasoft.WebApp.Global.Session_End(Object sender, EventArgs e)

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)

   at System.Web.HttpApplication.InvokeMethodWithAssert(MethodInfo method, Int32 paramCount, Object eventSource, EventArgs eventArgs)

   at System.Web.HttpApplication.ProcessSpecialRequest(HttpContext context, MethodInfo method, Int32 paramCount, Object eventSource, EventArgs eventArgs, HttpSessionState session)

   at System.Web.HttpApplicationFactory.FireSessionOnEnd(HttpSessionState session, Object eventSource, EventArgs eventArgs)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.RaiseSessionEnd(String sessionId)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.<>c__DisplayClass33_0.b__0(IRedisClient redisClient)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.RetryOperationIfNeed(IRedisClient client, Action`1 operation)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.ClearExpiredSessions()

   at Polly.Policy.<>c__DisplayClass109_0.b__0(Context ctx, CancellationToken ct)

   at Polly.RetrySyntax.<>c__DisplayClass12_1.b__1(Context ctx, CancellationToken ct)

   at Polly.Retry.RetryEngine.Implementation[TResult](Func`3 action, Context context, CancellationToken cancellationToken, IEnumerable`1 shouldRetryExceptionPredicates, IEnumerable`1 shouldRetryResultPredicates, Func`1 policyStateFactory)

   at Polly.RetrySyntax.<>c__DisplayClass12_0.b__0(Action`2 action, Context context, CancellationToken cancellationToken)

   at Polly.Policy.Execute(Action`2 action, Context context, CancellationToken cancellationToken)

   at Polly.Policy.Execute(Action action)

   at Terrasoft.Redis.PerformanceMonitor.ExecuteWithMonitoring(String operationName, Action operation)

   at Terrasoft.Redis.RedisThrottledExecutor.Execute(Action action)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.ClearExpiredSessionsCallback(Object state)

   at Terrasoft.Common.Timer.NonOverlappingTimerCallback(TimerCallback callback, Object state, Int32 dueTime, Int32 period)

   at Terrasoft.Common.Timer.<>c__DisplayClass2_0.b__0(Object currentState)

   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   at System.Threading.TimerQueueTimer.CallCallback()

   at System.Threading.TimerQueueTimer.Fire()

   at System.Threading.TimerQueue.FireNextTimers()

2023-02-07 00:56:21,882 [91] ERROR IIS APPPOOL\Creatio Terrasoft.Core.UserConnection OnCurrentUserConnectionChanged - Overwriting UserConnection.Current in the same context is not allowed    at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

   at System.Environment.get_StackTrace()

   at Terrasoft.Core.UserConnection.OnCurrentUserConnectionChanged(AsyncLocalValueChangedArgs`1 args)

   at System.Threading.AsyncLocal`1.System.Threading.IAsyncLocal.OnValueChanged(Object previousValueObj, Object currentValueObj, Boolean contextChanged)

   at System.Threading.ExecutionContext.SetLocalValue(IAsyncLocal local, Object newValue, Boolean needChangeNotifications)

   at Terrasoft.WebApp.Global.Session_End(Object sender, EventArgs e)

   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

   at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)

   at System.Web.HttpApplication.InvokeMethodWithAssert(MethodInfo method, Int32 paramCount, Object eventSource, EventArgs eventArgs)

   at System.Web.HttpApplication.ProcessSpecialRequest(HttpContext context, MethodInfo method, Int32 paramCount, Object eventSource, EventArgs eventArgs, HttpSessionState session)

   at System.Web.HttpApplicationFactory.FireSessionOnEnd(HttpSessionState session, Object eventSource, EventArgs eventArgs)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.RaiseSessionEnd(String sessionId)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.<>c__DisplayClass33_0.b__0(IRedisClient redisClient)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.RetryOperationIfNeed(IRedisClient client, Action`1 operation)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.ClearExpiredSessions()

   at Polly.Policy.<>c__DisplayClass109_0.b__0(Context ctx, CancellationToken ct)

   at Polly.RetrySyntax.<>c__DisplayClass12_1.b__1(Context ctx, CancellationToken ct)

   at Polly.Retry.RetryEngine.Implementation[TResult](Func`3 action, Context context, CancellationToken cancellationToken, IEnumerable`1 shouldRetryExceptionPredicates, IEnumerable`1 shouldRetryResultPredicates, Func`1 policyStateFactory)

   at Polly.RetrySyntax.<>c__DisplayClass12_0.b__0(Action`2 action, Context context, CancellationToken cancellationToken)

   at Polly.Policy.Execute(Action`2 action, Context context, CancellationToken cancellationToken)

   at Polly.Policy.Execute(Action action)

   at Terrasoft.Redis.PerformanceMonitor.ExecuteWithMonitoring(String operationName, Action operation)

   at Terrasoft.Redis.RedisThrottledExecutor.Execute(Action action)

   at Terrasoft.Redis.RedisSessionStateStoreProvider.ClearExpiredSessionsCallback(Object state)

   at Terrasoft.Common.Timer.NonOverlappingTimerCallback(TimerCallback callback, Object state, Int32 dueTime, Int32 period)

   at Terrasoft.Common.Timer.<>c__DisplayClass2_0.b__0(Object currentState)

   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)

   at System.Threading.TimerQueueTimer.CallCallback()

   at System.Threading.TimerQueueTimer.Fire()

   at System.Threading.TimerQueue.FireNextTimers()

2023-02-07 01:05:55,995 [44] ERROR IIS APPPOOL\Creatio Terrasoft.WebApp.FileWebEventProvider RaiseInternal - Date: 2/7/2023 1:05:55 AM

Date (UTC): 2/6/2023 11:05:55 PM

Exception Message: The remote host closed the connection. The error code is 0x800704CD.

Exception Type: System.Web.HttpException

Exception Source: System.Web

Exception Stack Trace:

   at System.Web.Hosting.IIS7WorkerRequest.RaiseCommunicationError(Int32 result, Boolean throwOnDisconnect)

   at System.Web.Hosting.IIS7WorkerRequest.ExplicitFlush()

   at System.Web.HttpResponse.Flush(Boolean finalFlush, Boolean async)

   at Microsoft.Web.WebSockets.WebSocketFixModule.b__0(Object sender, EventArgs e)

   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)

   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Request URL: /SE_8.0.6.3422/0/Nui/ViewModule.aspx.ashx

Request Path: /SE_8.0.6.3422/0/Nui/ViewModule.aspx.ashx

Request Type: GET

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36

User Host Address: 127.0.0.1

User: Supervisor

Is Authenticated: True

Authentication Type: Forms

Is Secure Connection: False

Application Version: 8.0.6.3422

Application Path: C:\inetpub\wwwroot\8.0.6.3422_SalesEnterprise_Softkey_MSSQL_ENU\Terrasoft.WebApp\

Application Virtual Path: /SE_8.0.6.3422/0

Application Trust Level: Full

Machine Name: LENOVO

Is Local: True

Process ID: 4136

Process Name: w3wp.exe

Process Account Name: IIS APPPOOL\Creatio

Thread Account Name: IIS APPPOOL\Creatio

OS Version: Microsoft Windows NT 10.0.22621.0

Net Framework Version: 4.0.30319.42000

DBExecutor Type: MSSqlExecutor

<-->

2023-02-07 01:05:55,995 [49] ERROR IIS APPPOOL\Creatio Terrasoft.WebApp.FileWebEventProvider RaiseInternal - Date: 2/7/2023 1:05:55 AM

Date (UTC): 2/6/2023 11:05:55 PM

Exception Message: The remote host closed the connection. The error code is 0x800704CD.

Exception Type: System.Web.HttpException

Exception Source: System.Web

Exception Stack Trace:

   at System.Web.Hosting.IIS7WorkerRequest.RaiseCommunicationError(Int32 result, Boolean throwOnDisconnect)

   at System.Web.Hosting.IIS7WorkerRequest.ExplicitFlush()

   at System.Web.HttpResponse.Flush(Boolean finalFlush, Boolean async)

   at Microsoft.Web.WebSockets.WebSocketFixModule.b__0(Object sender, EventArgs e)

   at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)

   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Request URL: /SE_8.0.6.3422/0/Nui/ViewModule.aspx.ashx

Request Path: /SE_8.0.6.3422/0/Nui/ViewModule.aspx.ashx

Request Type: GET

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36

User Host Address: ::1

User: Supervisor

Is Authenticated: True

Authentication Type: Forms

Is Secure Connection: False

Application Version: 8.0.6.3422

Application Path: C:\inetpub\wwwroot\8.0.6.3422_SalesEnterprise_Softkey_MSSQL_ENU\Terrasoft.WebApp\

Application Virtual Path: /SE_8.0.6.3422/0

Application Trust Level: Full

Machine Name: LENOVO

Is Local: True

Process ID: 4136

Process Name: w3wp.exe

Process Account Name: IIS APPPOOL\Creatio

Thread Account Name: IIS APPPOOL\Creatio

OS Version: Microsoft Windows NT 10.0.22621.0

Net Framework Version: 4.0.30319.42000

DBExecutor Type: MSSqlExecutor

<-->

 

Like 0

Like

2 comments

Hi,

The problem is probably lais in your dotnet sdk version. Here is the list of library's version where everything should work ok.

3.1.301 [C:\Program Files\dotnet\sdk]

6.0.405 [C:\Program Files\dotnet\sdk]

Microsoft.AspNetCore.App 3.1.5 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]

Microsoft.AspNetCore.App 3.1.32 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]

Microsoft.AspNetCore.App 6.0.13 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]

Microsoft.NETCore.App 3.1.5 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]

Microsoft.NETCore.App 3.1.32 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]

Microsoft.NETCore.App 6.0.13 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]

Microsoft.WindowsDesktop.App 3.1.5 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]

Microsoft.WindowsDesktop.App 3.1.32 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App]

Microsoft.WindowsDesktop.App 6.0.13 [C:\Program Files\dotnet\shared\Microsoft.WindowsDesktop.App] 

Show all comments

Hi There,



Can portal users login to Creatio through Single Sign On just like regular system users?



Thanks! 

Like 0

Like

1 comments

Hello Vishal,

 

Creatio supports only 1 user type for the SSO. It can be either Employee or Portal User. 

You can use both of them only in case there is a possibility of configuring separate IdP providers for portal users and company employees.

But in this case:

- You will not be able to use JIT 

- Service initiated login (when you getting redirected to your SSO provider after going to Creatio website) will be possible only with one provider or none of them. 

In case you enable it for one provider - (the one which will be stated in PartnerIdP key in web.config) you will have to make sure that all users of a type different from provided within this provider will use SSO only directly from their IdP. 



Best regards,

Anastasiia

Show all comments

Hi All,



I could able to add the rich text column from the Freedom UI page using the designer for Contact section.



But when I tried to add the rich text field from the object,





and drag-deop the element from the section wizard, this column seems to be a normal Text field.



Creatio Product version - 8.0.5.2483

How to make this coulmn as actual rich text field similar to which we see in Freedom UI?

 

Like 0

Like

3 comments
Best reply

I don't believe that data type works for classic pages. Instead you can use the steps in this article to convert a text field to a rich text editor: 

https://customerfx.com/article/adding-custom-rich-text-editors-to-a-pag…

Ryan

I don't believe that data type works for classic pages. Instead you can use the steps in this article to convert a text field to a rich text editor: 

https://customerfx.com/article/adding-custom-rich-text-editors-to-a-pag…

Ryan

Ryan Farley,

It's very useful. What if I want 2 rich text field in one section page. I tried to create 2 rich text field . All are working good except when I tried to upload image. Image is being cloned in both the field. If I upload image in one of the field it is been shown in both as well. Any solution for this issue?

Hi,

 

Please may I ask can the field set as "Rich Text" then be printed without any html characters?

Show all comments

Hello Community,

How can we set a default Image for image link column in freedom UI?

I want to Change the Image to my own Default Image. Can someone help?

 

Thanks in advance!

Indurthi Yasaswini

 

Like 0

Like

7 comments
Best reply

Julio.Falcon_Nodos,

Julio, he is referring to the Image column type that can be added to a Freedom UI page. It uses a default icon called "image-placeholder"

Ryan

Hello community,

 

We have tried Localizable images and direct links to SysImage as well. Please give an example of how to use Resources.Images to have a default image set up

Hello,

That image is not a resource image, but a mat-icon. I don't know whether the component has a property to select the default icon. I tried guessing at a few:

  • icon
  • defaultIcon
  • default
  • image
  • defaultImage

None of the above worked. It's possible that it does not have a property to set the initial default icon - but that seems unlikely? Either way, we'll have to wait for more documentation on what properties the component supports I suppose.

Ryan

Which image, this one? 

Julio.Falcon_Nodos,

Julio, he is referring to the Image column type that can be added to a Freedom UI page. It uses a default icon called "image-placeholder"

Ryan

Thanks Ryan, sorry, also have no idea how change it

Hello Yasaswini,

 

You will need to add these fields as shown on the screenshot:

      "placeholderMode":"icon", 

      "placeholder": "eye-blue",

 

 

Best regards,

Yuliya Gritsenko

Yuliya Gritsenko,

Thanks for this Yuliya. How can we go about finding this sort of thing out for ourselves in the new angular components? In the Extjs-based pages, it's easy to look at source to see what things can be done. However, with the angular components, plus everything being minified, it's very difficult to find where to look. Are there any tricks to using devtools to find the source of the components to look for this sort of thing (even if minified)?

Ryan

Show all comments

Hello, 

 

I see there are 2 duplicated records in SysProfileData forOrderSectionV2GridSettingsGridDataView

 

Select * from "SysProfileData"  

Where "Key" = 'OrderSectionV2GridSettingsGridDataView'

AND "ContactId" IS NULL

AND "SysCultureId"='1a778e3f-0a8e-e111-84a3-00155d054c03'

 

And when I save columns setup in Order section for all users the new record is added. But when this new record in bound to the package and installed on Production site, my column setup is not applied.

How safe is it to remove existing 2 records that came out of the box?



Thank you

Like 0

Like

1 comments

Hi,

There is a script that safely removes all duplicates in the table SysProfileData, you can use it:

delete

from "SysProfileData"

where "Id" in

  (

  select uuid(min("Id"))

  from "SysProfileData" 

  where "Key"<>'' and "Key"<>'chrome'and "Key"<>'gecko'

  group by "Key","ContactId", "SysCultureId"

  having count (*) > 1

  )

Show all comments