Repairing a data file

Previous  Top  Next

Foreword
Prospect Tracking manages one or several data files.
It can occur that one of these have been damages after a brutal interruption during the execution and this for whatever reason could be (sector breakdown, small electricity cut,….).

If a file has been particularly active (data import, creation and deletion of records), it finds itself more or less fragmented in mid term.
It is therefore necessary to give time to other of these maintenance operations of the data file.

Principally there are 2 repair methods to be used:

·

Recuperation by analysing the record labels when you really cannot access the data files from Prospect Tracking.

·

Compaction of the regular maintenance operation in order to prevent a deterioration of the database and therefore a drop in performance.

Important note on the exploitation in client/server mode
In the context of a client/server use of Prospect Tracking the manipulations described below should be done from the server and not from the clients station.

Repairs procedure

A - Activate 4D Util

·

Open Windows Explorer and select the PRG index of Prospect Tracking.

Note : By default Prospect Tracking folder is installed on C:\Program Files\Prospect Tracking\

·

Double Click on the program '4D Util.EXE' that you should see in the right column of Windows Explorer after you have clicked on the PRG index. (The icon of this program is represented by an ambulance).

Note : If you do not have 4Dutil contact the technical support.

·

The opening dialogue is now shown. Choose, in the list at the bottom of the dialogue, 'Compiled Base'.

·

After the selection 'Compiled Base' double-click on the icon Prospect Tracking.

·

Piece 'Admin' in the 'User name' area and then click on the button 'connection.

Note : You do not have to keep the password.

·

The 4D principal screen is displayed :

·

In the case of a maintenance operation, (prevention), click on the button 'Compact' and then pass directly to Chapter D, after this.

·

In the case of a serious problem, click on the button 'Verify data' and choose in the new dialogue option 3° : Recuperate by analysing the record tags and validate the following dialogue by clicking on the button ok.

Continue following the operations as described below.

D - Common procedures for recuperation or compaction.

·

Prospect Tracking proposes that after the registration of a new file base, (this file will be a copy of the old one), all the information that has been verified, repaired or compacted, depending on your initial choice.

Place yourself in the index (Prospect Tracking Data) in order to register the new file with one or other existing data files.

After validating with the 'register' button, the repair is done and lasts more or less for a long time depending on the size of your data files.

·

Once the repairs are done, exit 4D Util (Menu 'file' command 'exit), and then with the help of Windows Explorer place yourself in the index \Prospect Tracking\Data.

- Rename your old file Prospect Tracking.4DD to OLD.4DD.

- Rename your new file Prospect Tracking _2.4DD to Prospect Tracking.4DD.

The repairs are done, you can use Prospect Tracking again.

It is important to note that once your start up, you will be asked where the data files are situated. You must specify c:\Program Files\Prospect Tracking\Data.

To follow the procedure, go to the chapter "file data".
Complementary Information on 4D Util.
For complementary information on the functioning of 4D Util, you can also read the documentation (4D Util PDF), in the PG index of Prospect Tracking.