java.sql.SQLException: ORA-00923: Schlüsselwort FROM nicht an erwarteter Stelle gefunden

pentaho.com | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Drill Through SQLException: ORA-00923 [Archive] - Pentaho Community Forums

    pentaho.com | 9 months ago
    java.sql.SQLException: ORA-00923: Schlüsselwort FROM nicht an erwarteter Stelle gefunden
  2. Speed up your debug routine!

    Automated exception search integrated into your IDE

  3. 0

    {code:xml} <log4j:event logger="org.dcm4chex.archive.ejb.jdbc.BaseCmd" timestamp="1184784717500" level="WARN" thread="TCPServer-2-2"> <log4j:message><![CDATA[failed to execute sql: SELECT DISTINCT hp.hp_attrs FROM hp, hpdef WHERE hp.pk = hpdef.hp_fk(+) - retry: 1 of 20]]></log4j:message> <log4j:throwable><![CDATA[java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got BLOB at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1264) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at org.dcm4chex.archive.ejb.jdbc.BaseReadCmd.execute(BaseReadCmd.java:85) at org.dcm4chex.archive.ejb.jdbc.HPQueryCmd.execute(HPQueryCmd.java:191) at org.dcm4chex.archive.dcm.hpscp.HPFindScp.doCFind(HPFindScp.java:83) at org.dcm4che.net.DcmServiceBase.c_find(DcmServiceBase.java:152) at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:225) at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174) at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:148) at org.dcm4cheri.server.DcmHandlerImpl.handle(DcmHandlerImpl.java:249) at org.dcm4cheri.server.ServerImpl.run(ServerImpl.java:263) at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174) at org.dcm4cheri.util.LF_ThreadPool$1.run(LF_ThreadPool.java:221) at java.lang.Thread.run(Thread.java:595) ]]></log4j:throwable> <log4j:properties> <log4j:data name="called" value="DCM4CHEE"/> <log4j:data name="calling" value="hgreens"/> <log4j:data name="ip" value="10.237.225.235"/> </log4j:properties> </log4j:event> {code} Cause: Oracle does not support using DISTINCT with a blob data type! Solution: Refactor Left Join to sub-query as done for Composite Object Query [DCMEE-375]

    JIRA | 10 years ago | Tim Collins
    java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got BLOB
  4. 0

    LineChart_Data.xaction does not work with Oracle. The query in the xaction refers to a function called Quarter and Year which Oracle doesn't support. ChartSamplesDashboard uses linechart_data.xaction. Below is the stack trace from execution of linechart_data.xaction java.sql.SQLException: ORA-00904: "QUARTER": invalid identifier at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207) at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:801) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039) at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:841) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134) at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4055) at oracle.jdbc.driver.OracleStatement.doScrollStmtExecuteQuery(OracleStatement.java:4195) at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1281) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:171) at org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:282) at org.pentaho.data.connection.sql.SQLConnection.executeQuery(SQLConnection.java:253) at org.pentaho.plugin.sql.SQLBaseComponent.doQuery(SQLBaseComponent.java:589) at org.pentaho.plugin.sql.SQLBaseComponent.runQuery(SQLBaseComponent.java:530) at org.pentaho.plugin.sql.SQLBaseComponent.executeAction(SQLBaseComponent.java:234) at org.pentaho.plugin.ComponentBase.execute(ComponentBase.java:459) at org.pentaho.core.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1139) at org.pentaho.core.runtime.RuntimeContext.executeAction(RuntimeContext.java:1111) at org.pentaho.core.runtime.RuntimeContext.performActions(RuntimeContext.java:1023) at org.pentaho.core.runtime.RuntimeContext.executeLoop(RuntimeContext.java:978) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:881) at org.pentaho.core.runtime.RuntimeContext.executeSequence(RuntimeContext.java:780) at org.pentaho.core.solution.SolutionEngine.executeInternal(SolutionEngine.java:333) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:241) at org.pentaho.core.solution.SolutionEngine.execute(SolutionEngine.java:169) at org.pentaho.core.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:150) at org.pentaho.ui.servlet.ViewAction.handleActionRequest(ViewAction.java:139) at org.pentaho.ui.servlet.ViewAction.doGet(ViewAction.java:261) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:124) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:341) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at com.pentaho.security.SecurityStartupFilter.doFilter(SecurityStartupFilter.java:76) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.rememberme.RememberMeProcessingFilter.doFilter(RememberMeProcessingFilter.java:142) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at com.pentaho.security.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:164) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:174) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:271) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.ui.logout.LogoutFilter.doFilter(LogoutFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at com.pentaho.security.HttpSessionReuseDetectionFilter.doFilter(HttpSessionReuseDetectionFilter.java:130) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:249) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.wrapper.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:81) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:275) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:149) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:98) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:241) at org.apache.coyote.http11.Http11Processor.process(Htt 13:41:38,187 INFO [STDOUT] p11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:580) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Unknown Source)

    Pentaho BI Platform Tracking | 9 years ago | Ravi Hasija
    java.sql.SQLException: ORA-00904: "QUARTER": invalid identifier

    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.SQLException

      ORA-00923: Schlüsselwort FROM nicht an erwarteter Stelle gefunden

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
      6. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
      8. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
      10. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
      10 frames
    3. JBoss Application Server Connector
      WrappedStatement.executeQuery
      1. org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:169)
      1 frame
    4. com.tonbeller.jpivot
      MondrianDrillThroughTableModel.getColumnCount
      1. com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel.executeQuery(MondrianDrillThroughTableModel.java:163)
      2. com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel.getColumnCount(MondrianDrillThroughTableModel.java:113)
      2 frames
    5. com.tonbeller.wcf
      EditableTableComponent.setModel
      1. com.tonbeller.wcf.table.TableComponent.setModel(TableComponent.java:224)
      2. com.tonbeller.wcf.table.EditableTableComponent.setModel(EditableTableComponent.java:235)
      2 frames
    6. com.tonbeller.jpivot
      DrillThroughUI$DrillThroughHandler.request
      1. com.tonbeller.jpivot.table.navi.DrillThroughUI$DrillThroughHandler.request(DrillThroughUI.java:123)
      1 frame
    7. com.tonbeller.wcf
      ComponentSupport.request
      1. com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)
      2. com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)
      3. com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:104)
      3 frames
    8. com.tonbeller.jpivot
      TableComponent.request
      1. com.tonbeller.jpivot.table.TableComponent.request(TableComponent.java:180)
      1 frame
    9. com.tonbeller.wcf
      RequestFilter.doFilter
      1. com.tonbeller.wcf.controller.WcfController.request(WcfController.java:71)
      2. com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:119)
      3. com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
      4. com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
      4 frames
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    11. org.pentaho.core
      SystemStatusFilter.doFilter
      1. org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
      1 frame
    12. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    13. org.pentaho.ui
      SetCharacterEncodingFilter.doFilter
      1. org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
      1 frame
    14. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    15. JBoss Application Server Tomcat
      ReplyHeaderFilter.doFilter
      1. org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
      1 frame
    16. Glassfish Core
      StandardContextValve.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      4 frames
    17. JBoss Application Server Tomcat
      SecurityAssociationValve.invoke
      1. org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
      1 frame
    18. Glassfish Core
      AuthenticatorBase.invoke
      1. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
      1 frame
    19. JBoss Application Server Tomcat
      JaccContextValve.invoke
      1. org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
      1 frame
    20. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      4 frames
    21. Grizzly HTTP
      MasterSlaveWorkerThread.run
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
      2. org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      4. org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      4 frames
    22. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame