search cancel

Duplicate key in object dbo.CM_NIMBUS_PROBE

book

Article ID: 201348

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Received following alarm:

Checked discovery_server log and found the following messages:

03 oct 2020 13:43:51,840 [Thread-26 (HornetQ-client-global-threads-919063521)] WARN  org.hornetq.core.client - HQ212037: Connection failure has been detected: HQ119011: Did not receive data from server for [email protected][local= /XXX.XXX.XXX.XXX:59027, remote=/XXX.XXX.XXX.XXX:4334] [code=CONNECTION_TIMEDOUT]
06 oct 2020 10:57:24,768 [robotWorker-1] ERROR com.nimsoft.discovery.common.util.ExceptionUtil - ProbePersister exception for /UIMBPA/srappw001v112/w0100s02 : org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL []; Violation of PRIMARY KEY constraint 'PK_CM_NIMBUS_PROBE'. Cannot insert duplicate key in object 'dbo.CM_NIMBUS_PROBE'. The duplicate key value is (55, ad_server).; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK_CM_NIMBUS_PROBE'. Cannot insert duplicate key in object 'dbo.CM_NIMBUS_PROBE'. The duplicate key value is (55, ad_server).

06 oct 2020 10:57:24,768 [robotWorker-1] ERROR com.nimsoft.discovery.common.util.ExceptionUtil - org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL []; Violation of PRIMARY KEY constraint 'PK_CM_NIMBUS_PROBE'. Cannot insert duplicate key in object 'dbo.CM_NIMBUS_PROBE'. The duplicate key value is (55, ad_server).; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK_CM_NIMBUS_PROBE'. Cannot insert duplicate key in object 'dbo.CM_NIMBUS_PROBE'. The duplicate key value is (55, ad_server).

       at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)

       at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)

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

       at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:909)

       at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:933)

       at com.nimsoft.nis.dao.JdbcTemplateUpdater.update(JdbcTemplateUpdater.java:22)

       at com.nimsoft.nis.dao.JdbcTemplateUpdater.update(JdbcTemplateUpdater.java:32)

       at com.nimsoft.nis.dao.CmNimbusProbeDao.insert(CmNimbusProbeDao.java:52)

       at com.nimsoft.discovery.server.nis.persist.ProbePersister.doPersist(ProbePersister.java:72)

       at com.nimsoft.discovery.server.nis.persist.ProbePersister.persist(ProbePersister.java:46)

       at com.nimsoft.discovery.server.nimbus.scan.ProbeUpdater.persistProbes(ProbeUpdater.java:53)

       at com.nimsoft.discovery.server.nimbus.scan.ProbeUpdater.update(ProbeUpdater.java:41)

       at com.nimsoft.discovery.server.nimbus.scan.RobotUpdateWorker.updateProbes(RobotUpdateWorker.java:114)

       at com.nimsoft.discovery.server.nimbus.scan.RobotUpdateWorker.runUpdates(RobotUpdateWorker.java:64)

       at com.nimsoft.discovery.server.nimbus.scan.RobotUpdateWorker.run(RobotUpdateWorker.java:44)

       at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

       at java.util.concurrent.FutureTask.run(FutureTask.java:266)

       at com.nimsoft.discovery.common.thread.TimedFutureTask.run(TimedFutureTask.java:17)

       at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

       at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

       at java.lang.Thread.run(Thread.java:748)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Violation of PRIMARY KEY constraint 'PK_CM_NIMBUS_PROBE'. Cannot insert duplicate key in object 'dbo.CM_NIMBUS_PROBE'. The duplicate key value is (55, ad_server).

       at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)

       at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)

       at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)

       at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)

       at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)

       at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)

       at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)

       at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)

       at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:356)

       at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)

       at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98)

       at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:916)

       at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:909)

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

 

Environment

Release : 20.1

Component : ACTIVE DIRECTORY & EXCHANGE SERVER AIM

Resolution

Just restarted discover_server probe fixed the problem.