Re: [xwiki-users] Exceptions when initializing an empty db

Hi there, I'm trying to install a new version of xwiki enterprise manager (4.4). E set up an emtpy user in my oracle 10g xe with dba role. There the database user should have no problems to create tables or anyting else. When I start xwiki I get a long chain of exceptions in the browser and in the logs. It seams to me, that xwiki tries to update the Version number in the db before creating the requiered table for it. (loadXWikiDoc-> initializeEmptyDB-> setDBVersionToDatabase-> "Table or View does not exist") I tried with the "xwiki.store.migration" flag in xwiki.cfg on/off with the same result. I carefully read the installion documentation but I did not find any hint how to initialize a new database schema. Could you please help me out? I would appriciate any help. Thank you, Matthias Here's the root exception. java.sql.SQLSyntaxErrorException: ORA-00942: Table or View does not exist oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:20 5) oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement. java:1008) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java :1307) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedSta tement.java:3449) oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedState ment.java:3530) oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePrepar edStatementWrapper.java:1350) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating PreparedStatement.java:105) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating PreparedStatement.java:105) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(Delegating PreparedStatement.java:105) org.hibernate.hql.ast.exec.BasicExecutor.execute(BasicExecutor.java:101) org.hibernate.hql.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl. java:423) org.hibernate.engine.query.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.ja va:283) org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:1288) org.hibernate.impl.QueryImpl.executeUpdate(QueryImpl.java:117) com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$3.doIn Hibernate(HibernateDataMigrationManager.java:161) com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore. java:1229) com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseS tore.java:1315) com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.setDBV ersionToDatabase(HibernateDataMigrationManager.java:156) com.xpn.xwiki.store.migration.AbstractDataMigrationManager.setDBVersion(Abst ractDataMigrationManager.java:365) com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.initia lizeEmptyDB(HibernateDataMigrationManager.java:141) com.xpn.xwiki.store.migration.AbstractDataMigrationManager.initNewDB(Abstrac tDataMigrationManager.java:341) com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(Abs tractDataMigrationManager.java:401) com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseSt ore.java:665) com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateB aseStore.java:840) com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateB aseStore.java:772) com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.jav a:750) com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:290) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1404) com.xpn.xwiki.XWiki.getDocument(XWiki.java:1447) com.xpn.xwiki.XWiki.initializeMandatoryClasses(XWiki.java:824) com.xpn.xwiki.XWiki.initXWiki(XWiki.java:794) com.xpn.xwiki.XWiki.<init>(XWiki.java:735) com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:394) com.xpn.xwiki.XWiki.getXWiki(XWiki.java:483) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces sor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.j ava:144) com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFi lter(SavedRequestRestorerFilter.java:208) org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFi lter(SetCharacterEncodingFilter.java:111) _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users