topic Re: Error deleting raster in file geodatabase in Data Management Questions

Error deleting raster in file geodatabase

MeganZoch — Thu, 13 Dec 2012 15:17:34 GMT

I'm trying to delete a raster within a file geodatabase in ArcCatalog (ArcView 10.0). When I attempt to delete it I get the Delete Failed error below: (raster name is "e2797_02_3")

Failed to delete selected object(s)
The application is not license to perfore this operation
The table was not found. [e2797_02_3]
The table was not found. [fras_ras_e2797_02_3]
The table was not found. [e2797_02_3]
The table was not found. [fras_ras_e2797_02_3]

Also when I right-click on the raster and select "Properties" I get the error "Failed to Open Dataset." Is there any way to get around this?

Thanks!

Re: Error deleting raster in file geodatabase

KimPeter — Fri, 14 Dec 2012 16:48:37 GMT

What type of raster file is it? It's not a mosaic dataset, is it?

Re: Error deleting raster in file geodatabase

MeganZoch — Mon, 17 Dec 2012 15:33:32 GMT

No, it is a DOQQ from NAIP.

Re: Error deleting raster in file geodatabase

KenGalliher1 — Sun, 12 Dec 2021 07:16:14 GMT

Hi mzoch00,

It maybe necessary to delete the raster's associated tables from the database. The raster will have several tables that contain the image's information such as blk, aux, bnd, etc. References to the raster object also exist as records in the table_registry geometry_columns and raster_columns tables.

These queries below can help identify what needs to be removed. Please be aware that you are deleting entire tables from the database. Please contact Esri Technical Support if you are not comfortable deleting these tables and records.

SQL Server:

select * from sde.SDE_raster_columns where table_name = '<raster_name>' and owner = 'dbo'; 
select * from sde.SDE_table_registry where table_name = '<raster_name>' and owner = 'dbo'; 
select * from sde.SDE_column_registry where table_name = '<raster_name>' and owner = 'dbo'; 
select * from sde.SDE_geometry_columns where f_table_name = '<raster_name>' and f_table_schema = 'dbo';
select * from sde.SDE_layers where table_name = '<raster_name>' and owner = 'dbo'; 5
SELECT OBJECTID FROM dbo.GDB_ITEMS where PhysicalName = '<db_name>.<owner>.<raster_name>'

Oracle:

select * from sde.raster_columns where table_name = '<raster_name>' and owner = 'dbo'; 
select * from sde.table_registry where table_name = '<raster_name>' and owner = 'dbo'; 
select * from sde.column_registry where table_name = '<raster_name>' and owner = 'dbo'; 
select * from sde.geometry_columns where f_table_name = '<raster_name>' and f_table_schema = 'dbo';
select * from sde.layers where table_name = '<raster_name>' and owner = 'dbo'; 5
SELECT OBJECTID FROM dbo.GDB_ITEMS where PhysicalName = '<db_name>.<owner>.<raster_name>'

Re: Error deleting raster in file geodatabase

VinceAngelo — Tue, 01 Jan 2013 13:33:59 GMT

These SQL commands won't work for a file geodatabase. While I would recommend working
with Tech Support, I expect you'll need to extract the non-corrupt layers from the FGDB into a
new file geodatabase.

- V

Re: Error deleting raster in file geodatabase

MeganZoch — Thu, 31 Jan 2013 12:09:40 GMT

I apologize for the late response. Thank you all with your comments however I'm not very familiar with SQL or Oracle. Since my GDB was so small I just ended up making a new one and added the original raster to it again since I hadn't deleted it yet. I've also updated ArcMap to 10.1 recently. Everything seems to be working fine within the GDB now. Again I appreciate everyone's help!