laptop and a wrench

Bug

The 'sdegcdrules -o list' command fails on a DBO schema.

Last Published: May 20, 2015 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM041202
SubmittedJanuary 6, 2009
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found9.3
Operating SystemWindows OS
Operating System VersionXP
StatusWill Not Be Addressed

Description

The 'sdegcdrules -o list' command fails on a DBO schema, returning the following error:

DBMS table not found (-37)

ArcSDE 9.2, ArcSDE 9.3, ArcSDE 9.3.1 for SQL Server 2005 or SQL Server 2008 DBO schema are unable to list the geocoding rule files and report the error.

Cause

The 'sdegcdrules -o list' command fails on a DBO schema.

When running an sde post installation to create an sde database with a DBO schema using a Windows authentication and then running 'sdegcdrules -o list', the following error message returns:

C:\Documents and Settings\ssluser>sdegcdrules -o list -i 7272

ArcSDE 9.3 for SQL Server Build 546 Thu Sep 18 12:35:50 2008
Geocoding Rule Table Administration Utility
-----------------------------------------------------
Error: DBMS table not found (-37).
Error: Cannot list entries in the geocoding rule table.

Workaround

Create a new database with a SDE schema.

    Steps to Reproduce

    Bug ID: NIM041202

    Software:

    • ArcSDE/Enterprise Geodatabase

    Get notified when the status of a bug changes

    Download the Esri Support App

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options