topic Re: Size Limit for Writing to Reviewer Table in ArcGIS Data Reviewer Questions

Size Limit for Writing to Reviewer Table

TedCronin — Wed, 20 Oct 2010 20:10:36 GMT

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.

Re: Size Limit for Writing to Reviewer Table

KumarBhardwaj — Thu, 21 Oct 2010 19:24:09 GMT

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).

Re: Size Limit for Writing to Reviewer Table

TedCronin — Thu, 21 Oct 2010 20:27:25 GMT

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.

Re: Size Limit for Writing to Reviewer Table

TedCronin — Tue, 02 Nov 2010 23:55:49 GMT

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...

Re: Size Limit for Writing to Reviewer Table

TedCronin — Wed, 03 Nov 2010 00:28:10 GMT

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...

Re: Size Limit for Writing to Reviewer Table

MichelleJohnson — Fri, 05 Nov 2010 18:52:36 GMT

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.

Re: Size Limit for Writing to Reviewer Table

TedCronin — Fri, 05 Nov 2010 22:54:50 GMT

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?

Re: Size Limit for Writing to Reviewer Table

MichelleJohnson — Tue, 09 Nov 2010 18:23:14 GMT

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.

Re: Size Limit for Writing to Reviewer Table

TedCronin — Tue, 09 Nov 2010 19:03:37 GMT

Thank you.

What's the Path?

Nevermind.

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

Cool. May get to use Subprocess.

Re: Size Limit for Writing to Reviewer Table

AFCENTA7 — Mon, 31 Oct 2011 13:43:45 GMT

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.

Re: Size Limit for Writing to Reviewer Table

TedCronin — Mon, 31 Oct 2011 14:42:31 GMT

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

Why still on MDBs?

Re: Size Limit for Writing to Reviewer Table

CarlosLópez2 — Thu, 17 Nov 2011 21:06:13 GMT

In Regedit, I don't find the HKEY_LOCAL_MACHINE\SOFTWARE\PLTS path, but I found the HKEY_LOCAL_MACHINE\SOFTWARE\ESRIProduction path.

¿Can I create reviewer key there?

The OS is Windows XP.

Thanks a lot.

Regards,

Carlos López

Re: Size Limit for Writing to Reviewer Table

MichelleJohnson — Mon, 21 Nov 2011 21:19:07 GMT

Is there a version number after ESRIProduction? E.g., HKEY_LOCAL_MACHINE\SOFTWARE\ESRIProduction\<version#>

Create a new key named Reviewer.

Create a new string value in Reviewer named MaxRecordLimit.

Modify the data value to the value you want.

Note: The higher the number, you increase the chances of having ArcMap crash. The new size limit will be dependent on your computer configuration and other applications you have running on it.