com.xpn.xwiki.store.migration.DataMigrationException

Unable to update schema of database workspacetemplate


Solutions on the web5

Solution icon of xwiki
via XWiki.org JIRA by Sorin Burjan, 7 months ago
Unable to update schema of database workspacetemplate

Solution icon of xwiki
via XWiki.org JIRA by Sorin Burjan, 11 months ago
Unable to update schema of database xwiki

Solution icon of xwiki
via XWiki.org JIRA by Manuel Smeria, 1 year ago
Unable to update schema of wiki [xwiki]

Solution icon of web
Unable to update schema of wiki [xwiki]

Solution icon of xwiki
via XWiki.org JIRA by Sorin Burjan, 11 months ago
Failed to migrate database [xwiki]...

Stack trace

  • com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of database workspacetemplate at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:180)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsForDatabase(AbstractDataMigrationManager.java:689)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:619)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:343)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:551)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:665)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:840)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:772)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:757)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:290)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1408)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1451)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2183)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2215)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.loadPreferences(XWikiMacrosMappingRenderer.java:107)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.<init>(XWikiMacrosMappingRenderer.java:83)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.render.DefaultXWikiRenderingEngine.<init>(DefaultXWikiRenderingEngine.java:72)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.resetRenderingEngine(XWiki.java:1084)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:791)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.<init>(XWiki.java:739)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:398)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:487)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116)[xwiki-platform-legacy-oldcore-4.5.jar:na] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)[struts-1.2.9.jar:1.2.9] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)[struts-1.2.9.jar:1.2.9] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)[struts-1.2.9.jar:1.2.9] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)[struts-1.2.9.jar:1.2.9] at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)[servlet-api.jar:na] at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)[servlet-api.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)[catalina.jar:7.0.32] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.32] at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120)[xwiki-platform-legacy-oldcore-4.5.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.32] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.32] at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144)[xwiki-platform-wysiwyg-server-4.5.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.32] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.32] at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66)[xwiki-platform-webdav-server-4.5.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.32] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.32] at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)[xwiki-platform-container-servlet-4.5.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.32] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.32] at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)[xwiki-platform-container-servlet-4.5.jar:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)[catalina.jar:7.0.32] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)[catalina.jar:7.0.32] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)[catalina.jar:7.0.32] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)[catalina.jar:7.0.32] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)[catalina.jar:7.0.32] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)[catalina.jar:7.0.32] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)[catalina.jar:7.0.32] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)[catalina.jar:7.0.32] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)[catalina.jar:7.0.32] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)[catalina.jar:7.0.32] at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)[tomcat-coyote.jar:7.0.32] at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)[tomcat-coyote.jar:7.0.32] at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)[tomcat-coyote.jar:7.0.32] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)[na:1.6.0_22] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)[na:1.6.0_22] at java.lang.Thread.run(Thread.java:679)[na:1.6.0_22] Caused by: com.xpn.xwiki.XWikiException: Error number 3005 in 3: Unable to update schema of database workspacetemplate. Wrapped Exception: liquibase.exception.DatabaseException: Error executing SQL SELECT LOCKED FROM DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE: ORA-00942: table or view does not exist at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$4.doInHibernate(HibernateDataMigrationManager.java:294)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1229)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1296)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.liquibaseUpdate(HibernateDataMigrationManager.java:271)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:176)[xwiki-platform-legacy-oldcore-4.5.jar:na] ... 60 more Caused by: liquibase.exception.LockException: liquibase.exception.DatabaseException: Error executing SQL SELECT LOCKED FROM DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE: ORA-00942: table or view does not exist at liquibase.lockservice.LockService.acquireLock(LockService.java:121)[liquibase-core-2.0.3.jar:na] at liquibase.lockservice.LockService.waitForLock(LockService.java:61)[liquibase-core-2.0.3.jar:na] at liquibase.Liquibase.update(Liquibase.java:101)[liquibase-core-2.0.3.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$4.doInHibernate(HibernateDataMigrationManager.java:292)[xwiki-platform-legacy-oldcore-4.5.jar:na] ... 64 more Caused by: liquibase.exception.DatabaseException: Error executing SQL SELECT LOCKED FROM DATABASECHANGELOGLOCK WHERE ID=1 FOR UPDATE: ORA-00942: table or view does not exist at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:142)[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.query(JdbcExecutor.java:150)[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:158)[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:167)[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.queryForObject(JdbcExecutor.java:163)[liquibase-core-2.0.3.jar:na] at liquibase.lockservice.LockService.acquireLock(LockService.java:96)[liquibase-core-2.0.3.jar:na] ... 67 more Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)[ojdbc6.jar:11.2.0.3.0] at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)[commons-dbcp-1.3.jar:1.3] at liquibase.executor.jvm.JdbcExecutor$1QueryStatementCallback.doInStatement(JdbcExecutor.java:128)[liquibase-core-2.0.3.jar:na] at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)[liquibase-core-2.0.3.jar:na] ... 73 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 11 months ago
Samebug visitor profile picture
Unknown user
2 times, 11 months ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
71 more bugmates