Newly added devices not showing up in UMP/USM web

Document ID : KB000013457
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

Why are newly added devices not showing up in UMP/USM on an otherwise working system? 

Answer:

This may indicate a disconnect between the discovery_server and the backend database as reflected here from the discovery_server.log:

01 Mar 2016 1:45:46,944 [nisGraphImport-1] ERROR com.nimsoft.discovery.common.util.ExceptionUtil - Error importing device: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 

01 Mar 2016 1:45:46,944 [nisGraphImport-1] ERROR com.nimsoft.discovery.common.util.ExceptionUtil - org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) 

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:575) 

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639) 

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:668) 

at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:676) 

at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:736) 

at com.nimsoft.nis.dao.CmDeviceDao.queryByDeviceId(CmDeviceDao.java:74) 

at com.nimsoft.discovery.server.ec.importer.NisIPDeviceImporter.findMasterCmDevice(NisIPDeviceImporter.java:133) 

at com.nimsoft.discovery.server.ec.importer.NisIPDeviceImporter.importToNis(NisIPDeviceImporter.java:105) 

at com.nimsoft.discovery.server.ec.importer.handler.ImportDeviceImportHandler.importDevice(ImportDeviceImportHandler.java:40) 

at com.nimsoft.discovery.server.ec.importer.CtdIPDeviceImporter.importDevice(CtdIPDeviceImporter.java:78) 

at com.nimsoft.discovery.server.ec.importer.CtdIPDeviceImporter.importDevices(CtdIPDeviceImporter.java:72) 

at com.nimsoft.discovery.server.ec.importer.CtdIPDeviceImporter.importToNis(CtdIPDeviceImporter.java:51) 

at com.nimsoft.discovery.server.ec.importer.NisGraphImporter.importDevices(NisGraphImporter.java:274) 

at com.nimsoft.discovery.server.ec.importer.NisGraphImporter.importToNis(NisGraphImporter.java:106) 

at com.nimsoft.discovery.server.ec.importer.NisGraphImportRunner.run(NisGraphImportRunner.java:18) 

at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) 

at java.util.concurrent.FutureTask.run(Unknown Source) 

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) 

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) 

at java.lang.Thread.run(Unknown Source) 

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object 

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) 

at com.nimsoft.db.PooledDataSourceWrapper.getConnection(PooledDataSourceWrapper.java:34) 

at com.nimsoft.nis.db.oracle.OracleDataSourceWrapper.getConnection(OracleDataSourceWrapper.java:24) 

at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) 

at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) 

... 20 more 

Caused by: java.util.NoSuchElementException: Timeout waiting for idle object 

at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1134) 

at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) 

... 24 more

 

Deactivating and activating the discovery_server probe will likely clear this up. After a period of 10-15 minutes check to see if the new devices are now being populated in USM/UMP.