Error importar datos mapuche

SIU-Wichi Técnicos Pentaho
1

Hola, buenos días. Hace poco migramos a la nueva versión de Wichi 7.1.0. Y la versión de Mapuche es 3.30.2.

Cuando reviso el archivo: /opt/pentaho/server/pentaho-server/tomcat/logs/pentaho.log

2025-05-07 10:49:47,767 INFO [org.pentaho.di] 2025/05/07 10:49:47 - INFO - Comenzando el proceso de carga de datos de Mapuche.
2025-05-07 10:49:47,770 INFO [org.pentaho.di] 2025/05/07 10:49:47 - principal_carga_mapuche - Starting entry [Leer variables_ini]
2025-05-07 10:49:47,831 INFO [org.pentaho.di] 2025/05/07 10:49:47 - variables_ini - Dispatching started for transformation [variables_ini]
2025-05-07 10:49:47,894 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Entrada Fichero de Texto.0 - Opening file: file:///opt/pentaho/SIU-Wichi/etl/carga_de_datos/mapuche/variables_iniciales.txt
2025-05-07 10:49:47,933 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Entrada Fichero de Texto.0 - Finished processing (I=2, O=0, R=0, W=1, U=1, E=0)
2025-05-07 10:49:47,940 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Setting environment variables…
2025-05-07 10:49:47,941 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable base_wichi_host to value [postgres]
2025-05-07 10:49:47,942 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable base_wichi_puerto to value [5432]
2025-05-07 10:49:47,943 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable base_wichi_nombre to value [siu_wichi]
2025-05-07 10:49:47,943 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable base_wichi_usuario to value [postgres]
2025-05-07 10:49:47,944 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable base_wichi_clave to value [1357wichi]
2025-05-07 10:49:47,944 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable cantidad_legajos to value [50000]
2025-05-07 10:49:47,945 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable carga_directorioTemporal to value [/opt/pentaho/cargas/mapuche]
2025-05-07 10:49:47,945 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable carga_instalacion to value [3-mapuche]
2025-05-07 10:49:47,945 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable url_mapuche to value [http://10.10.20.89/siu/mapuche/rest/antiguedades]
2025-05-07 10:49:47,946 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable usuario_mapuche to value [mapuche_wichi]
2025-05-07 10:49:47,946 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable clave_usuario_mapuche to value [mapuche123]
2025-05-07 10:49:47,947 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable performance_commit_size to value [10000]
2025-05-07 10:49:47,947 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Set variable carga_comentario to value
2025-05-07 10:49:47,950 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Finished after 1 rows.
2025-05-07 10:49:47,950 INFO [org.pentaho.di] 2025/05/07 10:49:47 - Asignar valor a variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2025-05-07 10:49:48,067 INFO [org.pentaho.di] 2025/05/07 10:49:48 - principal_carga_mapuche - Starting entry [buscar_instalacion]
2025-05-07 10:49:48,106 INFO [org.pentaho.di] 2025/05/07 10:49:48 - buscar_instalacion - Using run configuration [Pentaho local]
2025-05-07 10:49:48,111 INFO [org.pentaho.di] 2025/05/07 10:49:48 - buscar_instalacion - Starting entry [parametro inst presente?]
2025-05-07 10:49:48,112 INFO [org.pentaho.di] 2025/05/07 10:49:48 - buscar_instalacion - Starting entry [verificar conexión]
2025-05-07 10:49:48,163 INFO [org.pentaho.di] 2025/05/07 10:49:48 - buscar_instalacion - Starting entry [buscar_instalacion]
2025-05-07 10:49:48,202 INFO [org.pentaho.di] 2025/05/07 10:49:48 - buscar_instalacion - Using run configuration [Pentaho local]
2025-05-07 10:49:48,203 INFO [org.pentaho.di] 2025/05/07 10:49:48 - buscar_instalacion - Dispatching started for transformation [buscar_instalacion]
2025-05-07 10:49:48,404 INFO [org.pentaho.di] 2025/05/07 10:49:48 - valida_instalacion.0 - Finished reading query, closing connection
2025-05-07 10:49:48,408 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables 2.0 - Setting environment variables…
2025-05-07 10:49:48,408 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Detect empty stream con d_instalacion.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
2025-05-07 10:49:48,409 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables 2.0 - Set variable instalacion_id to value [3]
2025-05-07 10:49:48,410 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables 2.0 - Set variable instalacion_desc to value [mapuche]
2025-05-07 10:49:48,410 INFO [org.pentaho.di] 2025/05/07 10:49:48 - valida_instalacion.0 - Finished processing (I=1, O=0, R=0, W=2, U=0, E=0)
2025-05-07 10:49:48,411 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables 2.0 - Set variable fuente_dato_desc to value [SIU-Mapuche]
2025-05-07 10:49:48,415 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables 2.0 - Finished after 1 rows.
2025-05-07 10:49:48,415 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2025-05-07 10:49:48,520 INFO [org.pentaho.di] 2025/05/07 10:49:48 - obtiene_parametros.0 - Finished reading query, closing connection
2025-05-07 10:49:48,522 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Detect empty stream con parametro_instalacion.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=0)
2025-05-07 10:49:48,524 INFO [org.pentaho.di] 2025/05/07 10:49:48 - obtiene_parametros.0 - Finished processing (I=1, O=0, R=0, W=2, U=0, E=0)
2025-05-07 10:49:48,522 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables.0 - Setting environment variables…
2025-05-07 10:49:48,526 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables.0 - Set variable base_fuente_host to value [10.10.20.89]
2025-05-07 10:49:48,527 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables.0 - Set variable base_fuente_puerto to value [5432]
2025-05-07 10:49:48,528 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables.0 - Set variable base_fuente_usuario to value [postgres]
2025-05-07 10:49:48,528 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables.0 - Set variable base_fuente_clave to value [prueba]
2025-05-07 10:49:48,529 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables.0 - Set variable base_fuente_nombre to value [siu_mapuche]
2025-05-07 10:49:48,532 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables.0 - Finished after 1 rows.
2025-05-07 10:49:48,533 INFO [org.pentaho.di] 2025/05/07 10:49:48 - Set Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2025-05-07 10:49:48,558 INFO [org.pentaho.di] 2025/05/07 10:49:48 - buscar_instalacion - Starting entry [loguear conexión]
2025-05-07 10:49:48,559 INFO [org.pentaho.di] 2025/05/07 10:49:48 - INFO - Se encontró exitosamente la instalación “3-mapuche” (mapuche) para la fuente de datos 2, con base de datos en 10.10.20.89:5432/siu_mapuche .
2025-05-07 10:49:48,560 INFO [org.pentaho.di] 2025/05/07 10:49:48 - buscar_instalacion - Starting entry [verifico version]
2025-05-07 10:49:48,608 INFO [org.pentaho.di] 2025/05/07 10:49:48 - verificar_version_base_etl - Dispatching started for transformation [verificar_version_base_etl]
2025-05-07 10:49:48,661 INFO [org.pentaho.di] 2025/05/07 10:49:48 - version_etl.0 - Opening file: file:///opt/pentaho/SIU-Wichi/etl/version.txt
2025-05-07 10:49:48,662 INFO [org.pentaho.di] 2025/05/07 10:49:48 - version_etl.0 - Finished processing (I=1, O=0, R=0, W=1, U=1, E=0)
2025-05-07 10:49:48,729 INFO [org.pentaho.di] 2025/05/07 10:49:48 - version_base.0 - Finished reading query, closing connection
2025-05-07 10:49:48,732 INFO [org.pentaho.di] 2025/05/07 10:49:48 - version_base.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
2025-05-07 10:49:48,990 INFO [org.pentaho.di] 2025/05/07 10:49:48 - formatear.0 - Optimization level set to 9.
2025-05-07 10:49:49,032 INFO [org.pentaho.di] 2025/05/07 10:49:49 - join.0 - Finished processing (I=0, O=0, R=2, W=1, U=0, E=0)
2025-05-07 10:49:49,225 INFO [org.pentaho.di] 2025/05/07 10:49:49 - formatear.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2025-05-07 10:49:49,228 INFO [org.pentaho.di] 2025/05/07 10:49:49 - Filter rows.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2025-05-07 10:49:49,230 INFO [org.pentaho.di] 2025/05/07 10:49:49 - Dummy (do nothing).0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
2025-05-07 10:49:49,253 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_instalacion - Starting entry [Instalación encontrada]
2025-05-07 10:49:49,255 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_instalacion - Finished job entry [Instalación encontrada] (result=[true])
2025-05-07 10:49:49,255 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_instalacion - Finished job entry [verifico version] (result=[true])
2025-05-07 10:49:49,255 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_instalacion - Finished job entry [loguear conexión] (result=[true])
2025-05-07 10:49:49,256 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_instalacion - Finished job entry [buscar_instalacion] (result=[true])
2025-05-07 10:49:49,256 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_instalacion - Finished job entry [verificar conexión] (result=[true])
2025-05-07 10:49:49,256 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_instalacion - Finished job entry [parametro inst presente?] (result=[true])
2025-05-07 10:49:49,275 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Starting entry [Set variables]
2025-05-07 10:49:49,277 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Starting entry [buscar_configuracion_legajos]
2025-05-07 10:49:49,329 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_configuracion_legajos - Using run configuration [Pentaho local]
2025-05-07 10:49:49,330 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_configuracion_legajos - Dispatching started for transformation [buscar_configuracion_legajos]
2025-05-07 10:49:49,424 ERROR [org.pentaho.di] 2025/05/07 10:49:49 - buscar_conf.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error
2025-05-07 10:49:49,425 ERROR [org.pentaho.di] 2025/05/07 10:49:49 - buscar_conf.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2025/05/07 10:49:49 - buscar_conf.0 - An error occurred executing SQL:
2025/05/07 10:49:49 - buscar_conf.0 - SELECT valor as carga_legajos_pasivos FROM public.parametros_fuente_dato
2025/05/07 10:49:49 - buscar_conf.0 - where esquema = ‘mapuche’ and clave = ‘carga_legajos_pasivos’
2025/05/07 10:49:49 - buscar_conf.0 - ERROR: no existe la relación «public.parametros_fuente_dato»
2025/05/07 10:49:49 - buscar_conf.0 - Position: 44
2025/05/07 10:49:49 - buscar_conf.0 -
2025/05/07 10:49:49 - buscar_conf.0 - at org.pentaho.di.core.database.Database.openQuery(Database.java:1776)
2025/05/07 10:49:49 - buscar_conf.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.doQuery(TableInput.java:242)
2025/05/07 10:49:49 - buscar_conf.0 - at org.pentaho.di.trans.steps.tableinput.TableInput.processRow(TableInput.java:143)
2025/05/07 10:49:49 - buscar_conf.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2025/05/07 10:49:49 - buscar_conf.0 - at java.lang.Thread.run(Thread.java:750)
2025/05/07 10:49:49 - buscar_conf.0 - Caused by: org.postgresql.util.PSQLException: ERROR: no existe la relación «public.parametros_fuente_dato»
2025/05/07 10:49:49 - buscar_conf.0 - Position: 44
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335)
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321)
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297)
2025/05/07 10:49:49 - buscar_conf.0 - at org.postgresql.jdbc.PgStatement.executeQuery(PgStatement.java:246)
2025/05/07 10:49:49 - buscar_conf.0 - at org.pentaho.di.core.database.Database.openQuery(Database.java:1765)
2025/05/07 10:49:49 - buscar_conf.0 - … 4 more
2025-05-07 10:49:49,428 ERROR [org.pentaho.di] 2025/05/07 10:49:49 - buscar_configuracion_legajos - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Errors detected!
2025-05-07 10:49:49,429 INFO [org.pentaho.di] 2025/05/07 10:49:49 - Set Variables.0 - We didn’t receive a row while setting the default values.
2025-05-07 10:49:49,444 INFO [org.pentaho.di] 2025/05/07 10:49:49 - Set Variables.0 - Set variable carga_legajos_pasivos to value [0]
2025-05-07 10:49:49,445 INFO [org.pentaho.di] 2025/05/07 10:49:49 - Set Variables.0 - Finished after 0 rows.
2025-05-07 10:49:49,430 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_conf.0 - Finished reading query, closing connection
2025-05-07 10:49:49,449 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_conf.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
2025-05-07 10:49:49,450 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_configuracion_legajos - Transformation detected one or more steps with errors.
2025-05-07 10:49:49,451 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_configuracion_legajos - Transformation is killing the other steps!
2025-05-07 10:49:49,472 ERROR [org.pentaho.di] 2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error
2025-05-07 10:49:49,472 ERROR [org.pentaho.di] 2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : org.pentaho.di.core.exception.KettleStepException:
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Unable to get queryfields for SQL:
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - SELECT valor as carga_legajos_pasivos FROM public.parametros_fuente_dato
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - where esquema = ‘mapuche’ and clave = ‘carga_legajos_pasivos’
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 -
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Couldn’t get field info from [SELECT valor as carga_legajos_pasivos FROM public.parametros_fuente_dato
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - where esquema = ‘mapuche’ and clave = ‘carga_legajos_pasivos’]
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 -
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - ERROR: no existe la relación «public.parametros_fuente_dato»
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Position: 44
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 -
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 -
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.steps.tableinput.TableInputMeta.getFields(TableInputMeta.java:275)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.TransMeta.getThisStepFields(TransMeta.java:2055)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.TransMeta.getStepFields(TransMeta.java:1873)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1952)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1922)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.TransMeta.getPrevStepFields(TransMeta.java:1905)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.steps.detectemptystream.DetectEmptyStream.processRow(DetectEmptyStream.java:72)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at java.lang.Thread.run(Thread.java:750)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Couldn’t get field info from [SELECT valor as carga_legajos_pasivos FROM public.parametros_fuente_dato
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - where esquema = ‘mapuche’ and clave = ‘carga_legajos_pasivos’]
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 -
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - ERROR: no existe la relación «public.parametros_fuente_dato»
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Position: 44
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 -
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2562)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.core.database.Database.getQueryFields(Database.java:2409)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.trans.steps.tableinput.TableInputMeta.getFields(TableInputMeta.java:267)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - … 8 more
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Caused by: org.postgresql.util.PSQLException: ERROR: no existe la relación «public.parametros_fuente_dato»
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Position: 44
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:190)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:134)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - at org.pentaho.di.core.database.Database.getQueryFieldsFallback(Database.java:2543)
2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - … 10 more
2025-05-07 10:49:49,473 INFO [org.pentaho.di] 2025/05/07 10:49:49 - Detect empty stream carga_legajos_pasivos.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=1)
2025-05-07 10:49:49,554 ERROR [org.pentaho.di] 2025/05/07 10:49:49 - buscar_configuracion_legajos - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Errors detected!
2025-05-07 10:49:49,555 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Starting entry [loguear errores]
2025-05-07 10:49:49,556 INFO [org.pentaho.di] 2025/05/07 10:49:49 - ERROR - Finalizó con errores el proceso de carga de datos de Mapuche.
2025-05-07 10:49:49,556 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Starting entry [Abortar trabajo]
2025-05-07 10:49:49,559 ERROR [org.pentaho.di] 2025/05/07 10:49:49 - Abortar trabajo - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Aborting job.
2025-05-07 10:49:49,559 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Finished job entry [Abortar trabajo] (result=[false])
2025-05-07 10:49:49,559 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Finished job entry [loguear errores] (result=[false])
2025-05-07 10:49:49,560 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Finished job entry [buscar_configuracion_legajos] (result=[false])
2025-05-07 10:49:49,560 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Finished job entry [Set variables] (result=[false])
2025-05-07 10:49:49,560 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Finished job entry [buscar_instalacion] (result=[false])
2025-05-07 10:49:49,560 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Finished job entry [Leer variables_ini] (result=[false])
2025-05-07 10:49:49,561 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Finished job entry [loguear inicio] (result=[false])
2025-05-07 10:49:49,561 INFO [org.pentaho.di] 2025/05/07 10:49:49 - principal_carga_mapuche - Job execution finished
2025-05-07 10:49:49,567 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_configuracion_legajos - Transformation detected one or more steps with errors.
2025-05-07 10:49:49,567 INFO [org.pentaho.di] 2025/05/07 10:49:49 - buscar_configuracion_legajos - Transformation is killing the other steps!

