Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Nan error message upon loading data to Oracle

  1. #1

    Default Nan error message upon loading data to Oracle

    For some reason large amounts (as double values) from a Webservice lookup end up as "Nan" error messages when writing to an Oracle table using JDBC.

    When using SoapUi to check on returned data, the values are quite large, but the SoapUi output returns them as true values. When writing the transformation output to a text file in some cases ? turns up as value. Is there a limit to numeric values that can be handled internally?

    The data is a fairly crude and unrealistic testset including some very large = silly - amounts , not realistic in any way, but then again..

  2. #2
    Join Date
    Jun 2012
    Posts
    5,534

    Default

    Which Kettle datatype do you use - Number?
    And which datatype has the Oracle SQL column - DOUBLE PRECISION?
    Could be a driver problem, then.
    So long, and thanks for all the fish.

  3. #3

    Default

    The webservice step returns the value as double, but further-on, the datatype is set to number. I took the SQL server type DDL for the tables and converted the scripts using Oracle datamodeler. The receiving column is a float. However, the output spooled to a text file also shows ? value for certain amounts.

    edit:

    On 2nd thought, SoapUI is also returning Nan values for amounts, so it must be something having little to do with PDI, more with the service itself..
    Last edited by blom0344; 06-26-2013 at 05:59 AM.

  4. #4

    Default

    Problem must be somewhere in the webservice, like an unfortunate divide by zero. I had no luck with a formula step to check like IsNumeric, but a simple Java script step using the IsNan() worked for me. It is not listed within the steps function overview, but I managed to define a check field that allows for filtering offensive output to the target table.

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.