Help

ReviewerConsole examples

Available with Data Reviewer license.

The ReviewerConsole command is a command line executable that can be used to run or analyze Data Reviewer batch jobs. In addition, it provides capabilities that allow you to modify Reviewer administration tables and sessions and perform some miscellaneous functions such as merging multiple batch jobs into a single batch job and listing the contents of a batch job.

The following are examples of how to use the ReviewerConsole application to perform specific tasks, such as creating a batch job, creating a Reviewer session, and running a batch job.

Example 1: Creating a new session in a database

The pattern for creating a new session in a Reviewer workspace is the following:

ReviewerConsole /wks:<path to the workspace> /session:<session name> /create

The example below is going to create a session named Session 1 in the SoCal.mdb geodatabase. If the session exists, it will not be overwritten. If the specified workspace is not a Reviewer workspace, the Reviewer administration tables are added to it prior to creating the session.

ReviewerConsole.exe /wks:C:\Data\SoCal.mdb /session:"Session 1" /create

Example 2: Converting a database to a Reviewer workspace

The pattern for converting a geodatabase to a Reviewer workspace, which adds the Reviewer dataset and other administrative tables to an existing workspace, is the following:

ReviewerConsole.exe /wks:<path to the workspace> /create

In the example below, the workspace is specified by the Reviewer_RDBMS.sde connection properties file. As no path component is provided, the ReviewerConsole program will look for the file locally first, then in the C:\Documents and Settings\<user name>\Application Data\ESRI\Desktop10.3\ArcCatalog directory. If the account specified in the connection properties file has the relevant permissions, the Reviewer administration tables are created in the specified workspace.

ReviewerConsole.exe /wks:Reviewer_RDBMS.sde /create

Example 3: Erasing Reviewer workspace information

The pattern for erasing the Reviewer administrative tables from a database is as follows:

ReviewerConsole.exe /wks:<path to the workspace> /erase

In the example below, the Reviewer workspace administration tables are erased from the Reviewer.gdb database. This includes the session tables, error records, and so forth.

ReviewerConsole.exe /wks:"C:\Data\Reviewer.gdb" /erase

Example 4: Erasing Reviewer workspace information and creating a new session

The pattern for erasing the Reviewer workspace administrative tables and dataset and creating a new session is as follows:

ReviewerConsole.exe /wks:<path to the workspace> /session:<session name> /erase /create

In this example, a new Reviewer workspace is created using SoCal.mdb, replacing any existing Reviewer workspace information. A new session is also created.

ReviewerConsole.exe /wks:"C:\Data\SoCal.mdb" /session:"Session 1" /erase /create

When the /erase option is used, all the sessions in the Reviewer workspace are deleted before the new session is created. You cannot delete only the session specified in the /session: parameter, should it happen to exist. Use the /delete option to delete a single session.

Erasing the Reviewer workspace information and creating the new session is equivalent to this:

ReviewerConsole.exe /wks:"C:\Data\SoCal.mdb" /erase
ReviewerConsole.exe /wks:"C:\Data\SoCal.mdb" /session:"Session 1" /create

Example 5: Listing the sessions in a Reviewer workspace

The pattern for listing the Reviewer sessions in a Reviewer workspace is as follows:

ReviewerConsole.exe /wks:<path to the workspace> /list

In the example below, the Reviewer sessions present in the SoCal.mdb database are listed.

ReviewerConsole.exe /wks:"C:\Data\SoCal.mdb" /list

The output for the Reviewer session list resembles the following. The first column contains an identifier that corresponds with the session number, and the second column contains the name of the session.

Sessions for 'C:\Data\SoCal.mdb'
====== =========================
1             Session 1
2             Session 2

Example 6: Running a batch job on a workspace

To run a batch job, you need to indicate a Reviewer workspace, the session that is going to store the results, and the path to the batch job. The pattern for this is the following:

ReviewerConsole /wks:<path to workspace> /session:<session name> /rbj:<path to the batch job> /exec

In this case, you are going to execute the TestGeoOnGeo.rbj batch job using the SoCalwErrors.mdb Reviewer workspace and write any error records into the Session 9 Reviewer session. It is assumed that the workspace connection information within the batch job is current.

ReviewerConsole.exe /wks:"C:\Data\SoCalwErrors.mdb" /session:"Session 9" /rbj:"C:\Data\Testing\
TestGeoOnGeo.rbj" /exec

Once the batch job has finished running, results similar to those shown below are written to the console:

[6/3/2008 4:28:36 PM] ArcGIS Data Reviewer Program v1.0.0.0
Runs or Analyzes ArcGIS Data Reviewer Batch Jobs

6/3/2008 4:28:43 PM, Level: Normal, Message: Setting session 'Session 9' active
Creating RevServiceJob[0]
There are 1 errors to write for job [0]
6/3/2008 4:29:01 PM, Level: Normal, Message: 1 new records written to Reviewer table

Job[0] Summary Report
===================================
Run Number: 0
Workspace: SoCalwErrors.mdb
Session Name: Session 9
Default checks from 'Session 9' processed.
Batch Jobs: C:\
Data\Testing\TestGeoOnGeo.rbj
Filter: none

RevCheck Validation Summary:
  Total checks validated (from all batch jobs): 2 (Total Good 2, Total Error 0, Total Warning 0)
  Batch Job 'TestGeoOnGeo'
   Status: Total checks 2 (Good 2, Error 0, Warning 0)

Execution Summary:
  Total checks executed (not including default checks): 2
  Execution started: 6/3/2008 4:28:49 PM
  Execution complete: 6/3/2008 4:29:05 PM
  Execution duration: 00h 00m 15s
  Execution results:
    Total errors:    1
    New Errors:      1
    Duplicate Errors:0

Example 7: Executing multiple batch jobs at the same time

The pattern for executing multiple batch jobs at the same time is as follows:

ReviewerConsole.exe /wks:<path to the workspace> /session:<session name> /rbj:<path 
to batch job 1>,<path to batch job 2>,<path to batch job n> /exec

In this example, a list of batch jobs is executed. ReviewerConsole will construct a single batch job internally that contains all the checks from all the specified batch jobs. This merged batch job is then executed using the SoCalwErrors Reviewer workspace and Session 9.

ReviewerConsole.exe /wks:"C:\Data\SoCalwErrors.mdb" /session:"Session 9" /rbj:"C:\Data\Testing\
TestGeoOnGeo.rbj","C:\Data\SoCal_DomainChecks.rbj" /exec

Example 8: Validating batch jobs without executing them

The pattern for validating batch jobs is as follows:

ReviewerConsole.exe  /wks:<path to the workspace> /session:<session name> /rbj:<path to batch job 1>,<path to batch job 2><path to batch job n> /validate

In this example, batch validation (similar to the Validate functionality on the Reviewer Batch Validate dialog box) will be run without executing the checks. This ensures that the paths to the feature classes and tables referenced by the checks in the batch jobs have valid workspace paths. The results of validation are written to the console. A Reviewer workspace and session must be specified.

ReviewerConsole.exe /wks:"REVIEWER ON_SQLServer.sde" /session:"Session 4" /rbj:"C:\Data\Testing\TestGeoOnGeo.rbj","C:\SoCal_DomainChecks.rbj","C:\Data\RunInvalidGeom.rbj" /validate

Once the batch job validation is complete, results similar to those shown below are written to the console:

Validation Report
===================================
Workspace: null
Session Name: null
Batch Jobs processed: C:\Data\Testing\SoCal_GeoOnGeoChecks.rbj
Batch Jobs processed: C:\Data\Testing\TestGeoOnGeo.rbj, C:\Data\Testing\SoCal_DomainChecks.rbj
Batch Jobs processed: C:\Data\RunInvalidGeom.rbj

RevCheck Validation Summary:
  Total checks validated (from all batch jobs): 24 (Total Good 24, Total Error 0, Total Warning 0)
  Batch Job 'SoCal_GeoOnGeoChecks'
   Status: Total checks 4 (Good 4, Error 0, Warning 0)
  Batch Job 'socal_domainchecks'
   Status: Total checks 20 (Good 20, Error 0, Warning 0)
  Batch Job 'RunInvalidGeom'
   Status: Total checks 20 (Good 20, Error 0, Warning 0)

Example 9: Listing the checks in one or more batch jobs

The pattern for listing the checks in batch jobs is the following:

ReviewerConsole /rbj:<path to batch job 1>,<path to batch job 2> <path to batch job n>/list

When the contents of the batch job are listed, information includes the user name of the person who created the batch job, when it was created, and when it was last edited and by whom.

With each check in the batch job, you are provided with the following information:

  • Group: The name of the group that contains the check in the batch job
  • Check[number]: The number of the check, based on its order in the batch job
  • Name: The name of the check
  • Description: A description of the check, as provided in the dialog box
  • Category: The check category in which the check is contained
  • Resources: The names of the workspaces that contain the feature classes on which the check is run (The primary resource is the Feature Class 1 in the check. The secondary resources are Feature Class 2 and 3 in the check.)

