Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-17170

PDI Calculator step's NVL() function cannot evaluate Internet Address as value

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Fixed
    • Affects Version/s: 8.0.0 GA
    • Fix Version/s: 8.2.0 GA
    • Component/s: Step
    • Labels:
    • Story Points:
      0
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Steps to Reproduce:
      Hide

      1. Start Spoon
      2. Open the attached transformation
      3. Run and observe KettleStepException

      Show
      1. Start Spoon 2. Open the attached transformation 3. Run and observe KettleStepException

      Description

      Using NVL() function in PDI Calculator step to evaluate IP address values in the incoming fields results in the following error:

      2018/04/09 13:01:45 - Calculator.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : !Calculator.ErrorInStepRunning : 
      2018/04/09 13:01:45 - Calculator.0 - Internet Address: it's not possible to convert from Internet Address to a date
      2018/04/09 13:01:45 - Calculator.0 - !
      2018/04/09 13:01:45 - Calculator.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : Unexpected error
      2018/04/09 13:01:45 - Calculator.0 - ERROR (version 8.0.0.0-28, build 8.0.0.0-28 from 2017-11-05 07.27.50 by buildguy) : org.pentaho.di.core.exception.KettleStepException: 
      2018/04/09 13:01:45 - Calculator.0 - Error while running the step 
      2018/04/09 13:01:45 - Calculator.0 - 
      2018/04/09 13:01:45 - Calculator.0 - Internet Address: it's not possible to convert from Internet Address to a date
      2018/04/09 13:01:45 - Calculator.0 - 
      2018/04/09 13:01:45 - Calculator.0 - 
      2018/04/09 13:01:45 - Calculator.0 - 	at org.pentaho.di.trans.steps.calculator.Calculator.processRow(Calculator.java:179)
      2018/04/09 13:01:45 - Calculator.0 - 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
      2018/04/09 13:01:45 - Calculator.0 - 	at java.lang.Thread.run(Thread.java:745)
      2018/04/09 13:01:45 - Calculator.0 - Caused by: org.pentaho.di.core.exception.KettleValueException: 
      2018/04/09 13:01:45 - Calculator.0 - Internet Address: it's not possible to convert from Internet Address to a date
      2018/04/09 13:01:45 - Calculator.0 - 
      2018/04/09 13:01:45 - Calculator.0 - 	at org.pentaho.di.core.row.value.ValueMetaInternetAddress.getDate(ValueMetaInternetAddress.java:156)
      2018/04/09 13:01:45 - Calculator.0 - 	at org.pentaho.di.core.row.value.ValueMetaDate.getNativeDataType(ValueMetaDate.java:56)
      2018/04/09 13:01:45 - Calculator.0 - 	at org.pentaho.di.core.row.ValueDataUtil.nvl(ValueDataUtil.java:1171)
      2018/04/09 13:01:45 - Calculator.0 - 	at org.pentaho.di.trans.steps.calculator.Calculator.calcFields(Calculator.java:324)
      2018/04/09 13:01:45 - Calculator.0 - 	at org.pentaho.di.trans.steps.calculator.Calculator.processRow(Calculator.java:163)
      2018/04/09 13:01:45 - Calculator.0 - 	... 2 more
      

      Seemingly, nvl object is not correctly setting the metadata type and defaults to Date? Please, investigate.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              ikirianov Igor Kirianov
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: