File Verification

OBJECTIVE

The File Verification option is used to check whether files are corrupted or contain errors. This option also lets you check the indexes, file structures and rebuild the files.

PREREQUISITE

Security Management (provide access to the Rebuild File – Normal).

steps

maestro* > Maintenance > File Maintenance > File > File Verification

Check files

Select the company(ies) to be checked.

The company being processed is displayed in green.

In multidimensional mode, only one company is displayed for all companies defined in the same directory since they are all processed simultaneously.

Field

Description

Current Company

By default, the current company is selected.

All

If you check All, all of the companies in the DATA directory will be selected.

NOTE: The Uncheck All button allows you to clear all of the companies.

Selection

Lets you select the companies that must be processed manually.

NOTE: The Uncheck All button allows you to select all of the companies.

Field	Description
Current Company	By default, the current company is selected.
All	If you check All, all of the companies in the DATA directory will be selected. NOTE: The Uncheck All button allows you to clear all of the companies.
Selection	Lets you select the companies that must be processed manually. NOTE: The Uncheck All button allows you to select all of the companies.

Complete the verification mode as required.

Verification mode section:

Only one verification method can be selected from among Verify the files structure only, Records read by batch (Quick method), Verify index 0 only or Verify all index.

In the following verification modes: Records read by batch (Quick method), Verify Index 0 only and Verify all index, the system reads all of the records for each of the selected files. The system will compare the number of records read against the expected number of records and report the differences.

Field

Description

Verify the files structure only

The system only checks the file structures without reading the data.

Records read by batch (Quick method)

Used to read multiple records at the same time.

NOTE: The number of records read is determined by the length of the table. The shorter the table (length of a record), the higher the number of records read at the same time. This is the fastest processing method of all the choices.

If you use this verification method, all of the errors in a file may not necessarily be detected.

Verify Index 0 Only

Reads the records once using the 0 index (main index) only.

NOTE: If you use this verification method, all of the errors in a file may not necessarily be detected.

Verify All Index

Reads the records using all indexes.

Ignore version warnings

Ignores files created with a version of Pervasive lower than 8 if the box is checked.

Details section:

This section displays information based on the file selected in the table at the bottom of the screen.

When a file is being processed, the system also displays the index being checked.

Field	Description
Verify the files structure only	The system only checks the file structures without reading the data.
Records read by batch (Quick method)	Used to read multiple records at the same time. NOTE: The number of records read is determined by the length of the table. The shorter the table (length of a record), the higher the number of records read at the same time. This is the fastest processing method of all the choices. If you use this verification method, all of the errors in a file may not necessarily be detected.
Verify Index 0 Only	Reads the records once using the 0 index (main index) only. NOTE: If you use this verification method, all of the errors in a file may not necessarily be detected.
Verify All Index	Reads the records using all indexes.
Ignore version warnings	Ignores files created with a version of Pervasive lower than 8 if the box is checked.

Select the files to be checked in the table at the bottom of the screen.

By default, all files are selected for file verification. However, you can make a manual selection by clicking the Uncheck All button and manually check the Selection column.

The table allows users to select files to be checked.

Field

Description

Verify the general folder files

By checking this field, the grid is refreshed to display the files in the general directory.

Below is a summary description of some columns:

Column

Description

Progress

Displays the progress percentage of the file processing.

File

Name of the table file.

Description.

Description of the table file.

Record

Displays the length of the table.

NOTE: The longer the record, the longer processing will take.

Nb of Keys

Indicates the number of times the file will be read, unless the user selects the Records read in batches(quick method) or Check o indexes only methods.

Details

Displays relevant information after processing:

The number of records in the file.

Error or warning messages encountered during processing.

NOTE: A line shown in green indicates that the file is being checked. A red line means that there are errors or warnings in the file.

Spent Time

Time required checking the file.

Rebuild**

Indicates that the file must be reconstructed if checked.

When you start checking the files, no files are checked. If errors are detected in certain files, the system automatically checks the erroneous files.

NOTE: The user can change the selection manually by checking or clearing the box in the Rebuild column.

If the files are selected, to rebuild the files, click the Rebuild icon. This icon is located in the middle of the screen, on the right.

Result**

Displays the result after reconstructing the files.

The rebuild and result columns are displayed on the screen if the user has access to the Rebuild File - Normal option in Security Management.

Field	Description
Verify the general folder files	By checking this field, the grid is refreshed to display the files in the general directory.

Column	Description
Progress	Displays the progress percentage of the file processing.
File	Name of the table file.
Description.	Description of the table file.
Record	Displays the length of the table. NOTE: The longer the record, the longer processing will take.
Nb of Keys	Indicates the number of times the file will be read, unless the user selects the Records read in batches(quick method) or Check o indexes only methods.
Details	Displays relevant information after processing: The number of records in the file. Error or warning messages encountered during processing. NOTE: A line shown in green indicates that the file is being checked. A red line means that there are errors or warnings in the file.
Spent Time	Time required checking the file.
Rebuild**	Indicates that the file must be reconstructed if checked. When you start checking the files, no files are checked. If errors are detected in certain files, the system automatically checks the erroneous files. NOTE: The user can change the selection manually by checking or clearing the box in the Rebuild column. If the files are selected, to rebuild the files, click the Rebuild icon. This icon is located in the middle of the screen, on the right.
Result**	Displays the result after reconstructing the files.

Click OK.

The Skip this file icon aborts the processing of the current file and continues with the next selected file.

The Cancel icon is used to cancel checking files and exit the option.

File Verification

OBJECTIVE

PREREQUISITE

steps

Check files

See also