Pentaho DI Opening transformation: [null] in directory











up vote
-1
down vote

favorite












guys!



I have problem with starting kettle job from server.
I have simple job with one trasformation. Trasformation is saved in the repository server.



job in spoon



If i start job from Pentaho local machine, the job runs successful, but transformation didn't work.



Log(very detailed):




  • Spoon - Starting job...

  • Job_test - Start of job execution

  • Job_test - exec(0, 0, START.0)

  • START - Starting job entry

  • Job_test - Starting entry [simple_upsert]

  • Job_test - exec(1, 0, simple_upsert.0)

  • simple_upsert - Starting job entry
    - simple_upsert - Opening transformation: [null] in directory [/home/.../test]

  • simple_upsert - Loading transformation from repository [test_ms_sql] in directory [/home/.../test]

  • Job_test - Starting entry [Success]

  • Job_test - exec(2, 0, Success.0)

  • Success - Starting job entry

  • Job_test - Finished job entry [Success] (result=[true])

  • Job_test - Finished job entry [simple_upsert] (result=[true])

  • Job_test - Job execution finished

  • Spoon - Job has ended.


Transformation is valid and located in directory [/home/.../test].
I tested running from local machine and pentaho server. In both cases there are same strokes and transformation didn't performed.
What does mean Opening transformation: [null]? Why job doesn't see transformation? Transformation exactly located in this directory, i browse it in settings transformation.
Who know how it resolve?










share|improve this question







