-
It is recommended to run consistency checks with an administrative user.
Not all consistency checks are available for end users and configuration users.
-
To use the Consistency Editor, users need the Option to call a consistency check for a database (Common_ConsistencyCheck) program function.
-
To use the repair function in the Consistency Editor, users need the Option to start automatic consistency check repair function (Common_ConsistencyCheck_Repair) program function.
-
Consistency checks of type Object test are always run in the context of the user currently logged in. If users do not have any permissions for a certain object, errors may not be identified or repairing errors may fail.
About this guide
Simulating data changes in the Manager
Prerequisites for using the simulation mode
Configuring the simulation report
Starting and ending simulation
Evaluating the simulation data
Exporting simulation data
Scheduling operations activation times
Planning activation times for actions in the Manager
Displaying scheduled operations in the Manager
Restricting the display of scheduled operations
Labeling input fields and assignments with planned changes
Re-applying templates
Exporting data with the Manager
Creating data exports
Saving export definitions as simple reports
Saving export definitions in a file
Saving export definition in user settings
Analyzing data and data changes
Displaying reports in the Manager
Analyzing data changes in reports and the TimeTrace
Analyzing process monitoring in the Manager
Connecting a One Identity Manager History Database through an application server
Establishing a direct connection to a One Identity Manager History Database
Displaying change information in the Manager's TimeTrace
The Info system in the Manager
Prerequisites for displaying the process information
Working with the process view
Process information layout
Layout of logged data changes
Schedules in One Identity Manager
Enabling and disabling schedules
Starting schedules immediately
Creating and editing schedules
Properties of schedules
Calculating the activation time
Scheduled maintenance tasks
Mail templates in One Identity Manager
Creating and editing mail templates
Copying mail templates
Creating mail previews
General properties of mail templates
Creating and editing mail definitions
Password policies in One Identity Manager
Using base object properties in mail templates
Using hyperlinks to the Web Portal in mail templates
Default functions for creating hyperlinks
Using scripts in mail templates
Support for dynamically generated HTML code in mail templates
Usingprocess parameters in hyperlinks
Defining default fonts and default font sizes for mail templates
Email signature configuration for mail templates
Predefined password policies
Using password policies
Editing password policies
Creating password policies
General main data of password policies
Policy settings
Character classes for passwords
Custom scripts for password requirements
Editing the excluded list for passwords
Checking passwords
Testing the generation of passwords
Password expiry
Displaying locked employees and system users
Working with change labels
Snapshots of objects or object references
Tips for working with change labels
Creating and editing change labels
Assigning objects and dependencies to change labels
Editing change labels
Removing objects from change labels
Assigning change labels when saving in the Designer
Displaying content of change labels
Locking change labels
Deleting change labels
Release management
Checking data consistency
Notes on the consistency check
Running consistency checks
Test settings for consistency checks
Displaying test objects and test status
Logging test results
Repairing errors
Compiling a One Identity Manager database
Transporting custom changes
Types of transport packages
Basics for transporting modifications
General tips for transporting changes
Creating transport packages with the Database Transporter
Importing data with the Data Import
Integrating SQL statements in transport packages
Exporting favorite objects
Exporting change labels
Exporting changes based on change information
Transporting schema extensions
Exporting selected objects and dependencies
Exporting system files
Transporting the system configuration
Importing transport packages with the Database Transporter
Displaying contents of transport packages
Using transport templates
Importing data from a CSV file
Importing and exporting individual files for the software update
Loading the CSV file
Structure of the CSV file
Importing data from an external database
Configuring an import
Specifying the line structure for data with delimiters
Specifying the line structure for data with a fixed width
Defining a condition for the import
Assigning target tables and target columns
Specifying the data hierarchy
Options for handling records
Specifying connection variables
Importing the data
Using an import definition file
Importing custom files into One Identity Manager databases
Editing file settings for the automatic software update
Exporting files from a One Identity Manager database
Creating a One Identity Manager database for test or development from a database backup
Initializing DBQueue Processor the after extending the server hardware
Command line programs
InstallManager.CLI.exe
DBCompilerCMD.exe
Quantum.MigratorCmd.exe
AppServer.Installer.CMD.exe
AutoUpdate.exe
SoftwareLoaderCMD.exe
DBTransporterCMD.exe
DataImporterCMD.exe
SchemaExtensionCmd.exe
CryptoConfigCMD.exe
DBConsCheckCmd.exe
WebDesigner.InstallerCMD.exe
VI.WebDesigner.CompilerCmd.exe
Create-web-dir.exe
Notes on the consistency check
Running consistency checks
To run a consistency check
-
in the Designer or the Manager, start the Consistency Editor with the Database > Check data consistency menu item.
During start up, One Identity Manager schema table definitions are loaded and database objects are made available for testing.
-
Specify the test settings.
-
In the Consistency Editor toolbar, click
.
-
Enable the test that is to be run and adjust the test settings further if necessary.
- Click OK.
NOTE: In the Designer, the test settings dialog opens immediately after the Consistency Editor is started.
-
-
Start the consistency check. The following test procedures are available in the Consistency Editor for this:
-
Checking all test objects
Use the
button to start the check.
NOTE: To exclude individual test objects from the check, use the Disable item in the context menu to disable these test objects in the list view before the check starts.
-
Checking single test objects
In the list view, select the relevant test objects and start this check by selecting Test.
TIP: Use Shift + select or Ctrl + select to select more than one test object to be checked.
NOTE: To stop a check that is in progress, click
in the Consistency Editor toolbar.
-
-
Verify error output.
-
Repair errors if necessary.
Related topics
Test settings for consistency checks
Define the valid test settings before you run a consistency check. Tests are performed at database, table, and object level. There are already predefined tests available. You can run your own custom tests.
To configure the settings for testing
-
in the Designer or the Manager, start the Consistency Editor with the Database > Check data consistency menu item.
-
In the Consistency Editor toolbar, click
-
Enable the test that is to be run and adjust the test settings further if necessary.
- Click OK.
The tests are grouped according to different criteria.
| Icon | Meaning |
|---|---|
|
|
Tests are grouped by themes. |
|
|
Tests are grouped by types (database, tables , objects). |
|
|
Tests are displayed as a list. |
|
|
Tests are grouped by module association. |
|
|
Tests with Error severity are displayed. |
|
|
Tests with Warning severity are displayed. |
|
|
Tests with Information severity are displayed. |
Use user-defined tests to run your own tests. You can use the scripts from the script library for these tests. All scripts in the script library are provided for custom tests. The method call of these scripts corresponds to the following syntax.
Database test
Public Sub Methodname (ByRef con As IConnection)
Public Sub Methodname (ByVal con As IConnection)
Table test
Public Sub Methodname (ByRef dbTable As ITableDef)
Public Sub Methodname (ByVal dbTable As ITableDef)
Object test
Public Sub Methodname (ByRef dbObject As ISingleDBObject)
Public Sub Methodname (ByVal dbObject As ISingleDBObject)
For detailed information about scripts and the script library, see the One Identity Manager Configuration Guide.
Displaying test objects and test status
When Consistency Editor is starting up, One Identity Manager schema table definitions are loaded and database objects are made available for testing. The database tables, the number of objects per table and the test status are displayed in the Consistency Editor’s list view.
TIP: To sort by a specific column, click on that column in the table header.
Figure 10: Consistency Editor with Initialized Data
| Column | Meaning |
|---|---|
|
Object |
Test object name. |
|
Count |
Total number of objects in the database table. |
|
Verified |
Test progress in percent. |
|
Errors |
The number of error that occurred during a consistency check. |
|
Status |
Current test status. The status is updated during the consistency check. |
| Icon | Meaning |
|---|---|
|
|
Test object is currently being test. |
|
|
Consistency check was successful for this Test object. |
|
|
Consistency check for this test object is complete but errors occurred. |
| Context menu item | Meaning |
|---|---|
|
Enable |
Enables selected test object(s) for the period of the consistency check. |
|
Disable |
Disables selected test object(s) for the period of the consistency check. |
|
Test |
Starts running the consistency check for the selected test object(s). |
|
Skip |
Skip the test object during the consistency check. |