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

Oracle Community | Nirav Dedhia | 3 years ago
  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 | 9 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
      tcDataObj.update
      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.tcDataObj.update(Unknown Source)
      17. com.thortech.xl.dataobj.tcDataObj.save(Unknown Source)
      18. com.thortech.xl.dataobj.tcTableDataObj.save(Unknown Source)
      19. com.thortech.xl.dataobj.tcRCE.updateUserRecord(Unknown Source)
      20. com.thortech.xl.dataobj.tcRCE.provisionObject(Unknown Source)
      21. com.thortech.xl.dataobj.tcRCE.linkToUser(Unknown Source)
      22. com.thortech.xl.dataobj.tcRCE.applyActionRules(Unknown Source)
      23. com.thortech.xl.dataobj.tcRCE.checkDataSorted(Unknown Source)
      24. com.thortech.xl.dataobj.tcRCE.eventPostUpdate(Unknown Source)
      25. com.thortech.xl.dataobj.tcDataObj.update(Unknown Source)
      25 frames
    5. 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
    6. org.jboss.jms
      StdServerSession.onMessage
      1. org.jboss.jms.asf.StdServerSession.onMessage(StdServerSession.java:266)
      1 frame
    7. 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
    8. org.jboss.jms
      StdServerSession.run
      1. org.jboss.jms.asf.StdServerSession.run(StdServerSession.java:194)
      1 frame
    9. Dough Lea's util.concurrent package
      PooledExecutor$Worker.run
      1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:761)
      1 frame
    10. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame