AnsweredAssumed Answered

Ability to serve non-sde table in Open Data

Question asked by PSLarkin_SpokaneCounty on May 11, 2017
Latest reply on Aug 4, 2017 by PSLarkin_SpokaneCounty

Solution: Don't use ESRI_OID.

TLDR: Downloading CSV's fails on Open Data. Data is served from Map Services hosting Query Layers from non-sde databases.

 

I have tables in MSSQL databases that I would like to offer on our Open Data site. I have published map services with these tables added as Query Layers, connected as either NT user ArcGISSOC and a database account. The service publishes fine and I'm able to see rows in the Data and Table tabs of AGOL and Open Data Admin site. REST queries to these services returns data as expected. Unfortunately when attempting to download the data as a spreadsheet I receive a generic error '...Something went wrong with the server....'. Logs on the server give a string of errors: 'General geodatabase error occurred , Error performing query operation. Wait time of the request to the service ... has expired, Unable to process request, no instances for .... were available for 60 seconds.'

 

Environment: 

ArcGIS Server 10.3

SQL Server 2008 R2

Example REST Endpoint

AGOL layer page

Open data page

 

I'd like to know if Open Data is configured to accept Map Services with Query Layers configured in this way. If this isn't accepted, I'd like to know if there is an alternative that does not involve uploading CSV's to AGOL.

 

Thanks for your help

 

Courtney ClaessensKlara Schmitt

Outcomes