Uploaded image for project: 'Sparkl - Pentaho Application Builder'
  1. Sparkl - Pentaho Application Builder
  2. SPARKL-66

Endpoint: Unable to retrieve data from last transformation within job

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Unknown
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • 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.

      Description

      I tried to source data from the last step of transformation within a job - sample attached - but couldn't get it working.

      I understood that the approach should be: In a job you can use as many transformations as necessary. For the transformation which returns the data:
      1) Use a *Copy rows to results* step in the end
      2) Prefix the job entry name with *OUTPUT*.

      But it is still not working for me:

      I tested with following URL:
      http://localhost:8080/pentaho/plugin/bissolTableDataEditor/api/fetchDataJob?stepName=OUTPUTfetchData&paramparam_config_id=32s3a343as332sasf3

      I can see in the catalina log that the transformation returns two rows:
      2014/07/18 18:30:59 - OUTPUTfetchData - Loading transformation from XML file file:///home/dsteiner/apps/pentaho/biserver/biserver-ce-5.1.0/pentaho-solutions/system/bissolTableDataEditor/endpoints/kettle/fetchData.ktr
      2014/07/18 18:30:59 - fetchData - Dispatching started for transformation [fetchData]
      2014/07/18 18:30:59 - Table input.0 - Finished reading query, closing connection.
      2014/07/18 18:30:59 - Table input.0 - Finished processing (I=2, O=0, R=0, W=2, U=0, E=0)
      2014/07/18 18:30:59 - Copy rows to result.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
      2014/07/18 18:30:59 - fetchDataJob - Starting entry [Success]
      2014/07/18 18:30:59 - fetchDataJob - Finished job entry [Success] (result=[true])

      In the web browser I see:

      {"result":true,"exitStatus":0,"nrRows":0,"nrErrors":0}

      So somewhere I must be still doing something wrong ... or is this just now working yet ... please clarify. Please find attached my job and transformations.

        PractiTest Integration




          Attachments

          1. fetchConfig.ktr
            39 kB
          2. fetchData.ktr
            10 kB
          3. fetchDataJob.kjb
            14 kB

            Issue Links

              Activity

                People

                Assignee:
                graimundo Guilherme Raimundo
                Reporter:
                diddy Diethard Steiner
                Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                  Dates

                  Created:
                  Updated:
                  Resolved: