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
4. For the solution of the problem, delete the file in the SX2 or add fields related to file in the SX3.
The field <campo> is duplicated in the SX3
1. Open the SX3 of the company.
2. Index the file of the field X3_CAMPO.
3. Find the duplicated field.
4. Delete the record.
The size in the SX3 of the field <campo> is other than the SXG The size in the SX3 of field <campo> is smaller than the SXG limit
1. Open the SX3 of the company.
2. Index file by the field X3_CAMPO
3. Find the field with error, check the content of the fields X3_TAMNHO e X3_GRPSXG.
4. Create a filter only with the field containing X3_GRPSXG equal to the field with error.
5. Compare the X3_TAMANHO of all fields.
6. Open the SXG of the company, then check the content of the SIZE field of group informed in X3_GRPSXG.
7. Adjust the size of the field in the SX3 e in the table.
The size of the question 00 of the group <grupo> is different than SXG
The size of the question 00 of the group <grupo> is larger than the SXG limit
1. Open the SX1 of the company.
2. Index file by the field X1_GROUP
3. Find the field with error, check the content of the fields X1_TAMNHO e X1_GRPSXG.
4. Create a filter only with the field containing X1_GRPSXG equal to the field with error.
5. Compare the X1_TAMANHO of all fields.
6. Open the SXG of the company, then check the content of the SIZE field of group informed in X1_GRPSXG.
7. Adjust the size of the field in the SX1 e in the table.
The field of the user <campo> exists in the standard version and is replaced by the version field
Type:= c; Size:= 11; Decimal:= 0
Type:= c; Size:= 11; Decimal:= 0
1. Open SX3 of the company.
2. Find the field.
3. Switch the content of the field X3_PROPRI to S.
|
