Question

SQLcreator returns different results data written FME2015 and dat written FME 2018

  • 8 April 2019
  • 1 reply
  • 0 views

Badge

I have an existing FME 2015 workspace that writes records to a PostgreSQL database.

With FME 2015, it writes 2626 records to the database.

With a FME 2018 workspace i count with SQLcreator the number of records in the PostgreSQL database using the next SQL statement.

 

Select

Nspname AS SchemaName, Relname, Reltuples

WHERE

Nspname NOT IN (' Pg_catalog ', ' information_schema ') AND

Relkind = ' R '

ORDER BY reltuples DESC;

 

It returns as result 2626 records

 

Now I open that same FME2015 workspace and save it as FME2018, I run that workspace again and it writes again 2626 Records.

Only, when I run workspace with the SQLcreator again, it returns as result only 1000 records.

 

In both cases, the PostgreSQL database has the correct number of records, only if they are written with 2015 The SQL statement gives the correct number of records and if they are written with 2018 then the SQLstatement gives a wrong number of records.

 

Does someone know what i do wrong?

1 reply

Userlevel 4

I think 1000 records is the default transaction size in FME for postgresql.

You should check the FME log for any warnings or errors that could explain why only the first transaction gets written.

Reply