cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
842
Views
0
Helpful
1
Replies

Error SQLAnywhere LMS 4.0.1

I'm receiving a lot of this log message:

com.sybase.jdbc2.jdbc.SybSQLException: SQL Anywhere Error -193: Primary key for table 'Technology_Device_Template' 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.SybStatement.updateLoop(SybStatement.java:1702)

        at com.sybase.jdbc2.jdbc.SybStatement.executeUpdate(SybStatement.java:1685)

        at com.sybase.jdbc2.jdbc.SybPreparedStatement.executeUpdate(SybPreparedStatement.java:115)

        at com.cisco.nm.rmeng.technology.util.TechnologyDBUtil.saveTechnology(TechnologyDBUtil.java:411)

        at com.cisco.nm.rmeng.technology.server.TechnologyCacheManager.updateDatabase(TechnologyCacheManager.java:357)

        at com.cisco.nm.rmeng.technology.server.TechnologyCacheManager.addTechnologiesForDevice(TechnologyCacheManager.java:247)

        at com.cisco.nm.rmeng.technology.server.TechnologyCacheManager.getTechnologiesForAllDevices(TechnologyCacheManager.java:181)

        at com.cisco.nm.rmeng.technology.server.TechnologyCacheManager.handleApplication(TechnologyCacheManager.java:407)

        at com.cisco.nm.rmeng.dcma.configmanager.DcmaService.handleTechnologies(DcmaService.java:243)

        at com.cisco.nm.rmeng.dcma.configmanager.DcmaService.main(DcmaService.java:81)

Do you know what dows it means?

Thank you

Fabrizio

1 Reply 1

Joe Clarke
Cisco Employee
Cisco Employee

This can point to database problems (not really corruption, but bad data).  You can try restarting Daemon Manager to see if that gets config archive working again.  If not, you will need to restore LMS from a known good backup or reinit the rmeng database using the instructions in

https://supportforums.cisco.com/docs/DOC-8796.

Review Cisco Networking for a $25 gift card