To minimize the overhead I am asking an Oracle database table only for specific objects through the OpenTable method. While it works with in the first attempt, all others fail. I do not know what the issue is but I am getting an ArcGIS.Core.Data.GeodatabaseQueryexception thrown when trying to open the table based on my query description. Below is the code how I am trying to get the data. The exception thrown is pointing to "Geometry is null geometry" which is strange since I can find multiple objects that fulfil the SQL statement. public async void SearchValidationTables ( ) { await QueuedTask . Run ( ( ) = > { using ( Database ValidationDatabase = new Database ( connectionFileValidation ) ) { // get national string prefix string nationalStringPrefix = "" ; SQLSyntax sqlSyntax = ValidationDatabase . GetSQLSyntax ( ) ; nationalStringPrefix = sqlSyntax . GetSupportedStrings ( SQLStringType . NationalStringPrefix ) . First ( ) ; // build query here and set it into next line string querySQL = "SELECT * FROM SCHEMA.DBTABLE WHERE FEATURETYPE = " + nationalStringPrefix + "'waterways'" ; QueryDescription queryDescription = ValidationDatabase . GetQueryDescription ( querySQL , "test" ) ; // set the column with a unique identifier queryDescription . SetObjectIDFields ( "OBJECTID" ) ; // get data as featureclass and load it as featurelayer try { FeatureClass fcFromTable = ValidationDatabase . OpenTable ( queryDescription ) as FeatureClass ; LayerFactory . Instance . CreateFeatureLayer ( fcFromTable , MapView . Active . Map ) ; } catch ( GeodatabaseQueryException e ) { throw e ; } } } ) ; } I found a bit more information by looking at the inner exception: Does that mean I have to adjust the QueryLayerName?

Thomas, Could you try setting the QueryDescription shape type? For example, add the following after line 15 above: queryDescription . SetShapeType ( GeometryType . Polyline ) ; // assuming the underlying geometry type is polyline I hope this helps, --Rich

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; } } }

Database.OpenTable work very selective, throws exception otherwise

TomGeo

To minimize the overhead I am asking an Oracle database table only for specific objects through the OpenTable method.

While it works with in the first attempt, all others fail. I do not know what the issue is but I am getting an ArcGIS.Core.Data.GeodatabaseQueryexception thrown when trying to open the table based on my query description.

Below is the code how I am trying to get the data. The exception thrown is pointing to "Geometry is null geometry" which is strange since I can find multiple objects that fulfil the SQL statement.

<SPAN class="keyword token">public</SPAN> <SPAN class="keyword token">async</SPAN> <SPAN class="keyword token">void</SPAN> <SPAN class="token function">SearchValidationTables</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="punctuation token">{</SPAN>
            <SPAN class="keyword token">await</SPAN> QueuedTask<SPAN class="punctuation token">.</SPAN><SPAN class="token function">Run</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">=</SPAN><SPAN class="operator token">></SPAN>
            <SPAN class="punctuation token">{</SPAN>
                <SPAN class="keyword token">using</SPAN> <SPAN class="punctuation token">(</SPAN>Database ValidationDatabase <SPAN class="operator token">=</SPAN> <SPAN class="keyword token">new</SPAN> <SPAN class="token class-name">Database</SPAN><SPAN class="punctuation token">(</SPAN>connectionFileValidation<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
                <SPAN class="punctuation token">{</SPAN>
                    <SPAN class="comment token">// get national string prefix</SPAN>
                    <SPAN class="keyword token">string</SPAN> nationalStringPrefix <SPAN class="operator token">=</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">;</SPAN>
                    SQLSyntax sqlSyntax <SPAN class="operator token">=</SPAN> ValidationDatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetSQLSyntax</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    nationalStringPrefix <SPAN class="operator token">=</SPAN> sqlSyntax<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetSupportedStrings</SPAN><SPAN class="punctuation token">(</SPAN>SQLStringType<SPAN class="punctuation token">.</SPAN>NationalStringPrefix<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="token function">First</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="comment token">// build query here and set it into next line</SPAN>
                    <SPAN class="keyword token">string</SPAN> querySQL <SPAN class="operator token">=</SPAN> <SPAN class="string token">"SELECT * FROM SCHEMA.DBTABLE WHERE FEATURETYPE = "</SPAN><SPAN class="operator token">+</SPAN> nationalStringPrefix <SPAN class="operator token">+</SPAN><SPAN class="string token">"'waterways'"</SPAN><SPAN class="punctuation token">;</SPAN>
                    QueryDescription queryDescription <SPAN class="operator token">=</SPAN> ValidationDatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">GetQueryDescription</SPAN><SPAN class="punctuation token">(</SPAN>querySQL<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"test"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="comment token">// set the column with a unique identifier</SPAN>
                    queryDescription<SPAN class="punctuation token">.</SPAN><SPAN class="token function">SetObjectIDFields</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN>
                    <SPAN class="comment token">// get data as featureclass and load it as featurelayer</SPAN>
                    <SPAN class="keyword token">try</SPAN>
                    <SPAN class="punctuation token">{</SPAN>
                        FeatureClass fcFromTable <SPAN class="operator token">=</SPAN> ValidationDatabase<SPAN class="punctuation token">.</SPAN><SPAN class="token function">OpenTable</SPAN><SPAN class="punctuation token">(</SPAN>queryDescription<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> FeatureClass<SPAN class="punctuation token">;</SPAN>
                        LayerFactory<SPAN class="punctuation token">.</SPAN>Instance<SPAN class="punctuation token">.</SPAN><SPAN class="token function">CreateFeatureLayer</SPAN><SPAN class="punctuation token">(</SPAN>fcFromTable<SPAN class="punctuation token">,</SPAN> MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<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">GeodatabaseQueryException</SPAN> e<SPAN class="punctuation token">)</SPAN>
                    <SPAN class="punctuation token">{</SPAN>

                        <SPAN class="keyword token">throw</SPAN> e<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>

I found a bit more information by looking at the inner exception:

Does that mean I have to adjust the QueryLayerName?

Finde mehr Beiträge mit dem Tag

Accepted answers

RichRuh

Thomas,

Could you try setting the QueryDescription shape type?

For example, add the following after line 15 above:

queryDescription<SPAN class="punctuation token">.</SPAN><SPAN class="token function">SetShapeType</SPAN><SPAN class="punctuation token">(</SPAN>GeometryType<SPAN class="punctuation token">.</SPAN>Polyline<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// assuming the underlying geometry type is polyline</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I hope this helps,

--Rich

All comments

TomGeo

Actually, the error message is not pointing to any line in the C# code, but is raised by ArcGIS Pro, shortly after I try to open the attribute table.
I found a discussion about the same problem here Oracle community but cannot make heads and tails out of it on how to implement that.

Thomas

RichRuh

We read the spatial type from the first feature that we find. Without an Order By, you can get features back in variable order- this would explain why it sometimes worked and sometimes didn't.

As for the spatial reference error, I don't have any immediate ideas. What line of SDK code is causing the error?

--Rich

TomGeo

Thanks Rich, that certainly helped. May I ask how you figured out that's the issue?

And, of course, now there is another problem... The FeatureLayer is added to the TOC, but the attempt to visualize some features isn't successful and when I try to see feature attributes then I am getting an error returned, pointing at the SRID:

The active maps coordinate system is set to ETRS 1989 UTM Zone 32N and I get and set the spatial reference of the queryDescription through:

SpatialReference sr <SPAN class="operator token">=</SPAN> MapView<SPAN class="punctuation token">.</SPAN>Active<SPAN class="punctuation token">.</SPAN>Map<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">;</SPAN>
queryDescription<SPAN class="punctuation token">.</SPAN><SPAN class="token function">SetSpatialReference</SPAN><SPAN class="punctuation token">(</SPAN>sr<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I also checked the database table, where the SDO_SRID of the geometry column is saying 25832.

Still, the error remains. Any good ideas on how to overcome that one?

RichRuh

Thomas,

Could you try setting the QueryDescription shape type?

For example, add the following after line 15 above:

queryDescription<SPAN class="punctuation token">.</SPAN><SPAN class="token function">SetShapeType</SPAN><SPAN class="punctuation token">(</SPAN>GeometryType<SPAN class="punctuation token">.</SPAN>Polyline<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">;</SPAN> <SPAN class="comment token">// assuming the underlying geometry type is polyline</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

I hope this helps,

--Rich

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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