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
------------------------------