com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of database workspacetemplate


Solutions on the web4

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

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

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

Solution icon of xwiki
via XWiki.org JIRA by Manuel Smeria, 1 year ago
Unable to update schema of wiki [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, 1 year ago
Samebug visitor profile picture
Unknown user
2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
72 more bugmates