Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: SQL Log for Adhoc Report in Pentaho 5.0

  1. #1
    Join Date
    Oct 2013
    Posts
    10

    Default SQL Log for Adhoc Report in Pentaho 5.0

    I am currently using Pentaho CE 5.0.1. I want to generate the SQL Logs So that I can tarec the sql queries of Adhoc Reports. In some forums i found that there is to change something in log4j.xml in tomcat server. The link is attached http://biadvantage.wordpress.com/cat...-intelligence/ .
    I made the changes but it does not work for me. Kindly if someone knows how to implement it in Pentaho BI 5.0.1

    Thanks

  2. #2

    Default

    Change to relative path for example <param name="File" value="../logs/adhoc_sql.log"/>
    The log in tomcat\logs.

  3. #3
    Join Date
    Oct 2013
    Posts
    10

    Default

    Dear Orkan I have already done this activity but the file remain empty. No Log generated while I run adhoc reports.

  4. #4

    Default

    Open log4j file in Notepad2. Check File>Encoding. Must be UTF-8.

    I add the file tested on Windows Vista.
    Attached Files Attached Files

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.