Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm hitting an error when publishing a model from ArcGIS Desktop 10.1 to ArcGIS Server 10.1. The model I want to publish uses a layer from a Postgres DB defined via a Query Layer in my MXD. The model is very simple for now, run the Select function on the Query Layer and return the result as a shapefile.

Publishing fails with a "Failed to create service definition" message and a "ERROR 001270: Consolidating the data failed" message in the results window.

This error links to http://resources.arcgis.com/en/help/main/10.1/index.html#//00vp0000002r001270

I have taken all of the steps mentioned therein - shortening service names, paths etc, and ensuring that the DB connection is registered in my ArcGIS Server instance. I can add the PG layer as a standalone map service which works fine.

Thanks for any help or suggestions!

EDIT: I should add that my Postgres instance (9.1.3) is not configured as an ESRI Enterprise Geodatabase, so that could be an issue? PostGIS 1.5.3 is installed on the DB, which is currently used for web mapping (MapServer) and hopefully data connections into ESRI GP services.

share|improve this question
    
make sure there are no <NULL> values in the field you are querying. I have had issues with that on other query functionality. –  Brad Nesom Nov 5 '12 at 19:06
    
Thanks Brad - I confirmed that the field I am querying does not contain <NULL>s. I also tried another model with a PG table with no <NULLS>s in any field throughout and got the same error messages. –  Jesse Cleary Nov 6 '12 at 15:32

1 Answer 1

up vote 1 down vote accepted

I made some progress here. Instead of using an existing Postgres DB, I created a totally new Postgres instance on my ArcGIS Server and used the instructions found here to create an Enterprise GDB. This works and I can then publish models with PG layers in them!

Next step is the use the documentation here on my existing Postgres DB.

I suppose it was too much to ask that ArcGIS would work with an existing Postgres DB without any tweaking...

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.