English

Problem: Cannot serve ArcMap documents referencing ArcSDE data

Description

ArcMap documents that reference ArcSDE data cannot be served.

Cause

The following are some possible causes:

1. ArcSDE requires a username and password when connecting to the database. If this information is not saved with the map, ArcIMS will not be able to serve the map.

When creating a service, the ArcIMS administrator does not have the capability to prompt for the ArcSDE login information.

2. The Save Version checkbox of the database connection properties is unchecked.

3. The ArcSDE instance name, or service name, is being used in the connection to ArcSDE. If the instance name has not been entered in the server machine's services file, the connection to the ArcSDE database will not be made.

4.

** This issue has been resolved in ArcGIS 9.0. **


All the layers in the map reference ArcSDE feature classes containing at least one field using subtypes.

Solution or Workaround

If the ArcSDE user information is not saved with the map, a prompt appears for a username and password when opening the document in ArcMap. This messagebox prompt keeps the map from being served. This is also the case if the Save Version checkbox is unchecked in the connection properties. In this case a dialog box appears every time a map that is opened requests that a version be chosen.

If the username and password are saved with the map, and the Save Version checkbox is checked, the prompt for this information does not occur when opening the map document and the map should be able to be served.

  1. To save the username and password with the map:
    A. Open ArcCatalog. Right-click on the database connection used by the ArcMap document and select Connection Properties. If there is no database connection, create a new one.

    B. In the Spatial Database Connection dialog box that opens, provide the correct ArcSDE user information and check the Save Name/Password check box.

    C. Create a new map document to use data from this database connection or modify the data source of an existing map document to use data from this new database connection.

    D. Save the map document and serve.

    [O-Image] Spatial Database Connection Dialog
  2. To save the version with the map:

    A. Open ArcCatalog. Right-click on the database connection used by the ArcMap document and select Connection Properties. If a database connection is not present, create a new one.

    B. In the Spatial Database Connection dialog box, check the Save Version check box.

    C. Create a new map document to use data from this database connection or modify the data source of an existing map document to use data from this new database connection.

    D. Save the map document and serve.

  3. To see if an instance name is being used, check the connection properties to the ArcSDE database:

    A. Open ArcCatalog.

    B. Select the ArcSDE database, right-click, then select Connection Properties.

    C. Notice the Services input box.

    If there is a port number; for example, 5151, no additional modifications are necessary.
    [O-Image] SDEconnectionPropPort
    If there is an instance name; such as esri_sde, verify that this instance has been properly entered in the \WINNT\system32\drivers\etc\services file on the server machine.
    [O-Image] SDEconnectionPropName


    If it is not, consider copying the entry in the \WINNT\system32\drivers\etc\services file on the ArcGIS machine used to author the map over to the \WINNT\system32\drivers\etc\services file on the machine serving the ArcMap document.
  4. For ArcSDE layers containing subtypes, there is no solution for this other than to utilize a personal geodatabase instead of ArcSDE, if ArcIMS 4.0 or ArcIMS 4.0.1 is used.