mvcsd Absent Member.
Absent Member.
464 views

Dynamic groups won't recalculate

After upgrading to 2017 update2a I've noticed our dynamic workstation groups are no longer recalculating. Clicking Details -> Preview Members shows the correct list, but clicking Recalculate Group Members or just waiting for them to recalculate on a schedule is not working. I tried deleting a dynamic group and recreating it, and now I get an error creating dynamic groups. I found the following in my services-messages.log each time I try to recalculate or create a new dynamic group:

[TRACE] [07/09/2018 13:46:45.147] [4105] [ZENService] [107] [] [DeviceAdminImpl] [] [useStoredProcedure=true] [] [] [] [ZENServer]
[TRACE] [07/09/2018 13:46:45.198] [4105] [ZENService] [107] [] [HibernateGroupSession] [] [Error message from Database procedure: Error Stage : Inserting into zQueryGroupLogEntry for ADDED Exception : Primary key for table '???' is not unique: Primary key value ('???')] [] [] [] [ZENServer]
[TRACE] [07/09/2018 13:46:45.198] [4105] [ZENService] [107] [] [HibernateGroupSession] [] [,Error message from Database procedure : Error Code:-193 Error Stage : Inserting into zQueryGroupLogEntry for ADDED Exception : Primary key for table '???' is not unique: Primary key value ('???')] [] [] [] [ZENServer]
[TRACE] [07/09/2018 13:46:45.199] [4105] [ZENService] [107] [] [HibernateGroupSession] [] [Exception while adding group membership through stored procedure:Error Code:-193 Error Stage : Inserting into zQueryGroupLogEntry for ADDED Exception : Primary key for table '???' is not unique: Primary key value ('???')] [] [] [] [ZENServer]
[TRACE] [07/09/2018 13:46:45.201] [4105] [ZENService] [107] [] [DeviceAdmin] [] [Exception in refreshQueryGroup : com.novell.zenworks.datamodel.exceptions.InternalDataModelException: Error Code:-193 Error Stage : Inserting into zQueryGroupLogEntry for ADDED Exception : Primary key for table '???' is not unique: Primary key value ('???')
at com.novell.zenworks.datamodel.session.hibernate.HibernateGroupSession.updateMembers(HibernateGroupSession.java:633)
at com.novell.zenworks.datamodel.services.groupings.GroupingImpl.updateMembers(GroupingImpl.java:658)
at com.novell.zenworks.datamodel.services.groupings.GroupingImpl.updateMembers(GroupingImpl.java:636)
at com.novell.zenworks.datamodel.services.devices.DeviceAdminImpl.refreshQueryGroup(DeviceAdminImpl.java:1400)
at com.novell.zenworks.datamodel.services.devices.DeviceAdminImpl.create(DeviceAdminImpl.java:386)
at com.novell.zenworks.admin.pages.common.wizards.newDynamicGroup.Controller.onFinish(Controller.java:200)
at com.novell.zenworks.fw.web.layout.WizardController.onWizardEvent(WizardController.java:283)
at com.novell.zenworks.fw.web.internal.layout.Wizard.verifyActionWithController(Wizard.java:736)
at com.novell.zenworks.fw.web.internal.layout.Wizard.finishButton_Click(Wizard.java:476)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.novell.web.controls.WebControl.fireEvent(WebControl.java:1977)
at com.novell.web.controls.WebControl.fireEvent(WebControl.java:1952)
at com.novell.web.controls.Button.raisePostBackEvent(Button.java:471)
at com.novell.web.controls.Page.raisePostBackEvent(Page.java:1125)
at com.novell.web.controls.Page.raisePostBackEvents(Page.java:1082)
at com.novell.web.controls.Page.internalProcessRequest(Page.java:747)
at com.novell.web.controls.Page.processRequest(Page.java:691)
at com.novell.zenworks.fw.web.internal.layout.Index.processRequest(Index.java:1384)
at com.novell.web.internal.controls.PageTag.doEndTag(PageTag.java:86)
at org.apache.jsp.jsp.index_jsp._jspService(index_jsp.java:740)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:716)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:466)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:358)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:318)
at com.novell.web.NJWCServlet.serviceImpl(NJWCServlet.java:98)
at com.novell.zenworks.fw.web.internal.ZENworksServlet.service(ZENworksServlet.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at com.patchlink.sapphire.web.pages.vulnerability.session.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:75)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:616)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
at com.googlecode.psiprobe.Tomcat80AgentValve.invoke(Tomcat80AgentValve.java:41)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at com.novell.zenworks.tomcat.ZENRequestValve.synchronousInvoke(ZENRequestValve.java:1740)
at com.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:1050)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1104)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1519)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1475)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)


I'm using the embedded sybase, checking in dbisqlc I only saw a few log entries in the zQueryGroupLogEntry. I deleted those, but still getting the same error.
Labels (1)
0 Likes
1 Reply
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Dynamic groups won't recalculate

There are not any known issues I could find around this issue.
You may require an SR, since most likely something has gone amiss in the DB somewhere...which is generally tougher to fix when it is not a known issue that may have some ready made SQL to fix.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.