New contributor




Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
























    up vote
    -1
    down vote

    favorite












    guys!



    I have problem with starting kettle job from server.
    I have simple job with one trasformation. Trasformation is saved in the repository server.



    job in spoon



    If i start job from Pentaho local machine, the job runs successful, but transformation didn't work.



    Log(very detailed):




    • Spoon - Starting job...

    • Job_test - Start of job execution

    • Job_test - exec(0, 0, START.0)

    • START - Starting job entry

    • Job_test - Starting entry [simple_upsert]

    • Job_test - exec(1, 0, simple_upsert.0)

    • simple_upsert - Starting job entry
      - simple_upsert - Opening transformation: [null] in directory [/home/.../test]

    • simple_upsert - Loading transformation from repository [test_ms_sql] in directory [/home/.../test]

    • Job_test - Starting entry [Success]

    • Job_test - exec(2, 0, Success.0)

    • Success - Starting job entry

    • Job_test - Finished job entry [Success] (result=[true])

    • Job_test - Finished job entry [simple_upsert] (result=[true])

    • Job_test - Job execution finished

    • Spoon - Job has ended.


    Transformation is valid and located in directory [/home/.../test].
    I tested running from local machine and pentaho server. In both cases there are same strokes and transformation didn't performed.
    What does mean Opening transformation: [null]? Why job doesn't see transformation? Transformation exactly located in this directory, i browse it in settings transformation.
    Who know how it resolve?










    share|improve this question







    New contributor




    Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.






















      up vote
      -1
      down vote

      favorite









      up vote
      -1
      down vote

      favorite











      guys!



      I have problem with starting kettle job from server.
      I have simple job with one trasformation. Trasformation is saved in the repository server.



      job in spoon



      If i start job from Pentaho local machine, the job runs successful, but transformation didn't work.



      Log(very detailed):




      • Spoon - Starting job...

      • Job_test - Start of job execution

      • Job_test - exec(0, 0, START.0)

      • START - Starting job entry

      • Job_test - Starting entry [simple_upsert]

      • Job_test - exec(1, 0, simple_upsert.0)

      • simple_upsert - Starting job entry
        - simple_upsert - Opening transformation: [null] in directory [/home/.../test]

      • simple_upsert - Loading transformation from repository [test_ms_sql] in directory [/home/.../test]

      • Job_test - Starting entry [Success]

      • Job_test - exec(2, 0, Success.0)

      • Success - Starting job entry

      • Job_test - Finished job entry [Success] (result=[true])

      • Job_test - Finished job entry [simple_upsert] (result=[true])

      • Job_test - Job execution finished

      • Spoon - Job has ended.


      Transformation is valid and located in directory [/home/.../test].
      I tested running from local machine and pentaho server. In both cases there are same strokes and transformation didn't performed.
      What does mean Opening transformation: [null]? Why job doesn't see transformation? Transformation exactly located in this directory, i browse it in settings transformation.
      Who know how it resolve?










      share|improve this question







      New contributor




      Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      guys!



      I have problem with starting kettle job from server.
      I have simple job with one trasformation. Trasformation is saved in the repository server.



      job in spoon



      If i start job from Pentaho local machine, the job runs successful, but transformation didn't work.



      Log(very detailed):




      • Spoon - Starting job...

      • Job_test - Start of job execution

      • Job_test - exec(0, 0, START.0)

      • START - Starting job entry

      • Job_test - Starting entry [simple_upsert]

      • Job_test - exec(1, 0, simple_upsert.0)

      • simple_upsert - Starting job entry
        - simple_upsert - Opening transformation: [null] in directory [/home/.../test]

      • simple_upsert - Loading transformation from repository [test_ms_sql] in directory [/home/.../test]

      • Job_test - Starting entry [Success]

      • Job_test - exec(2, 0, Success.0)

      • Success - Starting job entry

      • Job_test - Finished job entry [Success] (result=[true])

      • Job_test - Finished job entry [simple_upsert] (result=[true])

      • Job_test - Job execution finished

      • Spoon - Job has ended.


      Transformation is valid and located in directory [/home/.../test].
      I tested running from local machine and pentaho server. In both cases there are same strokes and transformation didn't performed.
      What does mean Opening transformation: [null]? Why job doesn't see transformation? Transformation exactly located in this directory, i browse it in settings transformation.
      Who know how it resolve?







      pentaho kettle pentaho-spoon pentaho-data-integration






      share|improve this question







      New contributor




      Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked Nov 21 at 12:22









      Nelli

      1




      1




      New contributor




      Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Nelli is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.
























          1 Answer
          1






          active

          oldest

          votes

















          up vote
          0
          down vote













          I don't know if this will help because the only hint to this issue i found, is this forum post from 12 years ago. If you are working with Repositories it seems that everytime you save the KTR, it changes it's ID inside the Repository, so you'd have to re-link it everytime. I doubt this is still an issue, as this post is from Verison 2.2 or earlier. Hope it helps.



          Other possible solution, which i doubt you missed this, is the KTR call coded in the Job step ? I've experienced a similar 'Null' pointer by trying to run a Job with an empty KTR call.






          share|improve this answer





















          • thank for reply. Forum's post i've read, unfortunately, it's not my case, i use pdi 8.0 version. And if miss path to transformation it'd error. In my case job run succesed.
            – Nelli
            Nov 21 at 14:49











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Nelli is a new contributor. Be nice, and check out our Code of Conduct.










           

          draft saved


          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53411939%2fpentaho-di-opening-transformation-null-in-directory%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          up vote
          0
          down vote













          I don't know if this will help because the only hint to this issue i found, is this forum post from 12 years ago. If you are working with Repositories it seems that everytime you save the KTR, it changes it's ID inside the Repository, so you'd have to re-link it everytime. I doubt this is still an issue, as this post is from Verison 2.2 or earlier. Hope it helps.



          Other possible solution, which i doubt you missed this, is the KTR call coded in the Job step ? I've experienced a similar 'Null' pointer by trying to run a Job with an empty KTR call.






          share|improve this answer





















          • thank for reply. Forum's post i've read, unfortunately, it's not my case, i use pdi 8.0 version. And if miss path to transformation it'd error. In my case job run succesed.
            – Nelli
            Nov 21 at 14:49















          up vote
          0
          down vote













          I don't know if this will help because the only hint to this issue i found, is this forum post from 12 years ago. If you are working with Repositories it seems that everytime you save the KTR, it changes it's ID inside the Repository, so you'd have to re-link it everytime. I doubt this is still an issue, as this post is from Verison 2.2 or earlier. Hope it helps.



          Other possible solution, which i doubt you missed this, is the KTR call coded in the Job step ? I've experienced a similar 'Null' pointer by trying to run a Job with an empty KTR call.






          share|improve this answer





















          • thank for reply. Forum's post i've read, unfortunately, it's not my case, i use pdi 8.0 version. And if miss path to transformation it'd error. In my case job run succesed.
            – Nelli
            Nov 21 at 14:49













          up vote
          0
          down vote










          up vote
          0
          down vote









          I don't know if this will help because the only hint to this issue i found, is this forum post from 12 years ago. If you are working with Repositories it seems that everytime you save the KTR, it changes it's ID inside the Repository, so you'd have to re-link it everytime. I doubt this is still an issue, as this post is from Verison 2.2 or earlier. Hope it helps.



          Other possible solution, which i doubt you missed this, is the KTR call coded in the Job step ? I've experienced a similar 'Null' pointer by trying to run a Job with an empty KTR call.






          share|improve this answer












          I don't know if this will help because the only hint to this issue i found, is this forum post from 12 years ago. If you are working with Repositories it seems that everytime you save the KTR, it changes it's ID inside the Repository, so you'd have to re-link it everytime. I doubt this is still an issue, as this post is from Verison 2.2 or earlier. Hope it helps.



          Other possible solution, which i doubt you missed this, is the KTR call coded in the Job step ? I've experienced a similar 'Null' pointer by trying to run a Job with an empty KTR call.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 21 at 13:06









          Cristian Curti

          1988




          1988












          • thank for reply. Forum's post i've read, unfortunately, it's not my case, i use pdi 8.0 version. And if miss path to transformation it'd error. In my case job run succesed.
            – Nelli
            Nov 21 at 14:49


















          • thank for reply. Forum's post i've read, unfortunately, it's not my case, i use pdi 8.0 version. And if miss path to transformation it'd error. In my case job run succesed.
            – Nelli
            Nov 21 at 14:49
















          thank for reply. Forum's post i've read, unfortunately, it's not my case, i use pdi 8.0 version. And if miss path to transformation it'd error. In my case job run succesed.
          – Nelli
          Nov 21 at 14:49




          thank for reply. Forum's post i've read, unfortunately, it's not my case, i use pdi 8.0 version. And if miss path to transformation it'd error. In my case job run succesed.
          – Nelli
          Nov 21 at 14:49










          Nelli is a new contributor. Be nice, and check out our Code of Conduct.










           

          draft saved


          draft discarded


















          Nelli is a new contributor. Be nice, and check out our Code of Conduct.













          Nelli is a new contributor. Be nice, and check out our Code of Conduct.












          Nelli is a new contributor. Be nice, and check out our Code of Conduct.















           


          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53411939%2fpentaho-di-opening-transformation-null-in-directory%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

          Calculate evaluation metrics using cross_val_predict sklearn

          Insert data from modal to MySQL (multiple modal on website)