Nilesh Patil's blog

INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role> add following configuration before close   </security-constraint> <security-role>         <description>security role</description>         <role-name>PENTAHO_ADMIN</role-name>     </security-role>

Installed Pentaho Repository Synchronizer with branch Trunk This plugin copies a version of libpensol.*.jar to the server's WEB-INF/lib. It's possible that on Windows boxes there's an error upgrading the repositorySynchronizer. If that happens, stop the server and delete the WEB-INF/lib/libpensol.* jar file(s)

To hide the .CDA files, its no use to the end user to see the datasource in the treeview so edit: biserver-ce/pentaho-solutions/system/cda/ plugin.xml And comment the lines between: <!– <content-types> … </content-types> //–>

Caused by: java.sql.BatchUpdateException: Packet for query is too large (1434172 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. The max_allowed_packet variable can be set globally by running a query. However, if you do not change it in the my.ini file (as dragon112 suggested), the value will reset when the server restarts, even if you set it globally. To change the setting for everyone until the server restarts: SET GLOBAL max_allowed_packet=1073741824;

If you get the following error message in the console: 14:02:38,763 ERROR [SolutionEngine] 89a06230-0b76-11df-b4e9-ab19d7ccef2f:SOLUTION-ENGINE:session-region-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed 14:03:34,760 ERROR [SolutionEngine] ab02fbe1-0b76-11df-b4e9-ab19d7ccef2f:SOLUTION-ENGINE:global-department-list.xaction: SolutionEngine.ERROR_0007 - Action sequence execution failed Solution :- Check inside this file : /pentaho-solutions/system/sessionStartupActions.xml and comment the bean that uses this deleted action. 

ERROR [GenericServlet] GenericServlet.ERROR_0004 - Resource /reporting/reportviewer/cdf/cdf-module.js not found in plugin reporting copy solutions/system/pentaho-cdf/js/cdf-module.js solutions/system/reporting/reportviewer/cdf/ http://forums.pentaho.com/showthread.php?138924-Report-does-not-appear-in-server

After upgrading CGG community graphics generator from marketplace on Pentaho BI 4.8, Stop BI server and Please remember to replace all batik, xml-apis and xmlgraphics jars on WEB-INF/lib with ones on system/cgg/lib

Are you running on Java 1.4 with Apache Crimson? Upgrade to Apache Xerces (or Java 1.5) for full XSD support. org.springframework.beans.factory.BeanDefinitionStoreException: Unexpected exception parsing XML document from class path resource [com/auchan/core/context/applicationContext.xml]; nested exception is org.springframework.beans.factory.BeanDefinitionStoreException: Unable to validate using XSD: Your JAXP provider [org.apache.crimson.jaxp.DocumentBuilderFactoryImpl@121f1d] does not support XML Schema. Are you running on Java 1.4 or below with Apache Crimson? Upgrade to Apache Xerces (or Java 1.5) for full XSD support. Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: Unable to validate using XSD: Your JAXP provider [org.apache.crimson.jaxp.DocumentBuilderFactoryImpl@121f1d] does not support XML Schema. Are you running on Java 1.4 or below with Apache Crimson? Upgrade to Apache Xerces (or Java 1.5) for full XSD support.  Solution :- Just add the...

Error :- 09:25:10,924 ERROR [Logger] misc-class org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager: PluginManager.ERROR_0011 - Failed to register plugin cdc org.pentaho.platform.api.engine.PlatformPluginRegistrationException: PluginManager.ERROR_0017 - Could not load lifecycle listener [pt.webdetails.cdc.CdcLifeCycleListener] for plugin cdc at org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.bootStrapPlugin(DefaultPluginManager.java:163) at org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.registerPlugin(DefaultPluginManager.java:197) at org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager.reload(DefaultPluginManager.java:128) Solution :- Copy jar files located at biserver-ce\pentaho-solutions\system\cdc\pentaho-lib to biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib Issue will be resolve. http://forums.pentaho.com/showthread.php?137442-error-on-cdc-plugin-13-02-07-at-pentaho-...

You can find docs biserver-ce\tomcat\webapps\pentaho\docs\ Changing the Java VM Memory Limits If you are running out of memory even though your server has a lot of RAM, you probably need to increase the resources allocated to the JRE instance that runs the Pentaho software you're trying to improve performance on. Adjusting the memory limit is an easy configuration change to make, but the instructions differ depending on the client tool or Web application server you're using. Refer only to the sections below that apply to your situation. Note: If you are running multiple Pentaho programs concurrently, the sum of their JVM maximum memory limits must not exceed the available RAM minus system overhead. Increasing Memory Limits on Microsoft Windows with a Graphical Installation By default, Tomcat has a relatively low memory allotment. This can cause out-of-memory errors in the BA Server fromtime to time. The below instructions will explain how to increase the mem...

http://forums.pentaho.com/showthread.php?26490-Getting-Help  Understanding that those of us at Pentaho are volunteering our time to help users get started with the platform, if you reach a point where reading the provided documentation and looking through the forums can't solve your problem, here's a quick best-practices way to get the most out of the forum. Start Here: http://community.pentaho.org/faq/forum_assistance.php Post information about your environment, operating system, whether you're using the Preconfigured Install (PCI), what application server you're running in, what jdbc driver you're using, what version of the platform you have, what version of the client tool you're running, etc. If you're using Tomcat for example, we need to know the exact version of Tomcat you're running. We also need to know the JDK version. Without all this information, we just have to turn around and ask you what you're running. This wastes...

ERROR [org.quartz.core.ErrorLogger] An error occured while scanning for the next trigger to fire.org.quartz.JobPersistenceException: Couldn’t acquire next trigger: Field ‘PRIORITY’ doesn’t have a default value [See nested exception: java.sql.SQLException: Field 'PRIORITY' doesn't have a default value] Solution :- Simply to set the DEFAULT of the column to 0 in following tables QRTZ_TRIGGERS                  COLUMN         PRIORITY          set default value 0 QRTZ_FIRED_TRIGGERS                  COLUMN         PRIORITY          set default value 0

In case you get this error Failed to obtain DB connection from data source ‘myDS’: java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:comp/env/jdbc/Quartz’ Solution :-  delete the following file toncat/conf/Catalina/localhost/pentaho.xml and try again.

To change the location of the pentaho.log file, You must edit the log4j.xml available at /pentaho/server/biserver-ee/tomcat/webapps/pentaho/WEB-INF/classes/ .  By default pentaho.log file available at biserver-ce\tomcat\bin folder  Modify the location as shown in the sample below using the appropriate path  <param name="File" value="C:\logs\pentaho.log"/> <param name="Append" value="true"/>

I had created lots of reports and published on Pentaho BI server. One day my Technical team told me our database server is going to changed. I am really very get tense now I have to change database details in every report that is very hectic and silly work. So that time I have in mind "Don't hardcode host names, use JNDI", my best friend google always help me & found two blogs that really very help to configure JNDI (in Pentaho called as Pentaho Datasources). JDNI is a technique to hold database connections outside of the report definition. By holding this information in a central spot, you only have to change one place and all your reports get updated. The JNDI stored connection information is stored on the computer where your report runs. This also allows you to have separate definitions based on where the report runs. Your report designer can access a local copy of your production database, while your production server uses the real database server. ...

http://forums.pentaho.com/showthread.php?135082-how-to-add-maximum-length-for-GROUP_CONCAT-in-pentaho-report-designer&p=330725#post330725 GROUP_CONCAT() in a MySQL query to convert multiple rows into a single string. However, the maximum length of the result of this function is 1024 characters.  I'm very well aware that I can change the param group_concat_max_len to increase this limit: SET SESSION group_concat_max_len = 1000000 ; Above is set for SESSION SET GLOBAL group_concat_max_len = 1000000; above is set for GLOBAL ref :- http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat http://rpbouman.blogspot.in/2008/07/calculating-nth-percentile-in-mysql.html http://rpbouman.blogspot.in/2009_03_01_archive.html