Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Schedule Transformation

  1. #1
    Join Date
    May 2014
    Posts
    2

    Default Schedule Transformation

    I tried running the transformation and there was no error but once I run the transformation in the scheduler it always report this error:
    2014/05/27 12:52:03 - biotime - Dispatching started for transformation [biotime]
    2014/05/27 12:52:04 - department_bio.0 - ERROR (version 5.0.6, build 1 from 2014-04-26_17-32-54 by buildguy) : An error occurred, processing will be stopped:
    2014/05/27 12:52:04 - department_bio.0 - Error occured while trying to connect to the database
    2014/05/27 12:52:04 - department_bio.0 -
    2014/05/27 12:52:04 - department_bio.0 - Error connecting to database: (using class sun.jdbc.odbc.JdbcOdbcDriver)
    2014/05/27 12:52:04 - department_bio.0 - [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    2014/05/27 12:52:04 - department_bio.0 - ERROR (version 5.0.6, build 1 from 2014-04-26_17-32-54 by buildguy) : Error initializing step [department_bio]
    2014/05/27 12:52:04 - biotime - ERROR (version 5.0.6, build 1 from 2014-04-26_17-32-54 by buildguy) : Step [department_bio.0] failed to initialize!
    2014/05/27 12:52:04 - department_bio.0 - Finished reading query, closing connection.

    Can someone explain this error? How can I solve this problem?
    Last edited by Azyl; 05-27-2014 at 08:11 AM.

  2. #2
    Join Date
    Oct 2010
    Posts
    369

    Default

    problem with your ODBC-JDBC driver check your connections and drivers

  3. #3
    Join Date
    Apr 2008
    Posts
    4,687

    Default

    Quote Originally Posted by Azyl View Post
    Can someone explain this error? How can I solve this problem?
    Watch out that you aren't pointing to a UserDSN.
    When running a scheduled task, you *AREN'T* the user you are currently running under.

    Also, the Sun JDBC-ODBC bridge is not recommended for production use.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.