java.sql.SQLException: ORA-00936: missing expression

Oracle Community | Nirav Dedhia | 3 years 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

    Updating user organisation through flat file recon error

    Oracle Community | 3 years ago | Nirav Dedhia
    java.sql.SQLException: ORA-00936: missing expression
  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-00936: missing expression

      at oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OracleStatement.executeQuery
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
      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:754)
      5. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
      6. oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:804)
      7. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1051)
      8. oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:845)
      9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1156)
      10. oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1315)
      10 frames
    3. JBoss Application Server Connector
      WrappedStatement.executeQuery
      1. org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:226)
      1 frame
    4. com.thortech.xl
      ReconMessageHandlerMDB.onMessage
      1. com.thortech.xl.util.JDBCUtils.executeQuery(Unknown Source)
      2. com.thortech.xl.dataaccess.tcDataBase.readPartialStatement(Unknown Source)
      3. com.thortech.xl.dataobj.tcDataBase.readPartialStatement(Unknown Source)
      4. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
      5. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
      6. com.thortech.xl.dataaccess.tcDataSet.executeQuery(Unknown Source)
      7. com.thortech.xl.dataobj.tcDataSet.executeQuery(Unknown Source)
      8. com.thortech.xl.dataobj.tcORC.setOrcTosInstanceKeyFromMap(Unknown Source)
      9. com.thortech.xl.dataobj.tcORC.eventPreInsert(Unknown Source)
      10. com.thortech.xl.dataobj.tcDataObj.insert(Unknown Source)
      11. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
      12. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
      13. com.thortech.xl.dataobj.tcUSR.moveUserOrcs(Unknown Source)
      14. com.thortech.xl.dataobj.tcUSR.postUpdateMoveUserFunction(Unknown Source)
      15. com.thortech.xl.dataobj.tcUSR.eventPostUpdate(Unknown Source)
      16. com.thortech.xl.dataobj.tcUSR.postUpdateMoveUserFunction(Unknown Source)
      17. com.thortech.xl.dataobj.tcUSR.eventPostUpdate(Unknown Source)
      18. com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
      19. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
      20. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
      21. com.thortech.xl.dataobj.tcRCE.updateUserRecord(Unknown Source)
      22. com.thortech.xl.dataobj.tcRCE.provisionObject(Unknown Source)
      23. com.thortech.xl.dataobj.tcRCE.linkToUser(Unknown Source)
      24. com.thortech.xl.dataobj.tcRCE.applyActionRules(Unknown Source)
      25. com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)
      26. com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
      27. com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
      28. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
      29. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
      30. com.thortech.xl.dataobj.tcRCE.finishDataReceived(Unknown Source)
      31. com.thortech.xl.schedule.jms.reconOffline.ProcessOfflineReconMessages.finishReconciliationEvent(Unknown Source)
      32. com.thortech.xl.schedule.jms.reconOffline.ProcessOfflineReconMessages.execute(Unknown Source)
      33. com.thortech.xl.schedule.jms.messagehandler.MessageProcessUtil.processMessage(Unknown Source)
      34. com.thortech.xl.schedule.jms.messagehandler.ReconMessageHandlerMDB.onMessage(Unknown Source)
      34 frames
    5. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      3. java.lang.reflect.Method.invoke(Method.java:597)
      3 frames
    6. JBoss Application Server Server
      MessageDrivenContainer$ContainerInterceptor.invoke
      1. org.jboss.invocation.Invocation.performCall(Invocation.java:359)
      2. org.jboss.ejb.MessageDrivenContainer$ContainerInterceptor.invoke(MessageDrivenContainer.java:495)
      2 frames
    7. JBoss Application Server Connector
      CachedConnectionInterceptor.invoke
      1. org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)
      1 frame
    8. JBoss Application Server Server
      JMSContainerInvoker$MessageListenerImpl.onMessage
      1. org.jboss.ejb.plugins.MessageDrivenInstanceInterceptor.invoke(MessageDrivenInstanceInterceptor.java:116)
      2. org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)
      3. org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)
      4. org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)
      5. org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
      6. org.jboss.ejb.plugins.RunAsSecurityInterceptor.invoke(RunAsSecurityInterceptor.java:109)
      7. org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
      8. org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
      9. org.jboss.ejb.MessageDrivenContainer.internalInvoke(MessageDrivenContainer.java:402)
      10. org.jboss.ejb.Container.invoke(Container.java:960)
      11. org.jboss.ejb.plugins.jms.JMSContainerInvoker.invoke(JMSContainerInvoker.java:1092)
      12. org.jboss.ejb.plugins.jms.JMSContainerInvoker$MessageListenerImpl.onMessage(JMSContainerInvoker.java:1392)
      12 frames
    9. org.jboss.jms
      StdServerSession.onMessage
      1. org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:266)
      1 frame
    10. JBossMQ
      SpySession.run
      1. org.jboss.mq.SpyMessageConsumer.sessionConsumerProcessMessage(SpyMessageConsumer.java:906)
      2. org.jboss.mq.SpyMessageConsumer.addMessage(SpyMessageConsumer.java:170)
      3. org.jboss.mq.SpySession.run(SpySession.java:323)
      3 frames
    11. org.jboss.jms
      StdServerSession.run
      1. org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
      1 frame
    12. Dough Lea's util.concurrent package
      PooledExecutor$Worker.run
      1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
      1 frame