After updating our server to 10.2.2 I now get the following error when
trying to wake up workstations in ZCC:

Error: Failed to Wake up device: Failed to wakeup devices
See the ZENworks Control Center log file (zcc.log) for the full stack trace.

Server is Windows 2003 using the built in database. I didn't see any errors
in the logs after the server update but I will go back through them in the
morning and make sure.

Jim Koerner


ZCC.log of the error

16 Dec 2009 22:30:06

Exception Info:
16 Dec 2009 22:30:06 Class....... javax.servlet.jsp.JspException
16 Dec 2009 22:30:06 Message..... Invalid view state
16 Dec 2009 22:30:06 Logged at... Page................545
16 Dec 2009 22:30:06 ============== Exception (end)
=============================
16 Dec 2009 23:00:16 RemoteControlDial..1111 :OnLoad(): Remote Management
XML blob:<RMProxyData />
16 Dec 2009 23:00:16 RemoteControlDial..1049 :Entered the function
addDropdownListElements
16 Dec 2009 23:00:16 RemoteControlDialo..403 :initialize controls called
16 Dec 2009 23:05:54 MessageUtil..........99 :Note: Your username or
password is incorrect, please check spelling and try again
16 Dec 2009 23:07:22 BaseDeviceList......344 :Inside WOL menuitemclick
selected devices ed13cc2b12c67dc98c44f3d74e09b20cWorkstation Folder
16 Dec 2009 23:07:31 WakeOnLanOptionsDi..516 :BroadcastAddressList:[]
ServersList :[] Retry :1 Timeout :2
16 Dec 2009 23:07:31 WakeOnLanUtil........42 :Failed to wake up
devicecom.novell.zenworks.wol.WOLException: Failed to wakeup devices
16 Dec 2009 23:07:31 MessageUtil..........85 :Error: Failed to Wake up
device
16 Dec 2009 23:07:31 ============== Exception (begin)
===========================
16 Dec 2009 23:07:31 Exception occured
com.novell.zenworks.wol.WOLException: Failed to wakeup devices
at
com.novell.zenworks.wol.WakeOnLanDirectImpl.insert WOLActionToQueue(WakeOnLanDirectImpl.java:194)
at
com.novell.zenworks.wol.WakeOnLanDirectImpl.addWOL ActionToQueue(WakeOnLanDirectImpl.java:110)
at
com.novell.zenworks.admin.pages.devices.wakeOnLan. WakeOnLanUtil.wakeUpDevices(WakeOnLanUtil.java:30)
at
com.novell.zenworks.admin.pages.devices.wakeOnLan. WakeOnLanOptionsDialog.wolOkButton_click(WakeOnLan OptionsDialog.java:518)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.novell.web.controls.WebControl.fireEvent(WebCo ntrol.java:1977)
at com.novell.web.controls.WebControl.fireEvent(WebCo ntrol.java:1952)
at com.novell.web.controls.Button.raisePostBackEvent( Button.java:475)
at com.novell.web.controls.Page.raisePostBackEvent(Pa ge.java:885)
at com.novell.web.controls.Page.raisePostBackEvents(P age.java:872)
at com.novell.web.controls.Page.internalProcessReques t(Page.java:584)
at com.novell.web.controls.Page.processRequest(Page.j ava:528)
at
com.novell.zenworks.fw.web.internal.layout.Index.p rocessRequest(Index.java:518)
at com.novell.web.internal.controls.PageTag.doEndTag( PageTag.java:86)
at org.apache.jsp.jsp.index_jsp._jspService(index_jsp .java:179)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:328)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:315)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.ApplicationDispatcher.inv oke(ApplicationDispatcher.java:691)
at
org.apache.catalina.core.ApplicationDispatcher.pro cessRequest(ApplicationDispatcher.java:469)
at
org.apache.catalina.core.ApplicationDispatcher.doF orward(ApplicationDispatcher.java:364)
at
org.apache.catalina.core.ApplicationDispatcher.for ward(ApplicationDispatcher.java:301)
at com.novell.web.NJWCServlet.serviceImpl(NJWCServlet .java:97)
at
com.novell.zenworks.fw.web.internal.ZENworksServle t.service(ZENworksServlet.java:84)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:803)
at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:269)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at
com.patchlink.sapphire.web.pages.vulnerability.ses sion.HibernateSessionFilter.doFilter(HibernateSess ionFilter.java:75)
at
org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:215)
at
org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:188)
at
org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:210)
at
org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:174)
at
org.apache.catalina.authenticator.AuthenticatorBas e.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.invok e(StandardEngineValve.java:108)
at
com.novell.zenworks.tomcat.ZENRequestValve.invoke( ZENRequestValve.java:1122)
at
org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:151)
at
org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:870)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:665)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:528)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:81)
at
org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:595)
Caused by:
com.novell.zenworks.datamodel.exceptions.InternalD ataModelException:
org.hibernate.exception.GenericJDBCException: could not execute query
at
com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.newStandardDataModelException(Abst ractDatabaseTypeHelper.java:436)
at
com.novell.zenworks.datamodel.database.sqlanywhere .SQLAnywhereHelper.newStandardDataModelException(S QLAnywhereHelper.java:282)
at
com.novell.zenworks.datamodel.database.AbstractDat abaseTypeHelper.throwStandardDataModelException(Ab stractDatabaseTypeHelper.java:421)
at
com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.handleException(Abstrac tHibernateSessionImpl.java:177)
at
com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleQueryCount(Abstra ctHibernateSessionImpl.java:467)
at
com.novell.zenworks.datamodel.services.queue.Queue AdminImpl.addIfNotPending(QueueAdminImpl.java:380)
at
com.novell.zenworks.wol.WakeOnLanDirectImpl.insert WOLActionToQueue(WakeOnLanDirectImpl.java:189)
... 51 more
Caused by: org.hibernate.exception.GenericJDBCException: could not execute
query
at
org.hibernate.exception.SQLStateConverter.handledN onSpecificException(SQLStateConverter.java:103)
at
org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:91)
at
org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:214 8)
at org.hibernate.loader.Loader.listIgnoreQueryCache(L oader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoa der.java:392)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(Que ryTranslatorImpl.java:333)
at
org.hibernate.engine.query.HQLQueryPlan.performLis t(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.ja va:1109)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:7 9)
at
org.hibernate.impl.AbstractQueryImpl.uniqueResult( AbstractQueryImpl.java:756)
at
com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.simpleQueryCount(Abstra ctHibernateSessionImpl.java:459)
... 53 more
Caused by: java.sql.SQLException: [Sybase][ODBC Driver][SQL Anywhere]The
pattern is too long
at ianywhere.ml.jdbcodbc.IIPreparedStatement.executeQ uery(Native Method)
at
ianywhere.ml.jdbcodbc.IPreparedStatement.executeQu ery(IPreparedStatement.java:201)
at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeQuery(NewProxyPreparedStatement.java:76)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(Ab stractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.ja va:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:66 2)
at
org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:214 5)
... 62 more
16 Dec 2009 23:07:31

Exception Info:
16 Dec 2009 23:07:31 Class....... com.novell.zenworks.wol.WOLException
16 Dec 2009 23:07:31 Message..... Failed to wakeup devices
16 Dec 2009 23:07:31 Logged at... Messages............313
16 Dec 2009 23:07:31 ============== Exception (end)
===========================