09-15-2008 09:46 PM
we have problem with RME. Do you have any tips?
[ må sep 15 14:08:58 CEST 2008 ],ERROR,[Thread-22],com.cisco.nm.rmeng.util.logger.RMELogger,770,com.cisco.nm.rmeng.inventory.ics.invchange.AddInvChange,effect,33,Unexpected error :com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -193: Primary key for table 'PhysicalElement' is not unique
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2834)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2156)
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.executeLoop(SybStatement.java:1766)
at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1758)
at com.sybase.jdbc2.jdbc.SybPreparedStatement.execute(SybPreparedStatement.java:619)
at com.cisco.nm.rmeng.inventory.ics.dbrep.DBRecord.insert(DBRecord.java:50)
at com.cisco.nm.rmeng.inventory.ics.util.ICSDatabaseConnection.insert(ICSDatabaseConnection.java:91)
at com.cisco.nm.rmeng.inventory.ics.invchange.AddInvChange.effect(AddInvChange.java:29)
at com.cisco.nm.rmeng.inventory.ics.server.InvDataProcessor.processInvData(InvDataProcessor.java:394)
at com.cisco.nm.rmeng.inventory.ics.core.CollectionController.run(CollectionController.java:849)
at java.lang.Thread.run(Thread.java:534)
[ må sep 15 14:08:58 CEST 2008 ],ERROR,[Thread-22],com.cisco.nm.rmeng.inventory.ics.server.InvDataProcessor,448,ASA Error -193: Primary key for table 'PhysicalElement' is not unique
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -193: Primary key for table 'PhysicalElement' is not unique
at com.sybase.jdbc2.tds.Tds.processEed(Tds.java:2834)
at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2156)
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.executeLoop(SybStatement.java:1766)
at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1758)
at com.sybase.jdbc2.jdbc.SybPreparedStatement.execute(SybPreparedStatement.java:619)
at com.cisco.nm.rmeng.inventory.ics.dbrep.DBRecord.insert(DBRecord.java:50)
at com.cisco.nm.rmeng.inventory.ics.util.ICSDatabaseConnection.insert(ICSDatabaseConnection.java:91)
at com.cisco.nm.rmeng.inventory.ics.invchange.AddInvChange.effect(AddInvChange.java:29)
at com.cisco.nm.rmeng.inventory.ics.server.InvDataProcessor.processInvData(InvDataProcessor.java:394)
at com.cisco.nm.rmeng.inventory.ics.core.CollectionController.run(CollectionController.java:849)
at java.lang.Thread.run(Thread.java:534)
[ må sep 15 14:08:58 CEST 2008 ],ERROR,[Thread-22],com.cisco.nm.rmeng.inventory.ics.core.CollectionController,861, Exception occured in process method while processing: 172.19.6.125 ASA Error -193: Primary key for table 'PhysicalElement' is not unique
ICSException :: ASA Error -193: Primary key for table 'PhysicalElement' is not unique
at com.cisco.nm.rmeng.inventory.ics.server.InvDataProcessor.processInvData(InvDataProcessor.java:463)
at com.cisco.nm.rmeng.inventory.ics.core.CollectionController.run(CollectionController.java:849)
at java.lang.Thread.run(Thread.java:534)
09-16-2008 05:56 AM
What version of RME?
09-16-2008 10:05 PM
RME version 4.0.6
09-16-2008 10:15 PM
Then you are most likely hitting CSCsm97530. A patch for this bug is available by calling the TAC.
09-16-2008 10:16 PM
Ok, will do. Thank you
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: