RICS0001 error for 7206VXR

Answered Question
Nov 29th, 2011
User Badges:

Hi,


I am having trouble  with gathering inventory for  7206 XVR devices. I got this error:


RICS0001:Internal Error,unable to process the collected data from the device


How can I  make the inventory work for these devices ?


Thanks,

Akos


Here's an excerpt from IC_Server.log:


[ Tue Nov 29  16:24:53 CET 2011 ],ERROR,[Thread-31],com.cisco.nm.rmeng.inventory.ics.server.InvDataProcessor,458,SQL Anywhere Error -193: Primary key for table 'MemoryPool' is not unique

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

        at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1758)

        at com.sybase.jdbc2.jdbc.SybPreparedStatement.execute(SybPreparedStatement.java:630)

        at com.cisco.nm.rmeng.inventory.ics.dbrep.DBRecord.insert(DBRecord.java:61)

        at com.cisco.nm.rmeng.inventory.ics.util.ICSDatabaseConnection.insert(ICSDatabaseConnection.java:92)

        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:404)

        at com.cisco.nm.rmeng.inventory.ics.core.CollectionController.run(CollectionController.java:462)

        at java.lang.Thread.run(Thread.java:595)

[ Tue Nov 29  16:24:53 CET 2011 ],ERROR,[Thread-31],com.cisco.nm.rmeng.inventory.ics.core.CollectionController,468, Exception occured in process method while processing: 192.168.147.170 SQL Anywhere Error -193: Primary key for table 'MemoryPool' is not unique

ICSException :: SQL Anywhere Error -193: Primary key for table 'MemoryPool' is not unique

        at com.cisco.nm.rmeng.inventory.ics.server.InvDataProcessor.processInvData(InvDataProcessor.java:473)

        at com.cisco.nm.rmeng.inventory.ics.core.CollectionController.run(CollectionController.java:462)

        at java.lang.Thread.run(Thread.java:595)

[ Tue Nov 29  16:24:53 CET 2011 ],DEBUG,[Thread-31],com.cisco.nm.rmeng.util.logger.RMELogger,734,com.cisco.nm.rmeng.common.notification.Notification,refreshPrefsCache,233,Obtained Notification Configuration values from CCR

[ Tue Nov 29  16:24:53 CET 2011 ],DEBUG,[Thread-31],com.cisco.nm.rmeng.util.logger.RMELogger,734,com.cisco.nm.rmeng.common.notification.Notification,getCCRValue,88,is_notification_enabled  CfgDisabled:InvDisabled

[ Tue Nov 29  16:24:53 CET 2011 ],INFO ,[Thread-31],com.cisco.nm.rmeng.inventory.ics.core.CollectionController,596,No Trap

[ Tue Nov 29  16:24:53 CET 2011 ],INFO ,[Thread-31],com.cisco.nm.rmeng.inventory.ics.core.CollectionController,602,CALLING SELF TEST

[ Tue Nov 29  16:24:53 CET 2011 ],DEBUG,[Thread-31],com.cisco.nm.rmeng.inventory.ics.core.DevMgmtStatusUtil,95,QQQWQQ:   select count(NetworkElementId) from Dev_Mgmt_Status where NetworkElementId = 749

[ Tue Nov 29  16:24:53 CET 2011 ],DEBUG,[Thread-31],com.cisco.nm.rmeng.inventory.ics.core.DevMgmtStatusUtil,52,INSERT CHECK DONE

[ Tue Nov 29  16:24:53 CET 2011 ],DEBUG,[Thread-31],com.cisco.nm.rmeng.inventory.ics.core.DevMgmtStatusUtil,234,QQQWQQ2:         update Dev_Mgmt_Status set Sys_Object_Id = '.1.3.6.1.4.1.9.1.222',Dev_Status = -1,Inventory_Collection_Status = 2,AG_Collected = '',Failure_Reason = 'RICS0001:Internal Error,unable to process the collected data from the device.',Corrective_Action = '',Last_Updated_Time = '2011-11-29 16:24:53.634' where NetworkElementID = 749

Attachment: 
Correct Answer by Svetlana Radzevich about 5 years 8 months ago

Hi Akos,


it is a bug in RME 4.3.1 - "CSCta05277 - Inventory collection fails with RICS0001". The bug is fixed in RME 4.3.2 but you will need to delete and re-add the device in RME.


Svetlana

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
aslyuch Tue, 11/29/2011 - 23:26
User Badges:

I forgot to mention that we use LMS3.2  with RME 4.3.1

Correct Answer
Svetlana Radzevich Thu, 12/01/2011 - 00:32
User Badges:
  • Cisco Employee,

Hi Akos,


it is a bug in RME 4.3.1 - "CSCta05277 - Inventory collection fails with RICS0001". The bug is fixed in RME 4.3.2 but you will need to delete and re-add the device in RME.


Svetlana

Actions

This Discussion