Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Cannot execute job on the server

  1. #1
    Join Date
    Aug 2008
    Posts
    7

    Default Cannot execute job on the server

    Hi there,

    I am currently trying to run a job which calls a transformation, I can get this job to run locally, but whenever I attempt to run it remotely from the server, the job locks up and I get the following error:

    2008/09/17 15:37:34 - ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)) - Sleeping: 0 minutes
    2008/09/17 15:37:34 - ctlgetFilesForProcessingV7 - Starting entry [Set job meta-data informationSGB2]
    2008/09/17 15:37:34 - Set job meta-data informationSGB2 - Opening filename : [null]
    2008/09/17 15:37:34 - Set job meta-data informationSGB2 - Opening transformation: [Set job meta-data informationSGB2] in directory [/]
    2008/09/17 15:37:34 - Set job meta-data informationSGB2 - Loading transformation from repository [Set job meta-data informationSGB2] in directory [/]
    2008/09/17 15:37:34 - Set job meta-data informationSGB2 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : A database error occured reading a transformation from the repository
    2008/09/17 15:37:34 - Set job meta-data informationSGB2 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : org.pentaho.di.core.exception.KettleException:
    2008/09/17 15:37:34 - Set job meta-data informationSGB2 - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : This file doesn't exist : Set job meta-data informationSGB2
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : org.pentaho.di.core.exception.KettleException:
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Unexpected error during transformation metadata load
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : An error occured reading a transformation from the repository
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : This file doesn't exist : Set job meta-data informationSGB2
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:767)
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:423)
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.job.Job.execute(Job.java:331)
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.job.Job.execute(Job.java:389)
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.job.Job.execute(Job.java:257)
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : at org.pentaho.di.job.Job.run(Job.java:208)
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : Caused by: org.pentaho.di.core.exception.KettleException:
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : An error occured reading a transformation from the repository
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) : This file doesn't exist : Set job meta-data informationSGB2
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7 (Thread-31)),5,main] - ERROR (version 3.0.1, build 534 from 2007/12/12 12:28:23) :
    2008/09/17 15:37:34 - Thread[ctlgetFilesForProcessingV7 (ctlgetFilesForProcessingV7

    I am not sure what this means, I have managed to get other jobs to run successfully without any of these problems...

    I am not passing any parameters to the transformation...

    All help would be greatly appreciated....

    One other question:

    I did initially have some variables defined in the transformation job, which worked fine when the transformation was run on both the server and locally....but when I tried to run the Job which called the transformation, it did not use the trandformations variables....In the meantime I have hardcoded these values as part of the transformation job, just to try another way to get arround the problem...

    Hope this does not sound all too cryptic...

    Cheers,

    Prashant

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    To me it just looks as if the job is not in your repository... using wrong names, wrong database?

    Regards,
    Sven

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.