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

Can't see SQL table views in 10.3

MikeLouwrens

I installed the new ArcGIS Desktop 10.3 yesterday, I just noticed when looking in one of my SDE connections that I can't see any SQL table views in ArcCatalog anymore. I can see stand-alone tables, feature classes etc., but my table views are missing. Is there an option/setting somewhere that I can turn these back on?

Thanks,

Mike.

Find more posts tagged with

Accepted answers

Anonymous User

Sounds like 10.3 client/9.3 db compatibility. Check this link: Client and geodatabase compatibility—ArcGIS Help | ArcGIS for Desktop

It suggests to me that functionality is known to be limited, so they say you can connect "to upgrade." I would verify w/Esri support.

All comments

SusanJones

What flavour DBMS and in what version?

It sounds like some sort of compatability issue with the currently installed SNAC on the desktop with ArcGIS 10.5

trucheromayor

SQL Sever 2012

geodatabase version is 10.2.1.

When trying to upgrade to 10.5 it says that the geodatabase is already upgraded....

Asrujit_SenGupta

What is the SQL Server version?

What is the version of the sde geodatabase? Have you upgraded that to 10.5 as well?

trucheromayor

I have the same issue.

An enterprise geodatabase (10.2) with some table views (MSSQLSEVER).

The views were visible from 10.3 ArcMap version.

The view are not visible any more from ArcMap 10.5. But they are accessible for instance from a MS Management studio..

Even more. When creating a new View from 10.5 the view is created ... but is not visible ... (I can see them from Management Studio)...

Any idea....??

deleted-user-ozMtgCuiJxpu

I have this problem right now after upgraded desktop software to 10.4, can't see views that i created. if i open from client with 10.3 i can see the views. I am not sure how to resolve, any help would be appreciated.

Anonymous User

Hope that all worked out for you, Mike. And since I promised to update, here is my (similar but not related) issue, in case anyone uses this thread in the future:

Since the beginning of the relationship class in ArcGIS, you could make a relationship class whose name is the same as another table in the database. Though not a best practice, it did work. As of DT 10.3, it doesn't work anymore. The 10.3 client will not be able to see the related tables. Esri has logged a bug for this which doesn't describe the behavior, but rather the fact that the 10.3 client can still see SOME of the tables, when it shouldn't be able to see any of them at all.

Long story short: if you have relationship classes which have the same name as any of your tables, you'll need to rename the rel class to a unique name. I am renaming them in place, without rebuilding them.

Also worth noting: as of DT 10.3, the program will not allow you to create a rel class w/the same name of another table.

BUG-000084853

Inconsistent filtering of related tables, when the table name is identical to the relationship class name.

MikeLouwrens

Marianne Farretta wrote:
Sounds like 10.3 client/9.3 db compatibility. Check this link: Client and geodatabase compatibility—ArcGIS Help | ArcGIS for Desktop

ah thanks for that, yes it might be the issue. I'll pass that info on to my GIS admin people, it may mean we hold off installing 10.3 until we can upgrade our databases.

Cheers,

Mike.

Anonymous User

Sounds like 10.3 client/9.3 db compatibility. Check this link: Client and geodatabase compatibility—ArcGIS Help | ArcGIS for Desktop

It suggests to me that functionality is known to be limited, so they say you can connect "to upgrade." I would verify w/Esri support.

MikeLouwrens

my SSMS 2008 R2 can see everything it needs to see, it's just within ArcGIS Desktop that I can't see the views. Should I reinstall the 2008 R2 Native Client?

Cheers,

Mike.

SusanJones

Hi Mike

We had an almost identical issue with SSMS 2008 R2 accessing some objects and not others.

There is a patch out for SSMS 2008 R2 which should be applied which fixed the issue for the developers.

Susan

MikeLouwrens

on my PC? Looking in my Programs and Features list I see both 2008 R2 Native Client (10.51) and 2012 Native Client (11.2).

Cheers,

Mike.

SusanJones

Hi Mike

What version of the SQL Server Native Client is installed - 10.0 or 11.0?

Susan

Anonymous User

I can see table views, but cannot see all related tables. My 10.2 clients can see all tables, but my 10.3 client, using the same connection file, can't. I know this doesn't help you, but I wonder if the two are related. I'm creating an Esri ticket for mine, and will follow-up here if it proves informative for your issue.

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.