POST
|
Hi Marina - I had to install the SQL Server 2017 native client again on some users computers to get it to work. Some computers had older SQL Server native clients and i believe that is what was messing with the connection file. Once it was all cleaned up with a new 2017 native client it started behaving again
... View more
03-12-2020
02:46 PM
|
0
|
1
|
1393
|
POST
|
I checked the permission differences in each feature class within the feature dataset and they all have the same permissions - I also created a brand new feature dataset and then added a new feature class and still behaving the same. Another difference that I spotted is: The ones that are working are; outside of a feature dataset and look like this: GISDB.PORT.TAXLOT_PORT The ones that are not working are (1) within a feature datastet and (2) outside of a feature dataset. but look like this: gisdb.PORT.lease_activedoco_join So not sure if that is causing an issue for the MXD to reset back the SQL connection are the ones that are lowercase? We have not had ran into this issue before.
... View more
10-08-2019
01:43 PM
|
0
|
1
|
1393
|
POST
|
A new insight to this is I found out that it's only layers that are within a Feature Dataset that are causing the problem. If the feature class is not within a feature dataset I can save and open the mxd just fine.
... View more
10-04-2019
02:32 PM
|
0
|
3
|
1393
|
POST
|
I'm not sure that it's the SQL server connection since its the same native client that is installed on VM that is on our desktops - and I can access SDE just fine on the VM and on my desktop its literally when I only try to save that the connection changes on my desktop.
... View more
10-04-2019
10:16 AM
|
0
|
1
|
1393
|
POST
|
I have Microsoft SQL Server 2012 Native Client installed on my machine - it's the same that is on the VM machine that is where the MXD is working
... View more
10-04-2019
09:54 AM
|
0
|
3
|
2542
|
POST
|
Re-installing ArcMap did not help. Also sorry about the confusion, but I just received more information from our team that our SQL server is NOT highly available for both our test and prod environments. Also, I tried saving an ArcScene map (realize that ArcScene does not save as a MXD) but it worked when I saved and reopened again. So not sure why it's only for MXDs that the connections change.
... View more
10-04-2019
08:56 AM
|
1
|
5
|
2542
|
POST
|
Another test that I just ran too is the MXD Doctor and I can see all the connections and the layers just fine in the viewer - but when I open the MXD the connections are lost. So I'll try to uninstall and reinstall ArcMap and see if that clears it up.
... View more
10-03-2019
03:24 PM
|
0
|
0
|
2542
|
POST
|
What is interesting about the SDE connection is that when I open a MXD on my VM (the VM has the SQL server) everything works just fine- where I can save the MXD and the connections are not lost when I open it back up. It's only when I try to save a MXD on my personal machine that this is happening. Not sure why all of a sudden that local machines are reverting back this old 'old school ArcSDE'? I tried the rebuild and that still didn't work either, and our SQL Server is highly available.
... View more
10-03-2019
01:45 PM
|
0
|
8
|
2542
|
POST
|
Hi George - we are using SQL Server 2017 and not sure where to find if it's highly available. also when you say 'delete the .sde connection file and recreate it' are you saying delete it from catalog and add it back or create a whole new .sde file?
... View more
10-03-2019
10:25 AM
|
0
|
10
|
2542
|
POST
|
When I add a layer from our SDE it displays fine and I can edit - but when I go to save and close the MXD then reopen it back up the data sources connections are lost (screen shot 1 below) then once I set data source it works (screen shot 2 below). To make it more confusing - when I open the MXD and remove the layer then re-add it back in the connection works! I have ArcGIS 10.6, SQL Server, and Windows 10
... View more
10-02-2019
04:17 PM
|
0
|
19
|
4304
|
POST
|
So after following your links i was able to see that if I use the 'Create Database View' tool and just straight up make a view called "mv_ELEC_VAULT" that trigger (created way before my time...) ended up working!! No need to figure out how to use the SDE Command Line tools - Again, thanks for your insight and I was able to get the issue resolved. Now off to making all these new views.
... View more
09-24-2019
03:50 PM
|
0
|
1
|
10350
|
POST
|
I think we are getting closer now to figuring out the issue and it's those MV tables that -like you said- need to be created with the SDE command-line tools. I'm meeting with my team here soon to find if there is extra documentation somewhere about creating those and if we get stuck again - I'll gladly take that Tech Supports help. Thanks for the bit of insight of the issue so far!
... View more
09-24-2019
01:56 PM
|
0
|
3
|
10350
|
POST
|
I've looked in Table and Views in SQL server have not been able to find that port.mv_ELEC_VAULT - either its really good at hiding or it no longer exists (I fear the latter). I've found past documents on our GIS DB creation showing that MV tables are required, so not sure how those are set up ie different than the versioned tables that end in "_evw"
... View more
09-24-2019
11:57 AM
|
0
|
0
|
10350
|
POST
|
I was wondering if that "mv_" was related to a multi-versioned view created before. I tried your step and the Enable SQL Access option is greyed out and I'm the dataowner
... View more
09-24-2019
11:25 AM
|
0
|
2
|
10350
|
POST
|
This error pops up when I'm trying to edit a feature in a feature class: "Attribute Update: An unexpected failure occurred. DBMS table not found [42S02:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'port.mv_ELEC_VAULT'.][gisdb.PORT.elec_vault] but it lets me delete the feature and I can create a new feature as well. I've tried unregistering and re-registering DB and compress and all that -
... View more
09-24-2019
10:34 AM
|
0
|
9
|
11913
|
Title | Kudos | Posted |
---|---|---|
1 | 09-07-2018 09:36 AM | |
1 | 10-04-2019 08:56 AM | |
1 | 04-20-2015 08:07 AM | |
1 | 08-03-2018 12:24 PM | |
2 | 05-11-2015 08:55 AM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|