Latest Contributions by JohnFannon

Hi We have a customer who is increasingly reporting (since upgrading from 9.3.1 to 10.2.1 a year ago) that they are getting conflicts when reconciling versions. The conflicts reported are always related to deleted features in the edit version (see below example).  The customer has a relatively small team and there are only approx 6 versions open at any time. Edit versions are created from SDE.default and this particular case, no other users/versions have modified the objects in question since the the version was created, so the deletes should not be causing conflicts. Also, other similar deletes in the same version have reconciled without conflicts and I have tried to reproduce the same issue by performing similar edits in a new version, but do not get the same issues. I have tried looking at the sde_states and sde_state_lineages tables, as well as the _A and _D tables for the feature classes and can't see any obvious issues or differences between the conflicting objects and those that reconcile ok. However, I'm certainly not an expert in this area. Does anyone have an idea what might be causing the conflicts? Is there another scenario, other than a change to the objects in the default version since the edit version was created, that would cause a conflict? The feature classes involved are all part of a geometric network, could this be part of the problem? Does anyone have some useful SQL queries that I can run to investigate the state tree for this version or reproduce the queries that the reconcile tool is performing to detect the conflicts? Any thoughts or assistance would be much appreciated. Note the customer is using: ArcGIS Desktop 10.2.1 (with the utilities and telecoms update 3 patch) SQL Server 2012 / SDE 10.2.1 (with the utilities and telecoms update 3 patch) Cheers John ... View more

