Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Database Connection Fails

  1. #1

    Default Database Connection Fails

    I have a database connection that fails the first time I run a transformation, but if I run it again it works fine. It is a SQL Connection using JTDS version 1.2.5, with Pentaho 4.3. The URL is jdbc:jtds:sqlserver://10.1.66.111/ndisc_db;instance=SS01P . The connection that fails is the source input connection. I tried using JTDS 1.3 but it fails completely.

    The SQL Server is a named instance, and Dynamic Ports is set to "0", meaning I think that it is using Dynamic Ports, if that is relevant. We have other jobs where this doesn't seems to be a problem.

    The error log is:

    Code:
    2013/07/01 21:47:56 - write_to_csv_files -  Transformation has allocated a new step: [quarterly xls].0
    2013/07/01 21:47:56 - write_to_csv_files - This transformation can be replayed with replay date: 2013/07/01 21:47:56
    2013/07/01 21:47:56 - write_to_csv_files - Initialising 6 steps...
    2013/07/01 21:47:56 - dm_get_prev_month.0 - Running on slave server #0/1.
    2013/07/01 21:47:56 - monthly xls.0 - Running on slave server #0/1.
    2013/07/01 21:47:56 - conn_ndisc_dm - New database connection defined
    2013/07/01 21:47:56 - weekly xls.0 - Running on slave server #0/1.
    2013/07/01 21:47:56 - dm_get_prev_week.0 - Running on slave server #0/1.
    2013/07/01 21:47:56 - dm_get_prev_quarter.0 - Running on slave server #0/1.
    2013/07/01 21:47:56 - conn_ndisc_dm - New database connection defined
    2013/07/01 21:47:56 - conn_ndisc_dm - New database connection defined
    2013/07/01 21:47:56 - quarterly xls.0 - Running on slave server #0/1.
    2013/07/01 21:47:56 - conn_ndisc_dm - Connected to database.
    2013/07/01 21:47:56 - conn_ndisc_dm - Auto commit off
    2013/07/01 21:47:56 - dm_get_prev_week.0 - Connected to database...
    2013/07/01 21:48:02 - dm_get_prev_month.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : An error occurred, processing will be stopped: 
    2013/07/01 21:48:02 - dm_get_prev_month.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Error occured while trying to connect to the database
    2013/07/01 21:48:02 - dm_get_prev_month.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : 
    2013/07/01 21:48:02 - dm_get_prev_month.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    2013/07/01 21:48:02 - dm_get_prev_month.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Unable to get information from SQL Server: 10.1.66.111.
    2013/07/01 21:48:02 - dm_get_prev_quarter.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : An error occurred, processing will be stopped: 
    2013/07/01 21:48:02 - dm_get_prev_quarter.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Error occured while trying to connect to the database
    2013/07/01 21:48:02 - dm_get_prev_quarter.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : 
    2013/07/01 21:48:02 - dm_get_prev_quarter.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Error connecting to database: (using class net.sourceforge.jtds.jdbc.Driver)
    2013/07/01 21:48:02 - dm_get_prev_quarter.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Unable to get information from SQL Server: 10.1.66.111.
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - conn_ndisc_dm - Statement canceled!
    2013/07/01 21:48:02 - dm_get_prev_month.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Error initializing step [dm_get_prev_month]
    2013/07/01 21:48:02 - dm_get_prev_quarter.0 - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Error initializing step [dm_get_prev_quarter]
    2013/07/01 21:48:02 - write_to_csv_files - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Step [dm_get_prev_month.0] failed to initialize!
    2013/07/01 21:48:02 - write_to_csv_files - Step [monthly xls.0] initialized flawlessly.
    2013/07/01 21:48:02 - write_to_csv_files - Step [dm_get_prev_week.0] initialized flawlessly.
    2013/07/01 21:48:02 - write_to_csv_files - Step [weekly xls.0] initialized flawlessly.
    2013/07/01 21:48:02 - write_to_csv_files - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Step [dm_get_prev_quarter.0] failed to initialize!
    2013/07/01 21:48:02 - write_to_csv_files - Step [quarterly xls.0] initialized flawlessly.
    2013/07/01 21:48:02 - dm_get_prev_month.0 - Finished reading query, closing connection.
    2013/07/01 21:48:02 - dm_get_prev_week.0 - Finished reading query, closing connection.
    2013/07/01 21:48:02 - conn_ndisc_dm - Commit on database connection [conn_ndisc_dm]
    2013/07/01 21:48:02 - conn_ndisc_dm - Connection to database closed!
    2013/07/01 21:48:02 - dm_get_prev_quarter.0 - Finished reading query, closing connection.
    2013/07/01 21:48:02 - Spoon - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : write_to_csv_files: preparing transformation execution failed
    2013/07/01 21:48:02 - Spoon - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : org.pentaho.di.core.exception.KettleException: 
    2013/07/01 21:48:02 - Spoon - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : We failed to initialize at least one step.  Execution can not begin!
    2013/07/01 21:48:02 - Spoon - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : 
    2013/07/01 21:48:02 - Spoon - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : 
    2013/07/01 21:48:02 - Spoon - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) :     at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:784)
    2013/07/01 21:48:02 - Spoon - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) :     at org.pentaho.di.ui.spoon.trans.TransGraph$22.run(TransGraph.java:3662)
    2013/07/01 21:48:02 - Spoon - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) :     at java.lang.Thread.run(Unknown Source)
    2013/07/01 21:48:02 - write_to_csv_files - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Errors detected!
    2013/07/01 21:48:02 - write_to_csv_files - ERROR (version 4.2.0-RC1, build 15366 from 2011-06-14 12.04.35 by buildguy) : Errors detected!
    Any idea? Generally if I run it once and it fails it will succeed if I run it the second time quickly enough.

  2. #2

    Default

    bump.

  3. #3
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    With dynamic ports enabled, your driver must support the SQL Server Browser service to negotiate the port, which is done over the well known port 1434 UDP.
    The Microsoft JDBC driver does support SSB, jTDS does not, I recall.
    So, use a static port. Makes it easier for the firewall girls, anyway.
    So long, and thanks for all the fish.

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.