search cancel

Upgrade to 9.1 - Will 9.1 server start with 8.x database

book

Article ID: 190647

calendar_today

Updated On:

Products

CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort) CA Strong Authentication CA Rapid App Security CA Risk Authentication CA Advanced Authentication

Issue/Introduction

Upgrading to 9.1 from 8.2.1 on a new machine. 

I did the installation but have not yet upgraded the database, when i try to start the 9.1 service i get the following error.  Question , do i need to wait till upgrading the schema to start the services ? 

05/12/20 09:44:29.925 INFO  STARTUP      00003420 00WFMAIN - Instance found to be already registered. Updating start time
05/12/20 09:44:29.940 INFO  STARTUP      00003420 00WFMAIN - Dbm::SQL State:42S22, Native Code: CF, ODBC code: [Ca Technologies][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid column name 'INSTANCENAME'.
05/12/20 09:44:29.940 INFO  STARTUP      00003420 00WFMAIN - ArDBM::Execution with error (not ICV) for Query[WFSequence_FetchSeq]
05/12/20 09:44:29.940 INFO  STARTUP      00003420 00WFMAIN - Dbm::SQL State:42S22, Native Code: CF, ODBC code: [Ca Technologies][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid column name 'INSTANCENAME'.SQL State:HY000, Native Code: 1FF4, ODBC code: [Ca Technologies][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Statement(s) could not be prepared.
05/12/20 09:44:29.940 INFO  STARTUP      00003420 00WFMAIN - ArDBM::Execution with error (not ICV) for Query[WFSequence_CreateSequence:ARWFINSTANCETXNIDSEQ]
05/12/20 09:44:29.940 WARN  STARTUP      00003420 00WFMAIN - ArSQLOpResult:
05/12/20 09:44:29.940 WARN  STARTUP      00003420 00WFMAIN - Failed while inserting ARWFINSTANCETXNIDSEQ sequence information in database.
05/12/20 09:44:29.940 WARN  STARTUP      00003420 00WFMAIN - Registering the Server Instance Startup Failed!.
05/12/20 09:44:29.940 INFO  STARTUP      00003420 00WFMAIN - ArDBPool::clean Pool [(primary)]: All connection are released by threads. Cleaning the connections...
05/12/20 09:44:29.940 INFO  STARTUP      00003420 00WFMAIN - ArDBConnection::disConnect SQLDisConnect with _hDbc [00000238D02D61F0] _hEnv [00000238D02D6110]
05/12/20 09:44:29.940 INFO  STARTUP      00003420 00WFMAIN - ArDBPoolManagerImpl::clean: Both primary and backup pools destroyed successfully
05/12/20 09:44:29.940 WARN  STARTUP      00003420 00WFMAIN - Initializing server instance configuration Failed!.
05/12/20 09:44:29.940 FATAL STARTUP      00003420 00WFMAIN - CA Strong Authentication Service SHUTDOWN due to initialization failure!

Environment

Release : 9.1

Component : AuthMinder(Arcot WebFort)

Cause

9.1 Strong Auth server expects 9.1 DB schema but 8.2.1 does not have some extra changes done to DB schema in later releases.

Resolution

AuthMinder 9.1 requires compatible 9.1 schema but 8.2.1 does not have that and that is the reason the services do not start. Upgrade the schema from 8.2.1 to 9->9.1 and then try starting the service and it should work just fine.