Task Persistence database schema was not upgraded successfully, Task Persistence database schema version is 12.6.8.0.0

Products

• CA Identity Manager
• CA Identity Suite

Issue/Introduction

Running archive_crossdb_sqlserver.sql as we have a multiple database structure. After IDM restarts the database reverts the changes and returns the following in the logs:

2023-11-09 21:30:30,247 ERROR [ims.tmt.CreateDatabaseSchema] (ServerService Thread Pool -- 118) Task Persistence database schema was not upgraded successfully.
2023-11-09 21:30:30,247 INFO  [ims.Main] (ServerService Thread Pool -- 118) Task Persistence database schema version is 12.6.8.0.0

Environment

14.4.2
vApp or standalone

 

Cause

When IDM starts, it checks version and the database schema.  If the schema or version is incorrect it will revert and return an error.  This was caused by an incorrect migration from an older version of IM and step upgrade to end at 14.4.2.  The database showed TP_version at 12.6.8.0.0

Resolution

Review Task_persistence table in the database.  Manually change tp_version= 12.6.8 to tp_version= 14.4.0.0.0

Now when IDM starts it will see the correct version expected for tp_version and will not revert or make changes to the schema and allow you to run archive_crossdb_sqlserver.sql or any or our out of the box stored procedures properly.