2

Buenos dias! ciuando actualizaron a la version 7.1.0, corrieron los scripts de migracion de base de datos ubicados en <Ubicacion_descarga_repositorio>/SIU-Wichi/Paquete_Siu-Wichi/etl/migraciones_base_datos/700_710 ??

3

Hola Sabrina, me falto esa migración. Muchas gracias.

4

Ahora me tira otro error:

2025-05-07 12:03:41,213 ERROR [org.pentaho.di] 2025/05/07 12:03:41 - ft_legajos.txt.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error
2025-05-07 12:03:41,213 ERROR [org.pentaho.di] 2025/05/07 12:03:41 - ft_legajos.txt.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : org.pentaho.di.core.exception.KettleException:
2025/05/07 12:03:41 - ft_legajos.txt.0 - Error converting line
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - Couldn’t parse field [Integer] with value [02954- 41- 2865 / 2954- 46 02 94], format [#] on data row [3036].
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - Unexpected conversion error while converting value [nro_ficha String] to an Integer
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to Integer
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:651)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:445)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.trans.steps.fileinput.text.TextFileInputReader.readRow(TextFileInputReader.java:304)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.trans.steps.file.BaseFileInputStep.processRow(BaseFileInputStep.java:219)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at java.lang.Thread.run(Thread.java:750)
2025/05/07 12:03:41 - ft_legajos.txt.0 - Caused by: org.pentaho.di.core.exception.KettleException:
2025/05/07 12:03:41 - ft_legajos.txt.0 - Couldn’t parse field [Integer] with value [02954- 41- 2865 / 2954- 46 02 94], format [#] on data row [3036].
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - Unexpected conversion error while converting value [nro_ficha String] to an Integer
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to Integer
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:555)
2025/05/07 12:03:41 - ft_legajos.txt.0 - … 5 more
2025/05/07 12:03:41 - ft_legajos.txt.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2025/05/07 12:03:41 - ft_legajos.txt.0 - Unexpected conversion error while converting value [nro_ficha String] to an Integer
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to Integer
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2131)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3868)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertDataFromString(ValueMetaBase.java:4121)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:512)
2025/05/07 12:03:41 - ft_legajos.txt.0 - … 5 more
2025/05/07 12:03:41 - ft_legajos.txt.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to Integer
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1355)
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2069)
2025/05/07 12:03:41 - ft_legajos.txt.0 - … 8 more
2025/05/07 12:03:41 - ft_legajos.txt.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2025/05/07 12:03:41 - ft_legajos.txt.0 - nro_ficha String : couldn’t convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 12:03:41 - ft_legajos.txt.0 -
2025/05/07 12:03:41 - ft_legajos.txt.0 - at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1349)
2025/05/07 12:03:41 - ft_legajos.txt.0 - … 9 more
2025-05-07 12:03:41,215 INFO [org.pentaho.di] 2025/05/07 12:03:41 - ft_legajos.txt.0 - Finished processing (I=3037, O=0, R=0, W=3035, U=1, E=1)

