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
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_user
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/sampledata
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_user
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/sampledata
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_user
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/sampledata
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_user
passwordpassword
driverClassNameorg.hsqldb.jdbcDriver
urljdbc:hsqldb:hsql://localhost/sampledata
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14366449/viewspace-1010909/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14366449/viewspace-1010909/