Running archive_crossdb_sqlserver.sql works but restarting overwrites the tables back to default

Products

• CA Identity Manager

Issue/Introduction

Client had multiple databases.  They used one of our scripts "archive_crossdb_sqlserver.sql" but this could happen with any of our scripts.  The script worked but during a restart of the environment they would find the database would revert back to default and remove the changes from the script. 

Environment

Identity Manager 14.4.2

Virtual Appliance

Cause

This was caused by the TP_version table in the database having 12.6.8 as the version. When IM was restarted, it would see the wrong version and redeploy which reverted the database. 

Resolution

Change the TP_version to 14.0.0.0.  Now after the script is ran, IM will not redeploy the DB.