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

I noticed on the geodatabase (dataset) upgrade documentation for 10.7.X that something says (checklist item): Have all custom functionality added to the geodatabase system tables outside ArcGIS, such as triggers or additional indexes been removed?

JohnPavek

I would like to know is there a way around this step? We are going from 10.2.2 to 10.7.1. It is going to add a lot more hassle trying to minimize the downtime for the Production. We have to take things out, do the upgrade and put them back in hopefully as it was before without issues. If we could just do the upgrade without this step we can save time and not risk issues when things are put back. THANK YOU ALL!

Find more posts tagged with

Accepted answers

All comments

WillStafford

In reading this you said SDE schema and User Schema
Major Flags here Read this

Some clarification on terms/routine regarding user schema SDE in oracle.
Note:

Beginning with ArcGIS 10.7 and ArcGIS Pro 2.3, you cannot create user-schema geodatabases in Oracle.

That will be the biggest hurdle the "user geodatabases"

My Advice after 30 years in SDE. Make a new box and start migrating everything to a new geodatabase. You are NOT the only one out there impacted by this.
Plain tables added to the SDE geodatabase are okay to leave. Triggers, procs etc (database stuff) added to the sde geodatabase need to be pulled out and saved to a text files for later import.

Good Luck let us know how it turns out.
Will

Asrujit_SenGupta

Why not restore the entire Oracle DB on a test instance and try to upgrade. Check the issues you encounter and then move ahead accordingly..

JohnPavek

Hi Marco

Thanks for the reply. Believe me I agree with George major...unfortunately they didn't do backups as much as they should of here in the past

I'm trying to get more info about the "highly customized environment". But I know they have made many changes to give clients very specific functionality. I wish I had specifics right now but this just became a major issue last week. I have avoided large amounts of customization in my career just because of issues like this. Back when I started in the 1980's we needed it because GIS was still coming out of its infancy. Eventually I got rid of almost all of it.

Like most geodatabases we have an SDE schema and a User schema. Both have their tables and such as you know. From the limited info I can find so far it appears that if the changes are outside the geodatabase system tables we should be good. I just saw this in a doc about the upgrade tool and its use but what I gave here is about all i found from ESRI or anybody else which has been frustrating.

So I really could use the following info still...what things are typically removed? If I have customization in non-geodatabase system tables am I good to do the upgrade without removing it? Has anybody gone thru this and can give some examples of what they did? Is there any ESRI written info that explains this in more detail?

I understand Marco that I think you and I are seeing that any customizations outside the geodatabase system tables should be good to leave alone as long as the geodatabase system tables are clean. I just trying to get things as definitive as possible. I always appreciate any info you can give.

MarcoBoeringa

You do not specify, except a brief mentioning of "user tables, non-sde", what it actually is that constitutes your "highly customized environment"...

You could have a "highly customized environment" which still behaves entirely, and acts within, the geodatabase concept, but only a review of the applications / extensions involved and contacting the parties who developed it, should tell you this.

I don't think having some "user tables, non-sde" is necessarily a problem if that is the only true "customization" you have done. If I quote your quote of the docs, it says:

Have all custom functionality added to the geodatabase system tables outside ArcGIS, such as triggers or additional indexes been removed?

which specifically references the actual geodatabase system tables, not user tables or non-sde stuff inside the same database. So, the first question for you to answer to yourself is, do you have custom "triggers or additional indexes" set on the geodatabase "system" tables to implement some of that "highly customized environment"?

If not, you are likely safe upgrading the geodatabase.

That said, I would certainly take George Thompson‌ 's advice and ensure you have a full - and restore tested(!) - backup of your geodatabase before doing any upgrading of the geodatabase environment. You will be even worse off if anything fails and you don't have a working backup to quickly restore your environment.

JohnPavek

I appreciate George's answer very much! But it really is a pain dealing with that esp in such a highly customized environment like I'm now in.

So the next question in the progression is...what specifically has to be removed and is there any documentation that details this action? If we have to remove things like user tables, non-sde that is going to be a pain but if it is just anything in the SDE tables still a pain but not as bad. Can somebody give me info on this please...pretty please? :-). If this is majorly involved we may just do a migration method instead of upgrade.

Thanks again George!

George Thompson

I am not sure that there is a way around this in a safe and supported manner. I would highly recommend following the upgrading steps to make sure that it is successful.

I would recommend taking a backup and restoring to another instance and test the upgrade process to determine potential downtime.

JohnPavek

I see some views of this but no answer yet. So just to make sure people know the question...I noticed on the geodatabase (dataset) upgrade documentation for 10.7.X that something says (checklist item): "Have all custom functionality added to the geodatabase system tables outside ArcGIS, such as triggers or additional indexes been removed?" I would like to know is there a way around this step for us?

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.