Since upgrading to LMS4.x we are having problems with UT - a number of end hosts (including mine) are not appearing in UT, even though these were seen in LMS3.2, and some entries are not showing IP addresses or host names in reports. The UT.log file is repeatedly showing the following error:
2011/09/26 11:20:12 main ERROR VmpsMajorDBUtil: Error inserting Entry in DB for mac: 00-60-b9-57-a6-09com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -193: Primary key for table 'NewMAC' is not unique
com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -193: Primary key for table 'NewMAC' is not unique
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2884)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2206)
at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220)
at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203)
at com.sybase.jdbc2.jdbc.ParamManager.nextResult(ParamManager.java:700)
at com.sybase.jdbc2.jdbc.ParamManager.getOutValueAt(ParamManager.java:482)
at com.sybase.jdbc2.jdbc.SybCallableStatement.getLong(SybCallableStatement.java:313)
at com.cisco.nm.ani.server.vmpsadmin.VmpsMajorDBUtil.insertEntryInDB(VmpsMajorDBUtil.java:974)
at com.cisco.nm.ani.server.vmpsadmin.VmpsAdminSMFGenerateTable.generate(VmpsAdminSMFGenerateTable.java:1296)
at com.cisco.nm.ani.server.vmpsadmin.VmpsAdminSMFGenerateTable.apply(VmpsAdminSMFGenerateTable.java:210)
at com.cisco.nm.ani.server.framework.EvalSMFApply.apply(EvalSMFApply.java:93)
at com.cisco.nm.ani.server.frontend.EvalGroup.executeMajorNode(EvalGroup.java:639)
at com.cisco.nm.ani.server.frontend.EvalGroup.apply(EvalGroup.java:714)
at com.cisco.nm.ani.server.frontend.EvalGroup.apply(EvalGroup.java:672)
at com.cisco.nm.ani.server.frontend.AniTimeBaseImpl.performScheduledFunction(AniTimeBaseImpl.java:133)
at com.cisco.nm.ani.server.vmpsadmin.UTMajorDiscovery.performScheduledFunction(UTMajorDiscovery.java:303)
at com.cisco.nm.ani.server.vmpsadmin.UTMajorDiscovery.startUp(UTMajorDiscovery.java:168)
at com.cisco.nm.ani.server.vmpsadmin.UTMajorDiscovery.main(UTMajorDiscovery.java:37)
Can anyone suggest a remedy for this?