Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Job fails on random tranformation

  1. #1
    Join Date
    Apr 2010
    Posts
    14

    Question Job fails on random tranformation

    I'm dong a standard ETL from a remote MySQL server, back into the same remote server.

    I started by making individual transformations for all the different steps (about 24 transformations), then strung them together in one job.

    I've found that the job now seems to randomly stop with errors. The transformation it stops on seems to be random, and the error messages vary, bur are usually something about a failed savepoint/rollback:
    Code:
    "Unable to roll back database transaction to savepoint"
    Or unable to open a file on my local machine for outputting errors.
    Code:
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Couldn't open file \\exchange\Users\aidan\My Documents\Pentaho\event_booking_communications_err
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.core.exception.KettleException: 
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Error opening new file : org.pentaho.di.core.exception.KettleFileException: 
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.apache.commons.vfs.FileSystemException: Could not write to "file:////exchange/Users/aidan/My Documents/Pentaho/event_booking_communications_err.txt".
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Could not write to "file:////exchange/Users/aidan/My Documents/Pentaho/event_booking_communications_err.txt".
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : Could not write to "file:////exchange/Users/aidan/My Documents/Pentaho/event_booking_communications_err.txt".
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : 
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.openNewFile(TextFileOutput.java:672)
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.steps.textfileoutput.TextFileOutput.init(TextFileOutput.java:766)
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:52)
    2011/04/13 14:24:07 - event_booking_communications_err.0 - ERROR (version 4.1.0-stable, build 14410 from 2010-11-16 16.43.28 by buildguy) : java.lang.Thread.run(Unknown Source)
    Any ideas why this keeps happening? Faulty connection? I just restart the job from the transformation that failed and it carries on.

    Tanks for any help.

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

    Default

    PDI doesn't support writing directly to anonymous network shares like \\exchange\Users
    Try mounting the share first.

  3. #3
    Join Date
    Apr 2010
    Posts
    14

    Default

    Hi Matt, thanks for the response.

    That folder is already mounted, and until I hit that error, all the preceding transformations will have been writing to it without a problem.

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.