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

ArcGIS Pro 3.2 database connections to SQL Server 2019 not showing contents, no error

Jamie_Leitch_CNF

I just upgraded to ArcGIS Pro 3.2 on Windows 10 machine. When I right-click and Refresh any existing database connections, nothing happens. I cannot see the contents of the database at all and there are no errors. I can create a new feature class successfully. I tried creating a new database connection and it is created successfully but I cannot open the connection to see the contents, refresh does nothing. I've installed the MS ODBC Driver 18 for SQL Server. Existing projects created in 3.1 that have feature classes from the same database connections load and show up in the map and can view and edit records in the attribute table.

Geodatabase version: 11.0.0.3.0
SQL Server Version: 2019

Any ideas?

Find more posts tagged with

Geodatabase

Accepted answers

Jamie_Leitch_CNF

With the help of Esri Tech Support, I solved this problem. The solution was to delete all the folders in this path: C:\Users\<user name>\AppData\Local\ESRI\Index\

SGTomlins

I only turned off indexing as suggested. It solved the problem. 🙂

All comments

LarryMcEvoy70

I did the same upgrade last week if I use a OS authenticated user I can see the data if I use a database authenticated user I get no data, my solution was to downgrade and log a service call. It looks a bit buggy to me. I'm using SQL Server 2016 but problem seems to be the same.

ESRI support are looking for screen grabs of the connections in both 3.1 and 3.2 I will get around to it next week some time but I downgraded to get some work done so the will have to wait a little while for me to upgrade again just to get them some screen grabs.

Jamie_Leitch_CNF

@LarryMcEvoy70 Thanks for that info. For me it seems to make no difference if I use an OS authenticated connection or a DB authenticated connection. I'm also engaged with support on this issue and will post any findings.

Jamie_Leitch_CNF

With the help of Esri Tech Support, I solved this problem. The solution was to delete all the folders in this path: C:\Users\<user name>\AppData\Local\ESRI\Index\

Anonymous User

...

Jamie_Leitch_CNF

@Anonymous User no they did not, other than providing a link to this information about how projects are indexed: https://pro.arcgis.com/en/pro-app/latest/help/projects/index-project-items.htm

LaurenWinkler

I deleted the contents from C:\Users\<user name>\AppData\Local\ESRI\Index\ yesterday and was able to connect to an SDE database, but the same problem came back today. Can this be reopened to find a more permanent solution?

I am working in ArcGIS Pro 3.2.1.

JonM32

I had this issue twice in the last 3 months. The first time no one really knew what was causing the issue, but my SDE database connections wouldn't load any data. You would connect to them but in the Catalog, when you opened the drop down it would be empty. My IT department basically redid my computer since they thought it was related to my Windows User Profile. The problem was fixed at this point but was a huge pain.

Yesterday, 1/29/2024, the same issue happen. All my SDE database connections were in Catalog, but were empty all of a sudden. Thankfully, I found this thread and believe I found the issue as to why it happens. The problem only started after I enabled Indexing for Enterprise geodatabases in ArcGIS Pro. I just disabled this index and my databases load all of their contents.

@LaurenWinkler @Anonymous User @LarryMcEvoy70 I would disable Indexing on Enterprise geodatabases on your end and see if this resolves things. Hope this helps!

Screenshot 2024-01-30 135702.png

Jamie_Leitch_CNF

@JonM32 thanks for this info, I will be trying this. I've found that this issue most often occurs with aprx files that had been created prior to upgrading to 3.2, not sure if that's significant or not.

LaurenWinkler

Thanks! I checked the projects that had the issue and noticed that indexing was disabled for enterprise geodatabases, but will keep this in mind for the future.

MattWilkie1

I ran into this too. GDB in SQL Server 2019 seem to be ok with indexing enabled, but regular db are invisible.

In Sql Server 2016 and Oracle 19c both db and gdb are empty.

Thank you Esri Canada's Sukhjit P. for putting me on the right track with this thread. Solving this was a multiday endeavour.

SGTomlins

I only turned off indexing as suggested. It solved the problem. 🙂

ctalleygreenville

This solved our problem as well.

One user could no longer connect to the enterprise geodatabase. It was sudden and only affected this one user. It turns out that she had enabled the Pro Options-->Indexing-->Create and manage your own index-->index items about a month ago.

We deleted all the folders in this directory on her computer as mentioned above: C:\Users\<user name>\AppData\Local\ESRI\Index\

Then "un-enabled" the index items option.

Her enterprise geodatabase connections worked immediately.

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.