The output for the list of checks in batch jobs resembles the following:

RevBatchJob: 'c:\testdata\batch_jobs\test_spatial2.rbj'
=================================================================
Name: C:\TestData\Batch_Jobs\Test_spatial2.rbj
CreatedBy: Editor
CreationDate: Wednesday, May 14, 2008
LastEditDate: Wednesday, May 14, 2008
LastEditedBy: Editor
Count Checks: 5

Group: BuiltUpA
 Check[0]:
   Name: Evaluate Polygon Perimeter and Area Check
   Description: Returns polygon, part, ring, or segment geometries for polygon features where the area or perimeter is within specified parameters.
   Category: Polygon Checks
   Resources:
      Primary: BuiltupA, ReviewerRTFeatureClass

 Check[1]:
   Name: Intersection on Geometry Check
   Description: Returns geometries for features in Feature Class 3 that intersect with the intersections of features from Feature Class 1 and 2
   Category: Feature on Feature Checks
   Resources:
      Primary: BuiltupP, ReviewerRTFeatureClass
      Secondary[0]: RoadL, ReviewerRTFeatureClass
      Secondary[0]: BridgeL, ReviewerRTFeatureClass

Group: GrassA
 Check[0]:
   Name: Evaluate Polygon Perimeter and Area Check
   Description: Returns polygon, part, ring, or segment geometries for polygon features where the area or perimeter is within specified parameters.
   Category: Polygon Checks
   Resources:
      Primary: BuiltupA, ReviewerRTFeatureClass

 Check[1]:
   Name: Evaluate Extent Check
   Description: Returns features where the extent properties (X and Y) are within specified parameters.
   Category: Spatial Parameter Evaluation Checks
   Resources:
      Primary: GrassA, ReviewerRTFeatureClass

Example 10: Merging two or more batch jobs into one

The pattern for merging several batch jobs is as follows:

ReviewerConsole.exe /rbj:<path to batch job 1>,<path to batch job 2>,<path to batch job n> /merge:<path to storage location and name of merged batch job.rbj>

You need to specify a comma-delimited set of batch jobs to be merged along with the target output batch file. If the batch file already exists, it will be overwritten.

In the example below, the SoCal_GeoOnGeoChecks.rbj, SoCal_DomainChecks.rbj, and SoCal_SubtypeChecks.rbj batch jobs are merged into the RevService.rbj batch job file.

ReviewerConsole.exe /rbj:c:\TestData\RevService\SoCal_GeoOnGeoChecks.rbj,c:\TestData\RevService\SoCal_DomainChecks.rbj,C:\TestData\RevService\SoCal_SubtypeChecks.rbj /merge:RevService.rbj

Example 11: Executing a Data Reviewer service job file

The Data Reviewer service is a Windows service that runs Reviewer batch jobs that are scheduled for execution (by the service) within an XML-formatted job configuration file or job. These same jobs can also be run by the ReviewerConsole program.

A Data Reviewer service job file contains the name of the workspace, the name of the session, and the batch jobs to execute as well as scheduling information as to when and how frequently the job will be run. Essentially, the ReviewerConsole program ignores the scheduling information and executes the specified batch jobs using the specified workspace and session in the job file.

To execute a Reviewer service job, the pattern is as follows:

ReviewerConsole.exe /job:<path to the Reviewer service job file>

In the example below, the service_job1.xml file is run. The output to the console resembles the following:

ReviewerConsole.exe /job:"C:\TestData\RevService\ service_job1.xml"

6/9/2008 3:08:52 PM, Level: Normal, Message: Setting session 'Session 1' active
Creating RevServiceJob[0]
No errors to write for session 'Session 1' for job [0]

Job[0] Summary Report
===================================
Run Number: 0
RevServiceJob: c:\testdata\revservice\service_job1.xml
Workspace: RevService.mdb
Session Name: Session 1
Batch Jobs: C:\TestData\RevService\Simple_Test.rbj
Filter: none                     

RevCheck Validation Summary:
  Total checks validated (from all batch jobs): 1 (Total Good 1, Total Error 0,
Total Warning 0)
  Batch Job 'Simple_Test'
   Status: Total checks 1 (Good 1, Error 0, Warning 0)

Execution Summary:
  Total checks executed (not including default checks): 1
  Execution started: 6/9/2008 3:08:53 PM
  Execution complete: 6/9/2008 3:13:33 PM
  Execution duration: 00h 04m 40s
  Execution results:
    Total errors:    0
    New Errors:      0
    Duplicate Errors:0

Related topics