NIM000185 for No Product Found

Bug ID Number	NIM000185
Submitted	October 31, 2005
Last Modified	April 2, 2025
Applies to	No Product Found
Version found	9.1
Status	Non-Reproducible

Additional Information

No Public Explanation

Workaround

Perform (carefully) the following steps in SQL*Plus to completely unregister the 8.3 raster catalog from the geodatabase, and then re-run "Register with Geodatabase..." in ArcCatalog 9.1.## Determine the geodatabase object class identifier.#SELECT ID FROM SDE.GDB_OBJECTCLASSES WHERE NAME='TESTRC_A';## Record this number (eg, 25):# OBJECT CLASS ID: ____SELECT ID FROM SDE.GDB_OBJECTCLASSES WHERE NAME='TESTRC_A';## Delete the geodatabase object class for this raster.DELETE FROM SDE.GDB_OBJECTCLASSES WHERE ID=2;# Drop the OBJECTID column from the column registry.DELETE FROM SDE.COLUMN_REGISTRY WHERE TABLE_NAME='TESTRC_A' AND COLUMN_NAME='OBJECTID';# Drop the OBJECTID column from the business table (note the different tablespace # for wherever your data is stored).ALTER TABLE GIS.TESTRC_A DROP COLUMN OBJECTID;# Clear the ROWID_COLUMN field for the affected table.UPDATE SDE.TABLE_REGISTRY SET ROWID_COLUMN='' WHERE TABLE_NAME='TESTRC_A';COMMIT;