Pentaho BI Server 5.0.1CE MySQL installation guide


How to install Pentaho BI Server 5.0.1 Community Edition with MySQL 5.x and Windows

Hi all this is David Fombella and I would like to share a way to deploy Pentaho Community last edition installing its security into a MySQL database server.

Help me keep the guides up to date and the posts flowing by donating, every small amount of money helps!

btn_donatecc_lg

Here is the download link to get the biserver 5.0.1 CE .

http://sourceforge.net/projects/pentaho/files/Business%20Intelligence%20Server/5.0.1-stable/biserver-ce-5.0.1-stable.zip/download

Creation of Databases & Users

In our first stage we are going to create hibernate database and the user hibuser. To achieve this execute the SQL script  create_repository_mysql.sql included at biserver-ce\data\mysql5

SQL code

CREATE DATABASE IF NOT EXISTS `hibernate` DEFAULT CHARACTER SET latin1;
USE hibernate;
GRANT ALL ON hibernate.* TO 'hibuser'@'localhost' identified by 'password';
commit;

Next we create quartz database and the user pentaho_user. You only need to execute the SQL script  create_quartz_mysql.sql included at biserver-ce\data\mysql5

CREATE DATABASE IF NOT EXISTS `quartz` DEFAULT CHARACTER SET latin1;

grant all on quartz.* to 'pentaho_user'@'localhost' identified by 'password';

USE `quartz`;

DROP TABLE IF EXISTS QRTZ5_JOB_LISTENERS;
DROP TABLE IF EXISTS QRTZ5_TRIGGER_LISTENERS;
DROP TABLE IF EXISTS QRTZ5_FIRED_TRIGGERS;
DROP TABLE IF EXISTS QRTZ5_PAUSED_TRIGGER_GRPS;
DROP TABLE IF EXISTS QRTZ5_SCHEDULER_STATE;
DROP TABLE IF EXISTS QRTZ5_LOCKS;
DROP TABLE IF EXISTS QRTZ5_SIMPLE_TRIGGERS;
DROP TABLE IF EXISTS QRTZ5_CRON_TRIGGERS;
DROP TABLE IF EXISTS QRTZ5_BLOB_TRIGGERS;
DROP TABLE IF EXISTS QRTZ5_TRIGGERS;
DROP TABLE IF EXISTS QRTZ5_JOB_DETAILS;
DROP TABLE IF EXISTS QRTZ5_CALENDARS;

CREATE TABLE QRTZ5_JOB_DETAILS
  (
    JOB_NAME  VARCHAR(200) NOT NULL,
    JOB_GROUP VARCHAR(200) NOT NULL,
    DESCRIPTION VARCHAR(250) NULL,
    JOB_CLASS_NAME   VARCHAR(250) NOT NULL,
    IS_DURABLE VARCHAR(1) NOT NULL,
    IS_VOLATILE VARCHAR(1) NOT NULL,
    IS_STATEFUL VARCHAR(1) NOT NULL,
    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
    JOB_DATA BLOB NULL,
    PRIMARY KEY (JOB_NAME,JOB_GROUP)
);

CREATE TABLE QRTZ5_JOB_LISTENERS
  (
    JOB_NAME  VARCHAR(200) NOT NULL,
    JOB_GROUP VARCHAR(200) NOT NULL,
    JOB_LISTENER VARCHAR(200) NOT NULL,
    PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),
    FOREIGN KEY (JOB_NAME,JOB_GROUP)
        REFERENCES QRTZ5_JOB_DETAILS(JOB_NAME,JOB_GROUP)
);

CREATE TABLE QRTZ5_TRIGGERS
  (
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    JOB_NAME  VARCHAR(200) NOT NULL,
    JOB_GROUP VARCHAR(200) NOT NULL,
    IS_VOLATILE VARCHAR(1) NOT NULL,
    DESCRIPTION VARCHAR(250) NULL,
    NEXT_FIRE_TIME BIGINT(13) NULL,
    PREV_FIRE_TIME BIGINT(13) NULL,
    PRIORITY INTEGER NULL,
    TRIGGER_STATE VARCHAR(16) NOT NULL,
    TRIGGER_TYPE VARCHAR(8) NOT NULL,
    START_TIME BIGINT(13) NOT NULL,
    END_TIME BIGINT(13) NULL,
    CALENDAR_NAME VARCHAR(200) NULL,
    MISFIRE_INSTR SMALLINT(2) NULL,
    JOB_DATA BLOB NULL,
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (JOB_NAME,JOB_GROUP)
        REFERENCES QRTZ5_JOB_DETAILS(JOB_NAME,JOB_GROUP)
);

CREATE TABLE QRTZ5_SIMPLE_TRIGGERS
  (
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    REPEAT_COUNT BIGINT(7) NOT NULL,
    REPEAT_INTERVAL BIGINT(12) NOT NULL,
    TIMES_TRIGGERED BIGINT(10) NOT NULL,
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ5_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);

CREATE TABLE QRTZ5_CRON_TRIGGERS
  (
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    CRON_EXPRESSION VARCHAR(200) NOT NULL,
    TIME_ZONE_ID VARCHAR(80),
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ5_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);

CREATE TABLE QRTZ5_BLOB_TRIGGERS
  (
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    BLOB_DATA BLOB NULL,
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),
    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ5_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);

CREATE TABLE QRTZ5_TRIGGER_LISTENERS
  (
    TRIGGER_NAME  VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    TRIGGER_LISTENER VARCHAR(200) NOT NULL,
    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),
    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)
        REFERENCES QRTZ5_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP)
);

CREATE TABLE QRTZ5_CALENDARS
  (
    CALENDAR_NAME  VARCHAR(200) NOT NULL,
    CALENDAR BLOB NOT NULL,
    PRIMARY KEY (CALENDAR_NAME)
);

CREATE TABLE QRTZ5_PAUSED_TRIGGER_GRPS
  (
    TRIGGER_GROUP  VARCHAR(200) NOT NULL,
    PRIMARY KEY (TRIGGER_GROUP)
);

CREATE TABLE QRTZ5_FIRED_TRIGGERS
  (
    ENTRY_ID VARCHAR(95) NOT NULL,
    TRIGGER_NAME VARCHAR(200) NOT NULL,
    TRIGGER_GROUP VARCHAR(200) NOT NULL,
    IS_VOLATILE VARCHAR(1) NOT NULL,
    INSTANCE_NAME VARCHAR(200) NOT NULL,
    FIRED_TIME BIGINT(13) NOT NULL,
    PRIORITY INTEGER NOT NULL,
    STATE VARCHAR(16) NOT NULL,
    JOB_NAME VARCHAR(200) NULL,
    JOB_GROUP VARCHAR(200) NULL,
    IS_STATEFUL VARCHAR(1) NULL,
    REQUESTS_RECOVERY VARCHAR(1) NULL,
    PRIMARY KEY (ENTRY_ID)
);

CREATE TABLE QRTZ5_SCHEDULER_STATE
  (
    INSTANCE_NAME VARCHAR(200) NOT NULL,
    LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
    CHECKIN_INTERVAL BIGINT(13) NOT NULL,
    PRIMARY KEY (INSTANCE_NAME)
);

CREATE TABLE QRTZ5_LOCKS
  (
    LOCK_NAME  VARCHAR(40) NOT NULL,
    PRIMARY KEY (LOCK_NAME)
);

INSERT INTO QRTZ5_LOCKS values('TRIGGER_ACCESS');
INSERT INTO QRTZ5_LOCKS values('JOB_ACCESS');
INSERT INTO QRTZ5_LOCKS values('CALENDAR_ACCESS');
INSERT INTO QRTZ5_LOCKS values('STATE_ACCESS');
INSERT INTO QRTZ5_LOCKS values('MISFIRE_ACCESS');
commit;

Finally we create jackrabbit database and the user jcr_user. You only need to execute the SQL script  create_jcr_mysql.sql included at biserver-ce\data\mysql5

CREATE DATABASE IF NOT EXISTS `jackrabbit` DEFAULT CHARACTER SET latin1;
grant all on jackrabbit.* to 'jcr_user'@'localhost' identified by 'password';
commit;

Configuring JDBC Security

This section describes how to configure the Pentaho BI Platform JDBC security to use a MySQL server, this means the Pentaho BI Platform will now point to the hibernate database on the MySQL server instead of the packaged HSQL in memory database.

1. applicationContext-spring-security-hibernate.properties.

Edit the file pentaho-solutions\system\applicationContext-spring-security-hibernate.properties.

Original code

jdbc.driver=org.hsqldb.jdbcDriver
jdbc.url=jdbc:hsqldb:hsql://localhost:9001/hibernate
jdbc.username=hibuser
jdbc.password=password
hibernate.dialect=org.hibernate.dialect.HSQLDialect
 

Make the changes necessary to get the snippet of code below

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/hibernate
jdbc.username=hibuser
jdbc.password=password
hibernate.dialect=org.hibernate.dialect.MySQLDialect
 

    2. hibernate-settings.xml

Edit the file pentaho-solutions\system\hibernate\hibernate-settings.xml.

Original code

<config-file>system/hibernate/hsql.hibernate.cfg.xml</config-file>
 

Make the changes necessary to get the snippet of code below

<config-file>system/hibernate/mysql5.hibernate.cfg.xml</config-file>
 

3. mysql5.hibernate.cfg.xml

Edit the file pentaho-solutions\system\hibernate\mysql5.hibernate.cfg.xml .

You do not need to make any changes to this file if you would like to use the default user hibuser. However, if you would like to specify your custom user, change connection.username and password  properties.

Original code

<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property>
<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<property name="connection.username">hibuser</property>
<property name="connection.password">password</property>
 

4. quartz.properties

Edit the file pentaho-solutions\system\quartz\quartz.properties .

Original code

org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
 

Make the changes necessary to get the snippet of code below

org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
 

Configuring Hibernate and Quartz

Hibernate and Quartz need to specifically use the hibernate and quartz databases which were created on the MySQL server. To do so modifications need to be executed in context.xml file .

5. context.xml

Edit the file tomcat\webapps\pentaho\META-INF\context.xml.

Remember deleting tomcat\conf\Catalina\localhost\pentaho.xml , Pentaho creates  on startup pentaho.xml as a copy of context.xml.

Original code

<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
maxWait="10000" username="hibuser" password="password"
driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/hibernate"
validationQuery="select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES" />

<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
maxWait="10000" username="pentaho_user" password="password"
driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/quartz"
validationQuery="select count(*) from INFORMATION_SCHEMA.SYSTEM_SEQUENCES"/>
 

Make the changes necessary to get the snippet of code below

<Resource name="jdbc/Hibernate" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
maxWait="10000" username="hibuser" password="password"
driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/hibernate"
validationQuery="select 1" />

<Resource name="jdbc/Quartz" auth="Container" type="javax.sql.DataSource"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
maxWait="10000" username="pentaho_user" password="password"
driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/quartz"
validationQuery="select 1"/>
 

6. repository.xml

Edit the file pentaho-solutions\system\jackrabbit\repository.xml.

One of the new features of pentaho 5 is the use of Jackrabbit content repository.

http://jackrabbit.apache.org/repository-server-howto.html

jlogo

Comment the original code in the FileSystem part

<!--
Replace the following "FileSystem" XML node to use supported databases as
the repository file system.  Change the url, user, password and other parameters
to suit your db installation.  The schemaObjectPrefix should
be a unique prefix that will be prepended to the table names.
NOTE: The database must be pre-created in and match the parameters.  See Jackrabbit
documentation for further explanation.
-->
<FileSystem>
<param name="path" value="${rep.home}/repository"/>
</FileSystem>
 

Make this code active on FileSystem part of the code

<FileSystem>
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
<param name="user" value="jcr_user"/>
<param name="password" value="password"/>
<param name="schema" value="mysql"/>
<param name="schemaObjectPrefix" value="fs_repos_"/>
</FileSystem>
 

Comment the original code in the DataStore part

<!--
data store configuration
-->
<!--
Replace the following "DataStore" XML node to use supported databases as the data
store for the repository.  Change the url, user, password and other parameters
to suit your db installation.  The schemaObjectPrefix should
be a unique prefix that will be prepended to the table names.
NOTE: The database must be pre-created in and match the parameters.  See Jackrabbit
documentation for further explanation.
-->
<DataStore class="org.apache.jackrabbit.core.data.FileDataStore"/>
 

Make this code active on DataStore part of the code

 <DataStore class="org.apache.jackrabbit.core.data.db.DbDataStore">
    <param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
    <param name="user" value="jcr_user"/>
    <param name="password" value="password"/>
    <param name="databaseType" value="mysql"/>
    <param name="driver" value="com.mysql.jdbc.Driver"/>
    <param name="minRecordLength" value="1024"/>
    <param name="maxConnections" value="3"/>
    <param name="copyWhenReading" value="true"/>
    <param name="tablePrefix" value=""/>
    <param name="schemaObjectPrefix" value="ds_repos_"/>
  </DataStore>

Below the security part comment the original code in the FileSystem Workspace part

<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<!--
Replace the following "FileSystem" XML node to use supported databases as
the repository file system.  Change the url, user, password and other parameters
to suit your db installation.  The schemaObjectPrefix should
be a unique prefix that will be prepended to the table names.
NOTE: The database must be pre-created in and match the parameters.  See Jackrabbit
documentation for further explanation.
-->
<FileSystem>
<param name="path" value="${wsp.home}"/>
</FileSystem>
 

Make this code active on FileSystem WorkSpace part of the code

<FileSystem>
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
<param name="user" value="jcr_user"/>
<param name="password" value="password"/>
<param name="schema" value="mysql"/>
<param name="schemaObjectPrefix" value="fs_ws_"/>
</FileSystem>

Below  FileSystem Workspace part you will find the PersistenceManager part

<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager interface
-->
<!--
Replace the following "PersistenceManager" XML node to use a supported database as the
persistenanceManager store.  Change the url, user, password and parameters
to suit your db installation.  The schemaObjectPrefix should
be a unique prefix that will be prepended to the table names.
NOTE: The database must be pre-created in and match the parameters.  See Jackrabbit
documentation for further explanation.
-->

<PersistenceManager>
<param name="url" value="jdbc:h2:${wsp.home}/db"/>
<param name="schemaObjectPrefix" value="${wsp.name}_"/>
</PersistenceManager>

 

Make this code active on PersistenceManager part of the code

<PersistenceManager>
<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
<param name="user" value="jcr_user" />
<param name="password" value="password" />
<param name="schema" value="mysql"/>
<param name="schemaObjectPrefix" value="${wsp.name}_pm_ws_"/>
</PersistenceManager>

Below you will find FileSystem Versioning part

<!--
Configures the filesystem to use for versioning for the respective
persistence manager
-->
<!--
Replace the following "FileSystem" XML node to use a supported database as
the repository file system.  Change the url, user, password and other parameters
to suit your db installation.  The schemaObjectPrefix should
be a unique prefix that will be prepended to the table names.
NOTE: The database must be pre-created in and match the parameters.  See Jackrabbit
documentation for further explanation.
-->
<FileSystem>
<param name="path" value="${rep.home}/version" />
</FileSystem>
 

Make this code active on FileSystem Versioning part

<FileSystem>
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
<param name="user" value="jcr_user"/>
<param name="password" value="password"/>
<param name="schema" value="mysql"/>
<param name="schemaObjectPrefix" value="fs_ver_"/>
</FileSystem>

Below you will find PersistenceManager Versioning part

<!--
Configures the persistence manager to be used for persisting version state.
Please note that the current versioning implementation is based on
a 'normal' persistence manager, but this could change in future
implementations.
-->
<!--
Replace the following "PersistenceManager" XML node to use a supported database as the
persistenanceManager store.  Change the url, user, password and parameters
to suit your db installation.  The schemaObjectPrefix should
be a unique prefix that will be prepended to the table names.
NOTE: The database must be pre-created in and match the parameters.  See Jackrabbit
documentation for further explanation.
-->
<PersistenceManager>
<param name="url" value="jdbc:h2:${rep.home}/version/db"/>
<param name="schemaObjectPrefix" value="version_"/>
</PersistenceManager>

Make this code active on PersistenceManager Versioning part

<PersistenceManager>
<param name="url" value="jdbc:mysql://localhost:3306/jackrabbit"/>
<param name="user" value="jcr_user" />
<param name="password" value="password" />
<param name="schema" value="mysql"/>
<param name="schemaObjectPrefix" value="pm_ver_"/>
</PersistenceManager>

Quit HSQL Hypersonic automatic startup

By default  Hypersonic database starts up automatically – to avoid this  comment or delete locate the following snippets of code from web.xml:

<!-- [BEGIN HSQLDB DATABASES] -->
<context-param>
<param-name>hsqldb-databases</param-name>
<param-value>sampledata@../../data/hsqldb/sampledata,hibernate@../../data/hsqldb/hibernate,quartz@../../data/hsqldb/quartz</param-value>
</context-param>
<!-- [END HSQLDB DATABASES] -->
 

Second  section you need to comment or eliminate

<!-- [BEGIN HSQLDB STARTER] -->
<listener>
<listener-class>org.pentaho.platform.web.http.context.HsqldbStartupListener</listener-class>
</listener>
<!-- [END HSQLDB STARTER] -->
 

Sign into the user console

Using this URL http://localhost:8080/pentaho you can reach pentaho login screen:

login biserver5Once you are into the user console, you will see  Home perspective with several buttons:

  • Browse Files: Navigate through Public and Home root directories and Cut, Copy, Share, Download, Schedule all contents included in Pentaho ( PRPT reports,  sequence actions, jobs, transformations, olap views, saiku views —)
  • Create New: (JPivot View , Add components via Marketplace)
  • Manage DataSources: Create, Edit and Delete  JDBC datasources, Mondrian metadata sources  and Metadata.xmi reporting ad hoc datasources
  • Documentation: Documentation for Pentaho 5.0

PUC biserver5

One of the main changes of Pentaho 5 is the fact that there isn’t an external Administration Console and administration capabilities are included in the User Console. In this version our “ancient”  friend joe has been replaced with the admin user. Besides the new roles available are the following:

  • Administrator
  • Power User
  • Report Author
  • Business Analyst

You can access in the administration perspective in the user console using the dropdown and selecting Administration:

administration biserver5Then you will reach the administration perspective

administration roles biserver5

Advertisements

60 thoughts on “Pentaho BI Server 5.0.1CE MySQL installation guide

  1. If you got a 404 error whith this message, you have to edit the systemListeners.xml in the directory pentaho-solutions/system/ and comment the line mention quartz! This seems lacking from this – by the way great – tutorial.
    After that works like charm. Or… not exactly, cause I cant reach the files int the browse files part…

    Error message:
    ——————–
    Pentaho Initialization Exception

    The following errors were detected
    One or more system listeners failed. These are set in the systemListeners.xml.
    PentahoSystem.ERROR_0014 – Error while trying to execute startup sequence for
    org.pentaho.platform.scheduler.QuartzSystemListener

    Please see the server console for more details on each error detected.

  2. I get following error during start up:

    SEVERE: Error deploying web application directory pentaho
    com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence.
    at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(UTF8Reader.java:687)
    at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(UTF8Reader.java:557)
    at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(XMLEntityScanner.java:1753)
    at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.scanContent(XMLEntityScanner.java:926)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocument
    FragmentScannerImpl.java:2811)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:606)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScanne
    rImpl.java:510)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:848)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:777)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1213)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:649)
    at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1626)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1035)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
    at org.apache.catalina.core.StandardService.start(StandardService.java:525)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

  3. Hi David – thanks for this guide. One thing I have noticed is that the Administration console for user management is still pointing at another source of data even after these changes – do you have any ideas about this?

    Thanks,
    Piers Harding.

    • According to the sixth paragraph of this article, I changed the repository.xml, part of the original annotations FileSystem and instead MySQL
      After he was done, the server can start properly, jackrabbit database has some table

      But now some of the problems
      1 steel weel sample file can not be found
      2 Try to use pds-ce-win-64-4.0.0-stable to add a solution, complete set of activitie not upload, a message appears that this does not belong to any solution

      I attached a few pictures illustrate the current situation
      https://plus.google.com/photos/104901776252800146370/albums/5966338787923762945?authkey=COC0v_X4oJf0gAE

      1 files changed repository.xml

      2.MySQL database

      3.Pentaho Browse files

      Any suggestions are very helpful

  4. Hi ,

    If I transfere the HSQL repository (jackrabbit) to MySQL, it doesn’t work. If I don’t it work !
    I follow the installation guide. What can be the problem ?

    If someone can help me…

    thanks in advance

  5. Pingback: How to install Pentaho Business Analytics platform 5 – Francesco Corti

  6. Hi David, I want to know if is there any problem to publish a Pentaho-MSSQL installation guide based on your guide. Without this guide would have been impossible do the same for MSSQL.

    Thanks for all!

  7. Hi David,

    Thanks for this ellaborative steps to install and configure Pentaho with Mysql DB. I am wondering can you point me to minimum system requirements required to install Pentaho CE (business analytics and Data Integrator) on Linux considering the fact we are going to use it with hadoop for one of our POC.

    Thanks

  8. Hi David,
    Thanks for this guide!After I did all steps,getting quartz error while start BI server .This is the message:
    2014-03-15 11:32:22,564 ERROR [org.quartz.core.ErrorLogger] An error occured while scanning for the next trigger to fire.
    org.quartz.JobPersistenceException: Couldn’t acquire next trigger: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=5’ at line 1 [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=5’ at line 1]
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2785)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport$36.execute(JobStoreSupport.java:2728)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3742)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2724)
    at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:263)
    Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘OPTION SQL_SELECT_LIMIT=5’ at line 1
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
    at com.mysql.jdbc.Util.getInstance(Util.java:386)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
    at com.mysql.jdbc.StatementImpl.executeSimpleNonQuery(StatementImpl.java:1606)
    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2268)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggerToAcquire(StdJDBCDelegate.java:2921)
    at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2742)

    PS: MYSQL VERSION :5.6.16

    • 您好
      第一次遇到華文區的同好
      不曉得您的MySQL JDBC版本是?
      我用的是這個mysql-connector-java-5.1.27-bin.jar
      另外我在BA server啟動時有關掉版本檢查
      提供參考

      my jdbc is mysql-connector-java-5.1.27-bin.jar
      and I disabled update checker schedule while BA server first start

      • 您好:
        在這裏看到中文分外的親切。我已經修改完所有的步驟,並且在啓動server後,發布報表也已經測試成功。不過比較未修改前的版本,有以下問題:
        1.在未安裝插件前,new一個Jpivot View時失敗,信息如下:
        Sorry. We really did try.
        Something went wrong. Please try again
        or contact your administrator.
        2.啓動server時,有以下error:
        2014-04-03 15:10:38,778 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 0f3eafb6-baff-11e3-a205-0023243ddac2:SOLUTION-ENGINE:/public/bi-developers/Secure/global-department-list.xaction: SolutionEngine.ERROR_0007 – Action sequence執行失敗
        2014-04-03 15:12:00,620 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 4017dfd7-baff-11e3-a205-0023243ddac2:SOLUTION-ENGINE:/public/bi-developers/rules/session-region-list.xaction: SolutionEngine.ERROR_0007 – Action sequence執行失敗
        2014-04-03 15:12:00,649 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 401e4878-baff-11e3-a205-0023243ddac2:SOLUTION-ENGINE:/public/bi-developers/rules/session-region-list.xaction: SolutionEngine.ERROR_0007 – Action sequence執行失敗
        2014-04-03 15:12:00,675 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 40224019-baff-11e3-a205-0023243ddac2:SOLUTION-ENGINE:/public/bi-developers/rules/session-region-list.xaction: SolutionEngine.ERROR_0007 – Action sequence執行失敗
        请问您是否有办法解决?

        English:
        I got though a lot problems by this:
        http://www.patlaf.com/quick-tips-to-troubleshoot-the-first-installation-of-pentaho-bi-5-0-1-ce-with-mysql/
        but there still something wrong with my platform:
        1.when I create a new Jpivot viewer ,it not work:
        Sorry. We really did try.
        Something went wrong. Please try again
        or contact your administrator.
        2.after start the server ,there are some wrongs logged into pentaho.log:
        2014-04-03 15:10:38,778 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 0f3eafb6-baff-11e3-a205-0023243ddac2:SOLUTION-ENGINE:/public/bi-developers/Secure/global-department-list.xaction: SolutionEngine.ERROR_0007 – Action sequence執行失敗
        2014-04-03 15:12:00,620 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 4017dfd7-baff-11e3-a205-0023243ddac2:SOLUTION-ENGINE:/public/bi-developers/rules/session-region-list.xaction: SolutionEngine.ERROR_0007 – Action sequence執行失敗
        2014-04-03 15:12:00,649 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 401e4878-baff-11e3-a205-0023243ddac2:SOLUTION-ENGINE:/public/bi-developers/rules/session-region-list.xaction: SolutionEngine.ERROR_0007 – Action sequence執行失敗
        2014-04-03 15:12:00,675 ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] 40224019-baff-11e3-a205-0023243ddac2:SOLUTION-ENGINE:/public/bi-developers/rules/session-region-list.xaction: SolutionEngine.ERROR_0007 – Action sequence執行失敗

        can anybody help ?Thanks a lot.

    • 關於Jpivot view,我曾經遇過因為匯入的Mondrain schema中含有中文,造成之後Jpivot或saiku都啟動失敗,後來是在tomcat上加上啟動參數-Dfile.encoding=UTF-8
      解決

      第二部分的訊息我沒有遇過
      看起來像是找不到.xaction
      看一下您的browser files
      裡面應該要有一個資料夾Public\BI Developer Examples
      相關的範例檔都在裡面
      這個資料夾是從\biserver-ce\pentaho-solutions\system\default-content
      裡面的範例壓縮檔plugin-samples.zip&sample.zip所載入的
      壓縮檔的內容會在伺服器第一次啟動的時候載入到BA裡面
      載入完之後壓縮檔會被重新命名成plugin-samples.zip.201401211008 & samples.zip.201401211008
      後面那一串是日期時間
      可以檢查一下您有沒有這兩個檔案
      然後試試看把後面那串日期拿掉,在重啟伺服器重新載入壓縮檔

      About Jpivot view, I have met because imported Mondrain schema containing Chinese, after causing Jpivot or saiku have failed to start, then add in the tomcat startup parameter-Dfile.encoding = UTF-8
      Solve

      The second part of the message
      Looks like not found .Xaction
      go to browser files
      There should be a folder inside Public\BI Developer Examples
      Related sample file are inside
      This folder is from \ biserver-ce \ pentaho-solutions \ system \ default-content
      Examples inside compressed files plugin-samples.zip & sample.zip loaded
      The contents of the compressed file is loaded into BA inside the server when you first start
      After loading the finished compressed file is renamed to plugin-samples.zip.201401211008 & samples.zip.201401211008
      That was followed by a string of date and time
      You can check these two files there
      Then try to put behind the string of dates removed, restart the server to reload the archive

  9. Thanks for the manual.

    I haven’t managed to get Pentaho running. No errors, just this:

    Mar 25, 2014 3:45:46 PM org.apache.catalina.core.AprLifecycleListener init
    INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /home/artur/jdk1.6.0_43/jre/lib/amd64/server:/home/artur/jdk1.6.0_43/jre/lib/amd64:/home/artur/jdk1.6.0_43/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
    Mar 25, 2014 3:45:47 PM org.apache.coyote.http11.Http11Protocol init
    INFO: Initializing Coyote HTTP/1.1 on http-8788
    Mar 25, 2014 3:45:47 PM org.apache.catalina.startup.Catalina load
    INFO: Initialization processed in 697 ms
    Mar 25, 2014 3:45:47 PM org.apache.catalina.core.StandardService start
    INFO: Starting service Catalina
    Mar 25, 2014 3:45:47 PM org.apache.catalina.core.StandardEngine start
    INFO: Starting Servlet Engine: Apache Tomcat/6.0.36
    Mar 25, 2014 3:45:47 PM org.apache.catalina.startup.HostConfig deployDescriptor
    INFO: Deploying configuration descriptor pentaho.xml
    Mar 25, 2014 3:45:48 PM org.apache.catalina.startup.ContextConfig validateSecurityRoles
    INFO: WARNING: Security role name PENTAHO_ADMIN used in an without being defined in a

    And the http://localhost:8788/pentaho doesn’t load.

    The port was set in the “tomcat/conf/server.xml” and “tomcat/webapps/pentaho/WEB-INF/web.xml”.

    Software versioins:
    – Ubuntu 12.04 LTS
    – Java “1.6.0_43”

    Any ideas?

    Thanks in advance!

  10. Pingback: Patlaf » Quick tips to troubleshoot the first installation of Pentaho BI 5.0.1 CE with MySQL

    • Your log looks normal
      Finally, it should also have a line
      March 28, 2014 5:33:51 pm org.apache.catalina.startup.Catalina start
      Information: Server startup in 775101 ms
      Representative of the normal startup catalina

      Have tried to directly run the original environment?
      Do not make any changes to unlock the biserver-ce-5.0.1-stable.zip archive
      then run start-pentaho.sh

      In addition, is there any particular error message in pentaho.log?

  11. hi what version of java did you use I am using jdk 8.0 and I encounter a compilation error with an eclipse parameter.

    ####
    org.apache.jasper.compiler.JDTCompiler$1 findType
    SEVERE: Compilation error
    org.eclipse.jdt.internal.compiler.classfmt.ClassFormatException

    ####

  12. Thanks David.
    Great post!
    As an addendum, you might want to check this also:

    http://www.patlaf.com/quick-tips-to-troubleshoot-the-first-installation-of-pentaho-bi-5-0-1-ce-with-mysql/

    Some additional notes etc referencing this post.

    Your steps were fine, but I also followed the tips in the above post.
    I’m up and running!

    BTW – I hadn’t started BIServer before, so ensured folders etc existed before I started the BIServer.

    It takes a while for the repository and everything to be populated – I changed the various files as per your post to use mySQL as the repository, and then started the server with ./pentaho-start.sh

    Success!

    Thanks again.

    Cheers
    Brad

  13. Hi, I could setup pentaho on my Ubuntu 14.04 following your instructions.. thanks! however, I can’t login.. i’ve tried Admin, admin, Susy… using the passaword “password” and I always get a login error message. Any idea?

  14. I have followed all instructions to set this up and followed everything correct to the best of my knowledge… Can someone explain why my pentaho.xml is not copying my context.xml file. Every time I start the server pentaho.xml just reverts back to what it was before…

  15. I followed the documentation and getting the following error during startup. This log message is in tomcats catalina.out file
    2014/08/29 07:31:03 – General – Logging plugin type found with ID: CheckpointLogTable
    07:31:15,178 ERROR [DatabaseFileSystem] failed to initialize file system
    org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.)
    at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549)
    at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
    at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper.getExtraNameCharacters(ConnectionHelper.java:181)
    at org.apache.jackrabbit.core.util.db.ConnectionHelper.prepareDbIdentifier(ConnectionHelper.java:136)
    at org.apache.jackrabbit.core.fs.db.DatabaseFileSystem.init(DatabaseFileSystem.java:190)
    at org.apache.jackrabbit.core.config.RepositoryConfigurationParser$6.getFileSystem(RepositoryConfigurationParser.java:1078)
    at org.apache.jackrabbit.core.config.WorkspaceConfig.getFileSystem(WorkspaceConfig.java:220)
    at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.doInitialize(RepositoryImpl.java:2017)
    at org.apache.jackrabbit.core.RepositoryImpl$WorkspaceInfo.initialize(RepositoryImpl.java:2002)
    at org.apache.jackrabbit.core.RepositoryImpl.initStartupWorkspaces(RepositoryImpl.java:517)
    at org.apache.jackrabbit.core.RepositoryImpl.(RepositoryImpl.java:324)
    at org.apache.jackrabbit.core.RepositoryImpl.create(RepositoryImpl.java:589)

  16. Seems I can’t browse files and examples in BI server after migrating to MySQL. Any help on this? Thanks and very good post.

  17. Pingback: How to install Pentaho Business Analytics platform 5 - Francesco Corti

  18. Hi anonymousbi, I’ve followed your instructions, but when I try to launch tomcat from start-pentaho.bat I obtain the following error:
    Jan 20, 2015 2:37:28 PM org.apache.tomcat.util.digester.Digester fatalError
    SEVERE: Parse Fatal Error at line 8 column 2: The markup in the document following the root element must be well-formed.
    org.xml.sax.SAXParseException; systemId: file://E/DATAINTEGRATION/biserver-ce/tomcat/webapps/pentaho/META-INF/context.xml; lineNumber: 8; columnNumber: 2; The markup in the document following the root element must be well-formed.
    at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:198)
    at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177)
    at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:441)
    at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:368)
    at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(XMLScanner.java:1375)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$TrailingMiscDriver.next(XMLDocumentScannerImpl.java:1380)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:607)
    at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:488)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:835)
    at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)
    at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:123)
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1210)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:568)
    at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1659)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1035)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
    at org.apache.catalina.core.StandardService.start(StandardService.java:525)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

    Jan 20, 2015 2:37:28 PM org.apache.catalina.startup.HostConfig deployDirectory
    SEVERE: Error deploying web application directory pentaho
    org.xml.sax.SAXParseException; systemId: file://E/DATAINTEGRATION/biserver-ce/tomcat/webapps/pentaho/META-INF/context.xml; lineNumber: 8; columnNumber: 2; The markup in the document following the root element must be well-formed.
    at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1236)
    at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(SAXParserImpl.java:568)
    at org.apache.tomcat.util.digester.Digester.parse(Digester.java:1659)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1035)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:822)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
    at org.apache.catalina.core.StandardService.start(StandardService.java:525)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:601)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)

    Jan 20, 2015 2:37:28 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory pentaho-style
    Jan 20, 2015 2:37:28 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory ROOT
    Jan 20, 2015 2:37:28 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory sw-style
    Jan 20, 2015 2:37:28 PM org.apache.coyote.http11.Http11Protocol start
    INFO: Starting Coyote HTTP/1.1 on http-8080
    Jan 20, 2015 2:37:28 PM org.apache.jk.common.ChannelSocket init
    INFO: JK: ajp13 listening on /0.0.0.0:8009
    Jan 20, 2015 2:37:28 PM org.apache.jk.server.JkMain start
    INFO: Jk running ID=0 time=0/31 config=null
    Jan 20, 2015 2:37:28 PM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 671 ms

    Can you help me to fix it?

  19. Hello David ,
    I am using pentaho 5.2
    I have bypassed the built-in security on the BA Server by giving all permissions to anonymous users.
    I followed the following link – https://help.pentaho.com/Documentation/5.1/0P0/150/040
    It worked fine , but the issue is i cannot upload the reports from user console as the dashboard is not visible.
    User console is blank with “Anonymous” dropdown on the top right.
    What else settings i should do so that the user console gets displayed and i can upload my .prpt files from user console itself.

  20. Pingback: Estado HTTP 404 – /pentaho/Home | 我爱源码网

  21. Pingback: Estado HTTP 404 - /pentaho/Home - Technology

  22. Hello David and another users! I have Http 404 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘filterChainProxy’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘basicProcessingFilter’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security.xml]: Cannot resolve reference to bean ‘authenticationManager’ while setting bean property ‘authenticationManager’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘authenticationManager’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security.xml]: Cannot create inner bean ‘pen:bean#40233b8d’ of type [org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder] while setting bean property ‘providers’ with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#40233b8d’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.springframework.security.providers.dao.DaoAuthenticationProvider#1’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot create inner bean ‘pen:bean#440eca83’ of type [org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder] while setting bean property ‘userDetailsService’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#440eca83’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘cachingUserDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystempentahoObjects.spring.xml]: Cannot resolve reference to bean ‘UserDetailsService’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘UserDetailsService’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380) at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255) at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199) at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4206) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4705) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘basicProcessingFilter’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security.xml]: Cannot resolve reference to bean ‘authenticationManager’ while setting bean property ‘authenticationManager’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘authenticationManager’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security.xml]: Cannot create inner bean ‘pen:bean#40233b8d’ of type [org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder] while setting bean property ‘providers’ with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#40233b8d’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.springframework.security.providers.dao.DaoAuthenticationProvider#1’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot create inner bean ‘pen:bean#440eca83’ of type [org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder] while setting bean property ‘userDetailsService’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#440eca83’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘cachingUserDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystempentahoObjects.spring.xml]: Cannot resolve reference to bean ‘UserDetailsService’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘UserDetailsService’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:168) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:884) at org.springframework.security.intercept.web.FIDSToFilterChainMapConverter.(FIDSToFilterChainMapConverter.java:54) at org.springframework.security.util.FilterChainProxy.afterPropertiesSet(FilterChainProxy.java:119) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) … 39 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘authenticationManager’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security.xml]: Cannot create inner bean ‘pen:bean#40233b8d’ of type [org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder] while setting bean property ‘providers’ with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#40233b8d’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.springframework.security.providers.dao.DaoAuthenticationProvider#1’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot create inner bean ‘pen:bean#440eca83’ of type [org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder] while setting bean property ‘userDetailsService’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#440eca83’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘cachingUserDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystempentahoObjects.spring.xml]: Cannot resolve reference to bean ‘UserDetailsService’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘UserDetailsService’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:230) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:117) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveManagedList(BeanDefinitionValueResolver.java:287) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:126) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) … 56 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#40233b8d’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.springframework.security.providers.dao.DaoAuthenticationProvider#1’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot create inner bean ‘pen:bean#440eca83’ of type [org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder] while setting bean property ‘userDetailsService’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#440eca83’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘cachingUserDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystempentahoObjects.spring.xml]: Cannot resolve reference to bean ‘UserDetailsService’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘UserDetailsService’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:127) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:116) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:98) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:223) … 71 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.springframework.security.providers.dao.DaoAuthenticationProvider#1’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot create inner bean ‘pen:bean#440eca83’ of type [org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder] while setting bean property ‘userDetailsService’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#440eca83’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘cachingUserDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystempentahoObjects.spring.xml]: Cannot resolve reference to bean ‘UserDetailsService’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘UserDetailsService’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:230) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:117) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.pentaho.platform.engine.core.system.objfac.spring.SpringPentahoObjectReference.getObject(SpringPentahoObjectReference.java:47) at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:203) at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:565) at org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder.getObject(BeanBuilder.java:32) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:121) … 75 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘pen:bean#440eca83’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘cachingUserDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystempentahoObjects.spring.xml]: Cannot resolve reference to bean ‘UserDetailsService’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘UserDetailsService’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:127) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:116) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:98) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:223) … 92 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘cachingUserDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystempentahoObjects.spring.xml]: Cannot resolve reference to bean ‘UserDetailsService’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘UserDetailsService’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.pentaho.platform.engine.core.system.objfac.spring.SpringPentahoObjectReference.getObject(SpringPentahoObjectReference.java:47) at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:203) at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:565) at org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder.getObject(BeanBuilder.java:32) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:121) … 96 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘UserDetailsService’: FactoryBean threw exception on object creation; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:127) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:116) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:91) at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1288) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:275) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) … 115 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userDetailsService’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemapplicationContext-spring-security-jackrabbit.xml]: Cannot resolve reference to bean ‘userRoleDaoTxn’ while setting bean property ‘userRoleDao’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.pentaho.platform.engine.core.system.objfac.spring.SpringPentahoObjectReference.getObject(SpringPentahoObjectReference.java:47) at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:203) at org.pentaho.platform.engine.core.system.PentahoSystem.get(PentahoSystem.java:565) at org.pentaho.platform.engine.core.system.objfac.spring.BeanBuilder.getObject(BeanBuilder.java:32) at org.springframework.beans.factory.support.FactoryBeanRegistrySupport$1.run(FactoryBeanRegistrySupport.java:121) … 123 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDaoTxn’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘userRoleDao’ while setting bean property ‘target’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) … 140 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userRoleDao’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘adminJcrTemplate’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) … 153 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘adminJcrTemplate’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrAdminSessionFactory’ while setting bean property ‘sessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) … 168 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrAdminSessionFactory’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Cannot resolve reference to bean ‘jcrRepository’ while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104) at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:495) at org.springframework.beans.factory.support.ConstructorResolver.autowireConstructor(ConstructorResolver.java:162) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:925) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:835) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) … 181 more Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘jcrRepository’ defined in file [C:Pentahobiserver-cepentaho-solutionssystemrepository.spring.xml]: Invocation of init method failed; nested exception is org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:269) … 196 more Caused by: org.apache.jackrabbit.core.config.ConfigurationException: Duplicate configuration element FileSystem in Repository. at org.apache.jackrabbit.core.config.ConfigurationParser.getElement(ConfigurationParser.java:338) at org.apache.jackrabbit.core.config.ConfigurationParser.getElement(ConfigurationParser.java:314) at org.apache.jackrabbit.core.config.ConfigurationParser.parseBeanConfig(ConfigurationParser.java:110) at org.apache.jackrabbit.core.config.RepositoryConfigurationParser.parseBeanConfig(RepositoryConfigurationParser.java:356) at org.apache.jackrabbit.core.config.RepositoryConfigurationParser.getFileSystemFactory(RepositoryConfigurationParser.java:1073) at org.apache.jackrabbit.core.config.RepositoryConfigurationParser.parseRepositoryConfig(RepositoryConfigurationParser.java:305) at org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:351) at org.apache.jackrabbit.core.config.RepositoryConfig.create(RepositoryConfig.java:327) at org.springframework.extensions.jcr.jackrabbit.RepositoryFactoryBean.resolveConfigurationResource(RepositoryFactoryBean.java:91) at org.springframework.extensions.jcr.RepositoryFactoryBean.afterPropertiesSet(RepositoryFactoryBean.java:60) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335) … 206 more 2015-03-02 17:09:08,599 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho 2015-03-02 17:09:08,600 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.core.system.PentahoSystem: PentahoSystem.ERROR_0015 – Error while trying to execute shutdown sequence for org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘ICacheManager’ defined in file [C:Pentahobiserver-cepentaho-solutionssystempentahoObjects.spring.xml]: Instantiation of bean failed; nested exception is org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.pentaho.platform.plugin.services.cache.CacheManager]: Constructor threw exception; nested exception is java.lang.NullPointerException at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:883) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:826) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409) at java.security.AccessController.doPrivileged(Native Method) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380) at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164) at org.pentaho.platform.engine.core.system.objfac.spring.SpringPentahoObjectReference.getObject(SpringPentahoObjectReference.java:47) at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:203) at org.pentaho.platform.engine.core.system.objfac.AggregateObjectFactory.get(AggregateObjectFactory.java:87) at org.pentaho.platform.engine.core.system.PentahoSystem.getCacheManager(PentahoSystem.java:1097) at org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledDatasourceSystemListener.shutdown(PooledDatasourceSystemListener.java:68) at org.pentaho.platform.engine.core.system.PentahoSystem.shutdown(PentahoSystem.java:922) at org.pentaho.platform.web.http.context.SolutionContextListener.contextDestroyed(SolutionContextListener.java:236) at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4245) at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4886) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4750) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:675) at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:601) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1317) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1065) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1057) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414) Caused by: org.springframework.beans.BeanInstantiationException: Could not instantiate bean class [org.pentaho.platform.plugin.services.cache.CacheManager]: Constructor threw exception; nested exception is java.lang.NullPointerException at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:115) at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:61) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:877) … 42 more Caused by: java.lang.NullPointerException at org.pentaho.platform.engine.core.system.SystemSettings.getAbsolutePath(SystemSettings.java:182) at org.pentaho.platform.engine.core.system.PathBasedSystemSettings.getAbsolutePath(PathBasedSystemSettings.java:89) at org.pentaho.platform.engine.core.system.SystemSettings.getFile(SystemSettings.java:163) at org.pentaho.platform.engine.core.system.SystemSettings.getSystemSettingsDocument(SystemSettings.java:135)
  23. Hi mates, found the solution:

    I commented out this entries on jackrabbit xml, double-checked my quartz datasource on context.xml and after that it all went well:

    What you might want to do is to configure kettle repository after this.

    • Hello !

      I’m trying to run pentaho ce biserver 5.3 with postgre 9.1, but no luck!
      I have followed all instructions on many blogs but i keep getting the same errors.

      In my pentaho log file :

      ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
      org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘filterChainProxy’
      and many more errors creating beans with names ( ‘basicProcessingFilter’ ;’authenticationManager’ ;’pen:bean#3332625e’ ;’pen:bean#34afeb08’…and many more)

      Could anyone please help me with this !

  24. For those having the “Duplicate configuration element” error, please, make sure you don’t have duplicate items in the $/pentaho/server/biserver-ce/pentaho-solutions/system/jackrabbit/repository.xml file. Then, before starting up the server, remove the “repository” folder under $p/entaho/server/biserver-ce/pentaho-solutions/system/jackrabbit. It is created every time you start up the server and contains a copy of your repository.xml file. So, if it has a stale copy, this might be cause of the error.

    At least in Windows environment, you need to have i586 version of the Java 7. 64 bit version produces a lot of PermGen Space errors to me and the application does not work.

    I hope it helps.

  25. 2016-08-09 01:18:16,159 ERROR [org.pentaho.platform.util.logging.Logger] misc-org.pentaho.platform.engine.services.audit.AuditSQLEntry: FUNCTION hibernate.NEXTVAL does not exist
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: FUNCTION hibernate.NEXTVAL does not exist
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s