Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: PAN Unable to prepare (..) Log connection error?

  1. #1
    Join Date
    Nov 2010
    Posts
    9

    Default PAN Unable to prepare (..) Log connection error?

    When I start PAN (PDI 4.1.0), with log level=Debug, my transformation (that runs perfectly in SPOON) does not start. The last lines op PAN are:
    -------- PAN output
    (..)
    xyz - New database connection defined
    Transformatie 1 - Opening log connection [xyz]
    Unable to prepare and initialize this transformation
    C:\data-integration>
    -------- End PAN output

    The transformation should log to connection xyz. That is a MS SQL windows authenticated server (using ntlmauth.dll). No problem in SPOON.

    Is there a way to get more debug info from PAN (p.e. java exception trace).

    Carl van Denzen
    P.S. I have already put ntlmauth.dll in several places, I have changed my java.libray.path to reflect these changes. But that doesn't change the error message.

  2. #2
    Join Date
    Nov 2010
    Posts
    9

    Default

    I modified pan.java to print the stack trace and finally got this error: "(..) SQLServerDriver(..) could not establish a secure connection to SQL (..) Error: "RSA premaster secret error".
    I wonder why Spoon doesn't have this problem. Does anyone know how to solve this?

    Tip for the developers: simply add "+e" after the error message in Pan.java at line 401.

  3. #3
    Join Date
    Nov 2010
    Posts
    9

    Default

    Problem solved: I added
    set JAVA_EXT_DIRS=%JAVA_EXT_DIRS%;C:\Program Files\Java\jre6\lib\ext\

    after the other lines that set JAVA_EXT_DIRS.
    This lets ext dirs point to sunjce_provider.jar, dnsns.jar, loacledata.jar and sunpkcs11.jar.

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.