5

Lo que esta pasando, es que en el campo telefono de la persona de la fila 3036 del archivo ft_lt_legajos.txt, estan usando el separador | para separar distintos telefonos, y justo ese es usado para separar los campos en el archivo txt, entonces esta tomando un telefono para el siguiente campo que es nro_ficha.
Podes chequear a que legajo corresponde en los txt generados en la extraccion.
Para eso, ingresas al contenedor de pentaho:
docker exec -it pentaho bash
Luego vas al directorio cd cargas/mapuche
Ahi segun recuerdo vas a tener el un zip generado en la extraccion y una carpeta desempaquetado donde vas a ver los txt generados.
Para abrir el archivo ejecutar nano ft_lt_legajos.txt
Vas a la linea del error que es la 3036 y obtenes el campo del legajo que esta causando el problema.
Con el dato del legajo, vas a la tabla mapuche.dha1 filtrando nro_persona = NRO_LEGAJO_OBTENIDO. Pueden cambiar ahi el separador | por otro.
Si este caso se repite en muchos legajos, tendriamos que mandar un parche para el ETL.
Avisame si es un caso aislado o tienen muchos registros asi..

6

Mirando el archivo nos dimos cuenta que es en el correo electrónico.

202504|5346|LENTZ|BETIANA CELESTE|1|F|37|1987-11-23|SOLT|SECU|SECU|||0|0|1|1| | |27332424225|celelentz|hotmail.com|AR-L-6300-00|Calle: PJE. 22 DE ABRIL Nro:833 Piso: Dpto: Zona:|UNLP|0203||A+|02954- 41- 2865 / 2954- 46 02 94|5346|2012|8>

7

Ahh OK, como el resto son del mismo tipo, no daba error

8

Sigue tirando error:

2025-05-07 13:16:20,995 INFO  [org.pentaho.di] 2025/05/07 13:16:20 - ft_legajos.txt.0 - Opening file: file:///opt/pentaho/cargas/mapuche/desempaquetado/ft_lt_legajos.txt
2025-05-07 13:16:21,092 ERROR [org.pentaho.di] 2025/05/07 13:16:21 - ft_legajos.txt.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : Unexpected error
2025-05-07 13:16:21,093 ERROR [org.pentaho.di] 2025/05/07 13:16:21 - ft_legajos.txt.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : org.pentaho.di.core.exception.KettleException:
2025/05/07 13:16:21 - ft_legajos.txt.0 - Error converting line
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - Couldn't parse field [Integer] with value [02954- 41- 2865 / 2954- 46 02 94], format [#] on data row [3036].
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - Unexpected conversion error while converting value [nro_ficha String] to an Integer
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to Integer
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:651)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:445)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.trans.steps.fileinput.text.TextFileInputReader.readRow(TextFileInputReader.java:304)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.trans.steps.file.BaseFileInputStep.processRow(BaseFileInputStep.java:219)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at java.lang.Thread.run(Thread.java:750)
2025/05/07 13:16:21 - ft_legajos.txt.0 - Caused by: org.pentaho.di.core.exception.KettleException:
2025/05/07 13:16:21 - ft_legajos.txt.0 - Couldn't parse field [Integer] with value [02954- 41- 2865 / 2954- 46 02 94], format [#] on data row [3036].
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - Unexpected conversion error while converting value [nro_ficha String] to an Integer
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to Integer
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:555)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        ... 5 more
2025/05/07 13:16:21 - ft_legajos.txt.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2025/05/07 13:16:21 - ft_legajos.txt.0 - Unexpected conversion error while converting value [nro_ficha String] to an Integer
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to Integer
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2131)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.core.row.value.ValueMetaBase.convertData(ValueMetaBase.java:3868)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.core.row.value.ValueMetaBase.convertDataFromString(ValueMetaBase.java:4121)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.trans.steps.fileinput.text.TextFileInputUtils.convertLineToRow(TextFileInputUtils.java:512)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        ... 5 more
2025/05/07 13:16:21 - ft_legajos.txt.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to Integer
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1355)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.core.row.value.ValueMetaBase.getInteger(ValueMetaBase.java:2069)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        ... 8 more
2025/05/07 13:16:21 - ft_legajos.txt.0 - Caused by: org.pentaho.di.core.exception.KettleValueException:
2025/05/07 13:16:21 - ft_legajos.txt.0 - nro_ficha String : couldn't convert String to number : non-numeric character found at position 6 for value [02954- 41- 2865 / 2954- 46 02 94]
2025/05/07 13:16:21 - ft_legajos.txt.0 -
2025/05/07 13:16:21 - ft_legajos.txt.0 -        at org.pentaho.di.core.row.value.ValueMetaBase.convertStringToInteger(ValueMetaBase.java:1349)
2025/05/07 13:16:21 - ft_legajos.txt.0 -        ... 9 more
2025-05-07 13:16:21,094 INFO  [org.pentaho.di] 2025/05/07 13:16:21 - ft_legajos.txt.0 - Finished processing (I=3037, O=0, R=0, W=3035, U=1, E=1)

Por lo que veo tiene que ver con una conversión a numero:

Couldn’t parse field [Integer] with value [02954- 41- 2865 / 2954- 46 02 94], format [#] on data row [3036].

Revisando el archivo parece que tiene que ver con el teléfono o celular.

Acá esta la linea del archivo que tira error:

202504|5346|LENTZ|BETIANA CELESTE|1|F|37|1987-11-23|SOLT|SECU|SECU|||0|0|1|1| | |27332424225|celelentz|hotmail.com|AR-L-6300-00|Calle: PJE. 22 DE ABRIL Nro:833 Piso: Dpto: Zona:|UNLP|0203||A+|02954- 41- 2865 / 2954- 46 02 94|5346|2012|8|DNI |33242422|2015|9||SEMP|2012-07-01||1|1|37|44|.00|LA PAMPA||0930300121500104654464
9

Buen día! Sigue siendo el mail que tiene el
separador |, tienen que modificar en base mapuche porque los txt se regeneran en cada extracción.

10

Tenes razón, el técnico de mapuche actualizo otra base de datos y no la de producción. Ahí volvimos a ejecutar el proceso y termino con éxito.

Muchas gracias Sabrina por toda tu ayuda!

11

Buenísimo!!
Saludos,
Sabrina.