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

ArcSDE 9.2 SP6 upgrade to ArcSDE 10 SP5 upgrade issue

MilosMilicevic

Hello,

I am having issues with upgrading to ArcSDE 10 SP5.
My gdb is on ArcSDE 9.2 SP6 on Oracle 10.2.0.3 x32 .I have migrated the data to Oracle 11.2.0.3 x64 (Server 2008 R2 x64), and trying to make a direct connection through ArcCatalog 10, in order to perform the upgrade to ArcSDE 10 SP5.

The problem that I encounter is that the direct connection will not work. It gives all sort of error messages (the most common one is a general DBMS error "underlying DBMS error [Unkonown error.No extended error.]".
We have installed the 32bit Oracle Client (full, not Instant), but avail.
I have followed the instructions on ESRI site, on how to connect without SDE service, eg: sde:oracle11g:<Net service name 32bit>
What is interesting is this: When i try to connect to the new database, from the old server, with ArcCatalog 9.2, it connects and shows all the data, but cannot upgrade, since it has ArcSDE 9.2 installed, and I cannot install a new version since that server still runs as a production server.

Please advise...
tnx in advance.
Regards,
Milos.

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

MilosMilicevic

@Marco: I don't have the username and password for customer care...
@Vince: Yes, it contains the line...

My SDEHOME environment variable points to the only one ArcSDE home, in x64 Program Files.
I just type sdesetup -o update_key -d ORACLE11G -l '...' -p SDEpass... Also, when I use the postinstall tool, it fails with a general error :
Error: Operation Failed (-1).
Error upgrading authorization key.

P.S. How do I find out which version of SDE is installed (workgroup, Enterprise... ) ?
P.P.S. I am thinking just now and this came to me:

I did the ArcSDE Geodatabase upgrade using a direct connection to the old 10g Oracle server from my new test server, through ArcCAtalog v10. But, I did not uninstall the old ArcSDE on the old server before I did the upgrade! Could this be a problem?!

MarcoBoeringa

@Marco: I don't have the username and password for customer care...

Than I recommend you to get those. I guess your ESRI representative should be able to give them without issues. It could well be that you, as I presume you are the geodatabase administrator, are already registered for the Customer Care portal. Otherwise someone else at your organization who is responsible for buying the licences of ArcGIS.

P.S. How do I find out which version of SDE is installed (workgroup, Enterprise... ) ?
P.P.S. I am thinking just now and this came to me:

I don't know. Maybe you can find it in the Windows Registry, Vince undoubtedly has better instructions.

I did the ArcSDE Geodatabase upgrade using a direct connection to the old 10g Oracle server from my new test server, through ArcCAtalog v10. But, I did not uninstall the old ArcSDE on the old server before I did the upgrade! Could this be a problem?!

Well, according to the instructions here, you are supposed to uninstall the old ArcSDE before upgrading the geodatabase. But that is also a situation where you intend to install ArcSDE on the same machine again, whereas your situation is different: you want to install the upgraded geodatabase and ArcSDE on a different machine.

Maybe, in your case, simply shutting down any running ArcSDE Application Server, is enough to allow a good upgrade of the geodatabase. And, as long as you don't attempt to run the old 9.2 AS again against the geodatabase, it might be good.

I think you reported the upgrade finished well with no error? Might be an indication that the actual upgrade of the geodatabase tables / schema went well.

Vince can probably give more specific input here.

From the Help page:

12.Uninstall the old release of ArcSDE. See either Uninstalling ArcSDE from Windows or Uninstalling ArcSDE from Linux or UNIX for instructions.
13.In Windows, you are prompted to delete the ArcSDE services during the uninstallation process if any are running. Click Yes to delete the service if you are installing a new release of ArcSDE. If you are installing a service pack or patch, you can click No and reuse the service unless the service pack or patch instructions specify that you must re-create the service. (For example, if the service pack or patch fixes something in the service functionality, you most likely need to re-create it.)
14.Install the new release of ArcSDE.
On Windows operating systems, do not run the Post Installation wizard. The Post Installation wizard is for new installations only.

If installing ArcSDE 10 on Linux, apply service pack 1.

MarcoBoeringa

I do think contacting your ESRI representative to find out if you have the right licence files and ArcSDE installation, and getting them if not, is now important.

Also find out the Customer Care login so you can see what is there, maybe you can download the right install there. If not, you are not properly registered at ESRI and your ESRI representative should change that.

MilosMilicevic

hm...the trouble with ESRi here is that they don't care or don't know how to help me.
I am already trying to solve this with them, but none of their suggestions helped me so far...so my best chance to solve this is with you guys 🙂
Also, on my question, is the CD they gave me Enterprise or Workgroup, they said : "That is the only SDE install CD we have, so it must be correct. " 🙂 🙂

Yes, the log had no errors or warnings and it said that it finished succesfully. Also I tried to connect using ArcCatalog 9.2 and it said that it cannot access the later ArcSDE from an older release of ArcCatalog (or something like that). And the old server SDE service cannot start, so I think that the upgrade went ok.

MarcoBoeringa

Also, on my question, is the CD they gave me Enterprise or Workgroup, they said : "That is the only SDE install CD we have, so it must be correct. " 🙂 🙂

😞

Well, actually, I don't know if there are actually any differences in installation, so they might be right in the end. To be honest, it is quite a while I had to install ArcSDE myself.

Yes, the log had no errors or warnings and it said that it finished succesfully. Also I tried to connect using ArcCatalog 9.2 and it said that it cannot access the later ArcSDE from an older release of ArcCatalog (or something like that). And the old server SDE service cannot start, so I think that the upgrade went ok.

It sounds so... I think you may be OK as far as the geodatabase upgrade concerns. That still leaves you with the question to get valid licence files. If the files are wrong, nothing you do or we suggest will help and you really do need to get new *.ecp licence files for your 10.0 ArcSDE Enterprise Standard licence.

P.S. On this page:
http://www.esri.com/software/arcgis/arcgisserver/features/enterprise-workgroup
it says (note this is 10.1, but I guess this hasn't changed), that Workgroup edition ArcGIS for Server comes shipped with SQL Server Express 2008 R2, limited to 10GB databases.

Was that installation included on your DVDs? Might be an indication as to what installation you have.

MilosMilicevic

I killed the server...reinstalled the Windows and now starting everything from scratch, so I could eliminate the registry, Oracle RDBMS itself, etc as an issue.
Afterwards, I will do the whole process again, from the import and so on...

Marco, I looked at my install DVD and could not find the installation of SQL Server Express, only ArcSDE for SQL Server... Does this mean, that I have the Enterprise DVD?

M.

MarcoBoeringa

Marco, I looked at my install DVD and could not find the installation of SQL Server Express, only ArcSDE for SQL Server... Does this mean, that I have the Enterprise DVD?

M.

I can't say for sure, but it looks like it. Although this error message you posted still bothers me:

ArcSdeServer license not found in license file(-8001). Error reading license information Error: (-8001) You are not licensed for SdeWorkGroup..

As you correctly wondered, why this error about SdeWorkGroup?

Anyway, have you now requested the proper licence files from ESRI?

MilosMilicevic

Yes, I have asked them to check version they gave me with the licenses.
They say it is ok...

I have reinstalled the server, Installed everything from the start, and still cannot do a direct connect.
Also, the license update will not pass no matter what I try. The errors are all the same...
This is useless!

M.

MarcoBoeringa

Yes, I have asked them to check version they gave me with the licenses.
They say it is ok...

I have reinstalled the server, Installed everything from the start, and still cannot do a direct connect.
Also, the license update will not pass no matter what I try. The errors are all the same...
This is useless!

M.

Milo, you have not answered Vince's question that will also answer whether your ESRI representatives are right with "...it is ok...":

See this text by Vince in one of the post above:

"Does the new license file have a line that starts with "arcsdeserver,100"?

What tool are you using to apply the new license?
(Hint: It should be "sdesetup -o update_key", and the binary should be
from an SP5-patched ArcSDE 10.0 Oracle 11g 64-bit SDEHOME)"

If your licence file doesn't start with the arcsdeserver,100, it is almost a certainty they gave you the wrong licence files, no matter what they are saying to you.

Again, if you do get the credentials for the Customer Care portal, you no longer rely on your local representatives, you can than access your downloads and licences directly (if they are properly registered at ESRI USA).

MilosMilicevic

@Marco: I don't have the username and password for customer care...
@Vince: Yes, it contains the line...

That vas my reply.
The file contains the line that starts with arcsdeserver, only it is not a new line, but it only continues the line end of the previous feature (eg. svrstandard,100,ecp....arcsdeserver,100,ecp....).

I have asked them to give me the credentials, but they refused saying it will lead me to them again...

What annoys me the most is that I cannot do a direct connect... Through sqlplus it works from several machines, but through arccatalog it does not...I tried one more machine, but it will not connect the damn thing.

MarcoBoeringa

That was my reply.
The file contains the line that starts with arcsdeserver, only it is not a new line, but it only continues the line end of the previous feature (eg. svrstandard,100,ecp....arcsdeserver,100,ecp....).

Sorry, overlooked that one, you had confirmed it before. This thread is starting to become a bit long.

I have asked them to give me the credentials, but they refused saying it will lead me to them again...

Weird, I only have an ArcGIS for Home Use licence currently available with ArcSDE Personal, and I can simply login using my ESRI Global Account credentials. Even better, if I am already logged in here on the Forums using my Global Account, and switch to Customer Care, it automatically detects me and allows access. It gives me access to all the downloads and licencing information for my Home Use licence, I downloaded 10.1 from there without issue.

I guess it won't be different for big enterprise clients... Are you the only one involved in the ESRI licencing at your organization, and the only one having a Global Account?

What annoys me the most is that I cannot do a direct connect... Through sqlplus it works from several machines, but through arccatalog it does not...I tried one more machine, but it will not connect the damn thing.

If the licence process is not successfully finished, I think that is no surprise.

One thing though: are you absolutely sure you are using the right 32-bit Oracle Client when connecting? If ArcGIS somehow tries to use any 64-bit Oracle Client libraries to connect, it will fail. ArcGIS for Desktop is 32-bit and needs the 32-bit Oracle Client. Uninstall any 64-bit Oracle Client libraries if necessary to be sure it doesn't interfere (Leave them on the server, as ArcGIS for Server is 64-bit).

MilosMilicevic

Well I guess it is the right one, since I set the path to it in the Path variable...is there another way to ensure that?
I am a support engineer, a consultant, and my account has no connection to theese licenses...my colegues from the company that I work for as a consultant, do not have the ESRi accounts... I dont know how to get a customer number....
Regarding the Client, I suspect that is the problem, but dont know how to deal with it...

If i set the first path in the PATH variable to be to the 32bit client, shouldn't it be enough to point to ArcCatalog which service name to use?

M.

MarcoBoeringa

Milo, now you seem to have valid 10.0 licence keys, maybe trying to manually update the keys in the "server_config" table using:

sqlplus sde/password@instance
UPDATE server_config SET char_prop_value='arcsdeserver,100,ecpYOUR_ArcSDE10_CODE,none,YOUR_ArcSDE10_CODE' WHERE prop_name = 'AUTH_KEY';

might be an option. I hope Vince can confirm this as a valid operation or not.

VinceAngelo

If you are deploying this for a customer, then you should be using the customer's
user number and support resouces. If it's a legal copy with current maintenance,
they'll have the Customer Service contact information.

License files sometimes only have newlines, not {CR}{LF} pairs, which depending
on the editor, may seem like one line.

The UPDATE statement should work, though sometimes I've gotten a bad key file
and needed to have it re-issued.

- V

MarcoBoeringa

Milo,

Have you ever tried to run the post installation with the specific right-click menu option "Run as Administrator"?

It may be a long shot, but sometimes, even when your logged on as Administrator, you still need "Run as Administrator" to get something to work, especially with legacy software.

Marco

MilosMilicevic

Vince,
I have tried to request access to the customers portal using my customer's customer number, but someone from ESRi forwarded me to my local esri dealer, as they already told me it would happen. So that is off...

Did the update, and tried to create the service with sdeservice -o create.... but avail.
Marco,

I tried tthe Run as administrator, since I found a topic on the forum...no results.

So, as the things are going badly, this is how it is going to be:
Since the ArcGIS Desktop is here used as a base form some Utillity Extension, I will create a new empty gdb, create new SDE user and repository, and use the extensions tools to export/upgrade the data and then bulk load it back to the ArcSDE.
I do not see any other solution.
There is something very wrong in the way upgrades are ment to be performed, or in the software configuration that was asked from the extension manufacturer, or maybe in the position of the stars for the past two weeks that I have lost doing this. 🙂
I suspect that the Oracle client refuses connection to database, or ArcCatalog cannot connect to it, even though they are both x86.

I just give up, since I have an alternative...not a better one, but an usable one.

Thanks for your help guys, you were great.
Best regards.
Milos

product-survey-banner-1200x257.gif

MarcoBoeringa

So, as the things are going badly, this is how it is going to be:
Since the ArcGIS Desktop is here used as a base form some Utillity Extension, I will create a new empty gdb, create new SDE user and repository, and use the extensions tools to export/upgrade the data and then bulk load it back to the ArcSDE.
I do not see any other solution.

...

I just give up, since I have an alternative...not a better one, but an usable one.

Milos,

Sorry to hear that, but you are probably right it is now the best way to go. I am out of ideas of helping you "remotely"... If you can solve your issues this way, than by all means go for it and don't waste any more time on the impossible "upgrade path".

There is something very wrong in the way upgrades are ment to be performed, or in the software configuration that was asked from the extension manufacturer, or maybe in the position of the stars for the past two weeks that I have lost doing this. 🙂

Yeh, I guess the stars didn't align up well... 😉

Good luck with rebuilding and loading the data.

Marco

VinceAngelo

Rather than giving up, I'd recommend you create a new database instance, and try
installing a new 10.1 geodatabase in that 11g instance. If this works, you can copy
the data from the old instance to the new. If it doesn't, maybe that will help you
determine why there has been so much difficulty (I've never had an ArcSDE for
Oracle upgrade fail, and I've been doing them since Oracle 7 and SDE 2.0).

- V

JimRisley

Hi Milos,

Have you logged a support request with your local distributor? If not, please do so. Our team in International Support in the US work closely with our international distributors to troubleshoot issues such as these, and the distributor can and will involve us as necessary. You can find contact information for your local distributor here:

http://www.esri.com/about-esri/contact

Thanks,

Jim R.
Int'l Support

MilosMilicevic

It seems that we think alike, Vince 🙂
I didn't give up, instead I decided to follow this manual:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Migrating_to_ArcSDE_64_bit_on_Windows_when_the_existing_DBMS_is_32_bit/002n000000q0000000/

I deleted the geodatabase, created a new one, empty, and installed ArcSDE from the scratch...created the repository, user and voila....the authorization passed without a glitch. So it wasn't the license code...
Then, I created the service, started also without problems.
My next step was to create a direct connect from the new test server(ArcCatalog 10) to the old test server (the one I upgraded the ArcSDE from 9.2 to 10 on),and started copying the FDS using ArcCatalog copy - paste mechanism.

Everything went well, with minor stops because of the relationship classes and extensions, privileges, roles creation etc...but now I get the error in the attach, and do not know what it is: [ATTACH=CONFIG]24308[/ATTACH]

Any ideas?
Tnx,

M.

Capture.JPG

MarcoBoeringa

It seems that we think alike, Vince 🙂
I didn't give up, instead I decided to follow this manual:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Migrating_to_ArcSDE_64_bit_on_Windows_when_the_existing_DBMS_is_32_bit/002n000000q0000000/

I deleted the geodatabase, created a new one, empty, and installed ArcSDE from the scratch...created the repository, user and voila....the authorization passed without a glitch. So it wasn't the license code...
Then, I created the service, started also without problems.

Good to hear you finally managed to make headway and get it running! 🙂

But hey, didn't I point out that Help link before to you?!!

...

;);)

Everything went well, with minor stops because of the relationship classes and extensions, privileges, roles creation etc...but now I get the error in the attach, and do not know what it is: [ATTACH=CONFIG]24308[/ATTACH]

Any ideas?
Tnx,

M.

Can you provide some more context to this. Is "UTARC" a Feature Class or Stand-alone Table in the original 9.2 geodatabase?

And is there a field called "CO_C_JOINT_TYPE" in the attribute table?

Is this UTARC table potentially from another business system, registered with the geodatabase but not initially created by ArcGIS?

I think you mentioned this whole database involved an Utility Extension? Have you thought of installing that on the new server and client PCs, so that ArcGIS knows about specific custom objects added to the geodatabase base model?

MilosMilicevic

I have contacted the local ESRI dealer, and they will come to assistance today, since they are but busy...
Marco, yes you did, but I had overlooked the possibility, and maybe had to much confidence in Oracle's expdp. 🙂

UTARC is a schema name, and CO_C_JOINT_TYPE is the table owned by utarc.
I solved the issue, the problem was that the table was not registered with the gdb (had no objectid field)...
It seems that now everything works... I have copied everything, and all the data is now on Oracle 11g under SDE 10 SP5.

Thanks to you guys, your suggestions saved me.

P.S. If I run into more troubles, I'll come back 🙂

Best regards,
Milos

MarcoBoeringa

I have contacted the local ESRI dealer, and they will come to assistance today, since they are but busy...
...
It seems that now everything works... I have copied everything, and all the data is now on Oracle 11g under SDE 10 SP5.

Seems to me it's just going to be coffee and tea with ESRI... 😉 Anyway, may not be a bad thing to have just one last "check-up" on the finished work by someone with a fresh look on it and able to assist you directly versus "remote"...

Thanks to you guys, your suggestions saved me.

P.S. If I run into more troubles, I'll come back 🙂

You're welcome, and let us know the final outcome!

MilosMilicevic

Well,

it seems my troubles have ended, succesfully.
The problem was with the SDE.GDB_ITEMS.
It seems that Oracle datapump has issues with ST_GEOMETRY, and it will not copy the rows, it only creates the table structure.
So, here is what I did:

Did the expdp of the schemas needed, and a standalone export with exp tool of the gdb_items table.
used impdp to import the schemas.
Truncated the gdb_items table in the gdb, and used imp to import the gdb_items table alone.
Then run a script that refreshes the grants, recreates users, roles, and everything worked like a charm.

Best regards,
Milos.

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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