I experienced several issues when publishing a geoprocessing tool with a geometric network trace as a geoprocessing service.
I based my simplified geometric tracing models on the sample on http://resources.arcgis.com/en/help/main/10.1/index.html#/Geometric_Network_Trace/00570000009v000000...
When I try publishing the result as a geoprocessing service, the Analyze functionality shows no errors or warnings, but an Error shows up once I press Publish. The database is registered with the Server and works fine in other feature/map services referring to the same data.
ERROR 001270: Consolidating the data failed.
Specifications:
ArcGIS for Desktop and Server 10.2.1
Microsoft SQL Server Express Edition with Advanced Services (64-bit) - ArcSDE Workgroup Server - 10.50.2550.0
My presumption is that the connection string referencing to the SQL Server is somehow not accepted by the geoprocessing service. Does this issue sound familiar to anyone?
The two issues might be both be related to the workspace environment settings of the model since these are relevant for:
- Flags/Barriers feature sets
- Resulting feature layer
Does someone have experience with this on how to correctly configure these?
Thanks!
Tijs