topic Re: Query Layer Issue - Not behaving properly in ArcMap in Geodatabase Questions

Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Thu, 21 Dec 2017 20:03:05 GMT

Hi,

I am using ArcMap 10.4.1. If I go to File -> Add Data ->Add Query layer I can fill out everything, validate it, and hit ok - then it starts to run and ArcMap Crashes. I can use the "Make Query (Data Management)" Tool and successfully create a Query Layer, but it does Not show up in "Layers" in the TOC . See Screenshot.

The data is there, and I can use the identify tool to get information about the polygons. If i switch to List by Source, Visibility, or Selection in the TOC, sometimes the Query Layer will appear there and sometimes it won't. If I open an existing mxd with a query layer already in it, I can modify the Query and everything functions correctly. Any thoughts as to what is going on?

Thanks!

Pamela

Re: Query Layer Issue - Not behaving properly in ArcMap

DanPatterson_Retired — Thu, 21 Dec 2017 20:24:26 GMT

Have you checked the files for possible errors? could be geometry errors (use Check Geometry tool)

You could also try exporting it to a new featureclass (Copy Features) and see if the copy behaves badly as well

Re: Query Layer Issue - Not behaving properly in ArcMap

Asrujit_SenGupta — Fri, 22 Dec 2017 07:57:46 GMT

Is it only happening on your machine?
Is the issue with only one particular data or any data?

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Fri, 22 Dec 2017 12:46:02 GMT

have tried exporting, and the new feature class throws errors. my coworker can create the same query layer with no issue....wondering if it's my ArcMap..

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Fri, 22 Dec 2017 12:47:23 GMT

I have tested it out on two other computers and the query layer worked just fine which leads me to believe it's something to do with my computer. When trying to create query layers on my machine, nothing works no matter what data I am using.

Re: Query Layer Issue - Not behaving properly in ArcMap

DanPatterson_Retired — Fri, 22 Dec 2017 12:57:42 GMT

It could be something with your installation or your profile, but I suspect the first. From your windows access point to Install/Remove programs, go there, then when asked, try a 'Repair' to see if repairing the installation works.

I assume that you have the same permissions as all others and you have cleaned up all the trash that accumulates at the operating system level

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Fri, 22 Dec 2017 15:27:54 GMT

i cleared all my caches, uninstalled arcmap completely and reinstalled....it's still happening... might need to call tech support 😕

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Fri, 22 Dec 2017 16:03:42 GMT

Update: I have uninstalled and reinstalled ArcMap, and installed a 10.4.1 SQL patch and Desktop patch I found. I also deleted my normal.mxt and now ArcMap Crashes when I try to create a query layer using either method. I can still, however, open mxd's with query layers in them already, and they seem to function fine. These query layers work on other machines.... running out of ideas..

Re: Query Layer Issue - Not behaving properly in ArcMap

DanPatterson_Retired — Fri, 22 Dec 2017 16:31:42 GMT

that leaves your machine if everything works on every other machine but yours when you log in as you on those machines...

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Wed, 27 Dec 2017 15:04:32 GMT

right....now just have to figure out what on my machine is causing it....

Re: Query Layer Issue - Not behaving properly in ArcMap

DanPatterson_Retired — Wed, 27 Dec 2017 15:20:08 GMT

Well at least it isn't you... nothing has been of any help so far so if you are in an environment where they can re-deploy a good image, it will be a minor inconvenience. If you aren't, then you have the option of manually figuring out whether you have software differences with others or reinstalling from the operating system up or.... just get a new computer which is a far cheaper option

Re: Query Layer Issue - Not behaving properly in ArcMap

VinceAngelo — Wed, 27 Dec 2017 16:48:18 GMT

It would help if you specified which RDBMS you are using, the version of that RDBMS server, and the version of the client libraries being used (both on your host and others). Application crashes are extreme events; they shouldn't occur, and if they do it's often due to incompatible DLLs.

-V

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Tue, 02 Jan 2018 15:21:05 GMT

