Database exception while discovering workstation with agent : Duplicate entry for key
Hello. I had problems with scanning workstations. When scanning workstation via its IP address or Name next error "
Database exception while updating Workstation. : Duplicate entry for key"
Copy from log:
Caused by: java.sql.BatchUpdateException: Batch entry 1 INSERT INTO CIRelationships (CIRELATIONSHIPID,CIID,CIID2,RELATIONSHIPTYPEID,ATTRIBUTETABLENAME,RELATIONSHIPID,RELATIONSHIPTEXT) VALUES ('2780','2702','2702','46',NULL,NULL,'VMHOST_VMS_SCAN') was aborted. Call getNextException to see the cause.
at com.adventnet.db.adapter.Jdbc20DBAdapter.handleSQLException(Jdbc20DBAdapter.java:1192)
at com.adventnet.db.api.RelationalAPI.handleException(RelationalAPI.java:680)
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:656)
at com.adventnet.persistence.DataAccess.insertRows(DataAccess.java:2193)
... 106 more
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "cirelationships_uk"
Detail: Key (ciid, ciid2)=(2702, 2702) already exists.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:750)
at com.adventnet.db.api.RelationalAPI.executeBatch(RelationalAPI.java:652)
... 107 more
I have 3 host where
arise
error, and they are Hyper-V host.
Whats a problem??
New to ADSelfService Plus?