Hi I'm trying to develop a custom collection task for ArcGIS Mobile (10.2.1) which is based upon the SimpleDataCollectionExtension sample (code below). The collection is working fine and I can see the newly created feature on the map and it appears under 'Manage Edits'. However, when exiting the application I get this message: This seems to suggest that the application still thinks it's in some kind of editing mode, despite having done the following when the user clicks the OK button on the page: geometryCollectionMethod.StopGeometryCollection(); geometryCollectionMethod.CompleteCollection(); feature.SaveEdits(); feature.StopEditing(); If I do indeed click 'Yes' to exit the application and the feature is still present when next opening the application, so the changes have been saved. Does anyone know what I need to do to prevent the above message appearing when the application exits? What am I missing? Regards John Code for the sample is: using System; using System.Collections.Generic; using System.Linq; using System.Text; using ESRI.ArcGIS.Mobile.Client; using ESRI.ArcGIS.Mobile.Client.Tasks.ViewMap; using System.Windows; using System.Windows.Forms; using ESRI.ArcGIS.Mobile.Client.Pages; using ESRI.ArcGIS.Mobile.Client.Tasks.CollectFeatures; using ESRI.ArcGIS.Mobile.FeatureCaching; using ESRI.ArcGIS.Mobile.Client.Controls; namespace CustomizationSamples {   //This sample shows how to customize data collection workflows for the Windows Application.   //In View Map page, the extension adds a new button. By clicking the it, the application will jump to the geometry colltion page for the specified the layer.   public class SimpleDataCollectionExtension : ProjectExtension   {     //define the button name and layer name for customized data collection     string ButtonName = "Geometry";     string LayerName = "New Subtype";     private IPage _homePage;     private Feature _feature;     private FeatureType _featureType;     private EditFeatureAttributesPage _editFeatureAttributesPage;     private EditFeatureAttributesViewModel _editFeatureAttributesViewModel;     protected override void Initialize()     {     }     protected override void OnOwnerInitialized()     {       if (!MobileApplication.Current.Dispatcher.CheckAccess())       {         MobileApplication.Current.Dispatcher.BeginInvoke((System.Threading.ThreadStart)delegate()         {           OnOwnerInitialized();         });         return;       }       // Add three new custom commands to the View Map page to collect       // manageable areas, fire edge, and fire events.       ViewMapTask viewMapTask = MobileApplication.Current.FindTask(typeof(ViewMapTask)) as ViewMapTask;       if (viewMapTask != null)       {           //***********************************************************           // replace the layer name here           //***********************************************************         viewMapTask.ViewMapPage.ForwardCommands.Add(new UICommand(ButtonName,           param => this.CollectFireDataCommandExecute(LayerName)));           //***************************************************************       }     }     protected override void Uninitialize()     {            _editFeatureAttributesPage.ClickOk -= new EventHandler(_editFeatureAttributesPage_ClickOk);       _editFeatureAttributesPage.ClickCancel -= new EventHandler(_editFeatureAttributesPage_ClickCancel);       _editFeatureAttributesViewModel = null;       _editFeatureAttributesPage = null;     }     private void CollectFireDataCommandExecute(string featureTypeName)     {       try       {         Cursor.Current = Cursors.WaitCursor;         // Cache homepage for the application         // Once data collection is done, we come back to this cached page         _homePage = MobileApplication.Current.CurrentPage;         // Reset _feature and _featureType         _feature = null;         _featureType = FindFeatureTypeByName(featureTypeName);         if (_featureType == null)         {           ESRI.ArcGIS.Mobile.Client.Windows.MessageBox.ShowDialog("Can't find " + featureTypeName + ".", "Warning");           return;         }         // Create a new Feature, this will automatically call StartEditing on this feature         _feature = new Feature(_featureType, null);         _editFeatureAttributesViewModel = new EditFeatureAttributesViewModel(_feature);         _editFeatureAttributesPage = new EditFeatureAttributesPage(_editFeatureAttributesViewModel);         _editFeatureAttributesPage.ClickOk += new EventHandler(_editFeatureAttributesPage_ClickOk);         _editFeatureAttributesPage.ClickCancel += new EventHandler(_editFeatureAttributesPage_ClickCancel);         MobileApplication.Current.Transition(_editFeatureAttributesPage);              }       finally       {         Cursor.Current = Cursors.Default;       }     }         private FeatureType FindFeatureTypeByName(string name)     {       foreach (FeatureSourceInfo fsinfo in MobileApplication.Current.Project.EnumerateFeatureSourceInfos())       {         foreach (FeatureType featureType in fsinfo.FeatureTypes)         {           if (featureType.Name.ToLower() == name.ToLower())             return featureType;         }       }       return null;     }     void _editFeatureAttributesPage_ClickOk(object sender, EventArgs e)     {       // Save the feature       if (!SaveEdits())         ESRI.ArcGIS.Mobile.Client.Windows.MessageBox.ShowDialog("Cannot save edits.", "Warning");       // Go back to homepage       MobileApplication.Current.Transition(_homePage);     }     void _editFeatureAttributesPage_ClickCancel(object sender, EventArgs e)     {       // Cancel the edits       CancelDataCollection();       // Go back to homepage       MobileApplication.Current.Transition(_homePage);     }     private void CancelDataCollection()     {       if (_feature != null)       {         _feature.CancelEdit();         _feature.StopEditing();       }       _feature = null;       _featureType = null;     }     bool SaveEdits()     {       GeometryCollectionMethod method = _editFeatureAttributesViewModel.GeometryCollectionViewModel.GetCollectionMethodInProgress();       if (method != null)         method.StopGeometryCollection();       if (_feature != null)       {         // In case Geometry is invalid         if (_feature.Geometry == null || !_feature.Geometry.IsValid)           return false;         _feature.SaveEdits();         _feature.StopEditing();         return true;       }       else         return false;     }   } } ... View more

Hi I've come across this many times, but it's now becoming quite frustrating that when publishing an mxd as a feature service in ArcGIS Server, the feature templates included in the mxd are ignored and instead a default set of templates is generated based on the unique values used for symbology. The help etc seems to suggest that templates created in the mxd are transferred to the feature service, but my experience is that this is not the case. For example, I have an mxd with a layer that is symbolised by unique values on a WO_STATUS field: I have altered the feature templates for this layer to just have one template. But when I publish as a feature service I get the following templates in the resulting feature service: "types": [   {   "id": "ONROUTE",   "name": "In Progress",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "In Progress",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "ONROUTE",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "UNDERPREPARATION",   "name": "Open",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Open",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "UNDERPREPARATION",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "FINISHED",   "name": "Closed",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Closed",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "FINISHED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "REPORTED",   "name": "Closed",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Closed",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "REPORTED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "FAULTREPORT",   "name": "Open",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Open",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "FAULTREPORT",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "CANCELED",   "name": "Closed",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Closed",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "CANCELED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "ASSIGNED",   "name": "In Progress",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "In Progress",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "ASSIGNED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "PREPARED",   "name": "Open",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Open",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "PREPARED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "WORKREQUEST",   "name": "Open",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Open",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "WORKREQUEST",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "null",   "name": "Open",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Open",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "null",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "UNKNOWN",   "name": "Open",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "IFS Work Order",   "description": "",   "prototype": {   "attributes": {   "WO_STATUS": "UNKNOWN",   "WO_STATUS_DATE": null,   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "ACCEPTED",   "name": "In Progress",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "In Progress",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "ACCEPTED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "OBSERVED",   "name": "Open",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Open",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "OBSERVED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "RELEASED",   "name": "Open",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Open",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "RELEASED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "WORKDONE",   "name": "Closed",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "Closed",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "WORKDONE",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   },   {   "id": "STARTED",   "name": "In Progress",   "domains": {   "WO_STATUS": {"type": "inherited"}   },   "templates": [   {   "name": "In Progress",   "description": "",   "prototype": {   "attributes": {   "WO_NUMBER": null,   "WO_N_NUMBER": null,   "IFS_OBJECTID": null,   "WO_STATUS": "STARTED",   "WO_STATUS_DATE": null,   "WORK_TYPE": null,   "MAINT_ORG": null,   "DIRECTIVE": null,   "PRIORITY": null,   "DATE_CREATED": null,   "CREATED_USER": null,   "DATE_MODIFIED": null,   "MODIFIED_USER": null,   "IFSid": null   }   },   "drawingTool": "esriFeatureEditToolPoint"   }   ]   } ], This is clearly not based on the templates in the mxd, but on the unique values defined for symbology. This results in the following in something like the ArcGIS Online map viewer - which is not particularly user friendly. For reference we are using: ArcGIS Desktop 10.2.1 ArcGIS Server 10.2.1 If anyone has found a suitable workaround, I'd be glad to hear from you. John ... View more

Hi I have a layer from a mobile cache within the project which is symbolised by unique values (eg. work orders based on status). This works fine for visual display on the map, but because the layer is symbolised on unique values, ArcGIS Mobile is presenting all of the various statuses as feature types on the "Collect Features" - "Select Feature Types" page. This is going to be confusing for the end user (see below), but I can't find a way to change this with configuration, my source mxd only has one feature template set, and AGM is overriding that. I am writing some other customisations, so was wondering whether I can write an extension that will remove the extra feature types from the list that is presented on the "Select Feature Types" page. Does anyone have any experience doing similar? Is it possible? Or is there a better work around? Regards John ... View more

Hi I've written a python script that updates a number of versioned feature classes in an SDE geodatabase (SQL Server) with a single attribute sourced from a CSV file. The script basically does the following: starts an edit session reads the rows from the CSV file and uses the arcpy.da.updatecursor to return the correct row (using an ID in the where clause) then updates the value for that row in the feature class. stops the edit session and saves edits This performs ok for a small number of records (<1000) but when scaled up to 100k+ records, the script seems to slow down almost to a crawl beyond a few thousand records and took 10+ days to complete. The feature classes involved are not overly large (10-50k) records each, so I'm surprised by the poor performance. I have a feeling this is due to a build up of records in the delta tables in SDE, so as the data is updated, the query that the updatecursor is executing takes longer each time, because it's querying across the delta tables. Can anyone else offer a better explanation of what's going on and perhaps how to improve the performance? The only thing I can think of currently is to change the script to perform the edits in smaller batches (e.g. 1000). Any thoughts much appreciated. Regards John ... View more