topic Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase in Data Management Questions

Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Wed, 29 Aug 2012 14:18:45 GMT

Original User: nsridb

We are trying to upgrade a version 10.0 64 bit arcsde to a 10.1 64bit version (on Red Hat 5 64bit, Oracle 11 64bit).

We are getting the error message:
Cannot upgrade a user schema geodatabase
when the master schema geodatabase is at a previous release.
The master schema geodatabase must be upgraded first.

Unfortunately we don't have any user schema geodatabases as far as I can tell so can anyone tell me what the problem is.

I've checked the geodatabases using sdemon -o info -I instance and only the SDE master geodatabase appears.

Any help?

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Thu, 30 Aug 2012 15:16:29 GMT

Original User: yyngoh

Hi,

what user were you connected with when trying to upgrade? If it is not the SDE user, try connecting as SDE user.

Eugene

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Mon, 03 Sep 2012 07:21:32 GMT

Original User: nsridb

I was logged in as SDE so it shouldn't be that, and we've granted SDE all the relevant permissions.

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Tue, 04 Sep 2012 07:16:30 GMT

Original User: nsridb

I think we may have found what was causing the problem here. My ArcCatalog client was using Oracle InstantClient v11.2 to make the direct connection to the ArcSDE/oracle server. Although InstantClient is supposed to be compatible with ArcSDE 10.2 it appears there are still problems. I therefore installed the full Oracle client software. Checked the path and the TNS_ADMIN pointed at the right locations and tried again. This time successfully. Now we need to try it for real.

Caroline

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

PaulGrimes — Thu, 06 Sep 2012 08:44:54 GMT

Hi I have a similar issue but I'm using the full client, paths and libraries are correct .. but still no joy.

Did you solution work and if so what client version did you install please.

Thanks

Paulg

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Thu, 06 Sep 2012 14:42:48 GMT

Original User: nsridb

I installed oracle client 11.2.0. It came as two zip files win32_11gR2_database_1of2.zip and win32_11gR2_database_2of2.zip.
I installed the 32 bit client even though I have a 64 bit PC as I believe this is necessary, though I might be wrong.

I installed it to the folder D:\Tools\Oracle.
The only oracle directory in the path was then D:\tools\oracle\product\11.2.0\dbhome_1\bin
the TNS_ADMIN environment variable was set to D:\tools\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN
I made sure the SQLNET.ORA and TNSNAMES.ora files were in this folder.

I don't have any other environment variables set for libraries or such.

We are now retrying the upgrade in test from start to finish to see if it still works before hopefully attempting it for real next week.

Hope this helps.

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

KimPeter — Thu, 06 Sep 2012 16:13:20 GMT

You should be able to upgrade even when using the Oracle Instant Client. If this is not working, please contact Esri tech support so we can figure out what is happening in specific instances.

Thanks,

Kim

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Fri, 07 Sep 2012 14:11:34 GMT

Original User: Paulg

Thanks Caroline for taking the time to reply. Thanks Kim for the instruction..

I have a call logged with Esri-UK and its still in progress - I'll update the status if/when we get it working

just as background I have a 11.2.0.2 64bit oracle MasterSchema Geodatabse on a Win 2003r2 64 bit box and I have tried with Desktop Advanced 10.1 on the server using a 32bit client with the TNS sorted etc. as well as on a new pc on the newtork with a 11.2.0.2 client. I can connect, I can do a prerequisit test (perfect) but it errors on the upgrade bit. I have enabled tracing in oracle and all looks ok, normal enought queries and request and no errors!

[Fri Sep 07 15:36:30 2012] Cannot upgrade a user schema geodatabase
when the master schema geodatabase is at a previous release.
The master schema geodatabase must be upgraded first.
[Fri Sep 07 15:36:30 2012] ERROR: Geodatabase schema object install not completed (-522).

there is only one instance
SELECT * FROM SDE.INSTANCES;

INSTANCE_ID INSTANCE_NAME                    CREATION_     STATUS TIME_LAST

----------- -------------------------------- --------- ---------- ---------

          0 SDE                              16-DEC-09          1 06-SEP-12

If anybody has any contribution - by way of ideas of how I should go about resolving this I appreciate the follow-up.

Paulg

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Mon, 10 Sep 2012 08:50:24 GMT

Original User: nsridb

ESRI UK Tech support are aware of the issue I was having as it was them that suggested the InstantClient might be suspect. Though when he further investigated he reported that the problem with InstantClient has apparently been fixed in ArcSDE 10.1. By then however I had installed the full client (software only) on my PC and the upgrade worked.

We have just performed another successful test of the upgrade process. The only problem we are seeing now which we need to resolve before trying the upgrade for real is that the XML metadata is being corrupted when we upgrade from 9.2 to 10.0 and I'm not sure why or how to fix it post upgrade. I upgrade all the metadata on the live system so it is using the new ArcGIS metadata format (it was FGDC before).

