Hello!

Im getting this message when trying to view the System Information log from the Configuration tab:

Code:
Failed to retrieve Message Log entries.: org.hibernate.exception.DataException: could not execute query
See the ZENworks Control Center log file (zcc.log) for the full stack trace.
The error also accure on some workstations, not all of them, but some.
I have tryed restart services and i have done a reboot of the server.

Still the same error.

Did a Google and a Novell forum search with no results.

And the error code in logfile:

Code:
12 Oct 2007 10:02:47 ============== Exception (begin) ===========================
12 Oct 2007 10:02:47 Exception occured
com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.DataException: could not execute query
    at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:298)
    at com.novell.zenworks.datamodel.utils.hibernate.sqlanywhere.SQLAnywhereHelper.newStandardDataModelException(SQLAnywhereHelper.java:262)
    at com.novell.zenworks.datamodel.utils.hibernate.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:287)
    at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:175)
    at com.novell.zenworks.datamodel.utils.hibernate.HibernateResultHelper.query(HibernateResultHelper.java:228)
    at com.novell.zenworks.datamodel.utils.hibernate.HibernateResultHelper.getResults(HibernateResultHelper.java:185)
    at com.novell.zenworks.datamodel.services.messaging.MessageResultHelper.query(MessageResultHelper.java:85)
    at com.novell.zenworks.datamodel.services.messaging.MessageResultHelper.getMessages(MessageResultHelper.java:60)
    at com.novell.zenworks.datamodel.services.messaging.MessagingImpl.getMessages(MessagingImpl.java:251)
    at com.novell.zenworks.admin.controls.EventLog.updateData(EventLog.java:1291)
    at com.novell.zenworks.admin.controls.EventLog.bindGrid(EventLog.java:1324)
    at com.novell.zenworks.admin.controls.EventLog.prerender(EventLog.java:931)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2618)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.zenworks.admin.layout.SnapshotTemplate.preRenderRecursiveInternal(SnapshotTemplate.java:496)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.WebControl.preRenderRecursiveInternal(WebControl.java:2629)
    at com.novell.web.controls.Page.internalProcessRequest(Page.java:596)
    at com.novell.web.controls.Page.processRequest(Page.java:525)
    at com.novell.zenworks.admin.layout.Index.processRequest(Index.java:516)
    at com.novell.web.controls.PageTag.doEndTag(PageTag.java:83)
    at org.apache.jsp.jsp.index_jsp._jspService(index_jsp.java:178)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:691)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:364)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
    at com.novell.web.NJWCServlet.serviceImpl(NJWCServlet.java:82)
    at com.novell.zenworks.admin.NRMServlet.service(NRMServlet.java:176)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
    at com.novell.zenworks.tomcat.ZENRequestValve.invoke(ZENRequestValve.java:979)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
    at java.lang.Thread.run(Thread.java:595)
Caused by: org.hibernate.exception.DataException: could not execute query
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.loader.Loader.doList(Loader.java:2148)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
    at org.hibernate.loader.Loader.list(Loader.java:2024)
    at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:118)
    at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1659)
    at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
    at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:164)
    at com.novell.zenworks.datamodel.utils.hibernate.HibernateResultHelper.query(HibernateResultHelper.java:220)
    ... 57 more
Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]Right truncation of string data
    at ianywhere.ml.jdbcodbc.IIResultSet.next(Native Method)
    at ianywhere.ml.jdbcodbc.IResultSet.next(IResultSet.java:420)
    at com.mchange.v2.c3p0.impl.NewProxyResultSet.next(NewProxyResultSet.java:2859)
    at org.hibernate.loader.Loader.doQuery(Loader.java:685)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
    at org.hibernate.loader.Loader.doList(Loader.java:2145)
    ... 64 more
12 Oct 2007 10:02:47

Exception Info:
12 Oct 2007 10:02:47     Class....... com.novell.zenworks.datamodel.exceptions.InternalDataModelException
12 Oct 2007 10:02:47     Message..... org.hibernate.exception.DataException: could not execute query
12 Oct 2007 10:02:47     Logged at... EventLog...........1304
12 Oct 2007 10:02:47 ============== Exception (end) =============================