I want to create a new raster based on a specific item in an existing raster file using the Lookup tool. This fails when the number of records in the attribute table of the existing raster is more than ~95000 records. I've tested it with subsets of the original file (containing 1.1 million records). Lookup works fine with on subset with 92000 records but fails on a subset with 96000 records.
The message from Lookup is : (GDN2012V1sub2 = the input file, BN2004_V3_1 the item and bn200425msub2 the output file) Messages Executing: Lookup GDN2012V1sub2 BN2004_V3_1 H:\2012\divers\WOT\bkn2012\rastertests\data.gdb\bn200425msub2 Start Time: Fri Oct 12 14:58:29 2012 ERROR 999999: Error executing function. The table was not found. [VAT_bn200425msub2] A column was specified that does not exist. A column was specified that does not exist. The table was not found. [VAT_bn200425msub2] No spatial reference exists. ERROR 010010: Field not found. Invalid field index obtained. ERROR 010213: Error in reading raster GDN2012V1sub2. ERROR 010325: Run-time error - ***. ERROR 010067: Error in executing grid expression. Failed to execute (Lookup). Failed at Fri Oct 12 14:58:31 2012 (Elapsed Time: 2.00 seconds)
Is there a way to process rasters with many records using Lookup?
I got a similar error when I was accidentally trying to save the output into a max out hard drive. I would check to see if your output location has enough space for a raster that size. Hope that helps.