Access

  • Customizer → Databases → Check Database Consistency

Information

  • In this module, different objects (I-texts, hyperlinks, object protection, relations) can be checked for data consistency or incorrect data for each database instance.
    • The I-text check displays whether there are I-texts that are incorrect, unused, or used twice.
    • I-text correction (check and write I-texts) first checks whether there are incorrect or unused I-texts and thereafter corrects them in accordance with the table below.
    • The hyperlink check shows whether there are hyperlinks that are incorrect, unused, or used twice.
    • The hyperlink correction (check and write hyperlinks) first checks whether there are incorrect or unused hyperlinks and thereafter corrects them in accordance with the table below.
    • The Relation check shows, at which positions parent records of records are missing in the database.
    • The object protection check shows at which positions in the database the Object Protection is incorrect.
    • The dash record check shows whether there are records with "-" in the database that may temporarily be "ZERO".
    • The dash record correction (check and write dash records) first checks whether there are records with "-" in the database and thereafter corrects them in accordance with the table below.

Procedure

  • Select the required check-value for the required database from the Consistency check listbox.
  • Click on the Carry out checks button.
    • The respective database instances will be checked.
    • A file with the following structure will be created:
      • [Type]_check_[SchemaNameQ1-7B]_[Date]_[Time].chk or [Type]_fix_[SchemaNameQ1-7B]_[Date]_[Time].chk
        • Example: iText_Hyperlink_Relation_and_Object_check_Q3B_21092015_143656.chk / iText_and_Hyperlink_fix_Q3B_21092015_143656.chk
    • This file is stored in the Log folder in the PLANTA work directory.
    • The created ASCII file can be opened via a text editor (e.g. Notepad).

See also: System Parameter

Log File Analysis

General Output Information

Error typeError output exampleDescription
Datatable has incorrect data
Parent category for elements with incorrect files,
e.g. incorrect URL for hyperlinks

Datatable has incorrect relations

Hyperlinks with incorrect data

I-texts with wrong backlink

I-Text Check/Correction

