Starting a metadata service returns error 1001

Error Message

Starting the metadata in ArcIMS results in the following error:"ERR1001 Unable to connect to the database".

Cause

A connection problem prevented ArcIMS from connecting properly to ArcSDE to start the metadata service.

Solution or Workaround

1. Using ArcCatalog, create a spatial database connection to ArcIMS using the same connection information that is found within the metadata AXL file.
2. Ensure proper permissions are set up for the account to access and use the database. Import a shapefile into the database. If successful, delete the new feature class.
   
   If this step fails, return to the database administration software and ensure that proper permissions are set on the metadata user.
3. Ensure that Fulltext Indexing (or Catalog) have been enabled.
   Oracle database:
   
   

   Code:
   grant execute on ctx_dll to <metauser>;

   
   
   SQL Server:
   Create the full text catalog:
   

   Code:
   SDE_DEFAULT_CAT

   
   
4. After ensuring the connection is set up correctly, start the metadata services again.
5. If unsuccessul, enable Spatial Server and Application Server logging:
   Verbose logging for ArcIMS
   Open a support incident with ESRI Support Services indicating the problem, referencing the steps in this article and attach the log files.