EditOperation.Execute() didn't respond / stop

[SailiTang_HW]

Hi,

I have a piece of code below to create new rows with some attribute values in a standalone table. Every step worked perfectly but stopped at Line43(var result = createOperation.Execute();). No error message popped up and my visual studio showed running, but my Pro was frozen. It looked like waiting for the "Execute()" finishing. I only added 3 rows and shouldn't be that long. I even waited it for 30 minutes but still didn't go to the next step. I am using Visual studio 2019 and Pro 2.9. Does anyone have any idea about this problem? Or how can I do to debug this problem?

Thanks,

Saili

public Task<string> CreateNewRowsInTable(string drawingNumber, string remarks)
{
  StandaloneTable lDrawingLinkTable = DETUtil.GetTableFromMap(mAssetDrawingInfo.AssetDrawingLinkTableName);

  if (null == lDrawingLinkTable)
     throw new AssignDrawingLogicException(Defs.ASSIGN_DRAWING_MSG_ERROR_NO_DRAW_LINK_TABLE + mAssetDrawingInfo.AssetDrawingLinkTableName);

  return QueuedTask.Run(() => {               

         var selectedLayers = MapView.Active.Map.GetSelection();
         string lAssetIDFieldName = mAssignDrawingConfig.GetAssetIDFieldForFeatureClass(selectedLayers.First().Key.Name);
         int lTotalFeatures = 0;

         var createOperation = new EditOperation();
         Table lnkTable = lDrawingLinkTable.GetTable();
         int lAssestNameCode = mAssignDrawingConfig.GetAssetNameCodeForFeatureClass(selectedLayers.First().Key.Name);

          foreach (long ObjectId in selectedLayers.First().Value)
          {
            var selectedInspector = new Inspector();
            selectedInspector.Load(selectedLayers.First().Key, ObjectId);
            string lAssetID = selectedInspector[lAssetIDFieldName].ToString();

             try
             {
              var attributes = new Dictionary<string, object>();                             attributes.Add(mAssetDrawingInfo.AssetDrawingLinkAssetIDFieldname, lAssetID);
                         attributes.Add(mAssetDrawingInfo.AssetDrawingLinkAssetNameFieldname, lAssestNameCode);
                        attributes.Add(mAssetDrawingInfo.AssetDrawingLinkDrawNumberFieldname, drawingNumber);
               if (!String.IsNullOrEmpty(remarks))
                            attributes.Add(mAssetDrawingInfo.AssetDrawingLinkRemarksFieldname, remarks);
                        
               createOperation.Create(lnkTable, attributes);
              }
               catch (Exception)
               {
                throw new AssignDrawingLogicException(Defs.ASSIGN_DRAWING_MSG_CANNOT_EDIT_LINK_TABLE + mAssetDrawingInfo.AssetDrawingLinkTableName);
                    }
                   
                }

                if (!createOperation.IsEmpty)
                {
                    var result = createOperation.Execute();
                    if (!result)
                    {
                        MessageBox.Show(String.Format("ERROR: AssignDrawing: Please check if you have Edit permission on the layer!", "Desktop Edit Tool Error", MessageBoxButtons.OK, MessageBoxIcon.Error));
                    }
                }

                return "Assigned Drawing to: " + lTotalFeatures.ToString() + $" feature(s).{Environment.NewLine}Assign Drawing Complete.";

            });
      
        }

[SailiTang_HW]

I changed my ArcGIS Pro license from "Standard" to "Advanced" just now and then it worked! Being able to run EditOperation.Execute() needs "Advanced" license, doesn't it?!

Thanks

[SailiTang_HW]

I did more tests and found that it was not license issue. It worked sometimes for Standard license. No matter "Standard" license or "Advanced" license, they were not stable. Sometimes worked, sometimes didn't. How could I find out what the problem is?

[MaxW]

Hi Sail

I seem to have encountered this problem before. It appears to be because when you first open Pro, the SDE has not yet started reading. Therefore, the first execution does not update or write. However, if you read the SDE afterward, the execution will perform the update or write.

[SailiTang_HW]

Thank you so much for your reply, MaxW.

I did lots of tests last night and occasionally noticed that the code ran without issue if the standalone table was not opened. The standalone table could be added to Contents panel in Pro but not be opened. And also, the standalone table had to use .getTable to convert it to Table. "Standalone" data type variable had the same issue no matter it was opened or not.

For feature classes and feature layers, they don't have this issue. Adding new rows code can run properly no matter they are opened or not. After EditOperation.Execute() was done, I could see my feature layer was redrawn in the Map area and its attribute table was reloaded.

We just started converting ArcMap addins to Pro and this is my first Pro addin development. I don't know this standalone table issue is a bug or ESRI just designed like that? For some reasons, our organization cannot upgrade Pro to version 3.x now and we are still using 2.9. Does 3.x have the same issue?

Thanks.

[SailiTang_HW]

There is another thing I forgot to mention. I tested the code using both SDE data (versioned) and local file geodatabase data, but both had the same issue.

[Aashis]

Hi @SailiTang_HW, I could not reproduce the issue in our latest release, the Pro SDK 3.3. Is it possible to share sample data and code snippets for further investigation?