1: Caused by: org.apache.commons.vfs.FileSystemException: Multiple providers registered for URL scheme "solution"

原因: pentaho-vfs.jar版本衝突

解決方法: remove the pentaho-vfs.jar from lib directory (and application.xml declaration).

.

[@more@]

2: org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'myDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null' [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null']]

原因: JNDI data source 沒有正確配置.

解決方法: For tomcat 5.5, add following JNDI Datasource mappings in the server.xml's node

maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
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" />
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" />
factory="org.apache.commons.dbcp.BasicDataSourceFactory" maxActive="20" maxIdle="5"
maxWait="10000" username="sa" password="" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/shark" />
maxIdle="5" maxWait="10000" username="pentaho_admin" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />
maxIdle="5" maxWait="10000" username="pentaho_user" password="password"
factory="org.apache.commons.dbcp.BasicDataSourceFactory" driverClassName="org.hsqldb.jdbcDriver"
url="jdbc:hsqldb:hsql://localhost/sampledata" />

FOR TOMCAT 5.0 add following JNDI Datasource mappings in the server.xml's node, and the node should be located in node

factoryorg.apache.commons.dbcp.BasicDataSourceFactory
maxActive20
maxIdle5
maxWait10000
usernamepentaho_user
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/sampledata

factoryorg.apache.commons.dbcp.BasicDataSourceFactory
maxActive20
maxIdle5
maxWait10000
usernamepentaho_admin
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/sampledata

factoryorg.apache.commons.dbcp.BasicDataSourceFactory
maxActive20
maxIdle5
maxWait10000
usernamehibuser
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/hibernate

factoryorg.apache.commons.dbcp.BasicDataSourceFactory
maxActive20
maxIdle5
maxWait10000
usernamepentaho_user
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/quartz

factoryorg.apache.commons.dbcp.BasicDataSourceFactory
maxActive20
maxIdle5
maxWait10000
usernamesa
password
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/shark

factoryorg.apache.commons.dbcp.BasicDataSourceFactory
maxActive20
maxIdle5
maxWait10000
usernamepentaho_user
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/sampledata

3: create action sequence which only includes a jasper report, and there is a input parameter (type: request) without default value. when run the xaction ,the BI platform throws the following exception.
RuntimeContext.ERROR_0018_PARAMETER_NOT_FULFILLED.
原因: when the parameter is not specified in URL request, the input parameter must have a default value in xaction file

Pentaho 使用中發現的幾個問題和解決方法

相關文章