Size Limit for Writing to Reviewer Table

1886
12
10-20-2010 01:10 PM
TedCronin
MVP Honored Contributor
Is there a size limit to calculate to the Reviewer Table?  I am currently trying to write 26,000 features to the Review table and its not appearing to be progressing through the actual calculations.  It is still showing 0 Reviewer results processed, and I have been here for the last 30 minutes.  Perhaps another KILL is in order...

I am working with the Polyline or Path Closes on Self Check.
Tags (2)
0 Kudos
12 Replies
KumarBhardwaj
Occasional Contributor II
We have an enhancement logged for this issue with the following detail:

***
Defect ID: 36543
Name: Need ability to have 200K + records in reviewer table
***

However you can try the following workaround:

1. Open the Registry Editor (type regedit from Start > Run).

2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\PLTS.

3. Create a new key named reviewer.

4. Create a new string value in reviewer named MaxRecordlimit.

5. Modify the data value to the value you want (say 50000).
0 Kudos
TedCronin
MVP Honored Contributor
When is the enhancement going to get implemented in Reviewer, perhaps 10.1.

Thank you for the workaround idea, will have to play with that a bit.
0 Kudos
TedCronin
MVP Honored Contributor
Going on three hours now for a calc of about 15,000 for relationship classes.

One thing about Reviewer is you really start thinking, hmm, that SQL check would be good to run before that relationship class check, or that SQL Check would be good before that domain check...
0 Kudos
TedCronin
MVP Honored Contributor
Actually, it seems like It did not work, you can only have 20,000 records in the Reviewer Grid, yep, you guys definitely are pretty low here, 200K will be nice but it really should be bigger, even unlimited for File GB, and SDE.

Bummer...
0 Kudos
MichelleJohnson
Esri Contributor
Depending on your machine configuration, you may be able to load more than 20,000 records to the Reviewer table if you modify the registry key mentioned earlier.  The reason we limited it to 20K, is that it can crash ArcMap when there are lots of records in the table.

Currently, you can modify the definition query to manage the records in the reviewer table.

We are working on resolving this limitation for 10.1.
0 Kudos
TedCronin
MVP Honored Contributor
Excellent.  Thank you.

The less I have to deal with the registry the better, since I support the Mappers, and then would have to do this on everyones machine.

BTW, how do I delete a session?  Seems like this should be pretty stupid easy.  Am I missing something, Am I just stupid?
0 Kudos
MichelleJohnson
Esri Contributor
For ArcGIS Data Reviewer 10, we added a new parameter to the ReviewerConsole.exe that will allow you to delete sessions.  Refer to the web help here.
0 Kudos
TedCronin
MVP Honored Contributor
Thank you.

What's the Path?

Nevermind.

C:\Program Files (x86)\Common Files\ArcGISDataReviewer\Desktop10.0\Bin

Cool. May get to use Subprocess.
0 Kudos
AFCENTA7
New Contributor
Actually, it seems like It did not work, you can only have 20,000 records in the Reviewer Grid, yep, you guys definitely are pretty low here, 200K will be nice but it really should be bigger, even unlimited for File GB, and SDE.

Bummer...


Yeah but how much memory does a record take up?  An MDB with 2G limit could probably hold close to a bizzilion.
0 Kudos