What is the ArcGIS Pro version?

Do you use the same connectionfile when working from Pro and FME?

Versioned database?

I am on 2.6.1 and yes I am using exactly the same connection file

Not sure if this has anything to do with it, but in the next article, the correct combination should be ArcGIS Pro 2.6 / FME 2020.1.2 or higher 64 bit only.

I've also had issues with the Feature Class Qualifier. The way I write currently is <SchemaName.TableName> in the Feature Class Name field. Worth a try.

Thanks I will give it a try but I have also ArcGIS 10.5 installed on the same machine and I can see from the log file that FME is checking out a 10.5 license:

FME has checked out an Esri license. The product checked out is 'Advanced'Installed ArcGIS version is '10.5'

Connection made to server 'xxxxxxxxxxxxxx' for dataset 'dbtest' (transactional version 'sde.DEFAULT') using instance 'sde:postgresql:xxxxxxxxxxx' and user ID 'gisowner'

ArcSDE release: '10.0'. Underlying database: 'SQL Server'

And then I wonder why it says 'SQL Server' on the last line...

I have tried upgrading FME to the newest version with no luck. I have tried to insert rows to an existing table (and truncate as well) from FME and it worked so it looks like FME is not able to create the table.