If input data is corrupted (wrong format of field or wrong type), then psql process logs to standard error output and continues. This behaviour of psql is default, but can be changed by parameter ON_ERROR_STOP.
------------------------------
Brayan Cartwright
Chief Financial Officer
cisco
------------------------------
Original Message:
Sent: 11-22-2021 11:43
From: Leonardo Carvalho
Subject: Erro - PGSQL 8 PDI to
Kroger Schedule
Hello friends,
I have a problem in PDI with postgreSQL 8.
I load the input table (PGSQL) ---> output table (SQLSERVER).
If I set the limit for sql of 9997 everything works.
If I let the whole table load, I get this error:
Help me please !
2021/11/08 09:45:02 - Spoon - Running transformation using the Kettle execution engine
2021/11/08 09:45:02 - Spoon - Transformation opened.
2021/11/08 09:45:02 - Spoon - Launching transformation [index]...
2021/11/08 09:45:02 - Spoon - Started the transformation execution.
2021/11/08 09:45:03 - index - Dispatching started for transformation [index]
2021/11/08 09:45:03 - MSSQL tb_auditoria.0 - Connected to database [SQL_ SINASC] (commit=0)
2021/11/08 09:45:03 - tb_auditoria.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : Unexpected error
2021/11/08 09:45:03 - tb_auditoria.0 - ERROR (version 9.2.0.0-290, build 9.2.0.0-290 from 2021-06-02 06.36.08 by buildguy) : org.pentaho.di.core.exception.KettleDatabaseException:
2021/11/08 09:45:03 - tb_auditoria.0 - Couldn't get row from result set
2021/11/08 09:45:03 - tb_auditoria.0 - ERROR: portal "C_1" does not exist
2021/11/08 09:45:03 - tb_auditoria.0 -
------------------------------
Leonardo Carvalho
Systems Engineer
TIT
------------------------------