Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Carte error while running job

  1. #1
    Join Date
    Jun 2006
    Posts
    282

    Unhappy Carte error while running job

    Hi -
    I'm running 3.0.1 and I get the following error when trying to run a remote job on carte. I ran the first trans in the job just to verify that the trans will run on carte and it runs without exception.
    Not sure what constitues as an "etnry" but I noticed that it mentions the entry as division 102.0 when the name of the trans is division 102. The main issue is that division 102 is not in the root directory in my RDBMS repo. Hence the error msg. Any Ideas ?
    Code:
     
    2008/01/10 14:45:25 - division 102 - Dispatching started for transformation [division 102]
    2008/01/10 14:45:25 - division 102 - This is not a replay transformation
    2008/01/10 14:45:25 - division 102 - This transformation can be replayed with replay date: 2008/01/10 14:45:25
    2008/01/10 14:45:25 - division 102 - Initialising 4 steps...
    2008/01/10 14:45:26 - Dimension lookup/update.0 - Connected to database...
    2008/01/10 14:45:26 - Dimension lookup/update.0 - Starting to run...
    2008/01/10 14:45:26 - Table input.0 - Starting to run...
    2008/01/10 14:45:26 - Insert / Update.0 - Starting to run...
    2008/01/10 14:45:26 - Select values.0 - Starting to run...
    2008/01/10 14:45:26 - Table input.0 - Finished reading query, closing connection.
    2008/01/10 14:45:26 - Table input.0 - Finished processing (I=87, O=0, R=0, W=87, U=0, E=0)
    2008/01/10 14:45:26 - Select values.0 - Finished processing (I=0, O=0, R=87, W=174, U=0, E=0)
    2008/01/10 14:45:27 - Insert / Update.0 - Finished processing (I=87, O=0, R=87, W=87, U=0, E=0)
    2008/01/10 14:45:27 - Dimension lookup/update.0 - Finished processing (I=87, O=45, R=87, W=87, U=0, E=0)
    2008/01/10 14:46:13 - RepositoriesMeta - Reading repositories XML file: C:\Documents and Settings\DBLOCKER\.kettle\repositories.xml
    2008/01/10 14:46:13 - Upload Dictionaries (Upload Dictionaries (Thread-32)) - Sleeping: 0 minutes
    2008/01/10 14:46:13 - Upload Dictionaries - Starting entry [division 102]
    2008/01/10 14:46:13 - division 102 - Opening filename : [null]
    2008/01/10 14:46:13 - division 102 - Opening transformation: [division 102] in directory [/]
    2008/01/10 14:46:13 - division 102 - Loading transformation from repository [division 102] in directory [/]
    2008/01/10 14:46:13 - division 102 - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : A database error occured reading a transformation from the repository
    2008/01/10 14:46:13 - division 102 - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : org.pentaho.di.core.exception.KettleException: 
    2008/01/10 14:46:13 - division 102 - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : This file doesn't exist : division 102
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : org.pentaho.di.core.exception.KettleException: 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : Unexpected error during transformation metadata load
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : An error occured reading a transformation from the repository
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : This file doesn't exist : division 102
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:776)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:427)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.job.Job.execute(Job.java:331)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.job.Job.execute(Job.java:389)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.job.Job.execute(Job.java:257)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.job.Job.run(Job.java:208)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : Caused by: org.pentaho.di.core.exception.KettleException: 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : An error occured reading a transformation from the repository
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : This file doesn't exist : division 102
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2418)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2229)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:756)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : ... 5 more
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : Caused by: org.pentaho.di.core.exception.KettleException: 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : This file doesn't exist : division 102
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2402)
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : ... 7 more
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : A serious error occurred during job execution: 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : Unexpected error occurred while launching entry [division 102.0]
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : Unexpected error during transformation metadata load
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : An error occured reading a transformation from the repository
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : This file doesn't exist : division 102
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : org.pentaho.di.core.exception.KettleException: 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : Unexpected error occurred while launching entry [division 102.0]
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : Unexpected error during transformation metadata load
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : An error occured reading a transformation from the repository
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : This file doesn't exist : division 102
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) : 
    2008/01/10 14:46:13 - Thread[Upload Dictionaries (Upload Dictionaries (Thread-32)),5,main] - ERROR (version 3.1.0, build 562 from 2008/01/08 00:05:11) :
    Last edited by microdisney; 01-10-2008 at 07:49 PM.
    "If you want to increase your success rate, double your failure rate."
    Thomas Watson, Sr (former president of IBM)

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

    Default

    I think that for remote jobs we don't pass along the repository credentials like we do for remote transformations.
    At least, I don't think I ever tested or implemented that use-case.

    Can you file a JIRA case for it?

    Thanks in advance,

    Matt

  3. #3
    Join Date
    Jan 2007
    Posts
    29

    Default

    I got the same error when i put the transformation that called within a job in transformation sub directory. Job was run successfully when i move the transformation into transformation root directory.

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.