tzhang8807

portgreSQL geodatabase connection

Discussion created by tzhang8807 on Oct 7, 2013
Latest reply on Oct 7, 2013 by vangelo-esristaff
I am currently deploying working environment using this tutorial :

http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#/Publishing_the_Community_Planning_services/028s0000006p000000/ 

While I successfully created geodatabase with ArcDesktop 10.1 and postgreSQL 9.0.5, I came to the "set the data source for all layers to the new workgroup geodatabase" step.

I copied the layer into geodatabase, and as I checked the postgresql schema, the table is successfully created.
However when I tried to set the data source and pointed to the geodatabase, the error popped up:

One or more layers failed to draw:

Low Density Residential:  Attribute column not found [planning.sde.CitizenPlanningProposal]

For the record. the original data source is the the same one being copied to the geodatabase.
In other words, the data source set to a certain layer, and I copied this source layer into postgresql, and point the data source to the new location in postgresql, the error appears.

I checked the field in the layer's attribute table and the fields being created in geodatabase, they are all the same.

But the error keeps popping up.

Any help would be appreciated.
Thank you.

Outcomes