Highlighted
Knowledge Partner
Knowledge Partner

Re: Updated to 11.4, now user assigned bundles/policies not

FishEggStew;2408568 wrote:
I don't see any of the errors mentioned in the services-messages.log, but there are a couple of java exception errors in there. They look like this:

>>Begin quote
[TRACE] [10/13/2015 08:08:13.246] [18231] [ZENService] [3913] [] [Content Web Service] [] [getContentInfo: Error retrieving content object.] [] [] [] [ZENServer]
[TRACE] [10/13/2015 08:08:13.249] [18231] [ZENService] [3913] [] [Content Web Service] [com.novell.zenworks.datamodel.exceptions.ConnectionException: org.hibernate.exception.GenericJDBCException: ((Sybase()((JDBC Driver()((SQL Anywhere()Connection was terminated
at com.novell.zenworks.datamodel.database.sqlanywhere.SQLAnywhereHelper.newStandardDataModelException(SQLAnywhereHelper.java:307)
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:441)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:252)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleQuery(AbstractHibernateSessionImpl.java:701)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleQuery(HibernateBasicSession.java:1407)
at com.novell.zenworks.datamodel.utils.AdminImplUtil.getObjects(AdminImplUtil.java:306)
at com.novell.zenworks.datamodel.utils.AdminImplUtil.getObjects(AdminImplUtil.java:298)
at com.novell.zenworks.datamodel.utils.AdminImplUtil.getObject(AdminImplUtil.java:286)
at com.novell.zenworks.datamodel.utils.AdminImplUtil.getString(AdminImplUtil.java:244)
at com.novell.zenworks.datamodel.services.content.ContentAdminImpl.getAliasedContentUID(ContentAdminImpl.java:5538)
at com.novell.zenworks.datamodel.services.content.ContentAdminImpl.getContent(ContentAdminImpl.java:2414)
at com.novell.zenworks.datamodel.services.content.ContentAdminImpl.get(ContentAdminImpl.java:2392)
at com.novell.zenworks.webservice.contentservice.ContentWebServiceImpl.getContentOrError(ContentWebServiceImpl.java:147)
at com.novell.zenworks.webservice.contentservice.ContentWebServiceImpl.getContentInfoEx(ContentWebServiceImpl.java:445)
at com.novell.zenworks.webservice.contentservice.schema.ContentService_ServiceTieSkeleton.getContentInfoEx(ContentService_ServiceTieSkeleton.java:92)
at com.novell.zenworks.webservice.contentservice.schema.ContentService_ServiceSkeleton._invoke(ContentService_ServiceSkeleton.java:283)
at com.novell.soa.ws.server.ServletSkeleton.invokeEndPoint(ServletSkeleton.java:201)
at com.novell.soa.ws.impl.soap.MessageHandlerInvoker.invokeServerMessageHandlers(MessageHandlerInvoker.java:347)
at com.novell.soa.ws.impl.soap.SOAPHandler.handleServerRequest(SOAPHandler.java:85)
at com.novell.soa.ws.impl.rpc.ServerDelegateImpl.handleServerRequest(ServerDelegateImpl.java:92)
at com.novell.soa.ws.server.ServletSkeleton.handleRequest(ServletSkeleton.java:101)
at com.novell.soa.ws.server.ServletSkeleton.doPost(ServletSkeleton.java:300)
at com.novell.zenworks.webservice.contentservice.ContentWebService.doPost(ContentWebService.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.novell.zenworks.webservice.lib.StatisticFilter.doFilter(StatisticFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at com.googlecode.psiprobe.Tomcat70AgentValve.invoke(Tomcat70AgentValve.java:39)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at com.novell.zenworks.tomcat.ZENRequestValve.synchronousInvoke(ZENRequestValve.java:1442)
at com.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:849)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: ((Sybase()((JDBC Driver()((SQL Anywhere()Connection was terminated
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy48.prepareStatement(Unknown Source)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1711)
at org.hibernate.loader.Loader.doQuery(Loader.java:828)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
at org.hibernate.loader.Loader.doList(Loader.java:2438)
at org.hibernate.loader.Loader.doList(Loader.java:2424)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2254)
at org.hibernate.loader.Loader.list(Loader.java:2249)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1248)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleQuery(AbstractHibernateSessionImpl.java:693)
... 45 more
Caused by: java.sql.SQLException: ((Sybase()((JDBC Driver()((SQL Anywhere()Connection was terminated
at sybase.jdbc4.sqlanywhere.IConnection.nativePrepareStatement(Native Method)
at sybase.jdbc4.sqlanywhere.IConnection.prepareStatement(IConnection.java:606)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:274)
at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138)
... 63 more
] [com.novell.zenworks.datamodel.exceptions.ConnectionException: org.hibernate.exception.GenericJDBCException: (Sybase)(JDBC Driver)(SQL Anywhere)Connection was terminated
at com.novell.zenworks.datamodel.database.sqlanywhere.SQLAnywhereHelper.newStandardDataModelException(SQLAnywhereHelper.java:307)
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:441)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:252)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleQuery(AbstractHibernateSessionImpl.java:701)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.simpleQuery(HibernateBasicSession.java:1407)
at com.novell.zenworks.datamodel.utils.AdminImplUtil.getObjects(AdminImplUtil.java:306)
at com.novell.zenworks.datamodel.utils.AdminImplUtil.getObjects(AdminImplUtil.java:298)
at com.novell.zenworks.datamodel.utils.AdminImplUtil.getObject(AdminImplUtil.java:286)
at com.novell.zenworks.datamodel.utils.AdminImplUtil.getString(AdminImplUtil.java:244)
at com.novell.zenworks.datamodel.services.content.ContentAdminImpl.getAliasedContentUID(ContentAdminImpl.java:5538)
at com.novell.zenworks.datamodel.services.content.ContentAdminImpl.getContent(ContentAdminImpl.java:2414)
at com.novell.zenworks.datamodel.services.content.ContentAdminImpl.get(ContentAdminImpl.java:2392)
at com.novell.zenworks.webservice.contentservice.ContentWebServiceImpl.getContentOrError(ContentWebServiceImpl.java:147)
at com.novell.zenworks.webservice.contentservice.ContentWebServiceImpl.getContentInfoEx(ContentWebServiceImpl.java:445)
at com.novell.zenworks.webservice.contentservice.schema.ContentService_ServiceTieSkeleton.getContentInfoEx(ContentService_ServiceTieSkeleton.java:92)
at com.novell.zenworks.webservice.contentservice.schema.ContentService_ServiceSkeleton._invoke(ContentService_ServiceSkeleton.java:283)
at com.novell.soa.ws.server.ServletSkeleton.invokeEndPoint(ServletSkeleton.java:201)
at com.novell.soa.ws.impl.soap.MessageHandlerInvoker.invokeServerMessageHandlers(MessageHandlerInvoker.java:347)
at com.novell.soa.ws.impl.soap.SOAPHandler.handleServerRequest(SOAPHandler.java:85)
at com.novell.soa.ws.impl.rpc.ServerDelegateImpl.handleServerRequest(ServerDelegateImpl.java:92)
at com.novell.soa.ws.server.ServletSkeleton.handleRequest(ServletSkeleton.java:101)
at com.novell.soa.ws.server.ServletSkeleton.doPost(ServletSkeleton.java:300)
at com.novell.zenworks.webservice.contentservice.ContentWebService.doPost(ContentWebService.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at com.novell.zenworks.webservice.lib.StatisticFilter.doFilter(StatisticFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at com.googlecode.psiprobe.Tomcat70AgentValve.invoke(Tomcat70AgentValve.java:39)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at com.novell.zenworks.tomcat.ZENRequestValve.synchronousInvoke(ZENRequestValve.java:1442)
at com.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:849)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:620)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.GenericJDBCException: (Sybase)(JDBC Driver)(SQL Anywhere)Connection was terminated
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:146)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy48.prepareStatement(Unknown Source)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:147)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:166)
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:145)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1711)
at org.hibernate.loader.Loader.doQuery(Loader.java:828)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:289)
at org.hibernate.loader.Loader.doList(Loader.java:2438)
at org.hibernate.loader.Loader.doList(Loader.java:2424)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2254)
at org.hibernate.loader.Loader.list(Loader.java:2249)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:470)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:355)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:195)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1248)
at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleQuery(AbstractHibernateSessionImpl.java:693)
... 45 more
Caused by: java.sql.SQLException: (Sybase)(JDBC Driver)(SQL Anywhere)Connection was terminated
at sybase.jdbc4.sqlanywhere.IConnection.nativePrepareStatement(Native Method)
at sybase.jdbc4.sqlanywhere.IConnection.prepareStatement(IConnection.java:606)
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:274)
at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.hibernate.engine.jdbc.internal.proxy.ConnectionProxyHandler.continueInvocation(ConnectionProxyHandler.java:138)
... 63 more
] [] [] [] [ZENServer]
>>End quote


