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

JSON Input: "Last modification field" does not show millisecond information when running the transformation on the Pentaho Server on Centos/RHEL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Duplicate
    • Affects Version/s: 8.3.0 GA, 9.1.0 GA, 9.1.0.4 GA, 8.3.0.21
    • Fix Version/s: None
    • Component/s: Step
    • Labels:
      None
    • Story Points:
      3
    • 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.
    • Sprint Team:
      Mos Eisley
    • Steps to Reproduce:
      Hide

      Steps to replicate the issue:

      • Use Spoon 8.3 or 9.1 on your Windows10 machine
      • Use Pentaho Server 8.3 or 9.1 on the Centos/RHEL
      • Connect to the repository. Open the attached transformation 102073Sampletransformation.ktrand save it into the repository.
      • Download the attached JSON file test01.json and place it on to your Centos/RHEL machine where Pentaho server is running.
      • On your Spoon, create a Slave Server and a new Run Configuration pointing to your remote Pentaho server.
      • Run the transformation on the server by selecting the new Run Configuration from the spoon.

      NOTE: Change the path of the JSON file and the output file as per your environment.

       

      Actual result


      name,lastmodify_field
      ABCDE,2021/06/09 12:37:40.000

       
      Expected result


      name,lastmodify_field
      ABCDE,2021/06/09 12:37:40.787

      Show
      Steps to replicate the issue: Use Spoon 8.3 or 9.1 on your Windows10 machine Use Pentaho Server 8.3 or 9.1 on the Centos/RHEL Connect to the repository. Open the attached transformation  102073Sampletransformation.ktr and save it into the repository. Download the attached JSON file  test01.json and place it on to your Centos/RHEL machine where Pentaho server is running. On your Spoon, create a Slave Server and a new Run Configuration pointing to your remote Pentaho server. Run the transformation on the server by selecting the new Run Configuration from the spoon. NOTE: Change the path of the JSON file and the output file as per your environment.   Actual result name,lastmodify_field ABCDE,2021/06/09 12:37:40. 000   Expected result name,lastmodify_field ABCDE,2021/06/09 12:37:40. 787

      Description

      When running the transformation having the Json Input step with "Last modification field" set under the "Additional output fields" remotely on the server running on Centos/RHEL, the field does not show the millisecond information. Refer to the screenshot below:

       

      The same transformation when executed on the Pentaho Server running on Window, we get the expected result. Refer to the screenshot below

       

        Attachments

        1. 102073Sampletransformation.ktr
          15 kB
        2. 8308Last_Modified_Date.PNG
          8308Last_Modified_Date.PNG
          155 kB
        3. lastmodifiedtime.PNG
          lastmodifiedtime.PNG
          25 kB
        4. test01.json
          0.0 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              gdev Gurudev
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: