topic Re: Only one Pyramid Level created on MaxLevel -1 option in Data Management Questions

Only one Pyramid Level created on MaxLevel -1 option

AlainProulx — Fri, 05 Oct 2012 16:48:36 GMT

Hello,

I just loaded 350GB of GeoTIFF files into SDE as a Raster Dataset. When I create pyramids using the default -1 option, it takes 22 hours of processing but when I check the levels, only ONE level is created? If I try to create 10 levels, it completes in seconds but still indicates only one level.

We've been loading Rasters since 2002 without this happening. Our other raster datasets contain about 10 levels.

Any thoughts?

Thanks
Al

Re: Only one Pyramid Level created on MaxLevel -1 option

ChristopherThomas — Mon, 08 Oct 2012 11:54:25 GMT

Al,
Are you using 10.1? There is currently a bug logged for a similar behavior at 10.1. This bug was logged with an Oracle support incident, but the behavior has been reproduced in Sql Server as well.

NIM084474 [Synopsis: ArcGIS is not honoring Pyramid level setting for an ArcSDE raster stored in Oracle.]
http://support.esri.com/en/bugs/nimbus/TklNMDg0NDc0

You might try specifying the number of levels instead of using the -1 value. Since your other rasters are around 10 levels, you might try using 10 and see if that works.

Regards,
Chris
ESRI Geodata Support

Re: Only one Pyramid Level created on MaxLevel -1 option

AlainProulx — Tue, 09 Oct 2012 12:21:12 GMT

Thanks for the reply Chris. We're running SQL Server but this problem describes what's going. I figured out a workaround that worked for me. I first needed to delete existing pyramids and then create them by specifying the level to 10.

Thanks
Al