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 message of:
Failed to create service definition
ERROR 001270: Consolidating the data failed
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.
My PostgreSQL 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 geoprocessing services.