Hitachi Vantara Pentaho Community Forums
Results 1 to 14 of 14

Thread: Error when referencing transformation in job

  1. #1
    Join Date
    Jan 2011
    Posts
    16

    Default Error when referencing transformation in job

    Hi,

    I referenced a transformation in a job. Both in the same file repository.
    Transformation started seperately works fine.
    Starting it within the job, I get an error !?!

    Message
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected error during transformation metadata load
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.run (Job.java:282)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:344)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:600)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:471)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute (JobEntryTrans.java:594)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta (JobEntryTrans.java:1122)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.repository.filerep.KettleFileRepository.loadTransformation (KettleFileRepository.java:1151)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1142)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:594)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:471)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:600)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:344)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.run(Job.java:282)
    2011/02/01 13:36:46 - TK_EREP_STG_BASE - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : A serious error occurred during job execution:


    any ideas ?

    every hint would be highly appreciated
    thx
    Armin

  2. #2

    Default

    I've got the same issue please help us

  3. #3
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    If you each give us some more information, it would help...

    Which PDI version?
    Which Platform?
    Is your Java up to date?
    Post the Job and Transform (if possible)
    Post the entire log, not just what you think is important
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  4. #4
    Join Date
    Jan 2011
    Posts
    16

    Default

    Hi,

    PDI version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy
    Windows XP Professional SP3
    JRE 1.6.0_22

    Name:  transformation.jpg
Views: 237
Size:  25.9 KBName:  job.JPG
Views: 238
Size:  9.9 KB

    2011/02/01 17:37:57 - Spoon - Starting job...
    2011/02/01 17:37:57 - Spoon - Job has ended.
    2011/02/01 17:38:23 - Spoon - Starting job...
    2011/02/01 17:38:23 - Job 1 - Start of job execution
    2011/02/01 17:38:24 - Job 1 - Starting entry [TK_DWH_DIM_IMPORT]
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected error during transformation metadata load
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.run (Job.java:282)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:344)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:600)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:471)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute (JobEntryTrans.java:594)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta (JobEntryTrans.java:1122)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.repository.filerep.KettleFileRepository.loadTransformation (KettleFileRepository.java:1151)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1142)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:594)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:471)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:600)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:344)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.run(Job.java:282)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : A serious error occurred during job execution:
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected error occurred while launching entry [TK_DWH_DIM_IMPORT.0]
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) :
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected error during transformation metadata load
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.run (Job.java:282)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:344)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:600)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:471)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute (JobEntryTrans.java:594)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta (JobEntryTrans.java:1122)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.repository.filerep.KettleFileRepository.loadTransformation (KettleFileRepository.java:1151)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.core.exception.KettleException:
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected error occurred while launching entry [TK_DWH_DIM_IMPORT.0]
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) :
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Unexpected error during transformation metadata load
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.run (Job.java:282)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:344)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:600)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.Job.execute (Job.java:471)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute (JobEntryTrans.java:594)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta (JobEntryTrans.java:1122)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : at org.pentaho.di.repository.filerep.KettleFileRepository.loadTransformation (KettleFileRepository.java:1151)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) :
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:605)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.execute(Job.java:344)
    2011/02/01 17:38:24 - Job 1 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.job.Job.run(Job.java:282)
    2011/02/01 17:38:24 - Spoon - Job has ended.


    if you need more information, let me know.

    thanks in advance
    Armin

  5. #5
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Unfortunately, since you posted screenshots rather than the transform, it's hard to tell...
    But I would get that you have got a bad pointer...

    Double Check (and / or post) your Transform Step configuration.
    If things are set up correctly, you should be able to select the Transformation entry, and from the context (right-click) menu select the option "Open Transformation" if it can find it, it will open. If it can't, you will get a blank transformation


    (you can post the log as a file, rather than a paste into the post)
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  6. #6
    Join Date
    Jan 2011
    Posts
    16

    Default

    I think the problem is, that it is not possible to open transformations or jobs, that are referenced, with double-klick or context menu. Message attached (I'm learning :-))

    I have the same problem in the repository explorer. If I try to open a job or transform I get an error message (java.lang.NullPointerException).
    I thought this is a known bug.

    Something wrong with my installation ?


    Sorry for the "wrong" postings. I'm very new in this forum and also not very familiar with PDI by now. Please be patient :-)

    Armin
    Attached Files Attached Files

  7. #7
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Quote Originally Posted by mxyzptlk View Post
    Sorry for the "wrong" postings. I'm very new in this forum and also not very familiar with PDI by now. Please be patient :-)
    There is nothing wrong with your postings! You're doing well with this, keep with us, and the community will get you sorted out.
    Last edited by gutlez; 02-01-2011 at 02:13 PM.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  8. #8
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    I still think you might not have your Transform specified correctly, though you might be right - it could be a bug.

    What do you have in your Transformation Specification tab in the Step configuration? (Double-Click the Transform Step)
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  9. #9
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    The real question is why a "File Repository" is used here. Storing xforms and jobs in a folder wasn't good enough?

  10. #10
    Join Date
    Jan 2011
    Posts
    16

    Default

    transformation spec attached.

    I have referenced the transformation from my file repository but the next time i opened the transformation spec I saw no entry in the bottom field
    Attached Images Attached Images  

  11. #11
    Join Date
    Jan 2011
    Posts
    16

    Default

    Quote Originally Posted by MattCasters View Post
    The real question is why a "File Repository" is used here. Storing xforms and jobs in a folder wasn't good enough?
    Hi,
    I did not want to use a DB-repository for reasons like deploying an version-control (that I can do without any member of our support staff)
    so I decided to work with file rep. (after searching for best practices for pdi repositories) . Not a good choice ?

  12. #12
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Simply saving to the file-system works just as well. (without a repository)

  13. #13
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Using either of the top two options works.
    I believe the bottom one is DB only.

    Also... Listen to Matt, he knows what he's talking about.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  14. #14
    Join Date
    Jan 2011
    Posts
    16

    Default

    OK ! I understand !

    I'll drop the file-repository and work with the files further on.

    Thanx to Matt and gutlez


    Armin

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.