Thursday, June 27, 2013

solu'n for error connecting quartz in pentaho BI server 4.8.0



In case you get this error
Failed to obtain DB connection from data source ‘myDS’: java.sql.SQLException: Could not retrieve datasource via JNDI url ‘java:comp/env/jdbc/Quartz’

Solution :- 

delete the following file
toncat/conf/Catalina/localhost/pentaho.xml
and try again. :)

7 comments:

  1. 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.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ERROR: relation "information_schema.system_sequences" does not exist
    Position: 22) [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'java:comp/env/jdbc/Quartz' org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ERROR: relation "information_schema.system_sequences" does not exist
    Position: 22)]

    ReplyDelete
  2. even after deleting file toncat/conf/Catalina/localhost/pentaho.xml and restarting pentaho i am getting same error.

    i am using bi-server CE 4.5 along with postgres db

    any help/hints will be appreciated.

    ReplyDelete
  3. have u delete pentaho.xml file from tomcat/conf/Catalina/localhost/pentaho.xml

    ReplyDelete
  4. Hi

    I am able to crack it.
    there was a problem with web.xml configs

    ReplyDelete
    Replies
    1. What was the issue Syed?

      Delete
    2. issue was with web.xml configs., in which i have to create data source object same as other configs


      Delete

Create MongoDB service in Windows OS

1) Open Command Prompt 2) Create directory for Database and Logs                    mkdir c:\data\db                     mkdir c:\...