Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Error in Excell

  1. #1

    Default Error in Excell

    In a transformation I have an Excel Output step. The name of the file is:

    ${user.home}\My Documents\export-Domain_Menu

    when I run the transformation the system log this error:

    2007/10/30 18:26:08 - Export Domain_Menu.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : Error opening new file
    2007/10/30 18:26:08 - Export Domain_Menu.0 - ERROR (version 3.0.0-RC1, build 299003 from 2007/10/01 23:14:52) : org.apache.commons.vfs.FileSystemException: Could not write to "file:///C:/Documents and Settings/Abbrescia/My Documents/export-Domain_Menu.xls.xls" because it is read-only.

    if the name is:

    ${user.home}\export-Domain_Menu

    all is ok. Where is the problem?

    Thanks

    GiGi.

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

    Default

    Check whether you already have a file with that name, or if you use that filename anywhere else in your jobs/transformations.

    Regards,
    Sven

  3. #3

    Default

    Also check the value of your user.home? You might not have "My Documents" directory in your user.home directory.

  4. #4

    Default Error in Excel output step

    - the "My Documents" directory is present
    - that filename is not used anywhere else in my transformations.
    - if a use this path "${user.home}\My Documents\Test\export-Domain_Menu" the transformation run.

    It is very strange.
    I observed (I think can be a related problem) when a create a new transformation and, I save it in c:\user home\My Documents\ I got the same error.

    Thank.

    GiGi.

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

    Default

    Something like this maybe: http://jira.pentaho.org/browse/PDI-4 The 3.0-RC2 version should have the fix.

    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.