Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Repository files created on Mac not opening in Windows

  1. #1

    Default Repository files created on Mac not opening in Windows

    I have created all of our file-based repositories on my Mac using PDI 4.2.1. One of my colleagues installed PDI 4.2.1 on his PC (Windows 7) and get's an error when trying to open objects in via the repository browser saying "filename.ktr is not a file". However, if he just opens up the file directly through the "file" menu (not through the repository browser) it opens up just fine with no errors. I really need him to use the repository because we use repository database connections. Is there some difference between file-based repositories created on the Mac and ones created on Windows?

  2. #2

    Default

    Here is the full java output of the error:

    java.lang.reflect.InvocationTargetException: Error loading transformation
    at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:102)
    at org.eclipse.jface.operation.ModalContext.runInCurrentThread(ModalContext.java:369)
    at org.eclipse.jface.operation.ModalContext.run(ModalContext.java:313)
    at org.eclipse.jface.dialogs.ProgressMonitorDialog.run(ProgressMonitorDialog.java:495)
    at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog.open(TransLoadProgressDialog.java:110)
    at org.pentaho.di.ui.spoon.Spoon.loadObjectFromRepository(Spoon.java:3521)
    at org.pentaho.di.ui.spoon.Spoon.access$1700(Spoon.java:299)
    at org.pentaho.di.ui.spoon.Spoon$20.open(Spoon.java:3462)
    at org.pentaho.di.ui.repository.repositoryexplorer.controllers.BrowseController.openContent(BrowseController.java:311)
    at org.pentaho.di.ui.repository.repositoryexplorer.controllers.BrowseController.onDoubleClick(BrowseController.java:675)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:321)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.swt.tags.SwtTree.access$2100(SwtTree.java:95)
    at org.pentaho.ui.xul.swt.tags.SwtTree$12.doubleClick(SwtTree.java:581)
    at org.eclipse.jface.viewers.StructuredViewer$1.run(StructuredViewer.java:799)
    at org.eclipse.jface.util.SafeRunnable$3.run(SafeRunnable.java:154)
    at org.eclipse.jface.util.SafeRunnable.run(SafeRunnable.java:193)
    at org.eclipse.jface.viewers.StructuredViewer.fireDoubleClick(StructuredViewer.java:797)
    at org.eclipse.jface.viewers.StructuredViewer.handleDoubleSelect(StructuredViewer.java:1061)
    at org.eclipse.jface.viewers.StructuredViewer$4.widgetDefaultSelected(StructuredViewer.java:1173)
    at org.eclipse.jface.util.OpenStrategy.fireDefaultSelectionEvent(OpenStrategy.java:237)
    at org.eclipse.jface.util.OpenStrategy.access$0(OpenStrategy.java:234)
    at org.eclipse.jface.util.OpenStrategy$1.handleEvent(OpenStrategy.java:295)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
    at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
    at org.pentaho.di.ui.repository.repositoryexplorer.RepositoryExplorer.show(RepositoryExplorer.java:127)
    at org.pentaho.di.ui.spoon.Spoon$21$1.run(Spoon.java:3488)
    at org.eclipse.swt.widgets.RunnableLock.run(Unknown Source)
    at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Unknown Source)
    at org.eclipse.swt.widgets.Display.runAsyncMessages(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1169)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6945)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:553)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:134)
    Caused by: org.pentaho.di.core.exception.KettleXMLException:
    Unable to read file [file:///Z:/Documents/Ivy Tech/Development/PDI/350634/fact_hc_campus_headcount.ktr]
    Could not read from "file:///Z:/Documents/Ivy Tech/Development/PDI/350634/fact_hc_campus_headcount.ktr" because it is a not a file.


    at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:501)
    at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:485)
    at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2344)
    at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2326)
    at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2313)
    at org.pentaho.di.repository.filerep.KettleFileRepository.loadTransformation(KettleFileRepository.java:891)
    at org.pentaho.di.repository.filerep.KettleFileRepository.loadTransformation(KettleFileRepository.java:1186)
    at org.pentaho.di.ui.trans.dialog.TransLoadProgressDialog$1.run(TransLoadProgressDialog.java:95)
    ... 48 more
    Caused by: org.apache.commons.vfs.FileNotFoundException: Could not read from "file:///Z:/Documents/Ivy Tech/Development/PDI/350634/fact_hc_campus_headcount.ktr" because it is a not a file.
    at org.apache.commons.vfs.provider.AbstractFileObject.getInputStream(Unknown Source)
    at org.apache.commons.vfs.provider.DefaultFileContent.getInputStream(Unknown Source)
    at org.pentaho.di.core.vfs.KettleVFS.getInputStream(KettleVFS.java:237)
    at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:499)
    ... 55 more
    Caused by: java.io.FileNotFoundException: Z:\Documents\Ivy Tech\Development\PDI\350634\fact_hc_campus_headcount.ktr (The system cannot find the file specified)
    at java.io.FileInputStream.open(Native Method)
    at java.io.FileInputStream.<init>(Unknown Source)
    at org.apache.commons.vfs.provider.local.LocalFile.doGetInputStream(Unknown Source)
    ... 59 more

  3. #3

    Default

    Apparently after looking closer, it's not looking in the subdirectory for the file according to each error. It's trying to load the file from the root of the repository location every time and ignoring that these files are in folders.

  4. #4

    Default

    I copied the repository to an Ubuntu installation running PDI 4.2.1 and it works just fine. So it's definitely something with Windows (possibly Windows 7 exclusively?) that I have replicated on 3 machines now.

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

    Default

    There was some issue in 4.2.1 related to spaces in folders on Windows. However, I do believe we fixed that in 4.3.0.
    Best Google "JIRA Pentaho PDI file repository" or something along those lines.

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.