Step by Step: | The field <campo> of the index key <alias> order # record <# registro>, does not exist in the SX3 of the company <empresa> - - Open via APSDU the file SIX of the company
- Identify the index key generating error - Delete index related to table with error
The trigger <campo> sequence 000 is duplicated 1. Open via APSDU file SX7 of the company. 2. Index file through field X7_CAMPO. 3. Find trigger, then delete duplicated record.
The index key <alias> order 0 record <recno> is duplicated
1. Open via APSDU the file SIX of the company. 2. Index file by the field INDICE. 3. Check whether content of index key of the error does not exist in indexes of the inferior order of the table. 4. Delete the doubled index.
The file <alias> is duplicated in the SX2
1. Open via APSDU the file SX2 of the company. 2. Index file by the field X2_CHAVE. 3. Find file, then delete duplicated record.
The size of the decimal houses of the field <campo> file \dadosadv\<arquivo>.dbf is different than the data dictionary
1. Open via APSDU the existing file in the directory DADOSADV, if the file is blank, delete file. 2. If file has content, open structure table, then check the decimal size of the field with error. 3. Open the SX3 of the company, find the field, then compare the X3_DECIMAL with the size of the file 4. Adjust the structure in the SX3 or in the file.
The size of the field <campo> file \dadosadv\<arquivo>.dbf is different than the dictionary
1. Open via APSDU the existing file in the directory DATA\Database, if the file is blank, delete file. 2. If file has content, open structure table, then check the decimal size of the field with error. 3. Open the SX3 of the company, find the field, then compare the X3_TAMANHO with the size of the file 4. Adjust the structure in the SX3 or in the file.
The field <campo> does not exist in the file \dadosadv\<arquivo.dbf
1. Open the SX3 of the company. 2. index file by the field X3_CAMPO. 3. Find the field in the SX3 then check its structure. 4. Open file in the directory DADOSADV, check if the field exists in the structure. 5. Creates the field in the file.
The structure of the file <arquivo> does not exist in the SX3
1. Open the SX3 of the company. 2. Index the file by the field X3_ARQUIVO. 3. Find file with error
|