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

Jobs/Transformations within the Main Job configured to run on SSL enabled server fail with HTTP Status 400 Error.

    XMLWordPrintable

    Details

    • Story Points:
      5
    • 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
      • Configure Pentaho Server with SSL.
      • Configure PDI Client to connect to the SSL enabled server.
      • Download the attached Sample. Modify the path as per your environment.
      • Configure a Slave server to communicate with the HTTPS port.
      • Configure Run Configuration with the above Slave server.
      • In the attached sample, you will notice SJ_Main and S_Trans are configured for Slave server under Run Configuration ( Options tab )
      • Execute the Main Job J_Main remotely or local
      • Notice the Sub Job and Transformation fail with Error HTTP Status 400 - http://divya:8443/pentaho/kettle/registerPackage/?type=trans&load=S_Trans.ktr -
      Show
      Configure Pentaho Server with SSL. Configure PDI Client to connect to the SSL enabled server. Download the attached Sample. Modify the path as per your environment. Configure a Slave server to communicate with the HTTPS port. Configure Run Configuration with the above Slave server. In the attached sample, you will notice SJ_Main and S_Trans are configured for Slave server under Run Configuration ( Options tab ) Execute the Main Job J_Main remotely or local Notice the Sub Job and Transformation fail with Error HTTP Status 400 - http://divya:8443/pentaho/kettle/registerPackage/?type=trans&load=S_Trans.ktr -

      Description

      PDI server is configured with SSL and the PDI client is configured to connect to the SSL enabled server.
      Executing a Job/Transformation on the remote slave server with SSL configured fails with the below error. The issue is observed when executing from Spoon and Kitchen.

      2019/02/15 12:44:01 - SJ_Main - Start of job execution
      2019/02/15 12:44:01 - Carte - Installing timer to purge stale objects after 1440 minutes.
      2019/02/15 12:44:01 - SJ_Main - Starting entry [S_Trans]
      2019/02/15 12:44:01 - S_Trans - Using run configuration [SSL_Config]
      2019/02/15 12:44:02 - S_Trans - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Unable to open transformation: 
      2019/02/15 12:44:02 - S_Trans - HTTP Status 400 - http://divya:8443/pentaho/kettle/registerPackage/?type=trans&load=S_Trans.ktr - 
      2019/02/15 12:44:02 - S_Trans - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleException: 
      2019/02/15 12:44:02 - S_Trans - HTTP Status 400 - http://divya:8443/pentaho/kettle/registerPackage/?type=trans&load=S_Trans.ktr -
      

      However, the job/transformations do not exhibit the same error with local execution and on the server with the run configuration as "Pentaho Server"
      The issue is specific to the sub job and sub transformations which are configured to execute on the slave server( Job Entry - Edit - Option Tab ).

      Attached screenshots and logs of various tests done.

        Attachments

          Activity

            People

            Assignee:
            mleite Margarida Leite
            Reporter:
            dguru Divya Jyoti Guru
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: