Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Problems with the ODBC

  1. #1
    Join Date
    Aug 2007
    Posts
    12

    Default Problems with the ODBC

    Hello I started a conection using the jdbc driver including in Kettle.
    When I did a preview I can saw the data, but when I started the transformation I have this error:

    2007/10/08 21:27:51 - Spoon - Transformation opened.
    2007/10/08 21:27:51 - Spoon - Launching transformation [master_call]...
    2007/10/08 21:27:51 - Spoon - Started the transformation execution.
    2007/10/08 21:27:51 - master_call - Dispatching started for transformation [master_call]
    2007/10/08 21:27:51 - master_call - Nr of arguments detected:10
    2007/10/08 21:27:51 - master_call - This is not a replay transformation
    2007/10/08 21:27:51 - master_call - This transformation can be replayed with replay date: 2007/10/08 21:27:51
    2007/10/08 21:27:51 - master_call - Initialising 3 steps...
    2007/10/08 21:27:51 - Table input.0 - ERROR (version 2.5.1, build 1 from 2007/10/08 18:15:17) : An error occurred, processing will be stopped:
    2007/10/08 21:27:51 - Table input.0 - ERROR (version 2.5.1, build 1 from 2007/10/08 18:15:17) : Error occured while trying to connect to the database
    2007/10/08 21:27:51 - Table input.0 - ERROR (version 2.5.1, build 1 from 2007/10/08 18:15:17) :
    2007/10/08 21:27:51 - Table input.0 - ERROR (version 2.5.1, build 1 from 2007/10/08 18:15:17) : Error connecting to database: (using class com.informix.jdbc.IfxDriver)
    2007/10/08 21:27:51 - Table input.0 - ERROR (version 2.5.1, build 1 from 2007/10/08 18:15:17) : INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.
    2007/10/08 21:27:51 - Table input - ERROR (version 2.5.1, build 1 from 2007/10/08 18:15:17) : Error initializing step [Table input]
    2007/10/08 21:27:51 - Table output.0 - Connected to database [informes] (commit=1000)
    2007/10/08 21:27:51 - master_call - ERROR (version 2.5.1, build 1 from 2007/10/08 18:15:17) : Step [Table input.0] failed to initialize!
    2007/10/08 21:27:51 - master_call - ERROR (version 2.5.1, build 1 from 2007/10/08 18:15:17) : We failed to initialize at least one step. Execution can not begin!
    2007/10/08 21:27:51 - Table input.0 - Finished reading query, closing connection.
    2007/10/08 21:27:51 - Spoon - The transformation has finished!!
    I read information in informix and I pass to postgress.

    Thanks for your help.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    You use a wrong name or your informix server is setup wrong:

    "761 INFORMIXSERVER does not match either DBSERVERNAME or DBSERVERALIASES.

    Your INFORMIXSERVER environment variable does not match the DBSERVERNAME or any of the DBSERVERALIASES settings in the ONCONFIG configuration file of the server to which you are trying to connect. Check your environment variables and the ONCONFIG configuration file. Check that INFORMIXSERVER matches one of the settings in the ONCONFIG file."


    But I doubt it would make a difference between preview and real running.

    Regards,
    Sven

  3. #3
    Join Date
    Aug 2007
    Posts
    12

    Default Delete

    Hello.

    I have a table that has 200000 register and I have to update it every day, and when I used the option Update my program down.
    I got my data from pentaho to postres... So I though I can do a delete step in postgress, then a select in informix, a select row and insert in postrgres, but I have problem with the delete, how can i do to get field??

  4. #4
    Join Date
    May 2006
    Posts
    4,882

    Default

    Not... not directly anyway... as you found you can do inserts/updates, but if you want to do deletes you have to stage your data.
    Or you have to have another way of knowing which rows you deleted (but that's dependent on your applications)

    Regards,
    Sven
    Last edited by sboden; 10-08-2007 at 06:09 PM.

  5. #5

    Default Informix problem

    Has this somehow been solved in the meantime? I am having the same problem right now. I am reading values from an Excel file and use a database join step to additional info from INFORMIX. The preview of the database join step works perfectly well but I cannot run the transformation normally. I tried all kinds of things and noticed, that it also fails if I just try to right click my INFORMIX database join step and say "Show output fields". What is the difference between the preview and the real run?

    All the best,

    Axel
    http://osbi.gleichjetzt.de

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.