Lookup fails when Attribute table contains more than ~95000 records

henkkramer — Fri, 12 Oct 2012 12:29:33 GMT

Hello,

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?

Thanks,

Henk

Re: Lookup fails when Attribute table contains more than ~95000 records

CelenaCui — Wed, 10 Jul 2013 16:30:39 GMT

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.

topic Re: Lookup fails when Attribute table contains more than ~95000 records in Data Management Questions

Lookup fails when Attribute table contains more than ~95000 records

Re: Lookup fails when Attribute table contains more than ~95000 records