Latest Contributions by JoshuaKeller

‎01-16-2013

Thank you for the response and verifying that moving the .sde file was appropriate. Part of my confusion was based on the fact that when initially publishing with the Database Connections path it did recognized that the datasource was not registerd and that was cleared up once I registered it, so I assumed it would re-path/copy the .sde file as necessary, however that didn't seem to happen. Yes, it does appear to attempt to create a fgdb and copy the SDE layers into that however it fails after about 15 minutes I assume due to size (~40gb of data)...staging looks to actually get about 300-500MB in a fgdb but that is corrupt so I can't verify what is in it. I logged into the server after publishing with the Database Connections path and manually updated the extracted .py file and now it does appear to execute through the rest gpservice endpoint. My one remaining limitation is figure out how to pass the path to the generated PDF back so the client can download it. Thanks again, Josh

‎01-16-2013

I am trying to use arcpy and reportlab to generate a report with maps and data tables on a server. Basically the script exports 4 maps (all from the same MXD after setting extent and changing visible layers for each map). It then creates a feature layer from SDE featureclasses using arcpy.MakeFeatureLayer_management and a selection with arcpy.SelectLayerByLocation_management. It steps through each feature and appends attributes to a list for reportlab to generate the data tables. In the end arcpy.mapping combines all of the interim PDF files into a final multi-page PDF. This all works from my workstations and generates the reports exactly how I want, however when I try publishing to 10.1 server things stop working. I've fixed most of the problems but am stuck with the SDE featureclasses (SQL 2005) that are directly referenced in the python. Initially I set a string to the path of the feature class "Database Connections\\MyDatabase.sde\\FeatureDataset\\Featureclass" which works perfect from my machine. When it analyzed the tool before publishing the datasource was not registered with the server so I registered it, then published. The GPService fails to run and the error log indicates that it can't find "Database Connections\\MyDatabase.sde\\FeatureDataset\\Featureclass". I then tried moving the .sde file to a static location (C:\temp) on my local machine and the server but now it attempts to copy the entire SDE FC to the server during publish, and won't let me register it again because it is already registered. I removed and re-registered the server and no change. The FC (there are actually 6 different ones) are ~40GB so building the .sd fails. I thought that when it went through publishing it should have replaced any reference to the registered data source with the servers registered source, but that doesn't seem to be happening or the original configuration should have worked. Any ideas as to how to fix this? Thanks

‎08-22-2012

First, thank you for the help. I did some more testing based on some of what you suggested, and started with SQL profiler and performance monitor. Based on the SQL profiler and the performance monitor SQL appears to be returning the shape for the entire US within 800-1000ms and watching the network the data all appears to be transferred within about a second, then the CPU on the AGS machine chunks away for 4-10 more seconds. So based on that, it seems like it may not be a SQL issue because SQL is getting the data to AGS within 2 seconds, AGS is then taking an extra 4-10 seconds once it gets the data to render. When it pulls the data from the network share data transfer happens slightly faster as expected, and rendering barely puts a blip on the CPU monitor. This leads me to believe that I should be focusing on the AGS server, or there is some sort of additional overhead for AGS to process the SQL data since the same exact dataset renders so much faster out of FGDB than SDE once it gets the data. If it makes any difference, SDE is using SQL geometry for the shape. Thanks, Josh

‎08-22-2012

I had expected the FGDB to be slightly faster in this circumstance, but not 5-10 seconds faster, and the odd part to me was the high CPU usage on the client (AGS) side of things with little to no activity on the SQL side. While physical hardware would be ideal it simply isn't an option we have at this point, and since I need to be able to edit features I am stuck with using SDE rather than the FGDB. Is there something I'm missing here or is this 5-10 seconds to draw a simple table to be expected? Thanks, Josh I'd always expect a local file geodatabase of a simple table with "draw all features" to run rings around an ArcSDE database (even one run on physical hardware, and not imprisoned on a VM). In order for ArcSDE to shine, you'd need 8 concurrent mapping clients to several million rows of realtime multi-user edited enterprise data, queried from a physical server via Direct Connect, where only a tiny fraction of the data is rendered in each map. -V

‎08-21-2012

