ERROR
Building a pyramid with the 'sderaster' command yields a unique constraint violation error. For example:
"Updating pyramid...
Error: SE_stream_execute (-51)
Error: Underlying DBMS error
Error: DBMS error code (1)
Error: ORA-00001: unique constraint (VEGDIR.SDE_BLK_3_UK) violated".
This error is caused by pyramid blocks left behind by a mosaic or a previously failed attempt to build the pyramid.
Code:
select rastercolumn_id
from sde.raster_columns
where table_name =
'<business table name>';
Code:
select count(*) from sde_blk_<N>
where rasterband_id < 0;
Code:
delete from sde_blk_<N>
where rasterband_id < 0
Get help from ArcGIS experts
Download the Esri Support App