Error "Unable to fill pool: java:/SlimDS ... Unable to create connection" appears in the NuGenesis LMS server.log file - WKB99326

SYMPTOMS

• The following error message appears many times each day in the server.log file for NuGenesis LMS:

  • DATE TIME WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.PoolBySubject] (JCA PoolFiller) IJ000610: Unable to fill pool: java:/SlimDS: javax.resource.ResourceException: IJ031084: Unable to create connection
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.access$200(LocalManagedConnectionFactory.java:62)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory$1$1.run(LocalManagedConnectionFactory.java:259)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory$1$1.run(LocalManagedConnectionFactory.java:250)
        at java.security.AccessController.doPrivileged(Native Method)
        at javax.security.auth.Subject.doAs(Subject.java:422)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory$1.run(LocalManagedConnectionFactory.java:249)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory$1.run(LocalManagedConnectionFactory.java:246)
        at java.security.AccessController.doPrivileged(Native Method)
        at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:245)
        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1327)
        at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.fillTo(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1139)

ENVIRONMENT

• NuGenesis 9 LMS
• The NuGenesis Stability module is NOT in use and the "SLIM" database instance has been turned off/disabled

CAUSE

The default configuration file for the NuGenesis LMS server includes a connection to the SLIM database. The WildFly server will attempt to connect to the SLIM database in order to establish a connection pool for SLIM, but the connection will fail, and WildFly will re-attempt the connection many times. In addition, the LMS server configuration tool does not allow the connection parameters for the Stability database to be left blank.

FIX or WORKAROUND

1. Duplicate the LMS instance connection parameters into the Stability connection parameters. Now WildFly will be able to connect to the "SLIM" database, and it will no longer fill the log file with warning messages.
2. An alternative is to edit the file Drive:\WatersLMSServer\WildFly-11.0.0.Final\standalone\configuration\nugenesis-lms.xml to disable the SlimDS connection:

   1. <datasource enabled="false" jndi-name="java:/SlimDS" pool-name="SlimDS" statistics-enabled="true" use-ccm="true">

   2. Save and close nugenesis-lms.xml.

   3. Restart the NuGenesis LMS Server service.

ADDITIONAL INFORMATION

CRI-2133 was filed for this issue. It requests that the LMS server configuration tool be enhanced to allow for the removal of the Stability DB connection.