How to create an individual log file for Saiku Adhoc on Pentaho BI Server


Here I show an easy way of creatting an individual saiku.log file on your Pentaho BI server. An useful trick to organize and check saiku / saiku adhoc logs and debugging errors. I am sure you are familiar with mondrian_mdx and mondrian_sql  log files. These logs are disabled by default and may be enabled uncommenting  the blocks of code in the final part of the log file:


…but why do I talk about these log files? The answer is easy, it’s because  we only need to create on this area another block of code containing the lines of code attached below and you will create a new saiku.log file!

Remember you can  change log  level from  DEBUG to ERROR,WARN…or the one most fits your requirements.

<appender name="SAIKULOG">

 <param name="File" value="../logs/saiku.log"/>
 <param name="Append" value="false"/>
 <param name="MaxFileSize" value="100MB"/>
 <param name="MaxBackupIndex" value="1"/>
 <param name="ConversionPattern" value="%d %-5p [%c] %m%n"/>


<category name="org.saiku.adhoc">
 <priority value="DEBUG"/>
 <appender-ref ref="SAIKULOG"/>

Restart your BI Server and from now on saiku log will appear into saiku.log individual file on /biserver-ce/tomcat/logs directory. However, don’t forget checking pentaho.log and catalina.out logs files to acquire all the information you require to solve your issues.

Have fun!