11-30-2013 06:40 PM
Any suggestions on what I should do if I get this error when I try ot upgrade a database?
Solved! Go to Solution.
12-03-2013 10:52 PM
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.
Note : Before running SQL script on SQL server stop the Enterprise Vault Accelerator Manager Service (EVAMS) on the DA server.
11-30-2013 06:47 PM
What version of DA and are these customer databases?
Also, what version of SQL?
11-30-2013 08:20 PM
DA Version of the sucessfully upgraded databases shows 10.0 SP4 revision 16
SQL server 2005 SP3 Enterprise Edition X64
Going from Version 9.0 SP3 revision 26
Yes these are customer databases
12-01-2013 07:39 AM
Do you have database Snapshot folders? I found a couple post where folks had to go into the snapshot folder and update sch file for the offending table; i.e; change SET ANSI_PADDING from ON to OFF in sch file.
12-01-2013 08:05 AM
Yes have a database snapshots folder but no snapshots listed in it.
Thanks!
12-01-2013 02:37 PM
Hmm, ok then. Is there any sort of replication going on? You might need to involve a SQL DBA to assist with that error.
12-03-2013 10:52 PM
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.
Note : Before running SQL script on SQL server stop the Enterprise Vault Accelerator Manager Service (EVAMS) on the DA server.
12-04-2013 10:14 AM
Please note tat on the solution you will receive an error and it will say no rows updated - but did the trick - Thanks!
12-05-2013 12:42 AM
Thanks for sharing the information. Good to see that issue is resolved.