Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Oracle Bulk Loader error?

  1. #1

    Exclamation Oracle Bulk Loader error?

    Hi Everyone!

    I have a strange error with my Oracle Bulk Loader step. It doens't want to run. The error message in the log is always:
    Oracle Bulk Loader.0 - ERROR>Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; NO message file for product=RDBMS, facility=UL
    Oracle Bulk Loader.0 - Exit Value of sqlldr: 3

    I've googled for the error message, and they told to set the ORACLE_HOME and ORACLE_BASE parameters. I've set them, and still won't work. The strange thing, if I run the SQL Loader outside of PDI works perfectly fine, but If i want to use the Oracle Bulk Loader step, the error is always the same. What can be the problem? How to fix it?

    My enviroment: SLES 11, Oracle Client 11g, PDI 4.2 (the error still existed in 4.1)

    Thanks in advance.

  2. #2

    Default

    Can anyone tell, that it is an actual bug, or am i doing something wrong?

  3. #3
    Join Date
    Aug 2013
    Posts
    5

    Default

    Hi,
    you must set the value of ORACLE_HOME in .profile file of your user

    Something like this:
    ORACLE_BASE=/u01/app/oracle
    ORACLE_HOME=/u01/app/oracle/product/11.2.0/client_1

  4. #4
    Join Date
    Sep 2014
    Posts
    3

    Default

    Hi,

    can you upload your kettle?

    regards

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.