Hi,
I'm a bit new to FME so pardon me if the question is basic:
I use FME Workbench 2018.1.
I have a PostGIS table with 1035 polygon features which needs to be updated (Table A). The update source is a WFS layer with 27 polygon features, among which 26 are updated features and 1 new feature to be added to Table A.
The workflow is as follows:
1. Since the WFS has a different schema to Table A, I use AttributeManager to make the WFS attribute table consistent with Table A.
2. I use Tester to filter out the 1009 features that don't need to be updated.
3. I write the filtered 1009 features and the 27 updated/new features from WFS to Table A, hoping to get an updated layer with 1036 features. I have the following feature type settings:
-Table A has a column 'gdb_geomattr_data' which seems to store geometry, so I set the Spatial Column of the writer as 'gdb_geomattr_data'
-Table definition set to 'Automatic'
-Create Generic Spatial Columns: No
-Bulk Insert: No
-Table name: Table A
-Geometry: postgis_geometry
-Feature Operation: Insert
-Table Handling: Drop and Create
Unfortunately, although the translation succeeded and looks all good in Inspector, when I tried to load the layer in ArcGIS, an error popped up: 'Error opening feature class. The field is not nullable.'
Anyone know what that means and where went wrong?
Thanks a million.