Legend for the example

  • [Location (schema or DT-ID.DI-ID] ([Number of incorrect records]) [List of the I-text IDs of all incorrect I-texts]
Error typeError output exampleDescriptionAutom. correctionManual correction
I-texts with wrong backlink




DT441.DI000456 (1)
687,
Incorrect values in the Data item, Data Data Table, or Record ID field, e.g. incorrect values in I-text 687 in DI000456 in DT441Missing or incorrect data is automatically corrected.Not required.
duplicate I-texts in referencing tables




DT500.DI024237 (1)
761,
I-texts that are used twiceA new I-text with the same values will be created and the reference will use it instead of the old I-textNot required.
I-text reference inexistent in I-text table




DT441.DI000456 (1)
712,
I-texts which do not exist in the I-text tableI-text field of the reference value is set to emptyNot required.
Non-referenced I-text strings in I-text table




Q3B (2)
11457, 11458,
I-texts that are not usedI-text will be deletedNot required.

Hyperlink Check/Correction

Error typeError output exampleDescriptionAutom. correctionManual correction
Hyperlinks used twice




Q2B (1)
7,
Hyperlinks that are used mutliple timesA new hyperlink with the same values will be created and
the reference will use it instead of the old I-text
Not required.
Unused hyperlinks




Q2B (3)
4, 5, 15,
Hyperlinks that are ot usedHyperlinks will be deletedNot required.
Hyperlink does not exist in hyperlink DT




DT031.DI026735 (2)
255, 348,
Hyperlinks which do not exist in the hyperlink DT
I-text field of the reference value is set to emptyNot required.
Hyperlinks with incorrect data




Without Text - DT397 (2)
39045, 39092,
Hyperlinks with missing display textNew text is generated from HL-URL if there is one.
If no HL-URL exists:
For the File in DB HL type → New text will be generated hyperlink_XXX (ID)
Hyperlinks of other types will be deleted
Not required.

Without URL - DT397 (2)
39045, 39092,
Hyperlinks with missing URLNew URL is generated with the help of the display text
Example: %TEMP%\Testdokument.doc
Not required.

Data item incorrect - DT397 (2)
39045, 39092,
Hyperlinks the reference of which is incorrectReference data are enteredNot required.

Size incorrect - DT397 (2)
39045, 39092,
Hyperlinks with incorrect file size
(only for File in DB HL type)
The character length of the BLOBs is enteredNot required.

Storage incorrect - DT397 (2)
39045, 39092,
Hyperlinks with incorrect (BLOB)
(only for File in DB HL type)
NoneCorrect data.

CRC incorrect - DT397 (2)
39045, 39092,
Hyperlinks with incorrect check value (CRC)
(only for File in DB HL type)
  • If BLOB exists, the CRC will be generated.
  • If it does not not exist, correction will not be possible.
Not required.

Object Protection Check

Information on object protection

Note

  • Empty data tables are not checked.
  • Data tables without Pos. OS are not checked.
Error typeError output exampleDescriptionAutom. correctionManual correction
Data table without protection DIs




Q5B (2)
802, 425,
Data table has no object protection Dis but the Pos. OS field is filledNone
Enter object protection or clear Pos. OS.
In the DB pos. field of the Created on DI, the DB pos.
must be in the data table.
Data table without protection values




Q5B (2)
402, 473,
Data table has object protection Dis but they do not contain dataNoneCorrect data
Data table has wrong object protection




Wrong protection value (3)
91, 93, 286,
Values in "Owner", "Group", or "Any" are not between 0 and 7.NoneCorrect data.

Wrong order (1)
89,
Types of the object protection DIs are in the wrong order.NoneObject Protection-DIs must be in the data table in the
described order.

Wrong creation date (1)
101,
Creation date is emptyNoneCorrect data.

Wrong modify date (1)
101,
Modification date is emptyNoneCorrect data.

Wrong creation user (1)
373,
Creation user not setNoneCorrect data.

Wrong modify user (1)
487,
Modification user not setNoneCorrect data.

Wrong licence (1)
8559,
No license available or license incorrect
Valid licenses are PLANTA licenses or numeric customer licenses.
NoneCorrect data.

Relation Check

Error typeError output exampleDescriptionAutomatic correctionManual correction

Datatable DT457 has no upper relationsInformation that no relation check is carried out for this data table since the data table has no parent data tableNoneNone, since there are no errors

DT463: 12 reference(s) is/are inexistent in datatable DT461=

=Use this SQL Statement to check:=
SELECT * FROM DT463 WHERE NOT EXISTS (SELECT 1 FROM DT461 WHERE DI001001 DI001097);
There is/are one/multiple records in the first-mentioned data table which does/do not exist in the second-mentioned, parent data table.
This SQL statement serves to display the incorrect records in the database.
NoneCheck the records on the database with the specified select (or customize direct modules to the respective data table alternatively), check records and delete the obsolete child records, or recreate the parent records.
Relation has wrong DIs




Start/End DI does not exist (1)
461,
In the relation of DT461 no start or end DI has been specifiedNoneEnter start or end DI

Start/End DI - wrong length - DT461
123
Start or end DI has the wrong lengthNoneEnter (six-digit) DI number

Dash Record Check/Correction

Error typeError output exampleDescriptionAutom. correctionManual correction
Data table with references to dummy record in a foreign key




DT466 for records with primary ids: [['000233', '1445', 'ORACLE'], ['000233', '1445', 'SAP FI']]List of all records which reference a dash record.Change of the respective column to "Zero".Not required.
Data table with dummy records




Q5B (1)
DT840
Use this statement to check:
SELECT * FROM DT840 WHERE DI009754 = '-' AND DI009755 = '-';
List of all records which contain a dash record.Deletion of the dash records.Not required.