How to identify the database type for my Creatio cloud instance:

I need to determine which database my cloud Creatio instance is using (MSSQL, PostgreSQL, etc.). What's the simplest way to check this information?

 

Best practices for migrating large datasets from Pre-Production to Production:

I'm familiar with the Data Binding tool and standard migration procedures, but I'm working with extremely large datasets that make the standard approach challenging.

What's the recommended method for migrating substantial amounts of data between Pre-Production and Production cloud environments? Are there optimization techniques, alternative tools, or best practices specifically for handling large-volume migrations?

Any insights from those who've successfully managed large-scale data migrations would be appreciated!

Like 1

Like

1 comments

Hello,
 

Please contact the Creatio Customer Support directly to provide you with the information regarding your cloud-based site. Here is the support email address: support@creatio.com.

Show all comments

Hi Community,

 

Through a webservice we are receiving several account records. Some of these new accounts have a url with more than 250 chars, which is the limit set by Creatio for this field. As this limit is exceeded, we are receiving errors from the database.

 

Is there a way to increase the character limit for the Web Link to 500?

 

Thank you.

 

Best Regards,

Pedro Pinheiro

Like 3

Like

1 comments

Hello!



No, this element has a fixed length that cannot be modified.

Show all comments

All the solutions ive found to find your current Creatio version/distribution require you to use a specific MSSQL SQL query that doesnt work with PostgreSQL and doesnt seem to have any easy syntax conversion, does anyone have any ideas?

Like 2

Like

3 comments
Best reply

Oliver Crowe,

Use 'Product Version'

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Product version' 

 

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Configuration version' 

 

keith schmitt,

How do you get it to involve the product distribution? eg Sales enterprise/Studio

Oliver Crowe,

Use 'Product Version'

SELECT "Name", "TextValue"  FROM public."SysSettings" 
left join public."SysSettingsValue"  on public."SysSettings"."Id" = Public."SysSettingsValue"."SysSettingsId" 
where  "Name" = 'Product version' 

 

Show all comments

Hi! I've developed an application for Creatio, and now I want to publish it on the marketplace. However, it did not pass verification. 

The problem is that it didn't install on a system using MS SQL, although I haven't used anything DB-specific. Maybe you encountered such errors from the logs?

Do you know how to restart the verification process?

Like 0

Like

1 comments

Dear Pavel,



We know that your package has already published. In case you will have questions regarding the publication of packages please feel free to contact our Marketplace team: marketplace@creatio.com



Best regards,

Bogdan Sukhovoi

Show all comments