Seems like it's loosing connection to the database, is it running locally or do you have a remote sybase db?

Thomas
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Updated to 11.4, now user assigned bundles/policies not

The database is local. This is a standard single-server install of ZCM.

0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: Updated to 11.4, now user assigned bundles/policies not

FishEggStew;2408570 wrote:
The database is local. This is a standard single-server install of ZCM.


Hmm.. Can you check the sybase version "rpm -qa | grep sybase", should be 12.some.thing? Does this server have enough resources, memory for example? How many devices are you managing?

Thomas
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Updated to 11.4, now user assigned bundles/policies not

It is 12.0.1.3873. It has 16GB of RAM and we have around 750 devices. The only borderline issue is the processor. It is 2GHz. It is an Intel Xeon E5405, though.

0 Likes
Highlighted
Knowledge Partner
Knowledge Partner

Re: Updated to 11.4, now user assigned bundles/policies not

FishEggStew;2408583 wrote:
It is 12.0.1.3873. It has 16GB of RAM and we have around 750 devices. The only borderline issue is the processor. It is 2GHz. It is an Intel Xeon E5405, though.


Take a look at the other logs on the server if you can find anything useful, but since this seems like a very critical issue you'd might want to open a SR if you have that possibility.

Thomas
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: Updated to 11.4, now user assigned bundles/policies not

I'll look at the other logs. Thank you for all of your help.
Everything appears to be working right now.

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.