User Tracking Acquisition Error in LMS4.1

[marshajr]

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?

[Svetlana Radzevich]

Hi,

if you did not add any new device in the network, then you have stale entries in the UT database. Reinitializing this database most likely will fix the issue (you will lost only information collected during the data collection and UT acqusition - but next data collection and UT acquisition will re-populate this info).

Procedure to re-init UT database:

1. stop CiscoWorks:

         net stop crmdmgtd

2. Go under $NMSRoot\campus\bin and execute:

         perl reinitdb.pl -restore -ut

3. Start the daemon manager:

        net start crmdmgtd

4. run new data collection and UT acquisition.

Best regards,

Svetlana

[marshajr]

Svetlana - this is a two-week old install of LMS4.1. I do not wish to re-init the database as we need to keep data.

[Svetlana Radzevich]

This database does not contain any historical data. Every time you run data collection or user acquisition, the data from the database is deleted and a new data is added. However, if you have stale entries in the database, it will not be deleted automatically during data collection/user acquisition.

All data you will take back. The only drawback of re-init this database - if you have layout on the topology map, you will lose it, I mean that the devices on the topology map will be placed on different position on the map.