Latest Contributions by ChrisMathers1

ELI5 (for you redditors): I have an environment where we have a single production database and two publication databases which make up our  AGS Site. The two publication servers are children of the production environment with one way replication only. The minimal web based editing is done directly to the production environment. While there are mechanisms to pass a schema change from parent to child, new feature classes have to either go into a new replication or the existing one has to be dropped and rebuilt which is annoying with a lot of tables. We keep running into situations where "register existing data", even when a feature class has been manually equalized by deleting the data in the child and appending from the parent immediately before setup, fails to register the data and changes in the parent result in problem records in the child. This happens on both publication servers with several feature classes every time the replications are recreated. Because no changes are made to the data in the publication environment its not clear why its not recommended to use SQL replication instead of esri replication. I understand that if editing was happening in both places there could be conflicting OID created which would cause problems with network datasets, annotation, etc. which used the OID field to connect records. I know its a highly developed system but the in built geodatabase replication always seems cumbersome to deal with. Being that we have a single production database, which we are unlikely to grow out of anytime soon, we won't be in a situation where a single child is subscribed to multiple parents and we would have to deal with setting up identity ranges and such. All of our normal schema management, adding/dropping fields/tables, happens in ArcCatalog so there wouldnt be any conflict with table and field registration tables in the geodatabase. ... View more

I have had this work regularly before but for some reason, since the update to 10.5 I think but I cant say for sure, the UploadServiceDefinition tool isn't working consistently when I want to send something to AGOL. I haven't changed anything in the code and everything runs fine until that last step. I have tried logging in to AGOL in ArcMap and saving the map docs, signing in and leaving ArcMap open, and even running the script from within ArcMap while signed in. I just checked help(arcpy.UploadServiceDefinition_server) to make sure the docs didn't change at 10.5 without me noticing. server_type is set to 'MY_HOSTED_SERVICES' when creating the draft definition. It worked a couple weeks ago but now isnt.. Any ideas? arcpy.UploadServiceDefinition_server(in_sd_file = finalSD,                                              in_server = "My Hosted Services",                                              in_service_name = mapDoc,                                              in_cluster = "",                                              in_folder_type = "EXISTING",                                              in_folder = "OpenData")‍‍‍‍‍‍ Gives me an error: Failed to execute. Parameters are not valid. ERROR 000732: Server: Dataset My Hosted Services does not exist or is not supported Failed to execute (UploadServiceDefinition). ‍‍‍ ... View more

I have a simple app I have put together for a department to use in the field. They want to be able to identify on a point and get a report they can print sometimes of the attributes. I put together a nice little bootstrap page with an inset ArcGIS JS map but I need to authenticate the page to make a query against our REST endpoint. This page would be hosted on a local webserver and be querying a local ArcGIS Server. My idea was to have a link in the popup which passes the OID of the feature as a URL parameter. That goes into a request URL to the service and the JSON response is parsed out. That part is easy. I cant figure out how to authenticate it though. It could ask for a password at each page load but I would rather not since that would be irritating if they needed to print several in a row. Alternative solutions gladly welcome. ... View more

For the second time when investigating why our primary production database is slow I found that the edit tables are not compressing. The version tree from GDBTools is showing a pretty good compression each time but those edits still remain. It turns out that once again when I removed two replications they are taken out of all database tables except SDE_Versions. These two versions are acting as blocking states keeping 2 months worth of edits from compressing. The only way I've found to fix this is to back up the database and delete the rows from the table directly. I deleted them in descending order of creation date compressing between deletes. After the last compress all the edit tables were clean and empty and the database had updated all the state lineage numbers automatically. No edits were lost as far as we have been able to tell. I don't know if its just our database but DBA's may want to keep this in mind. ... View more

 I got a new computer which means a completely fresh install of Desktop at 10.4.1 which means no more rolling GDBTools forward. I really liked being able to visualize the state tree and want to try to replicate it using python. I'm grabbing the state list using use sde select sde.sde_states.state_id, parent_state_id, lineage_name, name from sde.SDE_states left join sde.SDE_versions on sde.sde_states.state_id = sde.sde_versions.state_id order by state_id;‍‍‍‍‍‍‍ but I'm having trouble sorting the states into their branches however. Anyone at esri have some advice? ... View more