Man,,, Just did a COMPLETE re-install of my 2 win2003 server,
just did a complete re-install of my (lab) Zen10....

Just to find the same error occuring AGAIN !!!

Scenario;

Clean install (obivously)
server 1- zen server
server 2- remote DB

Everything checks OK according to the installer and how it looks,
BUT,, ; Configuration / Patch Management Services;

If I press "subscription service" I only get a LONG java error...
( see below )

I don't know if this happens because I 1st pressed "subscription
download" and choose my languages and THEN pressend subscription
service.

Reason for the above "guess" is that I on my initial test first
enabled subscription service and then configured the language..



----------------------------
org.hibernate.exception.SQLGrammarException: could not execute query
at
org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:67)
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
com.patchlink.sapphire.datamodel.PatchSubscription AdminService.getSDDSubLog(PatchSubscriptionAdminSe rvice.java:172)
at
com.patchlink.sapphire.web.pages.vulnerability.sub scription.PatchManagementSubscriptionServices.getS ubscriptionLog(PatchManagementSubscriptionServices .java:455)
at
com.patchlink.sapphire.web.pages.vulnerability.sub scription.PatchManagementSubscriptionServices.onLo ad(PatchManagementSubscriptionServices.java:100)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2423)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at
com.novell.web.controls.WebControl.loadRecursive(W ebControl.java:2429)
at com.novell.web.controls.Page.internalProcessReques t(Page.java:572)
at com.novell.web.controls.Page.processRequest(Page.j ava:527)
at
com.novell.zenworks.fw.web.internal.layout.Index.p rocessRequest(Index.java:479)
at com.novell.web.internal.controls.PageTag.doEndTag( PageTag.java:86)
at org.apache.jsp.jsp.index_jsp._jspService(index_jsp .java:176)
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: java.sql.SQLException: [Sybase][ODBC Driver][SQL
Anywhere]Column 'isSuccessful' not found
at ianywhere.ml.jdbcodbc.IConnection.nativePrepareSta tement(Native
Method)
at
ianywhere.ml.jdbcodbc.IConnection.prepareStatement (IConnection.java:324)
at
com.mchange.v2.c3p0.impl.NewProxyConnection.prepar eStatement(NewProxyConnection.java:213)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStat ement(AbstractBatcher.java:497)
at
org.hibernate.jdbc.AbstractBatcher.getPreparedStat ement(AbstractBatcher.java:415)
at
org.hibernate.jdbc.AbstractBatcher.prepareQuerySta tement(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.prepareQueryStatement( Loader.java:1561)
at org.hibernate.loader.Loader.doQuery(Loader.java:66 1)
at
org.hibernate.loader.Loader.doQueryAndInitializeNo nLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:214 5)
.... 62 more