Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Using Infobright Loader

  1. #1
    Join Date
    Jan 2014
    Posts
    5

    Default Using Infobright Loader

    Hi everyone...Im using a Infobright database and I need load de dimensions data whose are saved in a XML File and then I have to process a huge CSV file and load the data into the Fact Table.

    Im trying to use the Infobright Loader step and I got an error and I don´t know how to solve it.. anyone could help me please ?
    Or someone can tell how its the correct way to use the Infobright Loader step?


    This is the error:

    Infobright Loader 2.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : An error occurred intialising this step
    2014/01/24 12:28:31 - Infobright Loader 2.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
    2014/01/24 12:28:31 - Infobright Loader 2.0 - java.io.EOFException
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at java.lang.Thread.run (Thread.java:695)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at org.pentaho.di.trans.step.StepInitThread.run (StepInitThread.java:65)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoader.init (InfobrightLoader.java:128)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoaderData.databaseSetup (InfobrightLoaderData.java:90)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at com.infobright.io.InfobrightNamedPipeLoader.<init> (InfobrightNamedPipeLoader.java:137)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at com.infobright.io.ClientProxy.<init> (ClientProxy.java:63)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at com.infobright.io.ClientProxy.<init> (ClientProxy.java:80)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at java.io.DataInputStream.readUTF (DataInputStream.java:547)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at java.io.DataInputStream.readUTF (DataInputStream.java:592)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at java.io.DataInputStream.readFully (DataInputStream.java:180)
    2014/01/24 12:28:31 - Infobright Loader 2.0 -
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoaderData.databaseSetup(InfobrightLoaderData.java:110)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoader.init(InfobrightLoader.java:128)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:65)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at java.lang.Thread.run(Thread.java:695)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - Caused by: java.io.EOFException
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at java.io.DataInputStream.readFully(DataInputStream.java:180)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at java.io.DataInputStream.readUTF(DataInputStream.java:592)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at java.io.DataInputStream.readUTF(DataInputStream.java:547)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at com.infobright.io.ClientProxy.<init>(ClientProxy.java:80)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at com.infobright.io.ClientProxy.<init>(ClientProxy.java:63)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at com.infobright.io.InfobrightNamedPipeLoader.<init>(InfobrightNamedPipeLoader.java:137)
    2014/01/24 12:28:31 - Infobright Loader 2.0 - at org.pentaho.di.trans.steps.infobrightoutput.InfobrightLoaderData.databaseSetup(InfobrightLoaderData.java:90)


    Thanks!

  2. #2

    Default

    What agent port did you configure in the bulk loader step? To use the Infobright bulk loader on a remote database, you need to start the agent on the remote database server and configure the agent port to connect to the port the remote agent listens on (mine is 5555).

    To run the agent on your database server, install Java on your database server (if it isn't there already) and copy the infobright-java-3.4.jar class library from your Pentaho installation to the remote database. Then start the agent with the command line:

    $ java -jar infobright-core-3.4.jar
    INFO: Mon Jan 27 09:42:19 EST 2014: Infobright remote load agent started on port 5555

    If you want to change the port from the default (5555), you can pass the "-p" argument to the command line with a port number.

  3. #3
    Join Date
    Jan 2014
    Posts
    5

    Default

    Thanks Man!
    That was the problem and now I solved it! !

    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.