cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1198
Views
0
Helpful
3
Replies

User Tracking Acquisition Error in LMS4.1

marshajr
Level 1
Level 1

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?

3 Replies 3

Svetlana Radzevich
Cisco Employee
Cisco Employee