java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

Oracle Community | Mr.Rius | 4 years ago
  1. 0

    Error OIM Impor the new User Metadata

    Oracle Community | 4 years ago | Mr.Rius
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  2. 0

    [OIM 11g] DBAT connector

    Oracle Community | 5 years ago | User12295533-Oracle
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  3. 0

    OIM Connector Installation Error. Cluster

    Oracle Community | 4 years ago | vicky
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Steps to reproduce: * setup a 2.7.2 XE (but I'm almost sure you can use a 4.0 too) * import the 2.7.2 XAR * setup a 4.1 RC-1 * start the instance. you will get a stacktrace when you access the wiki. I see something related to activity stream plugin. {code} Starting Jetty on port 8080 ... Logs are in the ./xwiki.log file 2012-06-13 17:45:17,864 [http://localhost:8080/xwiki/bin/view/Main/WebHome] INFO .HibernateDataMigrationManager - Running storage schema updates and migrations 2012-06-13 17:45:17,872 [http://localhost:8080/xwiki/bin/view/Main/WebHome] INFO .HibernateDataMigrationManager - No storage migration required since current version is [40001] 2012-06-13 17:45:22,398 [http://localhost:8080/xwiki/bin/view/Main/WebHome] ERROR .x.x.s.XWikiHibernateBaseStore - Failed updating schema while executing query [alter table xwiki.activitystream_events add ase_hidden number(1,0) default false not null] java.sql.SQLSyntaxErrorException: ORA-00984: column not allowed here 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.executeForRows(T4CStatement.java:1033) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1838) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1803) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294) ~[ojdbc6.jar:11.2.0.3.0] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) ~[commons-dbcp-1.3.jar:1.3] at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:527) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:344) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:176) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsForDatabase(AbstractDataMigrationManager.java:545) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:493) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:296) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:421) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.setDatabase(XWikiHibernateBaseStore.java:666) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:813) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:746) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:736) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:290) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1439) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1482) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2216) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.getXWikiPreference(XWiki.java:2248) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.loadPreferences(XWikiMacrosMappingRenderer.java:107) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.render.XWikiMacrosMappingRenderer.<init>(XWikiMacrosMappingRenderer.java:83) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.render.DefaultXWikiRenderingEngine.<init>(DefaultXWikiRenderingEngine.java:72) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.resetRenderingEngine(XWiki.java:1115) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:790) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.<init>(XWiki.java:738) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:399) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:486) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) [xwiki-platform-legacy-oldcore-4.1-rc-1.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:707) [servlet-api-2.5.jar:2.5] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [servlet-api-2.5.jar:2.5] at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1352) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) [xwiki-platform-wysiwyg-server-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) [xwiki-platform-webdav-server-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) [xwiki-platform-container-servlet-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) [xwiki-platform-container-servlet-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:476) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517) [jetty-security-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.Server.handle(Server.java:346) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1048) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601) [jetty-http-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214) [jetty-http-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535) [jetty-io-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) [jetty-io-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529) [jetty-util-7.4.5.v20110725.jar:7.4.5.v20110725] at java.lang.Thread.run(Thread.java:679) [na:1.6.0_22] 2012-06-13 17:45:25,746 [http://localhost:8080/xwiki/bin/view/Main/WebHome] WARN o.h.u.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000 2012-06-13 17:45:25,747 [http://localhost:8080/xwiki/bin/view/Main/WebHome] ERROR o.h.u.JDBCExceptionReporter - ORA-00904: "ASE_HIDDEN": invalid identifier 2012-06-13 17:45:25,749 [http://localhost:8080/xwiki/bin/view/Main/WebHome] ERROR .o.i.DefaultObservationManager - Failed to send event [org.xwiki.bridge.event.DocumentUpdatedEvent@da8afd11] to listener [com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamImpl@19f9f8e] org.hibernate.HibernateException: Failed to commit or rollback transaction. Root cause [] at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:924) ~[xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamImpl.addActivityEvent(ActivityStreamImpl.java:316) ~[xwiki-platform-activitystream-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamImpl.addDocumentActivityEvent(ActivityStreamImpl.java:401) ~[xwiki-platform-activitystream-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamImpl.addDocumentActivityEvent(ActivityStreamImpl.java:378) ~[xwiki-platform-activitystream-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.activitystream.impl.ActivityStreamImpl.onEvent(ActivityStreamImpl.java:904) ~[xwiki-platform-activitystream-4.1-rc-1.jar:na] at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:261) [xwiki-commons-observation-local-4.1-rc-1.jar:na] at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:226) [xwiki-commons-observation-local-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.saveDocument(XWiki.java:1415) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.watchlist.WatchListStore.initWatchListClass(WatchListStore.java:283) [xwiki-platform-watchlist-api-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.watchlist.WatchListStore.init(WatchListStore.java:336) [xwiki-platform-watchlist-api-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.watchlist.WatchListPlugin.init(WatchListPlugin.java:115) [xwiki-platform-watchlist-api-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.initPlugin(XWikiPluginManager.java:152) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugin(XWikiPluginManager.java:88) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.plugin.XWikiPluginManager.addPlugins(XWikiPluginManager.java:116) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.preparePlugins(XWiki.java:1123) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:793) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.<init>(XWiki.java:738) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.getMainXWiki(XWiki.java:399) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.XWiki.getXWiki(XWiki.java:486) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:136) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:116) [xwiki-platform-legacy-oldcore-4.1-rc-1.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:707) [servlet-api-2.5.jar:2.5] at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) [servlet-api-2.5.jar:2.5] at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1352) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:120) [xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.xwiki.wysiwyg.server.filter.ConversionFilter.doFilter(ConversionFilter.java:144) [xwiki-platform-wysiwyg-server-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at com.xpn.xwiki.plugin.webdav.XWikiDavFilter.doFilter(XWikiDavFilter.java:66) [xwiki-platform-webdav-server-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208) [xwiki-platform-container-servlet-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111) [xwiki-platform-container-servlet-4.1-rc-1.jar:na] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1323) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:476) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:517) [jetty-security-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) [jetty-servlet-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.Server.handle(Server.java:346) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1048) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601) [jetty-http-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214) [jetty-http-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411) [jetty-server-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535) [jetty-io-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40) [jetty-io-7.4.5.v20110725.jar:7.4.5.v20110725] at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529) [jetty-util-7.4.5.v20110725.jar:7.4.5.v20110725] at java.lang.Thread.run(Thread.java:679) [na:1.6.0_22] Caused by: org.hibernate.exception.SQLGrammarException: could not insert: [com.xpn.xwiki.plugin.activitystream.impl.ActivityEventImpl] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2454) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at com.xpn.xwiki.store.XWikiHibernateBaseStore.endTransaction(XWikiHibernateBaseStore.java:917) ~[xwiki-platform-legacy-oldcore-4.1-rc-1.jar:na] ... 60 common frames omitted Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "ASE_HIDDEN": invalid identifier 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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1044) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3665) ~[ojdbc6.jar:11.2.0.3.0] at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1352) ~[ojdbc6.jar:11.2.0.3.0] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) ~[commons-dbcp-1.3.jar:1.3] at org.hibernate.jdbc.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:46) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2434) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] ... 71 common frames omitted 2012-06-13 17:45:26,403 [http://localhost:8080/xwiki/bin/view/Main/WebHome] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.XWiki.getXMLEncoded] in xwiki:Main.WebHome@2,42 2012-06-13 17:45:27,404 [http://localhost:8080/xwiki/bin/view/Main/WebHome] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.Util.getHashMap] in unknown namespace@33,30 2012-06-13 17:45:27,594 [http://localhost:8080/xwiki/bin/view/Main/WebHome] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method [com.xpn.xwiki.api.Util.parseInt] in unknown namespace@50,25 2012-06-13 17:45:27,608 [http://localhost:8080/xwiki/bin/view/Main/WebHome] WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of getter [com.xpn.xwiki.api.Util.getArrayList] in unknown namespace@656,34 2012-06-13 17:45:27,690 [http://localhost:8080/xwiki/bin/view/Main/WebHome] WARN o.h.u.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000 2012-06-13 17:45:27,690 [http://localhost:8080/xwiki/bin/view/Main/WebHome] ERROR o.h.u.JDBCExceptionReporter - ORA-00904: "ACTIVITYEV0_"."ASE_HIDDEN": invalid identifier 2012-06-13 17:45:27,695 [http://localhost:8080/xwiki/bin/view/Main/WebHome] ERROR o.x.v.i.DefaultVelocityEngine - Exception in macro #displayActivity called at unknown namespace[line 2, column 1] {code}

    XWiki.org JIRA | 4 years ago | Sorin Burjan
    java.sql.SQLSyntaxErrorException: ORA-00984: column not allowed here
  6. 0

    Why did transaction rollback during stage3CommitProcessing?

    Stack Overflow | 5 years ago | Kingsly
    org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [LOCK TABLE T1 IN EXCLUSIVE MODE]; nested exception is java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock</p> <pre><code>at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:94)

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      ORA-00904: : invalid identifier

      at oracle.jdbc.driver.T4CTTIoer.processError()
    2. Oracle jdbc
      OracleStatementWrapper.executeUpdate
      1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
      4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
      5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
      6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
      7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
      8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1074)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1466)
      10. oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:2123)
      11. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:2067)
      12. oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:306)
      12 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor650.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    4. oracle.ucp.jdbc
      StatementProxyFactory.invoke
      1. oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:230)
      1 frame
    5. Unknown
      $Proxy330.executeUpdate
      1. $Proxy330.executeUpdate(Unknown Source)
      1 frame
    6. com.thortech.xl
      tcDataBase.writeStatement
      1. com.thortech.xl.util.JDBCUtils.executeUpdate(JDBCUtils.java:186)
      2. com.thortech.xl.dataaccess.tcDataBase.writeStatement(tcDataBase.java:465)
      2 frames