topic Re: MapService and SQL View in Publishing and Managing Services Questions https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69146#M16 <HTML><HEAD></HEAD><BODY><P>Hi Abe, I do have a definition query on the table. I can query the data from the rest page, but I get the error "Accessing data failed" when accessing the data in a webmap in AGOL.</P></BODY></HTML> Mon, 06 Jul 2020 23:36:34 GMT JuneAcosta 2020-07-06T23:36:34Z MapService and SQL View https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69143#M13 <HTML><HEAD></HEAD><BODY><P>I am trying the publish a map service with a table from a SQL View.&nbsp; The Map service publishes but table data is not accessible.&nbsp;</P></BODY></HTML> Fri, 27 Mar 2020 20:49:49 GMT https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69143#M13 ViktoriaMagnis 2020-03-27T20:49:49Z Re: MapService and SQL View https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69144#M14 <HTML><HEAD></HEAD><BODY><P>I'm running into this same issue. Did you figure out a solution for this?</P></BODY></HTML> Mon, 06 Jul 2020 22:31:04 GMT https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69144#M14 JuneAcosta 2020-07-06T22:31:04Z Re: MapService and SQL View https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69145#M15 <HTML><HEAD></HEAD><BODY><P>I believe, from memory, you have to have a definition query on it. I usually do 'OBJECTID &gt; 0'.</P></BODY></HTML> Mon, 06 Jul 2020 23:22:45 GMT https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69145#M15 AbeCoughlin 2020-07-06T23:22:45Z Re: MapService and SQL View https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69146#M16 <HTML><HEAD></HEAD><BODY><P>Hi Abe, I do have a definition query on the table. I can query the data from the rest page, but I get the error "Accessing data failed" when accessing the data in a webmap in AGOL.</P></BODY></HTML> Mon, 06 Jul 2020 23:36:34 GMT https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69146#M16 JuneAcosta 2020-07-06T23:36:34Z Re: MapService and SQL View https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69147#M17 <HTML><HEAD></HEAD><BODY><P>Can you clarify that you’re trying to publish a table from ArcMap/ArcPro [choose one] as a service in ArcGIS/AGOL [choose one] and then sharing this in a web map in AGOL?</P><P>&nbsp;</P><P>We’re having an issue with a service created in ArcMap, published to ArcGIS Server and shared into an AGOL app currently. Maybe this is related. We have a ticket in with ESRI currently. I’ll inquire more and get back to you.</P></BODY></HTML> Mon, 06 Jul 2020 23:48:02 GMT https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69147#M17 AbeCoughlin 2020-07-06T23:48:02Z Re: MapService and SQL View https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69148#M18 <HTML><HEAD></HEAD><BODY><P>We are publishing from ArcMap and adding it to a webmap in AGOL. I opened a ticket with Esri support earlier today.</P></BODY></HTML> Tue, 07 Jul 2020 00:01:37 GMT https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69148#M18 JuneAcosta 2020-07-07T00:01:37Z Re: MapService and SQL View https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69149#M19 <HTML><HEAD></HEAD><BODY><P>Looking at the 'Developer Tools' in the browser&nbsp;(Firefox is Ctrl+Shift+K, Chrome is Ctrl+Shift+i) we identified our issue as a CORS issue. That's what our ESRI ticket is about.&nbsp;</P><P></P><P>I'll keep you informed of our issue. Please provide the response from ESRI regarding your issue.</P></BODY></HTML> Tue, 07 Jul 2020 00:09:24 GMT https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/69149#M19 AbeCoughlin 2020-07-07T00:09:24Z Re: MapService and SQL View https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/1008104#M275 <P>Did you find a resolution to this issue?&nbsp; I'm having a similar issue.</P> Wed, 09 Dec 2020 16:41:03 GMT https://community.esri.com/t5/publishing-and-managing-services-questions/mapservice-and-sql-view/m-p/1008104#M275 JayJohnsonWashoeCounty 2020-12-09T16:41:03Z