Remedy - Server - ARS 9.x is not starting - org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

Version 1
    Share:|

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    Remedy AR System Server


    COMPONENT:

    AR System


    APPLIES TO:

    BMC Remedy AR System Server v9.x



    PROBLEM:

    Remedy ARSystem server is not starting up.

    The arerror.log may report the following referencing a 'null' URL and unable to find a system form.
    ......
    Tue Dec 08 07:25:41.058 2015 Removal of previously generated PID file successful
    Tue Dec 08 07:25:42.762 2015
    Error trying to find a system form.
    org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'

            at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452) ~[commons-dbcp-1.4.jar:1.4]
    ......


    The ardebug.log may report the null URL
    ......
    Sat Dec 05 17:31:41.634 2015 org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1452)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
        at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
        at com.bmc.arsys.configuration.service.impl.ConfigurationImpl.getSystemFormTableName(ConfigurationImpl.java:242)
        at com.bmc.arsys.configuration.service.impl.ConfigurationImpl.initDatabaseConfig(ConfigurationImpl.java:179)
        at com.bmc.arsys.configuration.service.impl.ConfigurationImpl.initialize(ConfigurationImpl.java:134)

    .....etc......
        at org.eclipse.gemini.blueprint.util.internal.PrivilegedUtils.executeWithCustomTCCL(PrivilegedUtils.java:85)
        at org.eclipse.gemini.blueprint.context.support.AbstractDelegatedExecutionApplicationContext.completeRefresh(AbstractDelegatedExecutionApplicationContext.java:290)

        at org.eclipse.gemini.blueprint.extender.internal.dependencies.startup.DependencyWaiterApplicationContextExecutor$CompleteRefreshTask.run(DependencyWaiterApplicationContextExecutor.java:137)
        at java.lang.Thread.run(Unknown Source)
    Caused by: java.lang.NullPointerException: null
        at oracle.jdbc.driver.OracleDriver.acceptsURL(OracleDriver.java:638)
        at java.sql.DriverManager.getDriver(Unknown Source)

        at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1437)
        ... 26 common frames omitted
    ......

     


    CAUSE:

    The database parameters in the ar.cfg/ar.conf may be missing or incorrect values.


    SOLUTION:

    Depending on the DB platform the following are the options. The values are also case sensitive.
    Db-Type: sqlserver
    Db-Type: oracle

    Note:  The current documentation incorrectly states value 'Oracle' instead of all lower case 'oracle'.


    Related Information:
    Article: Remedy - Server - Starting ARServer the following message can be observed: "Cannot create JDBC driver of class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' "


    Article Number:

    000099857


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles