Error upgrading DA
Any suggestions on what I should do if I get this error when I try ot upgrade a database?
DELETE failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SE...
Hi,
"DELETE failed because the following SET options have incorrect settings: 'ANSI_PADDING'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations."
Before the above error message appears the upgrade process will appear to hang on running the script AcceleratorPostInstallScriptsV8xx.sql.
Workaround :
Run the script AcceleratorPostInstallScriptsV8xx.sql manually in SQL Management Studio and then retry the upgrade.
- The script can be found in the Discovery Accelerator (DA) installation folder on the DA server.
- The default location for this folder is 'C:\Program Files (x86)\Enterprise Vault Business Accelerator'.
- To run the script manually, use an account with sufficient permissions to modify the DA Customer database contents, such as the Vault Service Account (VSA)
Note : Before running SQL script on SQL server stop the Enterprise Vault Accelerator Manager Service (EVAMS) on the DA server.
- The script can be found in the Discovery Accelerator (DA) installation folder on the DA server.
