Reinstallation gives schema error already loaded

Products

• CA Configuration Automation

Issue/Introduction

During reinstallation of Configuration automation 12.9 following error appears :

A version of the schema that cannot be updated has already been loaded.
Specify a different user name, or remove the existing schema before continuing.

Environment

Configuration Automation 12.9 build 123

Cause

Following SQL Query :
select filename, filetimestamp from mdb_schema_information where FileType='driver' ;

returns

FILENAME	FILETIMESTAMP
CCA_12_9_0_123_upgrade_2	2024-10-30T12:46:27+0000
CCA_12_8_5_66_upgrade_1	2020-10-02T06:39:51+0000
CCA_12_9_0_123_upgrade_1	2024-10-30T12:46:27+0000
ACM_r12	2018-01-05T14:53:48+0000
CCA_12_8_5_66_upgrade_2	2020-10-02T06:39:51+0000

 

Schema name CCA_12_9_0_123* appears in the result of query. This is preventing the reinstallation of Configuration Automation 12.9

Resolution

1. Execute following SQL Query
   
   delete from mdb_schema_information where FileType='driver' and filename like 'CCA_12_9_0_123_upgrade_%'
   
   
2. Try again the reinstallation of configuration automation 12.9.0.54
   
   
3. Then apply the patch (12.9 build 123 or higher version).