Is it safe to clear down the SysProfileData table?

Is it safe/supported to delete all data in the SysProfileData table where the ContactId is populated?

 

We want to deploy default column setups across the board into environments where users may have set them up, which isn't possible without removing their custom column setups from this table. The simplest way I can think to do this would be to delete all SysProfileData records where ContactId is populated (i.e. they are user customisations) but wanted to check this would be safe.

Like 1

Like

3 comments

Dear Harvey, 



Theoretically, it's possible. 

However, we recommend you to contact Creatio support team and request a DB backup of your website if it's deployed in cloud and carefully test it on the copy of the website before making any changes to actual production. 



Kind regards,

Roman

Hi Roman, is there a better/recommended way to reset all users' column bindings back to the defaults in an environment?  Also, what are the risks involved around doing this? I understand that users' applied filters for each Section are also stored in this table - what other data is stored there which could cause a problem if it were deleted?

 

Thanks

Any changes on this/better way of resetting all default list settings for users since this was posted? This is a frequent need.

Show all comments