Hello,

I am trying to install ZCM (production release), with the database on
a
remote SQL server without success. ZCM is being installed on a VMWare

windows 2003 SP2 server.

Every time the problem is the same. The Zen database gets created on
the
SQL server, as well as the Zenadmin user, but nothing else. I have
tried
to use domain and sql authentication on various attempt but the result
is
always the same, at the end of the installation the installation log
shows
the 2 error messages below. As you can see it seems to point to a sql

syntax error...

Thanks for any assistance you can provide.
Frank.



Unable to create DB tables: Line 19: Incorrect syntax near ';'.

ConfigureAction failed!:
com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: org.hibernate.exception.SQLGrammarException: could not insert:
[com.novell.zenworks.datamodel.objects.zone.Zone] at
com.novell.zenworks.datamodel.temp.ZoneCreator.cre ateZone(ZoneCreator.java:128)

at
com.novell.zenworks.datamodel.utils.hibernate.Zone Creator.doWork(ZoneCreator.java:191)

at
com.novell.zenworks.datamodel.utils.hibernate.Zone Creator.main(ZoneCreator.java:529)

Caused by:
com.novell.zenworks.datamodel.exceptions.InternalD ataModelException: org.hibernate.exception.SQLGrammarException: could not insert:
[com.novell.zenworks.datamodel.objects.zone.Zone] at
com.novell.zenworks.datamodel.utils.hibernate.Abst ractDatabaseTypeHelper.newStandardDataModelExcepti on(AbstractDatabaseTypeHelper.java:298)

at
com.novell.zenworks.datamodel.utils.hibernate.Abst ractDatabaseTypeHelper.throwStandardDataModelExcep tion(AbstractDatabaseTypeHelper.java:287)

at
com.novell.zenworks.datamodel.session.hibernate.Ab stractHibernateSessionImpl.handleException(Abstrac tHibernateSessionImpl.java:175)

at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.createDefaultFolder(Hiberna teAbstractSession.java:583)

at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.createDefaultFolders(Hibern ateAbstractSession.java:492)

at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession._postPasswordValidationInit ialize(HibernateAbstractSession.java:332)

at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateAdministratorSession._postPasswordValidatio nInitialize(HibernateAdministratorSession.java:85)

at
com.novell.zenworks.datamodel.session.hibernate.Hi bernateAbstractSession.loginAsSystem(HibernateAbst ractSession.java:317)

at
com.novell.zenworks.datamodel.services.DirectServi ceStoreImpl.loginAsSystem(DirectServiceStoreImpl.j ava:160)

at
com.novell.zenworks.datamodel.temp.ZoneCreator.get ServiceStore(ZoneCreator.java:174)

at
com.novell.zenworks.datamodel.temp.ZoneCreator.cre ateZone(ZoneCreator.java:95)

... 2 more Caused by: org.hibernate.exception.SQLGrammarException:
could
not insert: [com.novell.zenworks.datamodel.objects.zone.Zone] at
org.hibernate.exception.SQLStateConverter.convert( SQLStateConverter.java:67)

at
org.hibernate.exception.JDBCExceptionHelper.conver t(JDBCExceptionHelper.java:43)

at
org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2140)

at
org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2503)

at
org.hibernate.action.EntityInsertAction.execute(En tityInsertAction.java:51)

at org.hibernate.engine.ActionQueue.execute(ActionQue ue.java:248) at org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:232)
at
org.hibernate.engine.ActionQueue.executeActions(Ac tionQueue.java:139)
at
org.hibernate.event.def.AbstractFlushingEventListe ner.performExecutions(AbstractFlushingEventListene r.java:297)

at
org.hibernate.event.def.DefaultAutoFlushEventListe ner.onAutoFlush(DefaultAutoFlushEventListener.java :41)

at
org.hibernate.impl.SessionImpl.autoFlushIfRequired (SessionImpl.java:957)

at org.hibernate.impl.SessionImpl.list(SessionImpl.ja va:1102) 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.Hi bernateAbstractSession.createDefaultFolder(Hiberna teAbstractSession.java:552)

... 9 more Caused by: java.sql.SQLException: Invalid object name
'zZENObject'. at
net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnos tic(SQLDiagnostic.java:365)

at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(Td sCore.java:2781)
at
net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCor e.java:2224) at
net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(T dsCore.java:628) at

net.sourceforge.jtds.jdbc.JtdsStatement.processRes ults(JtdsStatement.java:525)

at
net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL (JtdsStatement.java:487)

at
net.sourceforge.jtds.jdbc.JtdsPreparedStatement.ex ecuteUpdate(JtdsPreparedStatement.java:421)

at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement .executeUpdate(NewProxyPreparedStatement.java:105)

at
org.hibernate.jdbc.NonBatchingBatcher.addToBatch(N onBatchingBatcher.java:23)

at
org.hibernate.persister.entity.AbstractEntityPersi ster.insert(AbstractEntityPersister.java:2120)

... 21 more