Buenos días gente, estoy teniendo un problema al querer correr el script kitchen.sh. Como dice la documentación, ya instalé el postgresql-contrib-9.6 (9.6 en mi caso), aca les paso para corroborar que esta instalado:
root@wichiwtest:/usr/local/pentaho/data-integration # dpkg -l |grep postgres
ii pgdg-keyring 2018.2 all keyring for apt.postgresql.org
ii postgresql-9.6 9.6.14-1.pgdg90+1 amd64 object-relational SQL database, version 9.6 server
ii postgresql-client-9.6 9.6.14-1.pgdg90+1 amd64 front-end programs for PostgreSQL 9.6
ii postgresql-client-common 203.pgdg90+1 all manager for multiple PostgreSQL client versions
ii postgresql-common 203.pgdg90+1 all PostgreSQL database-cluster manager
ii postgresql-contrib-9.6 9.6.14-1.pgdg90+1 amd64 additional facilities for PostgreSQL
Luego, al querer correr el script me aparece lo siguiente:
root@wichiwtest:/usr/local/pentaho/data-integration # sudo -u pentaho ./kitchen.sh \ -file=“/tmp/SIU-Wichi_6.5.0/etl/creacion_base_datos/principal_crear_siu_wichi.kjb” \ -param=“base_clave=postgres” \ -param=“base_nombre=siu_wichi” \ -param=“base_host=wichidbtest.rec.uba.ar” \ -param=“base_puerto=5432” \ -param=“base_usuario=postgres”
Java HotSpot™ 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
11:58:54,330 INFO [KarafInstance]
*** Karaf Instance Number: 1 at /usr/local/pentaho/data-integration/./syste ***
*** m/karaf/caches/default/data-1 ***
*** Karaf Port:8802 ***
*** OSGI Service Port:9051 ***
11:58:54,331 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
Jul 16, 2019 11:58:54 AM org.apache.karaf.main.Main$KarafLockCallback lockAquired
INFO: Lock acquired. Setting startlevel to 100
2019/07/16 11:58:55 - Kitchen - Start of run.
2019/07/16 11:58:56 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
Jul 16, 2019 11:58:58 AM org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
INFO: New Caching Service registered
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/local/pentaho/data-integration/launcher/…/lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/pentaho/data-integration/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
Processing stopped because of an error:
Unable to load the job from XML file [/tmp/SIU-Wichi_6.5.0/etl/creacion_base_datos/principal_crear_siu_wichi.kjb]
Unable to read file [file:///usr/local/pentaho/data-integration//tmp/SIU-Wichi_6.5.0/etl/creacion_base_datos/principal_crear_siu_wichi.kjb]
Could not read from “file:///usr/local/pentaho/data-integration//tmp/SIU-Wichi_6.5.0/etl/creacion_base_datos/principal_crear_siu_wichi.kjb” because it is not a file.
ERROR: Kitchen can’t continue because the job couldn’t be loaded.
Me fije que la ruta estuviera bien, y lo está. Pensé que se trataba de permisos y le hice un chown a la carpeta /tmp/SIU-Wichi_6.5.0.
P.D: La Base de Datos esta corriendo en otro equipo, por eso el parametro “base_host=wichidbtest.rec.uba.ar”
Gracias!