11-29-2011 07:36 AM
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
Solved! Go to Solution.
12-01-2011 12:32 AM
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
11-29-2011 11:26 PM
I forgot to mention that we use LMS3.2 with RME 4.3.1
12-01-2011 12:32 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide