Registering ArcSDE database with ArcGIS Server at 10.1

22564
22
Jump to solution
05-01-2012 12:40 PM
MattSimmons
Occasional Contributor
I've got Server 10.1 Prerelease up and running, and ArcSDE 10.1 up and running on Oracle 11g.  I've got Desktop 10.1 up and I'm trying to publish a service, but apparently I need to register the data with Server first. 
In Server Manager, I'm trying to do this by clicking Site -> Data Stores -> Register Database.  I browse to the local connection  *.sde file for that instance, click Import and I get a window that says

EDIT_PANE

and nothing else...... what the?
0 Kudos
1 Solution

Accepted Solutions
MattSimmons
Occasional Contributor
Thanks for your replies...

First, I double checked to ensure that the 64-bit client was installed on the client machine (for Server), and also the 32-bit client (for Desktop), and that the 64-bit path was before the 32-bit path in the environment variables.  They were all correct.  Still no success registering the datastore. 

I then uninstalled ArcGIS Server, and the Web Adapter and reinstalled.  I went through the same installation, even used the config.xml file set up in the initial install.   Boom - problem solved. 🙂  I went through the same steps and successfully registered the datastore via Server Manager; and then successfully published a service.

Can't say what the resolution was, but in my case uninstalling and reinstalling Server did the trick.

View solution in original post

22 Replies
MattSimmons
Occasional Contributor
Let me add to this...

I've also tried registering the database to ArcGIS Server via Desktop 10.1.  In the Catalog tree, right click the GIS Server connection and click Server Properties. On the Data Store tab, it's basically the same window as in Server Manager.  When I input the name and connection string, I'm getting the error: "The ArcgIS Server is not able to connect to the specified database.  Please ensure the database client libraries have been installed and the ArcGIS Server can access the database."

This seems to indicate a problem with the Oracle client on the client machine.  The client machine has the 32-bit Oracle client on it because it's also got Desktop 10.1 on it, which is a 32-bit applciation.  I can successfully connect, and administer, ArcSDE on this machine....

So, my environment looks like this:

ArcSDE 10.1 64-bit on a 64-bit Linux server
ArcGIS Server 10.1 is 64-bit native, and on a 64-bit Windows server
ArcGIS desktop is on this same 64-bit machine, but runs as a 32-bit app, and therefore....
Oracle client on this Desktop and Server machine is 32-bit

Anyone?
0 Kudos
LarsSitzmann
New Contributor
Hello,

I think I've got a similar problem.
Running ArcGIS Server 10.1 Pre on Windows 64bit machines (we've set up two different VMs). We've got several Oracle based 9.3.1 SDE instances running under Oracle 10g and we can't register a server connection to any of these SDEs with direct connect.

On one VM we installed ArcGIS Desktop and Server (both 10.1 pre) and therefor we installed both 32bit and 64bit Oracle client software (we instelled the 11g oracle client that ships with ArcGIS 10.1 pre).

On the ArcGIS Desktop side we've got no problems connecting to the SDE instances. But none of the servers are willing to register an enterprise connection.

If we try it with the web based ArcGIS Server Manager, we get the same "EDIT PANE"-Window msimmons75 gets. If we try it with the ArcCatalog (Server Properties... in the context menu of the admin-connection; Data Store-Tab; Register Database), we get the following error message:


[INDENT]WARNING 001308: The server is unable to connect to the database [The connection property set was missing a required property or the property value was unrecognized. Cannot connect to database because the database client software failed to load. Be sure the database client software is installed and configured correctly.].[/INDENT]


What can we do?
0 Kudos
LarsSitzmann
New Contributor
We found out some new information on this issue.

We tested with this small python-script on the machine that has only 64bit-Software installed (Ora-Client and AGS 10.1 pre):

import arcpy
arcpy.env.workspace=r"<path to our sde-connection-file>"
arcpy.ListDatasets()


This code doesn't show any errors, but it prints out an empty list instead of the list of our feature datasets.
When we look at the python.exe-process after we do this, we can see that the oracle client dlls are all loaded into the process as they should.

But in the application event log of the system we get the following error:

Fehler beim Generieren des Aktivierungskontextes für "C:\Program Files\Common Files\ArcGIS\bin\de\ResArcGISFileHelperLib.dll". 
Die abhängige Assemblierung "Microsoft.VC90.DebugCRT,processorArchitecture="amd64",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="9.0.21022.8"" 
konnte nicht gefunden werden. Verwenden Sie für eine detaillierte Diagnose das Programm "sxstrace.exe".


Sorry for the german. The message says, that ResArcGISFileHelperLib.dll cannot load "Microsoft.VC90.DebugCRT".

So my questions are?
    Why is the esri dll trying to load a debug version of the VC runtime?
    How can I install this debug libs?

Please help.
0 Kudos
EvaMui
by Esri Contributor
Esri Contributor
Beside making sure the Oracle 64-bit client is also installed on the machine where both ArcGIS Desktop and ArcGIS Server is installed, please also set the PATH variable to read the 64-bit client before the 32-bit client. 

Please refer to the documentation:
http://resourcesbeta.arcgis.com/en/help/main/10.1/index.html#//002n00000038000000
0 Kudos
MattSimmons
Occasional Contributor
Thanks for your replies...

First, I double checked to ensure that the 64-bit client was installed on the client machine (for Server), and also the 32-bit client (for Desktop), and that the 64-bit path was before the 32-bit path in the environment variables.  They were all correct.  Still no success registering the datastore. 

I then uninstalled ArcGIS Server, and the Web Adapter and reinstalled.  I went through the same installation, even used the config.xml file set up in the initial install.   Boom - problem solved. 🙂  I went through the same steps and successfully registered the datastore via Server Manager; and then successfully published a service.

Can't say what the resolution was, but in my case uninstalling and reinstalling Server did the trick.
LarsSitzmann
New Contributor
Or system now works too (at least the registration of the sde connection does).
The solution for us was taking the right oracle client. At the first step we installed the client software of the oracle enterprise installer, which obviously doesn't seem to cooperate well with ArcGIS Server. After uninstalling these oracle products and installing the oracle instant clients, the registration of the sde connection works.
0 Kudos
AlessandroAssom
New Contributor II
Hello, I solved the problem following these steps:
1) installing both the 64 and 32 bit version of the oracle client
2) placing the 64 bit path before the 32 bit path in the path system variable
3) creating a system variable TNS_ADMIN that points to the folder containing the tnsnames.ora file.

Finally I had to restart the ArcGIS Server process.

Ale
DerekWeatherbe
Esri Contributor
Hello,

I wanted to follow up on the reports in this thread where registering a database data store in Manager is displaying a dialog that says 'EDIT_PANE'. One known cause of the EDIT_PANE error is if the pre-configured System/PublishingTools service is stopped. Manager uses two tasks provided by this service for registering database data stores.  We will improve this workflow for SP1 by detecting when the service is stopped and allowing you to start it immediately without navigating away from this dialog.

I also wanted to highlight the point made by Ale: Restarting the ArcGIS Server service after installing the client libraries and configuring the PATH variable is very important. That insures that all server processes are aware of the new PATH setting. For the folks that uninstalled/reinstalled and found that things started working, we could think of this is a very roundabout way of restarting the ArcGIS Server service and that is why it fixed things.

Thank you

Derek
0 Kudos
KevinGooss
Occasional Contributor
So in order to connect to spatial data inside of oracle i need to install TWO oracle client pieces of software?
These are over 1GB each!
And why assume that everyone works in the cloud and wants to copy data just to publish a service.
Copying data was bad, is bad, and will always be bad.
0 Kudos