the SDE geodatabases I am trying to query are using SQL Server 2014 installed on Windows Server 2012R2. If i RDP into this server Query layers function correctly...from my actual Desktop is where I'm having issues. My machine is running SQL Server 2016 - could that be causing the issue?

Re: Query Layer Issue - Not behaving properly in ArcMap

VinceAngelo — Tue, 02 Jan 2018 21:46:08 GMT

Absolutely. Newer client DLL incompatibility could cause this sort of issue.

- V

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Thu, 04 Jan 2018 14:25:39 GMT

How do I fix this? Is there someone who can help? I uninstalled my SQL Server Native Client and reinstalled the version that I downloaded from my MyESRI portal, I also made sure I was using the same version of Microsoft SQL Server Management Studio that is on my coworker's computer (she has no issues with Query Layers).

Despite this, i am still having the same issues of ArcMap crashing when trying to create query layers. The other difference between my computer and my coworkers is that I am still on Windows 7 and she is on Windows 10..could that cause an issue?

Re: Query Layer Issue - Not behaving properly in ArcMap

JoshuaBixby — Thu, 04 Jan 2018 14:44:37 GMT

I doubt Windows 7 vs. 10 is the cause of the problem, per se. There have been a lot of good suggestions in this thread, and you seemed to have tried most or all of them to no avail. At this point, the troubleshooting gets so involved it is hard to work through in a forum like this one. At some point, chasing gremlins will consume more time than re-imaging a machine and getting set back up. If your co-workers are on Windows 10 and it works for them, can you have your machine re-imaged?

A couple last troubleshooting thoughts. You say that you can't make any query layers. Does that statement apply when connecting to a single SQL Server instance or any SQL Server instance, i.e., have you tried query layers against multiple SQL Server instances or just one?

You mention that you have cleared caches, uninstalled and reinstalled, etc.... After you uninstalled, did you remove or rename all of the Esri user-application folders (%appdata%\Esri and %localappdata%\ESRI)?

Have you tried deleting and recreating the SDE connection file you are using to create your connections to the SQL Server? If an SDE connection file was created with an unsupported SQL Server client and it got corrupted somehow, no amount of uninstalling and reinstalling either ArcGIS or DBMS clients will fix the problem if the same corrupt connection file is being used by the software.

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Thu, 04 Jan 2018 15:59:00 GMT

Thank you everyone for your responses!

I have a ticket in with your IT department to upgrade me to Windows 10 and re-image my machine....I feel like I have exhausted my options! Once that happens will post the outcome

Re: Query Layer Issue - Not behaving properly in ArcMap

RexRobichaux2 — Thu, 04 Jan 2018 18:13:57 GMT

Hi Pamela,

I hope the re-image fixes the issues you have been experiencing. You mentioned earlier that you applied one 10.4.1 SQL Server patch that you found- can you remember which patch this was? There are two patches in particular that I'd recommend installing for 10.4.1 / SQL Server data consumption:

10.4.1 SQL Server Quality Improvement Patch: ArcGIS 10.4.1 for (Desktop, Engine, Server) SQL Server Quality Improvement Patch
10.4.1 SQL Mixed Precision Patch: ArcGIS 10.4.1 for (Desktop, Server) SQL Server Mixed Precision Patch

Hopefully, between re-imaging and applying these patches, you won't experience this any longer. Also- if the issue still persists I'd recommend getting in touch with Esri Support Services to further analyze this behavior. Having the crash dump files that should be stored at the location below on your PC might be helpful as well if this is a known issue. Hope this helps!

C:\Users\<username>\AppData\Local\ESRI\ErrorReports

Re: Query Layer Issue - Not behaving properly in ArcMap

PamelaLocke1 — Wed, 24 Jan 2018 14:47:49 GMT

I had my computer re-imaged and upgraded from Windows 7 to Windows 10 - so far it looks like my problem has been solved!! (Fingers crossed )

Thank you everyone for your input!!

Pamela

Re: Query Layer Issue - Not behaving properly in ArcMap

MatthewAyer — Mon, 02 Apr 2018 12:30:06 GMT

I add this issue as well, and the only thing that worked for me was to turn off 'Background Processing' under Geoprocessing options.