000012335 - FIM is unable to start the derby database.

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000012335
Applies ToFederated Identity Management Module 4.1
IssueFIM is unable to start the derby database.

FIM throws the following error on startup:

javax.jdo.JDODataStoreException: Failed initialising database. Please check that your database JDBC driver is accessible, and the database URL and username/password are correct. Exception : Cannot get a connection, pool exhausted
org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted, cause:
java.util.NoSuchElementException: Could not create a validated object, cause: A read-only user or a user in a read-only database is not permitted to disable read-only mode on a connection.

CauseThis error may occur if the permissions on the FIM database folder do not allow WebLogic to access the database lock files.  HF_25 requires you to create a new database folder that may not have the correct permissions.
ResolutionEnsure that directory permissions on the FIM database folder in "C:\bea\user_projects\domains\FIM41\rsa-fim-config\demoDB " are sufficient to allow the WebLogic user to create and delete lock files.  The FIM installer will create the directories with the correct permissions but if you have applied FIM 4.1 HF_25 you may have to manually change these permissions.
WorkaroundApplied FIM 4.1 HF_25
Legacy Article IDa50994

Attachments

    Outcomes