AI-Driven Solutions

  • 1.  Erro - PGSQL 8 PDI to

    Posted 4 days ago
    Edited by Leonardo Carvalho 4 days ago
    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
    ------------------------------