Metric Studio Error -- CMM-SYS-5999

If you have multiple dispatchers and encounter the following error:

CMM-SYS-5999 - The Metrics Management Service encountered an internal error. 
 
java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
    at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1517)
    at java.lang.Runtime.loadLibrary0(Runtime.java:788)
    at java.lang.System.loadLibrary(System.java:834)
    at oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:262)
    at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:346)
    at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
    at java.sql.DriverManager.getConnection(DriverManager.java:512)
    at java.sql.DriverManager.getConnection(DriverManager.java:171)
    at com.cognos.canaveral.database.ConnectionPool$PooledConnection.reConnect(ConnectionPool.java:603)
    at com.cognos.canaveral.database.ConnectionPool.resetConnections(ConnectionPool.java:397)
    at com.cognos.canaveral.database.ConnectionPool.activateMoreConnections(ConnectionPool.java:365)
    at com.cognos.canaveral.database.ConnectionPool.initialize(ConnectionPool.java:244)
    at com.cognos.canaveral.database.ConnectionPool.<init>(ConnectionPool.java:82)
    at com.cognos.canaveral.database.PooledDBManager.initialize(PooledDBManager.java:98)
    at com.cognos.canaveral.database.PooledDBManager.<init>(PooledDBManager.java:50)
    at com.cognos.alp.control.Alp.createDBManager(Alp.java:1624)
    at com.cognos.cmm.MetricsManager.createDBInstance(MetricsManager.java:902)
    at com.cognos.cmm.MetricsManager.getUserDBAccessor(MetricsManager.java:833)
    at com.cognos.cmm.MetricsManager.processRequest(MetricsManager.java:483)
    at com.cognos.alp.control.Alp.service(Alp.java:621)
    at com.cognos.cpms.dispatcher.DispatcherAlpDriver$RunnableAlpRequest.run(DispatcherAlpDriver.java:377)
    at java.lang.Thread.run(Thread.java:534)
]]></item></parameters>

 

The problem likely occurred because the classes12.jar and the ojdbc14.jar file had been copied into the .../webapps/p2pd/WEB-INF/lib directory on the problem dispatcher.  Metric Studio 8.2 requires the use of the ojdbc14.jar file, remove the classes12.jar file from the .../webapps/p2pd/WEB-INF/lib directory

1. Stop the Cognos 8 service
2. Navigate to the .../webapps/p2pd/WEB-INF/lib directory
3. Remove the classes12.jar file
4. Start the Cognos 8 service