I am attempting to setup two servers for testing purposes and am having a problem with connections to SDE. My setup is 2 internal virtual servers both running Windows Server 2008 R2. One is setup with SQL Server 2008 R2 and the other is setup using ArcGIS Server 10.1. The ArcGIS Server machine also has the SQL 2008 R2 Client Connectivity tools installed. Both servers for the test are on the same hardware using the same SAN for storage. I used the toolbox to create an enterprise GDB in SQL and then added that as a registered data store with AGS. I then exported a polygon of the states to SDE and published that as a map service so AGS was connecting to SDE for the data. That services takes about 5-10 seconds to draw no matter what the extent, which much slower than I thought it should be. I then published the data to AGS from a local FGDB (forcing it to copy the data to the AGS) and that draws the service almost instantly. As final test I copied the FGDB from my workstation to the data drive of the SQL server (same folder as the SQL .mdf for testing) and shared that, then registered the folder as a data store. I published the service again and this also draws instantly which tells me the problem is on the AGS connectivity to SQL Server (not a network issue as I removed that by putting the data in the same location). One thing I do notice is that for the 5-10 seconds that it is attempting to draw when the data comes from SDE the AGS machine has both CPUs pegged at 100% while the SDE server looks like almost nothing is happening (no different than if I am pulling it from the FGDB). Does anyone have any ideas on what could be causing this? Thanks, Josh

‎04-19-2011

I have an ArcGIS Server 10 map service which has 2 layers on it. The first (0) is an X/Y Event layer using WGS 84 GPS coordinates. The second (1) is that same layer exported to a shapefile still GCS WGS 84, not projected. When i try to display the X/Y event layer in the flex viewer as a feature layer where the basemap is web mercator it doesn't re-project the X/Y event layer in the flex viewer. If I add the shapefile as a feature layer in the flex viewer it reprojects and all of the points show up fine. Has anyone else had this problem or found a way around it? I need to be able to display those points directly from the X/Y table not a shapefile to allow for user uploads of points easily. I've also tried chaning my map service from GCS WGS84 to web mercator and that didn't help either. Thanks

‎10-26-2010

I am attempting to use an ATOM feed with the 2.1 GeoRSS widget and I seem to be having some troubles. It displays the points correctly but I'm not able to get the title etc. to display, it just uses the widget title as the default. I know that the feed is good because I can recompile the Reading GeoRSS feeds from the ESRI sample and replace the Flickr URL with my feeds URL and that loads correctly, displaying all of the content and the title. Is there a difference in the config file for ATOM feeds or do I still just put the list of fields and title field? Is anyone else having this problem? Thanks, Josh

‎06-16-2010

I figured out the problem, I had missed disabling anonymous access on the REST folder when I did it to the services folder. Seems odd that it performed as expected when viewing it from the browser directly, but after making that change everything works fine.

‎06-15-2010

I'm using the sample viewer 1.3 and am trying to get it to work with services published on a secondary server that has security enabled and is using windows authentication. Prior to enabling security on a clean AGS install I published the two services, added them to my flex config.xml and everything works fine. They show up in the TOC, can be enabled, etc. I then added a windows group to the service permissions, one service I belonged to the group one service I did not. When viewing the REST URL in IE I am able to see only the service that for the group like I belonged to, as expected. I tried switching permissions around and everything when looking at the REST URL shows up as expected, giving me access to view the correct services, and the ability to view them using the javascript link as I would expect. I made no changes to my flex config.xml and I am no longer able to see either service...the service label is listed in the TOC but I am unable to expand it, view it, etc. Is there something I'm missing here? I've searched the forum and not been able to find this same situation. I added <allow-http-request-headers-from domain="*" headers="*"/> to my crossdomain.xml file but that did not help. Any help would be appreciated, Thanks

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by JoshuaKeller

Re: Accessing SDE from script published as GPservice in 10.1

Accessing SDE from script published as GPservice in 10.1

Re: Slow drawing from SDE (SQL Server)

Re: Slow drawing from SDE (SQL Server)

Slow drawing from SDE (SQL Server)

Feature layer from XY Event

GeoRSS Widget ATOM Feed

Re: Secured Service with Windows Auth

Secured Service with Windows Auth