Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PDI - MS SQL Server Connection Error 8.0

  1. #1
    Join Date
    Nov 2017
    Posts
    2

    Default PDI - MS SQL Server Connection Error 8.0

    Hi all,
    I have pentaho-server installation on RHEL server. And spoon installed on my client. I connected my client to server repository. I tried read from a file and write to a file on server and it worked well. But i couldnt connect my server to MS SQL Database as i can do on local spoon.
    I coppied sqljdbc drivers to folders and restart server and my client. But still server couldnt access to my MS SQL database.
    Does anyone have any idea?

    [pentaho@pentahosrv80 lib]$
    [pentaho@pentahosrv80 lib]$ ll /home/pentaho/Pentaho/design-tools/data-integration/lib/sqljd*
    -rw-rw-r--. 1 pentaho pentaho 893229 Jan 17 2017 /home/pentaho/Pentaho/design-tools/data-integration/lib/sqljdbc41.jar
    -rw-rw-r--. 1 pentaho pentaho 891490 Nov 28 23:37 /home/pentaho/Pentaho/design-tools/data-integration/lib/sqljdbc42.jar
    [pentaho@pentahosrv80 lib]$



    2017/11/29 00:25:29 - PurRepository - A request has been sent to the Pentaho Server. For more details on the execution, see: http://10.10.1.18:8080/pentaho/kettle/status

    [When i loged into server with URL defined above]
    2017/11/28 23:09:14 - Export_SO_to_CIFS_OnServerRHEL74 - Dispatching started for transformation [Export_SO_to_CIFS_OnServerRHEL74]
    2017/11/28 23:09:15 - Table input.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : An error occurred, processing will be stopped:
    2017/11/28 23:09:15 - Table input.0 - Error occurred while trying to connect to the database
    2017/11/28 23:09:15 - Table input.0 -
    2017/11/28 23:09:15 - Table input.0 - Driver class 'com.microsoft.sqlserver.jdbc.SQLServerDriver' could not be found, make sure the 'MS SQL Server (Native)' driver (jar file) is installed.
    2017/11/28 23:09:15 - Table input.0 - com.microsoft.sqlserver.jdbc.SQLServerDriver
    2017/11/28 23:09:15 - Table input.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Error initializing step [Table input]
    2017/11/28 23:09:15 - Export_SO_to_CIFS_OnServerRHEL74 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Step [Table input.0] failed to initialize!
    2017/11/28 23:09:15 - Table input.0 - Finished reading query, closing connection.

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    Did you place mssql driver on the server in the /pentaho-server/tomcat/lib directory?
    The log file is telling you that the driver cannot be found.

  3. #3
    Join Date
    Nov 2017
    Posts
    2

    Default

    Yes , i also did that but i m not sure that i must copy it into tomcat\lib or in data-integrtion\lib.

    Here is the schreenshot :

    [pentaho@pentahosrv80 lib]$
    [pentaho@pentahosrv80 lib]$
    [pentaho@pentahosrv80 lib]$ ls -al /home/pentaho/Pentaho/server/pentaho-server/tomcat/lib/sqljdb*
    -rw-rw-r--. 1 pentaho pentaho 893229 Nov 29 00:08 /home/pentaho/Pentaho/server/pentaho-server/tomcat/lib/sqljdbc41.jar
    -rw-rw-r--. 1 pentaho pentaho 891490 Nov 29 00:08 /home/pentaho/Pentaho/server/pentaho-server/tomcat/lib/sqljdbc42.jar


    After i coppied the driver i restarted application with following command.

    ./ctlscript.sh stop pentahoserver
    ./ctlscript.sh start pentahoserver
    Last edited by faruk; 11-29-2017 at 04:58 AM.

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.