topic Re: Can't see SQL table views in 10.3 in Data Management Questions

Can't see SQL table views in 10.3

MikeLouwrens — Thu, 11 Dec 2014 19:25:05 GMT

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.

Re: Can't see SQL table views in 10.3

Anonymous User — Tue, 27 Jan 2015 21:31:28 GMT

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.

Re: Can't see SQL table views in 10.3

SusanJones — Tue, 27 Jan 2015 22:29:31 GMT

Hi Mike

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

Susan

Re: Can't see SQL table views in 10.3

MikeLouwrens — Tue, 27 Jan 2015 22:33:12 GMT

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.

Re: Can't see SQL table views in 10.3

SusanJones — Tue, 27 Jan 2015 22:55:55 GMT

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

Re: Can't see SQL table views in 10.3

MikeLouwrens — Tue, 27 Jan 2015 23:01:02 GMT

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.

Re: Can't see SQL table views in 10.3

AsrujitSengupta — Tue, 27 Jan 2015 23:25:59 GMT

I just checked on a Desktop 10.3 machine and I can see the views w/o any issues.

The version of Native Client should match the database version. You can try re-installing Native Client and check if that helps.

Is this issue occurring for all users and multiple geodatabases?

Re: Can't see SQL table views in 10.3

Anonymous User — Tue, 27 Jan 2015 23:26:51 GMT

Can you successfully create and subsequently see a view in 10.3? And, do you have the ability to confirm with an earlier client that the view itself is healthy and happy?

Re: Can't see SQL table views in 10.3

SusanJones — Tue, 27 Jan 2015 23:33:04 GMT

There are some issues with the SQL Server client tools around ddl access to objects.

Despite the user rights and permissions being in place, some access to tables and views was restricted.

This was solved by applying the cumulative update of the client tools.

Re: Can't see SQL table views in 10.3

MikeLouwrens — Wed, 28 Jan 2015 00:21:36 GMT

Asrujit SenGupta wrote:
I just checked on a Desktop 10.3 machine and I can see the views w/o any issues.
The version of Native Client should match the database version. You can try re-installing Native Client and check if that helps.
Is this issue occurring for all users and multiple geodatabases?

Was this looking at a 9.3 geodatabase? I can see views fine looking at 10.3 database but not 9.3.

I have reinstalled the 2008 R2 Native Client but hasn't helped. I am the only one to have installed 10.3 so far (due to this issue), so no other users. It happens on all my 9.3 databases, however these are all on the one server. I don't have another SDE server to test it on.

Cheers,

Mike.

Re: Can't see SQL table views in 10.3

MikeLouwrens — Wed, 28 Jan 2015 00:22:09 GMT

Thanks Susan, I will get IT permission to download and install the hotfix and see how that goes.

Cheers,

Mike.

Re: Can't see SQL table views in 10.3

MikeLouwrens — Wed, 28 Jan 2015 00:22:34 GMT

Marianne Farretta wrote:
Can you successfully create and subsequently see a view in 10.3? And, do you have the ability to confirm with an earlier client that the view itself is healthy and happy?

Not in the 9.3 database.

Cheers,

Mike.

Re: Can't see SQL table views in 10.3

Anonymous User — Wed, 28 Jan 2015 00:27:39 GMT

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.

Re: Can't see SQL table views in 10.3

MikeLouwrens — Wed, 28 Jan 2015 00:32:07 GMT

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.

Re: Can't see SQL table views in 10.3

Anonymous User — Thu, 29 Jan 2015 01:46:30 GMT

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.

Re: Can't see SQL table views in 10.3

deleted-user-ozMtgCuiJxpu — Thu, 18 Aug 2016 20:11:44 GMT

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.

Re: Can't see SQL table views in 10.3

JonGarrido — Tue, 10 Jan 2017 14:26:21 GMT

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....??

Re: Can't see SQL table views in 10.3

Asrujit_SenGupta — Tue, 10 Jan 2017 19:48:41 GMT

What is the SQL Server version?

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

Re: Can't see SQL table views in 10.3

JonGarrido — Wed, 11 Jan 2017 08:14:57 GMT

SQL Sever 2012

geodatabase version is 10.2.1.

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

Re: Can't see SQL table views in 10.3

Asrujit_SenGupta — Wed, 11 Jan 2017 08:23:30 GMT

SQL Server 2012 SP3 is the minimum Database Version supported with 10.5. So try that.

I'll suggest creating a new post for these issues as you are not even able to upgrade the sde gdb to 10.5.

Can you upgrade using Desktop 10.3.x?

Note: Make sure you have backups before testing suggestions...