Latest Contributions by ChrisPedrezuela

seems been fixed, haven't tried though, Release notes for ArcGIS Pro 2.2—ArcGIS Pro | ArcGIS Desktop  ... View more

Fair enough. Geocortex actually just creates another layer-like object that references the rest url of the sublayer. When you reorder the TOC on geocortex,your not reordering the map service contents directly but its own layer objects generated from the webmap. ... View more

You can try adding the sublayers individually using the "Add Layer" then enter the map service sublayer URL, i.e. https://xxxxxxxxx/arcgis/rest/services/SomeData/MapServer/0 - '0' is the first layer from the "group" or the mxd's table of contents. ... View more

true, those will be the caveat of using it as a required parameter. Unless the suggestion you made to use os.getusername would allow the GP service running on the AGS box to somehow run a python process on the user's own machine. I reckon if you want to do it like that, you might have to include a javascript based function to query the users browser if its using SSO. Just a thought, but its getting a bit complex I think. ... View more

since the script will run on the AGS box, wouldn't this function just pick up the current login credential which will be the ags service account? ... View more

its a bug that I think is fixed on 10.5.1 or 10.6. ... View more

all good. just happened to see your post since I am researching on how ArcGIS server picks up usernames. from your original post you did mention it will be a secured service so im guessing you will have a portal built-in user group or AD group to share the GP service with so basically you already have a list of users. but if its a lot of users in that group then that's a bit of a task to identify who uses it most. like the other suggestion, you could just simply make it a "required" parameter on your script for it to execute and store that parameter in a table on your sde or fgdb. You can even go further and auto fill that parameter by somehow hooking up to the AD user table. ... View more

I think when you switch the default log messages level settings from "Warning" to "Verbose", you can capture detailed instance of the GP or even map service being consumed by a user. Just a thought. ... View more

if you do not need to specify a dataframe for your output, just try replace df variable with string "PAGE_LAYOUT". if you are specifying a dataframe, make sure your wildcard string to filter the dataframe name is correctly spelled? maybe a typo error or an extra white space at the end of the dataframe name? ... View more

keep 1000 record limit on the service but set an appropriate scale visibility setting (i.e. don't show layers when zoomed beyond 1:5000) on the layer to prevent it showing more than 1000 objects on a current map view. ... View more

possibly try pypyodbc instead of arcpy to implement SQL transactions, this one has native SQL drivers compared to arcpy.ArcSDESQLExecute(). Possibly will solve your issue. ... View more

possibly a cached service? ... View more

we spoke with our local ESRI vendor and currently the only solution is a workaround. On your sql query you can cast the date field as varchar. As string value the datestamp will be read. From here you would have to convert the string to datetime. ... View more

Thanks for testing Joshua. The same issue was reproduced by our local ESRI distributor. Also just to correct myself, we are using SQL 2016. I was thinking it was the database side but if I use 10.3 arcpy on the same database, I still get the timestamp values.  I'll update this thread once I get more feedback from our local distributors support team,. ... View more

Hi Joshua, The custom script is scheduled on a server where ArcGIS Server 10.5 is running. The test I did was done on Desktop 10.5 using featureclass\table on a 10.5 SDE and 2012 SQL server instance. Python install version we are using is 2.7.12. The code below is simple one to test, egdb = r'dataconnection\somedb.sde' egdb_conn = arcpy.ArcSDESQLExecute(egdb) sql = '''SELECT DATEFIELD FROM SOMEDATA''' egdb_return = egdb.execute(sql) the tuple returned by running this piece of code using the 10.5 setup (on server and desktop) will yield blank strings while when using just a 10.3 desktop install on a separate machine it extracts the datetime values correctly. ... View more