Hello all,
I am having difficulty reading foreign key constrain errors on cloud instances of Creatio. Everything I find says I need to execute a command in a SQL console which I don't have access to just to get something more helpful than "foreign key constraint error" Is there no lookup I can access to read the errors? Why are they so vague?
Like
That is a database level thing, so can only be read from the directly from the database:
To see it on a cloud instance, you can use Clio Explorer to execute the SQL statement to see what the constraint references. See this article for help setting Clio Explorer up (once all setup and installed, you can use it's Execute SQL function): https://customerfx.com/article/how-to-install-clio-explorer-for-creatio/
As for the query to determine the foreign key error details, see: https://customerfx.com/article/troubleshooting-constraint-violation-errors-in-creatio/
Ryan