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

SDE Database connection curruption in SQL server.

PaulWirth

I have an SDE SQL database that has been somehow corrupted. I cannot connect to it from ArcGIS desktop anymore. It was 10.x something. I need help fixing this connection and if I can't somehow copy the data and design out of it and save it somewhere else.

Najděte více příspěvků označených jako

Database Access

Databases

Accepted answers

All comments

VinceAngelo

More information is needed:

What exact RDBMS are you using? (If it's changed recently, we need both old and new versions)
What is the exact release of the geodatabase? ("10.x something" encompasses most databases produced in the past decade)
What is the exact release of the GIS client used to connect to the database?
Has anything changed on the system?

- V

PaulWirth

SQL server 2012 R2

I do not know the exact release sorry, it is an earlier one maybe 10.1

MarlonAmaya

@PaulWirth

If we do not know the specific version of the enterprise geodatabase. Can you provide the ArcGIS Client and version you are currently using?

If you can't cannot to it anymore, when was the last time you were able to connect to the database and was it using the same client you have now?

Can you provide an error message you receive from ArcMap/Pro?

Marlon

PaulWirth

I know I upgraded to 10.x from 9.1. Somehow something is wrong or got changed. Nothing happened to my other sde.

MMBR

@PaulWirth

1. You need to upgrade the Geodatabase Repository

Client and geodatabase compatibility—ArcGIS Server | Documentation for ArcGIS Enterprise

2. Old versions of SQL Server are not supported with new version of ArcGIS Desktop.

You need to upgrade your SQL Server version to a supported version.

Microsoft SQL Server database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.3 and 2.4—System Requirements | Documentation

You also need to upgrade the Microsoft ODBC Driver Version to a supported version when SQL Server is in one machine and ArcGIS Desktop is in another machine.

PaulWirth

Marcelo,

I understand with what you want me to do and I don't disagree. The problem I am having is that I have another SDE database in the same area and on the same SQL server 2012 R2 that I can connect to using my ArcGIS desktop 10.7.1 or ArcGIS Pro 3.0.3, with no problem. Is there some way to fix it without upgrading at this time because everything else is working, upgrading is a hassle with IT, and there is no guarantee that upgrading will work and now everything that works now doesn't.

Really all I want to do is copy all that info and design in that SDE database and paste it into another database if that one is somehow corrupt.

ShannonShields

It is likely that the geodatabase you can connect to has been upgraded to a 10.x release. Geodatabase upgrades are separate from upgrading ArcMap and ArcGIS Pro, as well as SQL Server.

Are you able to connect directly to the SQL Server instance using SQL Server Management Studio? If you can, look for a table called sde_version and compare the contents between the database you can connect to, and the one you to which you cannot.

Newer ArcGIS clients cannot upgrade geodatabases that are at versions earlier than 10.1. Major changes were made to the structure of geodatabases at 10.0, and upgrades to 10.0 or later releases could only be done from a geodatabase that was upgraded to 9.3.

Do you have access to older versions of ArcSDE software? This is going to be the only way to get the 9.1 database upgraded to a point where it can either be seen from 10.x and Pro software, or upgraded to something that can be connected to.
This doc from 10.1 https://resources.arcgis.com/en/help/main/10.1/index.html#/A_quick_tour_of_enterprise_geodatabase_upgrades/002q0000005p000000/
outlines
You can upgrade ArcSDE 9.3, 9.3.1, or 10 geodatabases to geodatabase release 10.1. If your geodatabase is at a lower release, you must first upgrade to a supported release, then upgrade to 10.1.
Getting to 9.3 from 9.1 is going to require ArcSDE software - upgrades prior to 10.x were done using ArcSDE software, not Desktop applications like ArcMap.

-Shannon

MMBR

@PaulWirth - Please see @ShannonShields reply above. She is right on the problem there.

PaulWirth

Shannon

I don't understand it, but it happened. In the version under the database that doesn't work it says 9.1. I know I upgraded about 10 years ago to 9.3 and then to 10.1, but somehow it got changed (IT). The other one that works says 10.7.1. I don't use this database obviously on a regular bases or else I would have known when the problem happened. I didn't create it, but I do want the data, table, design from it, so I can clean up the sde databases.. Is there a way to do this in sql server using some database diagrammer or design programm that captures the tables and how they are connected in sql server. I remember hearing something about that more than 10 years ago from an ESRI support specialist that worked with SDE databases.

ShannonShields

Could it be that the database was overwritten with an older backup? Could you check with whomever manages the SQL Server instance to see if you can get the upgraded database back?
There isn't any straightforward, or supported way to get anything out of a really old ArcSDE database without ArcGIS software. The data pre-dates SQL Server spatial types, which wasn't introduced until 2008, so all the spatial data would still be in sdebinary format. The 'geodatabase' component was in the old model where any behavior (subtypes, domains, relationships etc) was stored in blob formats. Before trying to hack anything at the database level I'd exhaust the possibilities of getting a newer backup restored, or getting access to old ArcSDE software to perform the upgrade.

PaulWirth

Well, it must have happened a while ago and IT will be unable to restore it. The other option is also not available to me either because I do not have the 9.1 - 9.3 sde disc with me anymore. I remember throwing it away because I upgraded everything to 10.x and IT reverted it back to 9.1. Any other ideas would be appreciated.

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.