topic Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2 in ArcGIS Pro SDK Questions

ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

GeoffY — Wed, 03 Jan 2024 13:08:22 GMT

I am using the ArcGis Pro SDK 3.0.0.36056 on our latest Add-In.

To support some functionality I have been utilising ArcGIS.Core.Data.Table GetDefinition method. This fails when the add-in is used with Pro v3.2, and Postgres. I have tried different versions of postgres and all have the same error:

The operation is not supported by this implementation.
at ArcGIS.Core.Data.Dataset.GetDefinitionHandle()
at ArcGIS.Core.Data.FeatureClass.CreateDefinition()
at ArcGIS.Core.Data.Table.GetDefinition()

Does anyone know if this is a breaking change for version 3.2+, or a bug?

Many Thanks.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

GKmieliauskas — Wed, 03 Jan 2024 13:21:00 GMT

Hi,

I had similar issue with Database view on PostgreSql and registered case on Esri support site. It is still open.

Have you tried to install patch 3.2.1?

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

GeoffY — Wed, 03 Jan 2024 14:18:28 GMT

Hi,

Yes I installed 3.2.1 to no avail. On a separate machine I tried recompiling using the 3.2 SDK and that made no difference. I know with a bit of effort I could code around the problem and avoid using this method altogether, but my worry is that there could be other functionality that is unsupported for Postgres with future Pro versions.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

GKmieliauskas — Wed, 03 Jan 2024 14:24:18 GMT

At first, we have made workaround for reading table fields from cursor instead of table definition.

We decided to go back to SDK 3.1 for the same reason as you worry.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

GeoffY — Wed, 03 Jan 2024 14:40:22 GMT

Yes, using the cursor for reading works well (at the moment). I was using it to get table field definitions, for a specific piece of functionality - will work my way around it another way.

Hopefully someone at Esri will respond to one of our posts to give us some insight into this and future breaking changes, so that we can plan in advance.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

Aashis — Wed, 03 Jan 2024 23:17:28 GMT

@GKmieliauskas @GeoffY - Could you please elaborate on the repro steps or provide sample codes? I could not reproduce the case on my machine. Table.GetDefinition works fine for Postgres.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

GKmieliauskas — Thu, 04 Jan 2024 07:43:14 GMT

As I mentioned above, I have issue with database view not simple table.

It worked fine in versions before 3.2.

Error: The operation is not supported by this implementation.

Code:

using (Table viewTable = geodatabase.OpenDataset<Table>(viewName)) { var tableDefinition = viewTable.GetDefinition(); // other code with tableDefinition }

I have attached print screen of database view properties window.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

GeoffY — Thu, 04 Jan 2024 10:42:11 GMT

Similarly for me, the following worked before 3.2:

await QueuedTask.Run(() =>

{

try

{

using (ArcGIS.Core.Data.Table t = _geodatabase.OpenDataset<ArcGIS.Core.Data.Table>(tableName))

{

TableDefinition td = t.GetDefinition();

.....

}

catch

{

throw;

}

});

I have also tried this against Pro v3.2.1, and against several versions of postgres (11.7, 13.6, 15.3). All fine at 3.1 but not at 3.2.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

DaveFullerton — Fri, 12 Jan 2024 04:48:25 GMT

Same problem, but with accessing a Query Feature Class with SQL Server. I wrote the code using v3.2 against a feature class in a file geodatabase for quicker testing and that worked fine. When I tried to move to production I got this same error with Table.GetDefintion().

ArcGIS.Core.Data.Exceptions.GeodatabaseGeneralException: The operation is not supported by this implementation.
---> System.Runtime.InteropServices.COMException (0x80040203): A syntax error occurred trying to evaluate a query string (0x80040203)
at ArcGIS.Core.Internal.IDatasetIOP.Dataset_GetDefinition(IntPtr datasetHandle)
at ArcGIS.Core.Data.Dataset.GetDefinitionHandle()
--- End of inner exception stack trace ---
at ArcGIS.Core.Data.Dataset.GetDefinitionHandle()
at ArcGIS.Core.Data.FeatureClass.CreateDefinition()
at ArcGIS.Core.Data.Table.GetDefinition()

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

BryanTurcotte — Thu, 25 Jan 2024 18:29:57 GMT

Same problem here, we are trying to access to Table.GetDefinition() and get the same error but with an Oracle database for us, the same code was working on 3.1 and not anymore on 3.2.

Ticket have been created on ESRI side with code to reproduce the issue, waiting an answer about that.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

Aashis — Mon, 29 Jan 2024 01:23:08 GMT

We have successfully replicated the issue and will release a resolution in the upcoming 3.2.2 patch.

Re: ArcGIS.Core.Data.Table GetDefinition not working with postgres on Pro v3.2

GeoffY — Mon, 29 Jan 2024 10:31:02 GMT

That's great news. Thanks.