SYMPTOM:
The following error message is encountered when upgrading the statistics tables to Strategy 9.x and newer:
Error executing the following SQL -- CREATE TABLE CT_DEVICE_STATS...
TABLE ALREADY EXISTS
CAUSE: This issue can be seen in cases where the statistics tables upgrade is re-attempted after encountering a failure on a previous attempt to upgrade .
ACTION: The CT_DEVICE_STATS and CT_EXEC_STATS statistics tables must be dropped from the database prior to upgrading the statistics tables. The following SQL statements may be used to do so:
DROP TABLE CT_DEVICE_STATS
DROP TABLE CT_EXEC_STATS
WARNING:Modifying Strategy Statistics tables incorrectly may cause serious, system-wide problems that may require the reconfiguration of the database. Any database modification is done at the user's own risk. Since these are user-initiated changes, they are not covered by any Strategy warranty.
The user should backup the database prior to editing database tables. 