org.xwiki.query.QueryException: Exception while execute query. Query statement = [ select distinct doc.space , doc.name from XWikiDocument as doc , BaseObject as translation WHERE 1=1 and doc.fullName=translation.name and translation.className='XWiki.TranslationDocumentClass' ]


Solutions on the web

Solution icon of xwiki
via XWiki.org JIRA by Sorin Burjan, 9 months ago
Exception while execute query. Query statement = [ select distinct doc.space , doc.name from XWikiDocument as doc , BaseObject as translation WHERE 1=1 and doc.fullName=translation.name and translation.className='XWiki.TranslationDocumentClass' ]

Solution icon of xwiki
via XWiki.org JIRA by Johannes Stoldt, 1 year ago
Exception while execute query. Query statement = [from VisitStats as obj where obj.cookie=:fieldValue and obj.endDate > :date order by obj.endDate desc]

Solution icon of xwiki
via XWiki.org JIRA by Rudolf Tronicek, 1 year ago
Exception while execute query. Query statement = [from VisitStats as obj where obj.cookie=:fieldValue and obj.endDate > :date order by obj.endDate desc]

Stack trace

org.xwiki.query.QueryException: Exception while execute query. Query statement = [ select distinct doc.space , doc.name from XWikiDocument as doc , BaseObject as translation WHERE 1=1  and doc.fullName=translation.name and translation.className='XWiki.TranslationDocumentClass' ]
	at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:115)[xwiki-platform-legacy-oldcore-4.5.jar:na]
	at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:68)[xwiki-platform-query-manager-4.5.jar:na]
	at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:248)[xwiki-platform-query-manager-4.5.jar:na]
	at org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:97)[xwiki-platform-query-xwql-4.5.jar:na]
	at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:68)[xwiki-platform-query-manager-4.5.jar:na]
	at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:248)[xwiki-platform-query-manager-4.5.jar:na]
	at org.xwiki.localization.wiki.internal.DocumentTranslationBundleFactory.loadTranslations(DocumentTranslationBundleFactory.java:226)[xwiki-platform-localization-source-wiki-4.5.jar:na]
	at org.xwiki.localization.wiki.internal.DocumentTranslationBundleFactory.initialize(DocumentTranslationBundleFactory.java:209)[xwiki-platform-localization-source-wiki-4.5.jar:na]
	at org.xwiki.component.embed.InitializableLifecycleHandler.handle(InitializableLifecycleHandler.java:39)[xwiki-commons-legacy-component-default-4.5.jar:na]
	at org.xwiki.component.embed.EmbeddableComponentManager.createInstance(EmbeddableComponentManager.java:323)[xwiki-commons-legacy-component-default-4.5.jar:na]
	at org.xwiki.component.embed.EmbeddableComponentManager.getComponentInstance(EmbeddableComponentManager.java:378)[xwiki-commons-legacy-component-default-4.5.jar:na]
	at org.xwiki.component.embed.EmbeddableComponentManager.getComponentInstance(EmbeddableComponentManager.java:346)[xwiki-commons-legacy-component-default-4.5.jar:na]
	at org.xwiki.component.embed.EmbeddableComponentManager.getInstance(EmbeddableComponentManager.java:161)[xwiki-commons-legacy-component-default-4.5.jar:na]
	at org.xwiki.component.embed.GenericProvider.get(GenericProvider.java:99)[xwiki-commons-legacy-component-default-4.5.jar:na]
	at org.xwiki.localization.wiki.internal.DocumentTranslationBundleInitializer.onEvent(DocumentTranslationBundleInitializer.java:89)[xwiki-platform-localization-source-wiki-4.5.jar:na]
	at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:261)[xwiki-commons-observation-local-4.5.jar:na]
	at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:226)[xwiki-commons-observation-local-4.5.jar:na]
	at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:408)[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:740)[xwiki-platform-legacy-oldcore-4.5.jar:na]
	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1228)[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.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:96)[xwiki-platform-legacy-oldcore-4.5.jar:na]
	... 57 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]
	... 62 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]
	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]
	... 40 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

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