[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)
Hi Matthias, I need more of your logs to better understand your issue. You may send it to me privately and will try to help. Regards, On Sun, Jan 6, 2013 at 3:08 PM, Matthias Ludwig <[email protected]>wrote:
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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Denis Gervalle SOFTEC sa - CEO eGuilde sarl - CTO
participants (2)
-
Denis Gervalle -
Matthias Ludwig