Question

converting from esri enterprise geodatabase on mssql server to postgis


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.


2 replies

Badge +2

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

Userlevel 4

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

Reply