Caroline

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

shirlymanimalethu — Tue, 11 Sep 2012 11:47:17 GMT

did you resolve this issue ? we are getting the same error .. just opened a ticket with ESRI on this ..

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Wed, 12 Sep 2012 08:55:27 GMT

Original User: Paulg

Hi ,

I still have the issue, I've tried everything (at least I think I have) -
1) uninstalled and reinstalled Oracle Clients - no joy.
2) Using Arccatalog I dropped all data in each schema - no joy.
3) Dropped each user that could ever have been in the database except obviously SDE and the generic Oracle Schemas. - no Joy
4) tried the python script to upgrade - same errors - management.py error on line 4063 as well as the usual entry in the log - no joy
5) restarted db server etc. - no joy

6) Stuck

Its a resonably big database 500gb, so the verison I have now has nothing in it and wont upgrade! - so we have to get the dba to do the space recovery on it so we can export it and send it to Esri Support - apparently this could take days.

So any response you get on your support ticket could you post it please incase it helps me.

Paulg

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Wed, 12 Sep 2012 12:15:26 GMT

Original User: nsridb

I'm sure it's something to do with the direct connect method. Have you checked your TNSNAMES.ora and SQLNET.ora files are correct and are in the directory pointed to by the TNS_NAMES environment variable?

My colleague was also using a full client install of oracle and he was getting the problem doing the upgrade, so it may not be as simple as InstantClient vs Full Client. It may however have something to do with a 32 bit client rather than a 64 bit client.

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

PaulGrimes — Fri, 14 Sep 2012 06:40:19 GMT

Thanks,

Your far off the mark... Its sorted thanks to the great detective work of a Support DBA in Esri-UK ( wont name just in case!) he persisted and tried every option and discovered the solution to my problem.

Use a 32 bit client in the client machine, take a look at the sqlnet.ora file and ensure the ezconnect is first eg .. NAMES.DIRECTORY_PATH= (EZCONNECT,TNSNAMES)

The from arcGis client do an 'Easy Connect' style connection to the database .... see http://resources.arcgis.com/en/help/main/10.1/index.html#//00290000003q000000

I used <servername>:<port>:<instance name> logged in as sde user and all worked like a dream.

I hope this helps anybody in the same situation.

Paulg

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Mon, 24 Sep 2012 12:37:52 GMT

Original User: nsridb

Interesting though I don't have ezconnect in the sqlnet.ora file and it worked for me. Glad you found a solution that works for you.

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

MuneebAnsari — Mon, 24 Sep 2012 16:14:57 GMT

Hi, ESRI is aware of this upgrade issue and a software bug has been logged: "NIM084987-When upgrading an ArcGIS 10 SP5 geodatabase to ArcGIS 10.1, while connecting with the syntax 'sde: oracle11g:TNSNAME' the upgrade fails with the error 'ERROR: geodatabase schema object install not completed (-522)."

http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3

-The workaround for this bug is to use the easy connect syntax to connect to the geodatabase or if you have the TNSNAME entry setup for the Oracle client, just make a connection to the Oracle geodatabase by typing only the TNSNAME in the 'Instance' textbox.

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Wed, 17 Oct 2012 16:13:46 GMT

Original User: andymartushev

I was seeing the same issue.

I resolved my problem by changing my connection instance to ip_address/servicename (sample 10.200.100.90/ora)

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

MariaThors — Fri, 25 Oct 2013 08:41:06 GMT

Hi, ESRI is aware of this upgrade issue and a software bug has been logged: "NIM084987-When upgrading an ArcGIS 10 SP5 geodatabase to ArcGIS 10.1, while connecting with the syntax 'sde: oracle11g:TNSNAME' the upgrade fails with the error 'ERROR: geodatabase schema object install not completed (-522)."

http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3

-The workaround for this bug is to use the easy connect syntax to connect to the geodatabase or if you have the TNSNAME entry setup for the Oracle client, just make a connection to the Oracle geodatabase by typing only the TNSNAME in the 'Instance' textbox.

Thanks a lot, this resolved my problem!

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

Anonymous User — Wed, 05 Mar 2014 17:47:26 GMT

Original User: PeterES

http://support.esri.com/en/bugs/nimbus/TklNMDg0OTg3

I used this to fix this problem as well. This was an upgrade from 10.0 to 10.1 on Oracle 11g. A simple fix if you can find the bug.

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

TomSchuller — Sat, 14 Feb 2015 06:28:41 GMT

Hy,

I just got it fixed by inluding the database @<instance name> in the password field:

Like this:

DataBase instance: GIS

Username: sde

Password: sde@GIS

Running under 10.3 with oracle on Linux

Tom

Re: Upgrade to 10.1 error Cannot upgrade a user schema geodatabase

LanceVarney — Fri, 24 Apr 2015 17:11:43 GMT

Thank you Tom! This solved it for me. I actually was upgrading from 10.0 sde to 10.22 sde.