Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Drill Through SQLException: ORA-00923

  1. #1
    Join Date
    Apr 2007
    Posts
    21

    Question Drill Through SQLException: ORA-00923

    Hi,

    I get an Exception when I want to drill through a pivot table.
    I'm using Oracle Express 10g and Pentaho BI Server 1.6.0-RC1.

    Drill Through Table
    An error occured
    java.sql.SQLException: ORA-00923: Schlüsselwort FROM nicht an erwarteter Stelle gefunden
    (means FROM keyword not found where expected)

    I modified the trace level in mondrian.properties, but don't see any sql statement. Is this a problem with oracle-sql-dialect?

    Can anyone help me?

    Thanks!
    Jan
    Last edited by mec_muc; 11-01-2007 at 04:08 PM.

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    You need to set 'mondrian.trace.level=1' in mondrian.properties. If it's not working, your mondrian.properties file is probably in the wrong place; or your appserver/webserver is writing the output to a logfile somewhere. When you find the SQL statement, please post it.

    Julian

  3. #3
    Join Date
    Apr 2007
    Posts
    21

    Post i don't find it...

    Thank you for your answer, but I don't find the statement.
    I use the pentaho-demo (for mysql).
    The trace level is set to 1 (mondrian.trace.level=1 in pentaho-demo\pentaho-solutions\system\mondrian\mondrian.properties)

    I looked for the logs in server.log (pentaho-demo\jboss\server\default\log\server.log).

    Or is there another logfile?

    But I only see the exception:
    2007-11-02 09:10:04,375 ERROR [STDERR] java.sql.SQLException: ORA-00923: Schlüsselwort FROM nicht an erwarteter Stelle gefunden
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:790)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:830)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
    2007-11-02 09:10:04,375 ERROR [STDERR] at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1273)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:169)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel.executeQuery(MondrianDrillThroughTableModel.java:163)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel.getColumnCount(MondrianDrillThroughTableModel.java:113)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.table.TableComponent.setModel(TableComponent.java:224)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.table.EditableTableComponent.setModel(EditableTableComponent.java:235)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.jpivot.table.navi.DrillThroughUI$DrillThroughHandler.request(DrillThroughUI.java:123)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:104)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.jpivot.table.TableComponent.request(TableComponent.java:180)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.controller.WcfController.request(WcfController.java:71)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:119)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)
    2007-11-02 09:10:04,375 ERROR [STDERR] at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.pentaho.core.system.SystemStatusFilter.doFilter(SystemStatusFilter.java:53)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.pentaho.ui.servlet.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:112)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    2007-11-02 09:10:04,375 ERROR [STDERR] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
    2007-11-02 09:10:04,375 ERROR [STDERR] at java.lang.Thread.run(Thread.java:534)
    2007-11-02 09:10:04,390 ERROR [com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel] ?
    java.sql.SQLException: ORA-00923: Schlüsselwort FROM nicht an erwarteter Stelle gefunden

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    .................


    Thanks!
    Jan
    Last edited by mec_muc; 11-02-2007 at 08:02 AM.

  4. #4
    Join Date
    Nov 1999
    Posts
    1,618

    Default

    Maybe your mondrian.properties is in the wrong place.

  5. #5
    Join Date
    Apr 2007
    Posts
    21

    Default

    What is the right place for mondrian.properties?

    Thanks,
    Jan

  6. #6
    Join Date
    Apr 2007
    Posts
    21

    Smile solution

    I just had to change the loglevel to debug for mondrian in log4j.xml

    then I got the sqlexception
    and the problem was
    select .... as
    "SUM of TR_CHECK_LOGGING"."TR_PLANNING_STATE" from...

    so the problem was, that the name of a measure in the cube included a point. I think this name was generated by the cube-designer.
    I renamed it and now it works fine :-)

    PS:
    There is also a mondrian.properties in
    pentaho-demo\jboss\server\default\deploy\pentaho.war\WEB-INF\classes
    but this seems only to be an empty dummy:
    # add mondrian properties to pentaho-solutions/system/mondrian/mondrian.properties
    # this file's sole purpose is to avoid warning messages from mondrian

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.