AI-Driven Solutions

 View Only
  • 1.  Erro - PGSQL 8 PDI to

    Posted 11-22-2021 11:44
    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
    ------------------------------


  • 2.  RE: Erro - PGSQL 8 PDI to

    Posted 18 days ago
    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
    ------------------------------