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

Job or Transformation name with a "#" character does not show the content on Kettle Status page

    XMLWordPrintable

    Details

    • Story Points:
      0
    • 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:
      Tatooine (Maint)
    • Steps to Reproduce:
      Hide

      1. Launch Spoon. 
      2. Connect to Pentaho Repository. 
      3. Create a new job. 
      4. Save the job as "testjob#aabc". 
      5. Execute the job on Pentaho Server. 
      6. After the job finishes, launch IE11 and open kettle/status page. 
      7. Select "testjob#aabc" in the Jobs table and click "View the dental" icon. 
      8. An error of "Job 'testjob' could not be found." occurs. 

      Show
      1. Launch Spoon.  2. Connect to Pentaho Repository.  3. Create a new job.  4. Save the job as "testjob#aabc".  5. Execute the job on Pentaho Server.  6. After the job finishes, launch IE11 and open kettle/status page.  7. Select "testjob#aabc" in the Jobs table and click "View the dental" icon.  8. An error of "Job 'testjob' could not be found." occurs. 

      Description

      For Pentaho v8.2 :

      A Job or Transformation with a # character in the naming convention(For Example Test#3123.ktr or Test#3123.kjb), executes on the Pentaho Server, Carte or Locally it gets executed. The same Job or Transformation, when tried to view on the Kettle Status Page or Carte Status Page it shows with the below message

      Message: ('Transformation/Job') name, could not be found.

      For Pentaho v8.1:

      When a Job or Transformation consists of a #,%** character in the naming convention(For Example Test#3123.ktr or Test#3123.kjb) we are not able to save them. However, when we have any other special character like !,@,$,^,&,* we are able to save, execute(Pentaho Server, Carte or Locally) and view it on the Kettle Status or Carte status page.

      Attaching the Screenshot for reference on the error.xlsx file for reference,

       

        Attachments

        1. 8.1.zip
          6.59 MB
        2. 8.2.zip
          8.88 MB
        3. error.xlsx
          88 kB
        4. hash_char.docx
          350 kB
        5. image-2020-04-21-11-23-25-839.png
          image-2020-04-21-11-23-25-839.png
          37 kB
        6. image-2020-04-21-11-23-38-884.png
          image-2020-04-21-11-23-38-884.png
          37 kB
        7. image-2020-04-21-11-59-12-829.png
          image-2020-04-21-11-59-12-829.png
          38 kB
        8. PDISpecialcharacters_Results.xlsx
          15 kB

          Activity

            People

            Assignee:
            ana.mendes Ana Rita Clemente Mendes
            Reporter:
            dguru Divya Jyoti Guru
            Votes:
            1 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: