com.xpn.xwiki.XWikiException

Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name from XWikiDocument as doc , BaseObject as obj, StringProperty as prop, BaseObject as userobj where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.value=? and doc.fullName=userobj.name and userobj.className=?] Wrapped Exception: Error number 3301 in 3: Exception while switching to database workspacetemplate Wrapped Exception: Migration of database [workspacetemplate] has failed, it could not be safely used! Database is currently in version [35102] while the required version is [43000].

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web625

  • via Unknown by Sorin Burjan,
  • via Unknown by Carlos Lopez,
  • via Unknown by kunal mahale,
  • Stack trace

    • com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL [select distinct doc.space, doc.name from XWikiDocument as doc , BaseObject as obj, StringProperty as prop, BaseObject as userobj where doc.fullName=obj.name and obj.className=? and obj.id=prop.id.id and prop.value=? and doc.fullName=userobj.name and userobj.className=?] Wrapped Exception: Error number 3301 in 3: Exception while switching to database workspacetemplate Wrapped Exception: Migration of database [workspacetemplate] has failed, it could not be safely used! Database is currently in version [35102] while the required version is [43000]. at com.xpn.xwiki.store.XWikiHibernateStore.searchGenericInternal(XWikiHibernateStore.java:2382)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentReferencesInternal(XWikiHibernateStore.java:2338)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNamesInternal(XWikiHibernateStore.java:2325)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.searchDocumentsNames(XWikiHibernateStore.java:2088)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiCacheStore.searchDocumentsNames(XWikiCacheStore.java:385)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.plugin.watchlist.WatchListStore.globalSearchDocuments(WatchListStore.java:624)[xwiki-platform-watchlist-api-4.5.jar:na] at com.xpn.xwiki.plugin.watchlist.WatchListStore.initSubscribersCache(WatchListStore.java:301)[xwiki-platform-watchlist-api-4.5.jar:na] at com.xpn.xwiki.plugin.watchlist.WatchListStore.init(WatchListStore.java:339)[xwiki-platform-watchlist-api-4.5.jar:na] at com.xpn.xwiki.plugin.watchlist.WatchListPlugin.init(WatchListPlugin.java:115)[xwiki-platform-watchlist-api-4.5.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:152)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:88)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:116)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:1092)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:794)[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 3301 in 3: Exception while switching to database workspacetemplate Wrapped Exception: Migration of database [workspacetemplate] has failed, it could not be safely used! Database is currently in version [35102] while the required version is [43000]. at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:669)[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:755)[xwiki-platform-legacy-oldcore-4.5.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.searchGenericInternal(XWikiHibernateStore.java:2363)[xwiki-platform-legacy-oldcore-4.5.jar:na] ... 55 more Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Migration of database [workspacetemplate] has failed, it could not be safely used! Database is currently in version [35102] while the required version is [43000]. at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:576)[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] ... 58 more Caused by: 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] ... 42 more 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

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitor2 times, last one
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    71 more bugmates