i have esri enterprise geodatabase (10.2.2) on mssql server 2012 and want to migrate to postgis(postgreSQL).
i get the following error:
Bulk copy failed on table 'table name' using delimiter ':' error was ERROR: column has Z dimension but geometry doesnot CONTEXT:
can anyone please how i can solve this issue.
thanks in advance.
@tlham We've see similar Bulk Insert errors when using FME to load attributes that have a mandatory value but no default set in the database when using FME. My guess is that you have a PostGIS table configured to hold XY and your source data has a Z value - see this discussion. If you turn off the Bulk Insert then postgreSQL sometimes returns a more helpful error message.
@tlham We've see similar Bulk Insert errors when using FME to load attributes that have a mandatory value but no default set in the database when using FME. My guess is that you have a PostGIS table configured to hold XY and your source data has a Z value - see this discussion. If you turn off the Bulk Insert then postgreSQL sometimes returns a more helpful error message.
Out of curiosity, would using a 2DForcer permit bulk inserts?