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

Exception from HRESULT: 0x80041538

AlvinChin1

I'm trying to add data from an Azure SQL table in an Azure SQL database onto the map in ArcGIS Pro but I'm getting an error:

Add data

Why is this the case? My Azure SQL table includes location data which is lat and long, both as numbers. I tried using my local Windows machine and also using a Windows VM hosted in Azure where the Azure SQL database resides.

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

geolio

If it still not working, there may be some problem with your geometry. For example if you have multilinestring and linestring in the same geom column.

I don't know about Azure but in PostgreSQL i fix it with

UPDATE table_name SET geom = ST_RemoveRepeatedPoints(ST_SnapToGrid(geom, 0.001))

geolio

I had the same issue!

You have to define a primary key in your database table first. You can add a serial column if needed with

alter table table_name

add column gid serial primary key;

After that refresh your database connection in arcgis pro and it will work.

Weltstaat

I had a similar problem when importing tables (osm planet dump) from a postgres DB. The solution for me was to add a new ID field with pgadmin, then with the 'create a query layer' tool importing the table by changing the SQL Query from 'select column1, column2, column3, ... from myTable' to 'select * from myTable'. Maybe that helps someone.

TheodoreF

I've had this error when adding a layer from a PostgreSQL .sde database connection in ArcGIS Pro (dragging the layer/right click adding from the catalog pane). In PostreSQL, if I create a copy of the table making sure it has a unique id field and only ONE geometry field, it adds to the map just fine.

So it seemed that the error was originally happening when trying to add a layer which had 2 geometry columns. Not sure if that is a cause or not however.

Raphiki

How did you deduced the int -2147216072 from 0x80041538 ? Is it an hexa to decimal conversion?

EugeneNamaste

I have this problem after extracting table from an Azure SQL Table into a local SQL Express table and trying to read the output table in ArcGIS Pro. I use Py Pandas to read/write the table and keep the index. Having 'index' field name in the output looks like only one of the reasons -- I rename index to something else. I finally I resolve this issue, a long way and still need to research what exactly causing this. Extracting the same Azure table but writing it to a geodatabase table give me a valid table so then I recreate a blank table using the same schema from the valid geodatabase table minus OBJECTID and its associated properties, then append from Azure SQL table to this table.

FAdair

Worked for me after converting excel file format to 'Excel 97-2003'.

JoshuaBixby

My guess is that it has to do with FULL OUTER JOIN. Although you likely need FULL OUTER JOIN, have you tried other joins with the same columns and condition?

ShawnRoberts1

Hi Joshua, thanks for the reply. On the SQL end the view is healthy and seems works correctly. Whatever is happening it seems to be happening on the pro side. I can delete the view completely use the "create view" tool in pro and it will either hang up and crash pro or cause the same error. The verbose SQL server logs say the data is provided to pro without a problem. So it seems to be on the pro end.

JoshuaBixby

The hex code 0x80041538 maps to error -2147216072: FDO_E_SE_DB_IO_ERROR. (https://desktop.arcgis.com/en/arcobjects/latest/net/webframe.htm#fdoError.htm ). Given it appears to be a DB IO error, I suggest you consult your SQL Server logs because there should be some more specific information in the logs about the error.

ShawnRoberts1

Any follow up on this one? I've got a view that I've really simplified down as I continue to get this error. Even with the most simple view I can do. Even with this I get the HR Result error. The view is stored in an enterprise gdb on SQL server 2019 if that helps in any way. There is no spaces in any field names. Any ideas?

SELECT a.ObjectID, a.ARN,a.SHAPE,b.roll_number
FROM tableA as a
FULL OUTER JOIN tableB as b
ON a.ARN = b.roll_number;

WilliamLawrenceCoG

For me it was because I had spaces in my column names from the view I was attempting to use. I replaced them with underscores and it worked just fine.

PatrickChapuis

Does anyone have a solution on this ? I work for two separate clients who are facing this issue. The first one is a recently migrated client (both database and ArcGIS Enterprise) but the second one not had a so important operation recently.

Considering the fact that, if i right click on a table, it proposes me to register with the geodatabase, I suspect there is something to deal with a dysfunctioning in sde.gdb_items...

CliffParker

Any update on this error? I am also getting this error message. I'm trying to add a spatial view that I created in a SQL database.

Thanks,

deleted-user-s-XH6KNGak26

I have the same problem, how could i fix this?

AlvinChin1

This is something that should be simple to solve. I have read that the table should have OID so I created an id column to be unique, but I am still having this problem of adding data to the map. I even also used the Create query layer, specified the SELECT statement for all records in the table, but still doesn't work.

George Thompson

I think that this one may best be served by contacting technical support.

KoryKramer

Geodatabase‌ Anybody have thoughts on this - what to look at?

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.