WARNING: This is mere guideline, we do not enforce it and it should be at your own discretion to apply/follow it. Please liaise with your DBA system administrator on this.
Error Message: (in French, English version is almost identical)
ERROR: Creating Table 'CW_AUDIT'...
Creating View 'CW_AUDIT_PER_PROPERTY'...
Creating the required audit triggers...
EXCEPTION: Running test 'Audit Compatibility: Check schema':
L'instruction ALTER TABLE a échoué parce que le déclencheur 'AUDIT_sysdiagrams'
de la table 'sysdiagrams' n'existe pas.
Error appears when trying to run the validate repository tool for Casewise Suite following an upgrade.
To resolve this, please follow below steps
- Make a backup of your SQL database first and inform your DBA.
- In the SQL server management studio, please delete the dbo.sysdiagram from your Casewise database→ “Table”. Please see below screenshots.
- Then rerun the validate repository tool as usual.