Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: [Mondrian] SQL Tracing

  1. #1
    Bruno Gomes Guest

    Default [Mondrian] SQL Tracing

    Hi, i want to trace the SQL statments, i have follow the mondrian
    technical guide, and added to mondrian.properties the follow
    properties:
    ----
    #Tracing
    mondrian.trace.level=5
    mondrian.debug.out.file=./traceLog.out
    ----
    I have putted the mondrian.properties in the
    [Tomcat_Path]/webapps/mondrian/WEB-INF/classes
    But now, i can't find the output file (traceLog.out), is the location
    of mondrian.properties right?

    Thanks for the help in advance.
    Best regards.

    --
    Bruno Gomes
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  2. #2
    Matt Campbell Guest

    Default Re: [Mondrian] SQL Tracing

    I believe *mondrian.trace.level* is obsolete. You should be able to get all
    SQL statements by setting up log4j appropriately, though. Edit log4j.xml
    and set the following category to log to your appender of choice, e.g.

    <category name="mondrian.sql">
    <priority value="DEBUG"/>
    <appender-ref ref="SQLLOG"/>
    <appender-ref ref="CONSOLE"/>
    </category>


    (there's also a mondrian.mdx logger).



    On Mon, Mar 22, 2010 at 11:09 AM, Bruno Gomes <semog15 (AT) gmail (DOT) com> wrote:

    > Hi, i want to trace the SQL statments, i have follow the mondrian
    > technical guide, and added to mondrian.properties the follow
    > properties:
    > ----
    > #Tracing
    > mondrian.trace.level=5
    > mondrian.debug.out.file=./traceLog.out
    > ----
    > I have putted the mondrian.properties in the
    > [Tomcat_Path]/webapps/mondrian/WEB-INF/classes
    > But now, i can't find the output file (traceLog.out), is the location
    > of mondrian.properties right?
    >
    > Thanks for the help in advance.
    > Best regards.
    >
    > --
    > Bruno Gomes
    > _______________________________________________
    > Mondrian mailing list
    > Mondrian (AT) pentaho (DOT) org
    > http://lists.pentaho.org/mailman/listinfo/mondrian
    >


    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian

  3. #3
    Julian Hyde Guest

    Default RE: [Mondrian] SQL Tracing

    Matt is correct. There is documentation on how to set up logging here:

    http://mondrian.pentaho.org/document...atement_Loggin
    g

    Julian


    _____

    From: mondrian-bounces (AT) pentaho (DOT) org [mailto:mondrian-bounces (AT) pentaho (DOT) org] On
    Behalf Of Matt Campbell
    Sent: Monday, March 22, 2010 8:26 AM
    To: Mondrian developer mailing list
    Subject: Re: [Mondrian] SQL Tracing


    I believe mondrian.trace.level is obsolete. You should be able to get all
    SQL statements by setting up log4j appropriately, though. Edit log4j.xml
    and set the following category to log to your appender of choice, e.g.



    <category name="mondrian.sql">
    <priority value="DEBUG"/>
    <appender-ref ref="SQLLOG"/>
    <appender-ref ref="CONSOLE"/>
    </category>


    (there's also a mondrian.mdx logger).



    On Mon, Mar 22, 2010 at 11:09 AM, Bruno Gomes <semog15 (AT) gmail (DOT) com> wrote:


    Hi, i want to trace the SQL statments, i have follow the mondrian
    technical guide, and added to mondrian.properties the follow
    properties:
    ----
    #Tracing
    mondrian.trace.level=5
    mondrian.debug.out.file=./traceLog.out
    ----
    I have putted the mondrian.properties in the
    [Tomcat_Path]/webapps/mondrian/WEB-INF/classes
    But now, i can't find the output file (traceLog.out), is the location
    of mondrian.properties right?

    Thanks for the help in advance.
    Best regards.

    --
    Bruno Gomes
    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/mondrian




    _______________________________________________
    Mondrian mailing list
    Mondrian (AT) pentaho (DOT) org
    http://lists.pentaho.org/mailman/listinfo/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.