I'm trying to use a DifferenceCursor on a utility network feature service geodatabase. I am following the guide here I am able to use the VersionManager class to open the default geodatabase and the version geodatabase and then open the same feature class from both of them. However, when I try to create a DifferenceCursor I get this error "Object has no schema locks". I dug into this a bit further via the VersionManagerServer rest endpoints. If you go to https:// /rest/services/ /VersionManagementServer/versions/ /differences and try to run it you get the same error: This can be overcome by running the startReading command Then you can go back to the differences endpoint, put the same sessionId in and it works. It doesn't look like VersionManager does this first step of starting a read session. Here's a snippet of the code I'm using. ServiceConnectionProperties serviceConnectionProperties = new ServiceConnectionProperties ( new Uri ( config . Connection . UtilityServiceUri ) ) ; using ( Geodatabase gdb = new Geodatabase ( serviceConnectionProperties ) ) using ( VersionManager versionManager = gdb . GetVersionManager ( ) ) { //here's where I was going to try calling the startReading operation directly off the ReST endpoint WebClient versionManagerClient = new WebClient ( ) { BaseAddress = config . Connection . UtilityServiceUri + "/VersionManagementServer" } ; Version navigateVersion = versionManager . GetVersions ( ) . First ( v = > v . GetName ( ) == config . ApplicationConfiguration . NavigateVersion ) ; using ( Geodatabase navigateGdb = navigateVersion . Connect ( ) ) { foreach ( string featureClass in config . FeatureClasses ) { //service feature classes have the layer number prefix i.e L0PipelineLine //so we use this function to translate between human readable and the actual layer name FeatureClassDefinition serviceFCDefinition = GetServiceFeatureClassName ( featureClass ) ; string serviceFeatureClassName = serviceFCDefinition . GetName ( ) ; FeatureClass defaultFc = gdb . OpenDataset FeatureClass > ( serviceFeatureClassName ) ; FeatureClass navigateFc = navigateGdb . OpenDataset FeatureClass > ( serviceFeatureClassName ) ; //this line gives me "Object has no schema locks" DifferenceCursor diffCursor = navigateFc . Differences ( defaultFc , DifferenceType . Insert ) ; while ( diffCursor . MoveNext ( ) ) { using ( Row row = diffCursor . Current ) { log . Append ( String . Format ( "Post Change: insert into geometry_changes ({0}) values()" , String . Join ( ", " , outputFields ) ) ) ; } } } } }

Hi Ryan, Unfortunately, I'm still not able to reproduce this in CoreHost. My stripped down test code (which does nothing interesting with the results) is attached. You could change out the service name and table name and see if it works on your system. Let me know how it turns out, --Rich using ArcGIS . Core . Hosting ; using System ; using System . Collections . Generic ; using System . Linq ; using ArcGIS . Core . Data ; using Version = ArcGIS . Core . Data . Version ; namespace CoreHostSandbox { class Program { //[STAThread] must be present on the Application entry point [ STAThread ] static void Main ( string [ ] args ) { //Call Host.Initialize before constructing any objects from ArcGIS.Core Host . Initialize ( ) ; Sandbox mySandbox = new Sandbox ( ) ; mySandbox . Do ( ) ; } } class Sandbox { const string FeatureServiceName = @"https://richruh.esri.com/server/rest/services/TableTestBranchVersioning/FeatureServer" ; const string EditVersionName = "VersionDifferencesTestSuiteVersion" ; const string CityTableName = "L0Cities" ; const DifferenceType DifferenceTypeToCheck = DifferenceType . Insert ; private Version _defaultVersion = null ; private Geodatabase _defaultGeodatabase = null ; private FeatureClass _defaultCitiesFeatureClass = null ; private Version _editVersion = null ; private Geodatabase _editGeodatabase = null ; private FeatureClass _editCitiesFeatureClass = null ; public void Do ( ) { ServiceConnectionProperties serviceConnectionProperties = new ServiceConnectionProperties ( new Uri ( FeatureServiceName ) ) ; using ( Geodatabase geodatabase = new Geodatabase ( serviceConnectionProperties ) ) { TestSuiteSetup ( geodatabase ) ; try { // Fetch all of the ObjectIDs found in the cursor List long > differences = new List long > ( ) ; using ( DifferenceCursor differenceCursor = _editCitiesFeatureClass . Differences ( _defaultCitiesFeatureClass , DifferenceTypeToCheck ) ) { while ( differenceCursor . MoveNext ( ) ) { differences . Add ( differenceCursor . ObjectID ) ; if ( DifferenceTypeToCheck != DifferenceType . DeleteNoChange ) { differenceCursor . Current . Dispose ( ) ; } } } Console . WriteLine ( "Differences= " + differences . ToString ( ) ) ; } catch ( Exception e ) { Console . WriteLine ( "FAIL: Exception thrown: " + e . Message + "\n" ) ; } TestSuiteTeardown ( ) ; } } //TestSuiteSetup private void TestSuiteSetup ( Geodatabase geodatabase ) { using ( VersionManager versionManager = geodatabase . GetVersionManager ( ) ) using ( Version currentVersion = versionManager . GetCurrentVersion ( ) ) { // Connect to the default version _defaultVersion = GetDefaultVersion ( currentVersion ) ; _defaultGeodatabase = _defaultVersion . Connect ( ) ; _defaultCitiesFeatureClass = _defaultGeodatabase . OpenDataset FeatureClass > ( CityTableName ) ; // Connect to the edit version _editVersion = versionManager . GetVersions ( ) . First ( v = > v . GetName ( ) . Contains ( EditVersionName ) ) ; _editGeodatabase = _editVersion . Connect ( ) ; _editCitiesFeatureClass = _editGeodatabase . OpenDataset FeatureClass > ( CityTableName ) ; } } //TestSuiteTeardown - clean up the stuff we created in TestSuiteSetup private void TestSuiteTeardown ( ) { _defaultVersion . Dispose ( ) ; _defaultGeodatabase . Dispose ( ) ; _defaultCitiesFeatureClass . Dispose ( ) ; _editCitiesFeatureClass . Dispose ( ) ; _editGeodatabase . Dispose ( ) ; _editVersion . Dispose ( ) ; } private Version GetDefaultVersion ( Version version ) { Version parentVersion = version . GetParent ( ) ; if ( parentVersion == null ) { return version ; } else { return parentVersion ; } } } }

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Does difference cursor work with branch versioning?

RyanMuller1

I'm trying to use a DifferenceCursor on a utility network feature service geodatabase.

I am following the guide here

I am able to use the VersionManager class to open the default geodatabase and the version geodatabase and then open the same feature class from both of them. However, when I try to create a DifferenceCursor I get this error

"Object has no schema locks".

I dug into this a bit further via the VersionManagerServer rest endpoints.

If you go to https://<server_url>/rest/services/<feature_server>/VersionManagementServer/versions/<version_guid>/differences

and try to run it you get the same error:

This can be overcome by running the startReading command

Then you can go back to the differences endpoint, put the same sessionId in and it works.

It doesn't look like VersionManager does this first step of starting a read session.

Here's a snippet of the code I'm using.

ServiceConnectionProperties serviceConnectionProperties <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ServiceConnectionProperties</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Uri</SPAN><SPAN class="punctuation token">(</SPAN>config<SPAN class="punctuation token">.</SPAN>Connection<SPAN class="punctuation token">.</SPAN>UtilityServiceUri<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Geodatabase gdb <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Geodatabase</SPAN><SPAN class="punctuation token">(</SPAN>serviceConnectionProperties<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>VersionManager versionManager <SPAN class="operator token">=</SPAN> gdb<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetVersionManager</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">{</SPAN>
	<SPAN class="comment token">//here's where I was going to try calling the startReading operation directly off the ReST endpoint</SPAN>
	WebClient versionManagerClient <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">WebClient</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
	<SPAN class="punctuation token">{</SPAN>
		BaseAddress <SPAN class="operator token">=</SPAN> config<SPAN class="punctuation token">.</SPAN>Connection<SPAN class="punctuation token">.</SPAN>UtilityServiceUri <SPAN class="operator token">+</SPAN> <SPAN class="string token">"/VersionManagementServer"</SPAN>
	<SPAN class="punctuation token">}</SPAN><SPAN class="punctuation token">;</SPAN>

	Version navigateVersion <SPAN class="operator token">=</SPAN> versionManager<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetVersions</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>v <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> v<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetName</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">==</SPAN> config<SPAN class="punctuation token">.</SPAN>ApplicationConfiguration<SPAN class="punctuation token">.</SPAN>NavigateVersion<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

	<SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Geodatabase navigateGdb <SPAN class="operator token">=</SPAN> navigateVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Connect</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
	<SPAN class="punctuation token">{</SPAN>
		<SPAN class="keyword token">foreach</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">string</SPAN> featureClass <SPAN class="keyword token">in</SPAN> config<SPAN class="punctuation token">.</SPAN>FeatureClasses<SPAN class="punctuation token">)</SPAN>
		<SPAN class="punctuation token">{</SPAN>
			 <SPAN class="comment token">//service feature classes have the layer number prefix i.e L0PipelineLine</SPAN>
			<SPAN class="comment token">//so we use this function to translate between human readable and the actual layer name</SPAN>
			FeatureClassDefinition serviceFCDefinition <SPAN class="operator token">=</SPAN> <SPAN class="token function">GetServiceFeatureClassName</SPAN><SPAN class="punctuation token">(</SPAN>featureClass<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
			<SPAN class="keyword token">string</SPAN> serviceFeatureClassName <SPAN class="operator token">=</SPAN> serviceFCDefinition<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetName</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

			FeatureClass defaultFc <SPAN class="operator token">=</SPAN> gdb<SPAN class="punctuation token">.</SPAN>OpenDataset<SPAN class="operator token"><</SPAN>FeatureClass<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>serviceFeatureClassName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
			FeatureClass navigateFc <SPAN class="operator token">=</SPAN> navigateGdb<SPAN class="punctuation token">.</SPAN>OpenDataset<SPAN class="operator token"><</SPAN>FeatureClass<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>serviceFeatureClassName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

			<SPAN class="comment token">//this line gives me "Object has no schema locks"</SPAN>
			DifferenceCursor diffCursor <SPAN class="operator token">=</SPAN> navigateFc<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Differences</SPAN><SPAN class="punctuation token">(</SPAN>defaultFc<SPAN class="punctuation token">,</SPAN> DifferenceType<SPAN class="punctuation token">.</SPAN>Insert<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
			<SPAN class="keyword token">while</SPAN> <SPAN class="punctuation token">(</SPAN>diffCursor<SPAN class="punctuation token">.</SPAN><SPAN class="token function">MoveNext</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
			<SPAN class="punctuation token">{</SPAN>
				<SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Row row <SPAN class="operator token">=</SPAN> diffCursor<SPAN class="punctuation token">.</SPAN>Current<SPAN class="punctuation token">)</SPAN>
				<SPAN class="punctuation token">{</SPAN>
					log<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Append</SPAN><SPAN class="punctuation token">(</SPAN>String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Format</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Post Change: insert into geometry_changes ({0}) values()"</SPAN><SPAN class="punctuation token">,</SPAN>
						String<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Join</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">", "</SPAN><SPAN class="punctuation token">,</SPAN> outputFields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

				<SPAN class="punctuation token">}</SPAN>
			<SPAN class="punctuation token">}</SPAN>
		<SPAN class="punctuation token">}</SPAN>
	<SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

RichRuh

Hi Ryan,

Unfortunately, I'm still not able to reproduce this in CoreHost. My stripped down test code (which does nothing interesting with the results) is attached. You could change out the service name and table name and see if it works on your system.

Let me know how it turns out,

--Rich

<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Hosting<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Collections<SPAN class="punctuation token">.</SPAN>Generic<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Linq<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> Version <SPAN class="operator token">=</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">.</SPAN>Version<SPAN class="punctuation token">;</SPAN>


<SPAN class="keyword token">namespace</SPAN> CoreHostSandbox
<SPAN class="punctuation token">{</SPAN>


  <SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Program</SPAN>
  <SPAN class="punctuation token">{</SPAN>
    <SPAN class="comment token">//[STAThread] must be present on the Application entry point</SPAN>
    <SPAN class="punctuation token">[</SPAN>STAThread<SPAN class="punctuation token">]</SPAN>
    <SPAN class="keyword token">static</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">Main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN> args<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>
      <SPAN class="comment token">//Call Host.Initialize before constructing any objects from ArcGIS.Core</SPAN>
      Host<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Initialize</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

      Sandbox mySandbox <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Sandbox</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      mySandbox<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Do</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

    <SPAN class="punctuation token">}</SPAN>
  <SPAN class="punctuation token">}</SPAN>

  <SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Sandbox</SPAN>
  <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">const</SPAN> <SPAN class="keyword token">string</SPAN> FeatureServiceName <SPAN class="operator token">=</SPAN> <SPAN class="string token">@"https://richruh.esri.com/server/rest/services/TableTestBranchVersioning/FeatureServer"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">const</SPAN> <SPAN class="keyword token">string</SPAN> EditVersionName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"VersionDifferencesTestSuiteVersion"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">const</SPAN> <SPAN class="keyword token">string</SPAN> CityTableName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"L0Cities"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">const</SPAN> DifferenceType DifferenceTypeToCheck <SPAN class="operator token">=</SPAN> DifferenceType<SPAN class="punctuation token">.</SPAN>Insert<SPAN class="punctuation token">;</SPAN>

    <SPAN class="keyword token">private</SPAN> Version _defaultVersion <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">private</SPAN> Geodatabase _defaultGeodatabase <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">private</SPAN> FeatureClass _defaultCitiesFeatureClass <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>

    <SPAN class="keyword token">private</SPAN> Version _editVersion <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">private</SPAN> Geodatabase _editGeodatabase <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">private</SPAN> FeatureClass _editCitiesFeatureClass <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>

    <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">Do</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>
      ServiceConnectionProperties serviceConnectionProperties <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ServiceConnectionProperties</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Uri</SPAN><SPAN class="punctuation token">(</SPAN>FeatureServiceName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Geodatabase geodatabase <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Geodatabase</SPAN><SPAN class="punctuation token">(</SPAN>serviceConnectionProperties<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="punctuation token">{</SPAN>
        <SPAN class="token function">TestSuiteSetup</SPAN><SPAN class="punctuation token">(</SPAN>geodatabase<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">try</SPAN>
        <SPAN class="punctuation token">{</SPAN>
          <SPAN class="comment token">// Fetch all of the ObjectIDs found in the cursor</SPAN>
          List<SPAN class="operator token"><</SPAN><SPAN class="keyword token">long</SPAN><SPAN class="operator token">></SPAN> differences <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">long</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

          <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>DifferenceCursor differenceCursor <SPAN class="operator token">=</SPAN> _editCitiesFeatureClass<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Differences</SPAN><SPAN class="punctuation token">(</SPAN>_defaultCitiesFeatureClass<SPAN class="punctuation token">,</SPAN> DifferenceTypeToCheck<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
          <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">while</SPAN> <SPAN class="punctuation token">(</SPAN>differenceCursor<SPAN class="punctuation token">.</SPAN><SPAN class="token function">MoveNext</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
              differences<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>differenceCursor<SPAN class="punctuation token">.</SPAN>ObjectID<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
              <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>DifferenceTypeToCheck <SPAN class="operator token">!=</SPAN> DifferenceType<SPAN class="punctuation token">.</SPAN>DeleteNoChange<SPAN class="punctuation token">)</SPAN>
              <SPAN class="punctuation token">{</SPAN>
                differenceCursor<SPAN class="punctuation token">.</SPAN>Current<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
              <SPAN class="punctuation token">}</SPAN>
            <SPAN class="punctuation token">}</SPAN>
          <SPAN class="punctuation token">}</SPAN>
          Console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Differences= "</SPAN> <SPAN class="operator token">+</SPAN> differences<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
        <SPAN class="keyword token">catch</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token class-name">Exception</SPAN> e<SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
          Console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FAIL: Exception thrown: "</SPAN> <SPAN class="operator token">+</SPAN> e<SPAN class="punctuation token">.</SPAN>Message <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
        <SPAN class="token function">TestSuiteTeardown</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>

    <SPAN class="comment token">//TestSuiteSetup</SPAN>
    <SPAN class="keyword token">private</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">TestSuiteSetup</SPAN><SPAN class="punctuation token">(</SPAN>Geodatabase geodatabase<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>

      <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>VersionManager versionManager <SPAN class="operator token">=</SPAN> geodatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetVersionManager</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Version currentVersion <SPAN class="operator token">=</SPAN> versionManager<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetCurrentVersion</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="punctuation token">{</SPAN>
        <SPAN class="comment token">// Connect to the default version</SPAN>
        _defaultVersion <SPAN class="operator token">=</SPAN> <SPAN class="token function">GetDefaultVersion</SPAN><SPAN class="punctuation token">(</SPAN>currentVersion<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        _defaultGeodatabase <SPAN class="operator token">=</SPAN> _defaultVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Connect</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        _defaultCitiesFeatureClass <SPAN class="operator token">=</SPAN> _defaultGeodatabase<SPAN class="punctuation token">.</SPAN>OpenDataset<SPAN class="operator token"><</SPAN>FeatureClass<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>CityTableName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

        <SPAN class="comment token">// Connect to the edit version</SPAN>
        _editVersion <SPAN class="operator token">=</SPAN> versionManager<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetVersions</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>v <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> v<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetName</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN>EditVersionName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        _editGeodatabase <SPAN class="operator token">=</SPAN> _editVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Connect</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        _editCitiesFeatureClass <SPAN class="operator token">=</SPAN> _editGeodatabase<SPAN class="punctuation token">.</SPAN>OpenDataset<SPAN class="operator token"><</SPAN>FeatureClass<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>CityTableName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>

    <SPAN class="comment token">//TestSuiteTeardown - clean up the stuff we created in TestSuiteSetup</SPAN>
    <SPAN class="keyword token">private</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">TestSuiteTeardown</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>
      _defaultVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _defaultGeodatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _defaultCitiesFeatureClass<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _editCitiesFeatureClass<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _editGeodatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _editVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>

    <SPAN class="keyword token">private</SPAN> Version <SPAN class="token function">GetDefaultVersion</SPAN><SPAN class="punctuation token">(</SPAN>Version version<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>
      Version parentVersion <SPAN class="operator token">=</SPAN> version<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetParent</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>parentVersion <SPAN class="operator token">==</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">return</SPAN> version<SPAN class="punctuation token">;</SPAN>
      <SPAN class="punctuation token">}</SPAN>
      <SPAN class="keyword token">else</SPAN>
      <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">return</SPAN> parentVersion<SPAN class="punctuation token">;</SPAN>
      <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
  <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

RyanMuller1

So after thinking about this a little bit more I realize I don't understand the threading model in CoreHost. Since all CoreHost applications must be in single threaded apartment (STA) mode I assumed that QueuedWorker.Run was there so you didn't block the main thread and break the STA contract which, very basically is to not block the thread and not to deadlock. Why would attempting to create a difference cursor in the MTA CLR threadpool (I'm assuming that's what QueuedWorker.Run does) cause it to behave differently than in the STA?

If I wrap my function in QueuedWorker.Run it continues to give me the "Object has no schema locks" error. Should I just not use QueuedWorker when creating CoreHost/STAThread applications?

RyanMuller1

Thank you Rich, I was trying to do this in QueuedWorker.Run. Removing that allowed it to work. The documentation mentions that the Differences cursor must be created on the MCT so I thought the same would apply in a CoreHost application. It appears that it does not.

RichRuh

Hi Ryan,

Let me know how it turns out,

--Rich

<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Hosting<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Collections<SPAN class="punctuation token">.</SPAN>Generic<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> System<SPAN class="punctuation token">.</SPAN>Linq<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">;</SPAN>
<SPAN class="keyword token">using</SPAN> Version <SPAN class="operator token">=</SPAN> ArcGIS<SPAN class="punctuation token">.</SPAN>Core<SPAN class="punctuation token">.</SPAN>Data<SPAN class="punctuation token">.</SPAN>Version<SPAN class="punctuation token">;</SPAN>


<SPAN class="keyword token">namespace</SPAN> CoreHostSandbox
<SPAN class="punctuation token">{</SPAN>


  <SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Program</SPAN>
  <SPAN class="punctuation token">{</SPAN>
    <SPAN class="comment token">//[STAThread] must be present on the Application entry point</SPAN>
    <SPAN class="punctuation token">[</SPAN>STAThread<SPAN class="punctuation token">]</SPAN>
    <SPAN class="keyword token">static</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">Main</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">string</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN> args<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>
      <SPAN class="comment token">//Call Host.Initialize before constructing any objects from ArcGIS.Core</SPAN>
      Host<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Initialize</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

      Sandbox mySandbox <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Sandbox</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      mySandbox<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Do</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

    <SPAN class="punctuation token">}</SPAN>
  <SPAN class="punctuation token">}</SPAN>

  <SPAN class="keyword token">class</SPAN> <SPAN class="token class-name">Sandbox</SPAN>
  <SPAN class="punctuation token">{</SPAN>
    <SPAN class="keyword token">const</SPAN> <SPAN class="keyword token">string</SPAN> FeatureServiceName <SPAN class="operator token">=</SPAN> <SPAN class="string token">@"https://richruh.esri.com/server/rest/services/TableTestBranchVersioning/FeatureServer"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">const</SPAN> <SPAN class="keyword token">string</SPAN> EditVersionName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"VersionDifferencesTestSuiteVersion"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">const</SPAN> <SPAN class="keyword token">string</SPAN> CityTableName <SPAN class="operator token">=</SPAN> <SPAN class="string token">"L0Cities"</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">const</SPAN> DifferenceType DifferenceTypeToCheck <SPAN class="operator token">=</SPAN> DifferenceType<SPAN class="punctuation token">.</SPAN>Insert<SPAN class="punctuation token">;</SPAN>

    <SPAN class="keyword token">private</SPAN> Version _defaultVersion <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">private</SPAN> Geodatabase _defaultGeodatabase <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">private</SPAN> FeatureClass _defaultCitiesFeatureClass <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>

    <SPAN class="keyword token">private</SPAN> Version _editVersion <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">private</SPAN> Geodatabase _editGeodatabase <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="keyword token">private</SPAN> FeatureClass _editCitiesFeatureClass <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">;</SPAN>

    <SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">Do</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>
      ServiceConnectionProperties serviceConnectionProperties <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ServiceConnectionProperties</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Uri</SPAN><SPAN class="punctuation token">(</SPAN>FeatureServiceName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Geodatabase geodatabase <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Geodatabase</SPAN><SPAN class="punctuation token">(</SPAN>serviceConnectionProperties<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="punctuation token">{</SPAN>
        <SPAN class="token function">TestSuiteSetup</SPAN><SPAN class="punctuation token">(</SPAN>geodatabase<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="keyword token">try</SPAN>
        <SPAN class="punctuation token">{</SPAN>
          <SPAN class="comment token">// Fetch all of the ObjectIDs found in the cursor</SPAN>
          List<SPAN class="operator token"><</SPAN><SPAN class="keyword token">long</SPAN><SPAN class="operator token">></SPAN> differences <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">List</SPAN><SPAN class="operator token"><</SPAN><SPAN class="keyword token">long</SPAN><SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

          <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>DifferenceCursor differenceCursor <SPAN class="operator token">=</SPAN> _editCitiesFeatureClass<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Differences</SPAN><SPAN class="punctuation token">(</SPAN>_defaultCitiesFeatureClass<SPAN class="punctuation token">,</SPAN> DifferenceTypeToCheck<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
          <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">while</SPAN> <SPAN class="punctuation token">(</SPAN>differenceCursor<SPAN class="punctuation token">.</SPAN><SPAN class="token function">MoveNext</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
            <SPAN class="punctuation token">{</SPAN>
              differences<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Add</SPAN><SPAN class="punctuation token">(</SPAN>differenceCursor<SPAN class="punctuation token">.</SPAN>ObjectID<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
              <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>DifferenceTypeToCheck <SPAN class="operator token">!=</SPAN> DifferenceType<SPAN class="punctuation token">.</SPAN>DeleteNoChange<SPAN class="punctuation token">)</SPAN>
              <SPAN class="punctuation token">{</SPAN>
                differenceCursor<SPAN class="punctuation token">.</SPAN>Current<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
              <SPAN class="punctuation token">}</SPAN>
            <SPAN class="punctuation token">}</SPAN>
          <SPAN class="punctuation token">}</SPAN>
          Console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Differences= "</SPAN> <SPAN class="operator token">+</SPAN> differences<SPAN class="punctuation token">.</SPAN><SPAN class="token function">ToString</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
        <SPAN class="keyword token">catch</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="token class-name">Exception</SPAN> e<SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
          Console<SPAN class="punctuation token">.</SPAN><SPAN class="token function">WriteLine</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"FAIL: Exception thrown: "</SPAN> <SPAN class="operator token">+</SPAN> e<SPAN class="punctuation token">.</SPAN>Message <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\n"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        <SPAN class="punctuation token">}</SPAN>
        <SPAN class="token function">TestSuiteTeardown</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>

    <SPAN class="comment token">//TestSuiteSetup</SPAN>
    <SPAN class="keyword token">private</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">TestSuiteSetup</SPAN><SPAN class="punctuation token">(</SPAN>Geodatabase geodatabase<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>

      <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>VersionManager versionManager <SPAN class="operator token">=</SPAN> geodatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetVersionManager</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Version currentVersion <SPAN class="operator token">=</SPAN> versionManager<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetCurrentVersion</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="punctuation token">{</SPAN>
        <SPAN class="comment token">// Connect to the default version</SPAN>
        _defaultVersion <SPAN class="operator token">=</SPAN> <SPAN class="token function">GetDefaultVersion</SPAN><SPAN class="punctuation token">(</SPAN>currentVersion<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        _defaultGeodatabase <SPAN class="operator token">=</SPAN> _defaultVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Connect</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        _defaultCitiesFeatureClass <SPAN class="operator token">=</SPAN> _defaultGeodatabase<SPAN class="punctuation token">.</SPAN>OpenDataset<SPAN class="operator token"><</SPAN>FeatureClass<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>CityTableName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>

        <SPAN class="comment token">// Connect to the edit version</SPAN>
        _editVersion <SPAN class="operator token">=</SPAN> versionManager<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetVersions</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN>v <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN> v<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetName</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">Contains</SPAN><SPAN class="punctuation token">(</SPAN>EditVersionName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        _editGeodatabase <SPAN class="operator token">=</SPAN> _editVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Connect</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
        _editCitiesFeatureClass <SPAN class="operator token">=</SPAN> _editGeodatabase<SPAN class="punctuation token">.</SPAN>OpenDataset<SPAN class="operator token"><</SPAN>FeatureClass<SPAN class="operator token">></SPAN><SPAN class="punctuation token">(</SPAN>CityTableName<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>

    <SPAN class="comment token">//TestSuiteTeardown - clean up the stuff we created in TestSuiteSetup</SPAN>
    <SPAN class="keyword token">private</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">TestSuiteTeardown</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>
      _defaultVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _defaultGeodatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _defaultCitiesFeatureClass<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _editCitiesFeatureClass<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _editGeodatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      _editVersion<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Dispose</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
    <SPAN class="punctuation token">}</SPAN>

    <SPAN class="keyword token">private</SPAN> Version <SPAN class="token function">GetDefaultVersion</SPAN><SPAN class="punctuation token">(</SPAN>Version version<SPAN class="punctuation token">)</SPAN>
    <SPAN class="punctuation token">{</SPAN>
      Version parentVersion <SPAN class="operator token">=</SPAN> version<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetParent</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
      <SPAN class="keyword token">if</SPAN> <SPAN class="punctuation token">(</SPAN>parentVersion <SPAN class="operator token">==</SPAN> <SPAN class="keyword token">null</SPAN><SPAN class="punctuation token">)</SPAN>
      <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">return</SPAN> version<SPAN class="punctuation token">;</SPAN>
      <SPAN class="punctuation token">}</SPAN>
      <SPAN class="keyword token">else</SPAN>
      <SPAN class="punctuation token">{</SPAN>
        <SPAN class="keyword token">return</SPAN> parentVersion<SPAN class="punctuation token">;</SPAN>
      <SPAN class="punctuation token">}</SPAN>
    <SPAN class="punctuation token">}</SPAN>
  <SPAN class="punctuation token">}</SPAN>
<SPAN class="punctuation token">}</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RichRuh

Oh. That is a very interesting development. While it certainly should work in CoreHost, my tests in this case also run in an add-in. Let me try it in CoreHost and get back to you.

--Rich

RyanMuller1

I was trying to do this in CoreHost. After moving my code over to a Pro addin module, it creates the difference cursor just fine. Do you know if CoreHost supports difference cursors and/or what I might need to do diffrently to get them to work in a CoreHost application?

RyanMuller1

1. I'm using ArcGIS Pro 2.5.2

2. All version names and tables are correct. I am able to open a RowCursor on both the versioned and default feature classes

3. I can see version changes in the Pro interface

In Fiddler, I can see the call to startReading when I open the differences tab in Pro.

I do not see any such call to startReading in Fiddler when I try my code. setting a breakpoint on the call to GetVersions shows it calling the following endpoints

VersionManagementServer/versionInfos

FeatureServer/relationships

VersionManagementServer/versions/GUID-To-Version (does this for all versions since I'm calling version.GetName() on them)

on line 26 in the code above where I create the difference cursor, I get this.

One thing different that I'm doing compared to the Pro SDK documentation, is creating the geodatabase using ServiceConnectionProperties and the url of the feature service.

 ServiceConnectionProperties serviceConnectionProperties <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">ServiceConnectionProperties</SPAN><SPAN class="punctuation token">(</SPAN>
     <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Uri</SPAN><SPAN class="punctuation token">(</SPAN>https<SPAN class="punctuation token">:</SPAN><SPAN class="operator token">/</SPAN><SPAN class="operator token">/</SPAN><SPAN class="operator token"><</SPAN>server_url<SPAN class="operator token">></SPAN><SPAN class="operator token">/</SPAN>server<SPAN class="operator token">/</SPAN>rest<SPAN class="operator token">/</SPAN>services<SPAN class="operator token">/</SPAN><SPAN class="operator token"><</SPAN>feature_service_name<SPAN class="operator token">></SPAN><SPAN class="operator token">/</SPAN>FeatureServer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

RichRuh

Hi Ryan,

I don't see any problems with your code. I set up some similar code and stepped through it with a debugger and Fiddler. On my machine, calling versionManager.GetVersions() is calling startReading on every version on the service.

Do you have fiddler installed, and, if so, could you tell me what output is created by that call on your machine?

Some other general questions:

1. What version of Pro are you running?

2. Are all of the version names/tables names, etc. correct? (i.e., you don't have any unexpected null pointers in your code)

3. Can you do a version differences with this version in the Pro user interface?

Thanks,

--Rich

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.