christoph3 Absent Member.
Absent Member.
567 views

Internal Sybase DB maintenance

Hello there,

i recently ran over the error that im unable to create a new Folder in Zenworks Bundle and Zenworks Policies in the zcm webpage. (see the error below)

i thought about doing some internal db rebuild, maybe the update from 17.2 to 17.3 screwed my sybase db.
https://www.novell.com/documentation/zenworks-2017-update-3/zen_sys_db_mgmt/data/bnww7vw.html#

im stuck on the step 8 where it says "Ensure that the database authentication has been set up by verifying that the database_authentication attribute in the saopts.sql file has been configured."

my saopts.sql script file does not have the entry for the "database_authentication"

as this is mixing up im not quite sure where to post it in the first way.

Are there any Suggestions or ideas to give me any hint to get it back to work?


[DEBUG] [10/25/2018 07:25:11.490] [1904] [ZENServer] [97] [__z_10_51__] [ZCC] [] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.SQLGrammarException: [SAP][JDBC Driver][SQL Anywhere]Spalte 'ZUID' nicht gefunden
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession._create(HibernateBasicSession.java:1663)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession.create(HibernateBasicSession.java:118)
at com.novell.zenworks.datamodel.services.BasicAdminImpl.create(BasicAdminImpl.java:111)
at com.novell.zenworks.datamodel.services.assignablecontent.AssignableContentObjectAdminImpl.create(AssignableContentObjectAdminImpl.java:265)
at com.novell.zenworks.datamodel.services.actions.ActionAdminImpl.create(ActionAdminImpl.java:100)
at com.novell.zenworks.datamodel.services.bundles.BundleAdminImpl.create(BundleAdminImpl.java:190)
at com.novell.zenworks.datamodel.services.bundles.BundleEventHandlerAdminImpl.create(BundleEventHandlerAdminImpl.java:44)
at com.novell.zenworks.core.web.objects.NewFolderDlg.ok_Click(NewFolderDlg.java:180)
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.BasePostbackControl.fireCommand(BasePostbackControl.java:546)
at com.novell.web.controls.Button.raisePostBackEvent(Button.java:470)
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:741)
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:608)
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:1132)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)
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)
Caused by: com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.SQLGrammarException: [SAP][JDBC Driver][SQL Anywhere]Spalte 'ZUID' nicht gefunden
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.newStandardDataModelException(AbstractDatabaseTypeHelper.java:504)
at com.novell.zenworks.datamodel.database.sqlanywhere.SQLAnywhereHelper.newStandardDataModelException(SQLAnywhereHelper.java:330)
at com.novell.zenworks.datamodel.database.AbstractDatabaseTypeHelper.throwStandardDataModelException(AbstractDatabaseTypeHelper.java:489)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.handleException(AbstractHibernateSessionImpl.java:295)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:474)
at com.novell.zenworks.datamodel.session.hibernate.HibernateBasicSession._create(HibernateBasicSession.java:1653)
... 62 more
Caused by: org.hibernate.exception.SQLGrammarException: [SAP][JDBC Driver][SQL Anywhere]Spalte 'ZUID' nicht gefunden
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:122)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
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.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)
at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)
at com.sun.proxy.$Proxy50.executeUpdate(Unknown Source)
at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2859)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3300)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:275)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:326)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:52)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1214)
at com.novell.zenworks.datamodel.session.hibernate.SessionImpl.flush(SessionImpl.java:389)
at com.novell.zenworks.datamodel.session.hibernate.AbstractHibernateSessionImpl.simpleSave(AbstractHibernateSessionImpl.java:465)
... 63 more
Caused by: java.sql.SQLException: [SAP][JDBC Driver][SQL Anywhere]Spalte 'ZUID' nicht gefunden
at sap.jdbc4.sqlanywhere.IIPreparedStatement.executeUpdate(Native Method)
at sap.jdbc4.sqlanywhere.IPreparedStatement.executeUpdate(IPreparedStatement.java:324)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:410)
at sun.reflect.GeneratedMethodAccessor211.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)
... 77 more
] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException: org.hibernate.exception.SQLGrammarException: (SAP)(JDBC Driver)(SQL Anywhere)Spalte 'ZUID' nicht gefunden] [] [com.novell.zenworks.datamodel.exceptions.InternalDataModelException] [ZENServer]
[DEBUG] [10/25/2018 07:25:11.491] [1904] [ZENServer] [97] [__z_10_51__] [ZCC] [] [Error: An error occurred while creating the folder.] [] [] [] [ZENServer]
Labels (1)
0 Likes
1 Reply
Micro Focus Expert
Micro Focus Expert

Re: Internal Sybase DB maintenance

BACKUP the DB and LOG FILES before doing anything.
If You can Snapshot...Do it.....

now......
I doubt the DB Rebuild will fix your issue....but try skipping that step.....
I'm THINKING it is not required any more....mostly because it's been Forever Since anyone has asked help with that....they used to all the time....

In the Past when that was not set....the symptom was the new DB would be created...but created empty...Doubt it was zero bytes...but clearly not big enough to actually hold your data...
(The Rebuild creates the table in a new folder and does not alter the production DB...so that is safe...)

All that being said...I don't think a rebuild will fix your issue....maybe....
Have you made many folders in the past?
What happens if you use a simple name such as "a".
Any Unusual Folder Names?

I'm TOTALLY GUESSING......That it does not like the new name, perhaps the LAST folder you made it does not really like but let you make it but is now having error reading thru the list of names when adding a new one....maybe there was a recent folder delete, but it did not properly delete but leaving in a state where adding is an issue....

These are total guesses.....Can't say I've seen that error before so the Conjecture level is QUITE high......
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.