I created a new file repository, and then moved my pentaho project files into the root folder using a file manager. I then connected to my file repository and opened(Ctrl-O) my job & transformation files(in a folder/
), then tried to run them, which threw the error below:
org.pentaho.di.core.exception.KettleXMLException:
Unable to load the job from XML file [F:/user/root/job.kjb]
Unable to read file [file:///F:/user/root/job.kjb]
Could not read from "file:///F:/user/root/job.kjb" because it is not a file.
at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:738)
at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:710)
at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:685)
at org.pentaho.di.repository.filerep.KettleFileRepository.loadJob(KettleFileRepository.java:949)
at org.pentaho.di.ui.spoon.job.JobGraph.startJob(JobGraph.java:3466)
at org.pentaho.di.ui.spoon.delegates.SpoonJobDelegate.executeJob(SpoonJobDelegate.java:1403)
at org.pentaho.di.ui.spoon.Spoon.executeJob(Spoon.java:8486)
at org.pentaho.di.ui.spoon.Spoon.executeFile(Spoon.java:8445)
at org.pentaho.di.ui.spoon.Spoon.runFile(Spoon.java:8410)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
at org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:43)
at org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:106)
at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)
at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.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.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1366)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7984)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9245)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:692)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
Caused by: org.pentaho.di.core.exception.KettleXMLException:
Unable to read file [file:///F:/user/root/job.kjb]
Could not read from "file:///F:/user/root/job.kjb" because it is not a file.
at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:561)
at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:540)
at org.pentaho.di.job.JobMeta.<init>(JobMeta.java:726)
... 35 more
Caused by: org.apache.commons.vfs2.FileNotFoundException: Could not read from "file:///F:/user/root/job.kjb" because it is not a file.
at org.apache.commons.vfs2.provider.AbstractFileObject.getInputStream(AbstractFileObject.java:1309)
at org.apache.commons.vfs2.provider.DefaultFileContent.getInputStream(DefaultFileContent.java:411)
at org.pentaho.di.core.vfs.KettleVFS.getInputStream(KettleVFS.java:270)
at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:559)
... 37 more
Caused by: java.io.FileNotFoundException: F:\user\root\job.kjb (The system cannot find the file specified)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(FileInputStream.java:195)
at java.io.FileInputStream.<init>(FileInputStream.java:138)
at org.apache.commons.vfs2.provider.local.LocalFile.doGetInputStream(LocalFile.java:241)
at org.apache.commons.vfs2.provider.AbstractFileObject.getInputStream(AbstractFileObject.java:1301)
... 40 more
I then saved(Ctrl-S) the file(s) and then they ran, however, they were also moved to the root/
from root/folder
. Why & How to resolve?