Select to view content in your preferred language

Error deleting raster in file geodatabase

1559
5
12-13-2012 07:17 AM
MeganZoch
Deactivated User
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!
0 Kudos
5 Replies
KimPeter
Esri Contributor
What type of raster file is it?  It's not a mosaic dataset, is it?
0 Kudos
MeganZoch
Deactivated User
No, it is a DOQQ from NAIP.
0 Kudos
KenGalliher1
Esri Contributor
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>'
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
MeganZoch
Deactivated User
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!
0 Kudos