Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: "Xbase input" not accept fields from "Get file names"

  1. #1
    Join Date
    Dec 2007
    Posts
    6

    Unhappy "Xbase input" not accept fields from "Get file names"

    Hi, I'm form Argentina (sorry for my English) and I have problems with a transformation.

    This transformation is very simple, it gets file names from a directory and send them to an Xbase Input step. This worked fine in Kettle 2.5.1 but when I upgraded to v3.0.0 (Windows) stopped working.

    It is easy to duplicate the error. Only you need to check "Accept file names from previous step" in Xbase Input and then right click Xbase Input and select "Show input fields". It show "I couldn't find any fields".

    I'll appreciate any help. And thanks in advance.

  2. #2
    Join Date
    Dec 2007
    Posts
    6

    Default

    Hi again.

    Can anybody help me? I'm totally lost with this problem!!

    Thanks.

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

    Default

    Raise a JIRA at http://jira.pentaho.org/browse/PDI

    Regards,
    Sven

  4. #4
    Join Date
    Dec 2007
    Posts
    6

    Default

    Hi:

    I have installed the new version 3.0.2 where it suppose this error is fixed but I'm still having the same problem.

    I don't know if I'm making a mistake so I attach a test Transformation and the log.

    Many thanks in advance.

    2008/02/13 08:34:47 - Spoon - Transformación abierta.
    2008/02/13 08:34:47 - Spoon - Ejecutando transformación [Prueba Xbase]...
    2008/02/13 08:34:47 - Spoon - Se ha iniciado la ejecución de la transformación.
    2008/02/13 08:34:48 - Prueba Xbase - Iniciado despacho de la transformación [Prueba Xbase]
    2008/02/13 08:34:48 - Prueba Xbase - Número de argumentos detectados:0
    2008/02/13 08:34:48 - Prueba Xbase - Esta no es una transformación de repetición
    2008/02/13 08:34:48 - Prueba Xbase - Esta transformación se puede repetir con fecha: 2008/02/13 08:34:48
    2008/02/13 08:34:48 - Prueba Xbase - Inicializaindo 3 pasos...
    2008/02/13 08:34:48 - Transformación Simulada (no hace nada).0 - Iniciando ejecución...
    2008/02/13 08:34:48 - Obtener nombres de fichero.0 - Iniciando ejecución...
    2008/02/13 08:34:48 - Entrada XBase.0 - Iniciando ejecución...
    2008/02/13 08:34:48 - Entrada XBase.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : Error desconocido en ' :
    2008/02/13 08:34:48 - Entrada XBase.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : org.pentaho.di.core.exception.KettleStepException:
    2008/02/13 08:34:48 - Entrada XBase.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : No se ha podido encontrar ficheros para procesar.
    2008/02/13 08:34:48 - Entrada XBase.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) :
    2008/02/13 08:34:48 - Entrada XBase.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.xbaseinput.XBaseInputMeta.getFields(XBaseInputMeta.java:361)
    2008/02/13 08:34:48 - Entrada XBase.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.xbaseinput.XBaseInput.processRow(XBaseInput.java:59)
    2008/02/13 08:34:48 - Entrada XBase.0 - ERROR (version 3.0.2, build 538 from 2008/02/06 13:13:19) : at org.pentaho.di.trans.steps.xbaseinput.XBaseInput.run(XBaseInput.java:236)
    2008/02/13 08:34:48 - Entrada XBase.0 - Finalizada lectura de registros, cerrando fichero(s).
    2008/02/13 08:34:48 - Transformación Simulada (no hace nada).0 - Procesamiento finalizado (I=0, O=0, R=0, W=0, U=0, E=0
    2008/02/13 08:34:48 - Obtener nombres de fichero.0 - Procesamiento finalizado (I=0, O=0, R=0, W=3, U=0, E=0
    2008/02/13 08:34:48 - Spoon - La transformación ha finalizado!!
    Attached Files Attached Files

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

    Default

    It was this http://jira.pentaho.org/browse/PDI-577 JIRA... but I have to check what changed for it.

    Regards,
    Sven

  6. #6
    Join Date
    Jan 2007
    Posts
    18

    Default Xbase input - could not find any fields

    Hi

    I tried this step(Xbase input) by using Get File Names step; but the error is "I couldn't find any fields". I am using pdi-open-3.1.0-M2 version for this transformation; in fact I tried earlier version too, it didn't work.

    Thanks
    PJ

    The error stack is:

    org.pentaho.di.core.exception.KettleException:
    We failed to initialize at least one step. Execution can not begin!
    at org.pentaho.di.trans.Trans.prepareExecution(Trans.java:607)
    at org.pentaho.di.ui.spoon.trans.TransGraph.debug(TransGraph.java:2880)
    at org.pentaho.di.ui.spoon.delegates.SpoonTransformationDelegate.executeTransformation(SpoonTransformationDelegate.java:922)
    at org.pentaho.di.ui.spoon.Spoon.executeTransformation(Spoon.java:6756)
    at org.pentaho.di.ui.spoon.Spoon.executeFile(Spoon.java:6745)
    at org.pentaho.di.ui.spoon.Spoon.previewFile(Spoon.java:6735)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.pentaho.xul.EventHandler.handleMenuEvent(EventHandler.java:42)
    at org.pentaho.xul.EventHandler.handleAccessKey(EventHandler.java:64)
    at org.pentaho.xul.EventHandler.handleAccessKey(EventHandler.java:57)
    at org.pentaho.xul.swt.menu.MenuBar.handleAccessKey(MenuBar.java:56)
    at org.pentaho.di.ui.spoon.Spoon$1.keyPressed(Spoon.java:572)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendKeyEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendKeyEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.wmSysKeyDown(Unknown Source)
    at org.eclipse.swt.widgets.Control.WM_SYSKEYDOWN(Unknown Source)
    at org.eclipse.swt.widgets.Control.windowProc(Unknown Source)
    at org.eclipse.swt.widgets.Canvas.windowProc(Unknown Source)
    at org.eclipse.swt.widgets.Display.windowProc(Unknown Source)
    at org.eclipse.swt.internal.win32.OS.DispatchMessageW(Native Method)
    at org.eclipse.swt.internal.win32.OS.DispatchMessage(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:921)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:6189)
    at org.pentaho.di.ui.spoon.Spoon.run(Spoon.java:6285)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:397)

  7. #7
    Join Date
    Sep 2012
    Posts
    2

    Default

    Hi juanrr_ar, you may use an output step, say text file output, to store all the file names between "Get file names" and "Xbase input"
    You may try this, it works for me ^_^

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.