When I try to change the filters on any of the groups I get the following error:
ICSU0024: Problem with the database. Check ICServerUI.log for more details. See User Guide for Resource Manager Essentials 4.1 for the log file location
Here is some of the output from the ICServerUI.log:
[ Mon Nov 26 10:09:23 PST 2007 ],ERROR,[TP-Processor2],DB Exception while updating change filter entries in DB
ICSException :: ASA Error -193: Primary key for table 'Inv_Change_Filter' is not unique
at com.cisco.nm.rmeng.inventory.ics.ui.helper.DBInterface.updateChangeFilterEntries(DBInterface.java:385)
at com.cisco.nm.rmeng.inventory.ics.ui.action.ICSChangeFilterAction.perform(ICSChangeFilterAction.java:291)
at org.apache.struts.action.ActionServlet.processActionPerform(ActionServlet.java:1786)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1585)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:509)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:754)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:684)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:876)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
Anyone know how to fix this?
THanks!