ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

AA cannot connect to database

book

Article ID: 212352

calendar_today

Updated On:

Products

CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)

Issue/Introduction

AA failed to connect to my backup oracle DB. here is the error message:

04/07/21 17:09:39.091 INFO  STARTUP      00001202 00WFMAIN - Attempting to load External Time Source (ETS) Plugin if available
04/07/21 17:09:39.091 INFO  STARTUP      00001202 00WFMAIN - Attempting to load the the module : [libwftimesourceplugin.so]
04/07/21 17:09:39.091 INFO  STARTUP      00001202 00WFMAIN - Primary database configuration is present and read successfully. dsn [dev] userName [arcotuser] pwd is not empty
04/07/21 17:09:39.091 INFO  STARTUP      00001202 00WFMAIN - Backup database configuration is all empty.
04/07/21 17:09:39.092 INFO  STARTUP      00001202 00WFMAIN - ArDBPool::createNewConnections: Pool [(primary)] is grown by [0] connections. Current total size is [0]. Current available size is [0]
04/07/21 17:09:39.092 INFO  STARTUP      00001202 00WFMAIN - ArDBPoolManagerImpl::init: Backup database parameters are not available
04/07/21 17:09:39.092 FATAL STARTUP      00001202 00WFMAIN - Error initializing primary DB [dev] for user [arcotuser]. Error []
04/07/21 17:09:39.092 INFO  STARTUP      00001202 00WFMAIN - ArDBPool::clean Pool [(primary)]: All connection are released by threads. Cleaning the connections...
04/07/21 17:09:39.092 INFO  STARTUP      00001202 00WFMAIN - ArDBPoolManagerImpl::clean: Both primary and backup pools destroyed successfully
04/07/21 17:09:39.092 INFO  STARTUP      00001202 00WFMAIN - ArDBPoolManagerImpl::clean: Both primary and backup pools destroyed successfully
04/07/21 17:09:39.092 FATAL STARTUP      00001202 00WFMAIN - CA Strong Authentication Service SHUTDOWN due to initialization failure!

Environment

Release : 9.0

Component : AuthMinder(Arcot WebFort)

Resolution

This issue can happen if the DataDirect driver is not getting loaded and that can be because a wrong path is specified in odbc.ini file. odbc.ini file can be found at ARCOT_HOME/odbc64 location and please verify the path Driver=ARCOT_HOME/odbc64/lib/WFora28.so file is accessible.