MSSQL problem with autosyncDb=True and ForeignKeys while upgrading to Preside V10.14.4

Description

None

Environment

MSSQL problem with autosyncDb=True while upgrading to Preside V10.14.4:
when starting the preside project with "autosyncDb=True" and a "preside" datasource with MSSQL I got the following MSSQL error (german database with german error messages):
"Error message: [Das Einführen der FOREIGN KEY-Einschränkung ""fk_368ff18b170cb751032b76ad8a2dcba7"" für die psys_formbuilder_question_response-Tabelle kann Schleifen oder mehrere Kaskadepfade verursachen.
Geben Sie ON DELETE NO ACTION oder ON UPDATE NO ACTION an, oder ändern Sie andere FOREIGN KEY-Einschränkungen.]."
SQL: [alter table [psys_formbuilder_question_response] add constraint [fk_368ff18b170cb751032b76ad8a2dcba7] foreign key ( [submission] ) references [psys_formbuilder_formsubmission] ( [id] ) on delete set null on update cascade].

Microsoft explanantion 1785:
You receive this error message because in SQL Server, a table cannot appear more than one time in a list of all the cascading referential actions that are started by either a DELETE or an UPDATE statement.
The tree of cascading referential actions must only have one path to a particular table on the cascading referential actions tree.
To resolve this problem, create a foreign key that will create a single path to a table in a list of cascading referential actions.

Activity

Show:
Dominic Watson
March 12, 2021, 3:12 PM

Thanks for the work on this all. Merging into hotfix 10.14.10

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Unassigned

Reporter

Rainer Nover

Accepted

Yes