KBI 310224 Database Integrity Issue During Argent AT Upgrade From Older Release
Version
Argent Advanced Technology All Versions
Date
23 Sep 2010
Summary
An issue occurred after upgrading Argent AT Argent for Exchange
2.0A-1001 to Argent AT 2.0A-1010.
After the upgrade, it was showing database integrity failures where Argent could no longer read many of the SQL tables.
Technical Background
The upgrade process re-named a lot of the SQL tables, but after the upgrade the front-end executables were still trying to read the old SQL table names.
For example, the database integrity check would show the following details for various SQL tables:
AAC_CONSOLE => FAILED => Table is missing
This was occurring because the new table name is ARGSOFT_AAC_CONSOLE, but the executables were still trying to access the tables by the old name of AAC_CONSOLE.
Resolution
The issue was addressed by re-installing Argent into a new SQL database, shutting down the Argent services, editing the SQL_DATABASE and SQL_SERVER registry fields to point back to the original SQL database, and then re-starting the Argent services.