IdentityIQ Error : Unable to check IdentityIQ database version

In one of the recent installations in a client environment we faced the below error in “application server.logs”


12:35:25,797 INFO [org.apache.catalina.core] (ServerService Thread Pool — 60) JBWEB001093: The listener com.sun.faces.config.ConfigureListener is already configured for this context, the duplicate definition has been ignored
12:35:26,188 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/identityiq]] (ServerService Thread Pool — 60) JBWEB000287: Exception sending context initialized event to listener instance of class sailpoint.web.StartupContextListener: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Cannot create PoolableConnectionFactory (Login failed for user ‘iiqstgdbuser’. ClientConnectionId:6c586f09-15da-4478-8224-ae2dfbaaca25)

This was not letting us login in the database giving below error

Error

Eventually the IIQ installation was not getting completed. Below are the details of the environment.

Operating System: Microsoft Server 2012
Application Server: JBOSS 6.1
IdentityIQ: 6.2
Database Used: SQL Server 2012
SQL Service was running under a Domain Service Account with sysadmin permission

Issue was fixed by:
1. Removing “sysadmin permission” from the Domain Service Account
2. Change the authentication mode to mixed
3. Restarting SQL services

8 Responses to“IdentityIQ Error : Unable to check IdentityIQ database version”

  1. Vinod
    May 6, 2015 at 3:59 PM #

    Nice post and thanks for sharing.

  2. Vinod
    August 23, 2015 at 4:05 PM #

    Hello Vaibhav,

    I am trying to install IIQ on my Win8.1 which I did it earlier successfully. Now getting above error and could you tell what is the reason in Win8,1 and what steps I need to take to address this..

    • VaibhavTripathi
      September 5, 2015 at 2:13 PM #

      Hello Vinod,

      Have you done a recent upgrade of IIQ or some change in Database?

      There is a table in IIQ database ‘spt database version’, which maintains a specific relation between database version and system version.This value pair has to maintained in order to establish a connection between IIQ Application and database.

  3. Jason
    December 17, 2015 at 9:59 PM #

    Hi Vaibhav,
    Good post, thanks. I would recommend using integrated security though, as this avoids the need for passwords to be stored in configuration files. For Tomcat we use sqljdbc_auth.dll, I think this should work for JBOSS also.
    Happy coding,
    Jason

  4. Archana
    January 31, 2016 at 8:04 AM #

    Hi Vaibhav,

    I’m new to Sailpoint.Even I got the similiar exception. It stopping me to complete iiq installation.

    org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: Unableto check IdentityIQ database version: Table ‘identityiq.spt_database_version’ doesn’t exist

    Operating System: Windows 7
    Application Server: Tomcat 7
    IdentityIQ: 6.4
    Database : mysql 5.0
    I will be thankful to you if I get through this Issue.

  5. Mani
    July 11, 2016 at 6:11 AM #

    Hi I am trying to install Sailpoint 6.1, while running the iiq console in commandprompt getting the following error. Would be great if somebody provide me a solution.
    C:\Tomcat\webapps\idenityiq\WEB-INF\bin>iiq console
    org.springframework.beans.factory.BeanCreationException: Error creating bean wit
    h name ‘versionChecker’ defined in class path resource [configBeans.xml]: Initia
    lization of bean failed; nested exception is java.lang.RuntimeException: Unable
    to check IdentityIQ database version: Invalid object name ‘spt_database_version’
    .

  6. Raja Bommana
    January 31, 2017 at 7:54 PM #

    Hi Vaibhav

    same issue
    EVERE: Exception sending context initialized event to listener instance of class sailpoint.web.StartupContextListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘versionChecker’ defined in class path resource [configBeans.xml]: Initialization of bean failed; nested exception is java.lang.RuntimeException: Unable to check IdentityIQ database version: Invalid object name ‘spt_database_version’.
    java.lang.RuntimeException: Unable to check IdentityIQ database version: Invalid object name ‘spt_database_version’.

    SQL Server: 2008 R2
    Sailpoint/Identityiq = 64 basic no patches

    please provide your thoughts/solution ..its really urgent

  7. VaibhavTripathi
    February 8, 2017 at 12:42 PM #

    Hi Raja,

    I have already mentioned one solution in my post.

    Another option can be to update the db version directly in the spt_database table.

    There is a specific value pair in the spt_database table.If you can find the right pair and run an update command directly on the table and then try to restart the app-server, you would not see this error.

Leave a Reply

Your email address will not be published. Required fields are marked *

(Required)

Proudly powered by WordPress   Premium Style Theme by www.gopiplus.com