Before executing the IN_DB_UPGRADE_SP_UPTIME_STEPS procedure, you must make the following changes to the Perceptive Content SQL Server ODBC Data Source (DSN) on the Perceptive Content application server(s). Failing to adjust the ODBC options as follows will result in an unplanned downtime.
In order for the Perceptive Content application to be compatible with the new filtered indexes, the “Quoted Identifiers” option must be enabled prior to creating the new filtered indexes. The filtered indexes are created as part of the 7.2.3.0 to 7.4.0.3 uptime schema changes.
After making the changes to the ODBC DSN you will need restart the Perceptive Content services so that all database connections are re-established with these options enabled.
These manual steps can be disregarded if the following is true:
- If the Perceptive Content Application Server is currently on version 7.3 and you have already switched over to the native ODBC drivers for SQL Server.
- If the Perceptive Content Application Server is currently on version 7.2.3 and you plan to run this script ONLY during downtime (no uptime steps).
These manual steps must be executed if the following is true:
- If the Perceptive Content Application Server is currently on version 7.2.3 and you plan to run this script using the uptime features. If this is the case then please follow the instructions below for the manual steps that must be executed prior to running the uptime steps.