One Identity Manager Software Architecture
Working with Objects in One Identity Manager
Inserting, Modifying and Deleting Objects in One Identity Manager
Working with the Designer
General Information about the Program
Menu Items
Views in the Designer
Customizing Program Settings
Using Help
Limiting List Sizes
Searching for List Entries
Using the Designer's Own Full-Text Search
Using User Defined Filters for Searching
Making and Committing Changes to Objects
The Designer Editors
Working with the Object Editor
Working with the List Editor
Customizing the One Identity Manager Default Configuration
Checking Data Consistency
Menu Items
Functions in the Result List
Result List Configuration
Multiple Editing of List entries
Displaying Object Relations
Working with the SQL Editor
Support for Scripting
Working with the Consistency Editor
Starting the Consistency Check
Recording Test Results
Repairing Errors
Compiling a One Identity Manager Database
Working with Change Labels
Creating Change Labels
Displaying Contents of a Change Label
Booking Changes to a Change Label Retrospectively
Basic System Configuration Data
One Identity Manager Authentication Module
Database Connection Data
The One Identity Manager Data Model
Database Connection Properties
Configuring a One Identity Manager Database for Testing, Development or Production
Configuration Parameters for System Configuration
Setting up the Mail Notification System
Enabling More Languages for Displaying and Maintaining Data
Displaying Country Information
Working in Different Time Zones
Determining Working Hours
Editing Countries
Editing States
Modifying Public Holidays
Setting Up and Configuring Schedules
Password Policies in One Identity Manager
Predefined Password Policies
Editing Password Policies
Custom Scripts for Password Requirements
Restricted Passwords
Testing a Password
Testing Generating a Password
Assigning a Password Policy
Reloading Changes Dynamically
TimeTrace Databases
Machine Roles and Server Functions
Files for Software Update
Importing New Files into a One Identity Manager Database
Exporting Files from a One Identity Manager Database
Configuring Files
Operating Systems in Use
System Configuration Reports
Using Predefined Database Queries
Managing Custom Database Objects within a Database
Basics of the Data Model
General Advice for Editing Table and Column Definitions
Working with the Schema Editor
Mapping Table Definitions
Granting One Identity Manager Schema Permissions
Table Properties
Working with Module Globally Unique Modifiers
Table scripts
Database Views of Type "View"
Database Views of Type "Union"
Database Views of Type "Proxy"
Database Views of Type "Read-only"
Mapping Column Definitions
Column Properties
Templates
Mapping Table Relations
Supporting File Groups
Editing Value Templates
Example of Local Value Templates within an Object
Example of Value Templates across Objects
Formats for Checking Values
Permitted Column Values
Mapping Dynamic Foreign Keys
Column Dependencies for Setting Values
Configuring Columns for Full-Text Search
Predefined Permissions Groups and System Users
Editing Permissions Groups and System Users
Working with the User Interface
Working with the User & Permissions Group Editor
Permissions Group Dependencies
Copying Permissions Groups
Manually Creating Permissions Groups
Permissions Groups Properties
Editing System Users
Adding a System User to Permissions Groups
Dynamic system user
Which Employees Use System Users?
Editing Permissions for One Identity Manager Schema Tables and Columns
Rules for Finding Valid Permissions for Tables and Columns
Working with the Permissions Editor
Availability of Certain Functionality
Displaying Permissions for an Object
Displaying the Current User's Permissions
Menu Items
Views in the Permissions Editor
Functions in the Permissions Edit View
Filtering Entries in the Permissions Editor
Granting Permissions for Tables
Granting Column Permissions
Object definitions for the User Interface
Process Orchestration in One Identity Manager
Selection Criteria for Object Definitions
Using Display Text for Object Definitions
Working with Object Definitions
User Interface Navigation
Navigation View Elements
Recommendations for Editing Menu Navigation
Working with the User Interface Editor
Editing Menu Items
General Menu Item Properties
Creating Database Queries for Data Dependent Menu Items
Editing Lists
Using Links
Using Variables
Forms for the User Interface
Recommendations for Editing Forms
Working with the Form Editor
Editing Interface Forms
Statistics in the One Identity Manager
User Interface Form Properties
Form Definitions and Form Templates
Effects of Object Definitions when Displaying Interface Forms
Features of the Assignment Form
Forms for Custom Extensions
Custom Master Data Forms
Configuration Data for Displaying Many-to-Many and Object Relations on Forms
Replacing Default Forms with Custom Forms
Working with Overview Forms
Working with Statistic Definitions
Linking Statistics into the User Interface
Diagram Types for Visualizing Statistics
Examples of Statistic Definitions
Extending the Launchpad
Task Definitions for the User Interface
Applications for Configuring the User Interface
Icons and Images for Configuring the User Interface
Language Dependent Data Representation
Declaring the Job Server
Tracking Changes with Process Monitoring
Working with the Job Server Editor
Editing a Job Server
One Identity Manager Service Configuration
Job Server Properties
Server Functions of a Job Server
Job Server Machine Roles
Job Server Statistic Information
Installing the One Identity Manager Service on the Job Server
Customizing the One Identity Manager Service Configuration for a Job Server
One Identity Manager Service Configuration Files
Process Collection Module
Handling Processes in the One Identity Manager
MSSQLJobProvider
OracleJobProvider
FileJobProvider
FTPJobProvider
HTTPJobProvider
AppServerJobProvider
The Jobdestination Module
The Configuration Module
The Logwriter Module
The Dispatcher Module
The Connection Module
The HTTP Authentication Module
The Plug-ins Module
HTTPLogPlugin
ScheduleCommandPlugin
DBSchedulerWatchDogPlugin
RequestWatchDogPlugin
PerformanceCounterPlugin
DebugMailPlugin
ShareInfoPlugin
RemoteConnectPlugin
Module File with Private Key
Working with the Process Editor
Defining Processes
Creating and Editing Processes
Executing Processes Automatically
Process Components
Properties for a Process
Using Process Specific and Global Variables for the Process Definition
Thresholds for Handling Processes
Creating and Editing Events
Creating and Editing Process Steps
Process Step Parameters
Searching for a Process Step within a Process
Comparing Processes
Exporting and Importing Processes
Simulating Process Generation
Checking the Validity of a Process
Compiling a Process
Basics for Process Monitoring
Logging Data Changes
Logging Process Information during Process Handling
Recording Messages in the Process History
Process Tracking for DBQueue Processor Operations
Archiving and Deleting Recordings
Conditional Compilation using Preprocessor Conditions
Preprocessor Relevant Configuration Parameters
Preprocessor Conditions in Objects
Preprocessor Conditions in VB.Net Expressions
Evaluation of Preprocessor Conditions during Compilation
One Identity Manager Scripts
Using Scripts
Message Output
Implementing Dates
Using Dollar ($) Notation
Maintaining Mail Templates
Reports in the One Identity Manager
Accessing Local Object Columns
Accessing Object Columns Connected by a Relation
Accessing the Old Column Value
Accessing Column Display Values
Accessing References in Comments
Accessing Local Object Meta Values
Using base. Object
Calling Functions
Pre-scripts for using in Processes and Process Steps
Using Session Services
Querying Configuration Parameters
Testing the Existence of Certain Database Entries
Querying Session Object Global Variables
Using #LD Notation
Scripts in the Script Library
Working with the Script Editor
Editing Scripts
Overriding Scripts
Testing Script Compilation
Testing a Script with the Script Editor
Testing Scripts with the System Debugger
Working with the Report Editor
Creating and Editing Reports
Custom schema extensions
General Report Properties
Creating a Data Source
Example of a Simple Report with Data Grouping
Translating Reports
Linking Reports into the User Interfaces
Data Retrieval using an SQL Query
Data Retrieval using a Database View
Data Retrieval using an Object
Data Retrieval using Single Object History
Data Retrieval using Multiple Object History
Data Retrieval using Historical Assignments
Data Query for Simulation Data
Editing Report Parameters
Using Virtual Data Sources
Editing the Report Form
Creating a New Table
Extending a Table
Defining Columns
Transporting One Identity Manager Schema Customizations
Creating a Simple Column
Creating a Foreign Key Column
Creating New Columns for Database Views
Configuring Column Properties
Creating a Read-Only Database View
Creating a Union View
Creating New Assignments Tables
Creating Indexes
Permissions for Schema Extensions
Specifying Change Labels for Schema Extensions
Adding Schema Extensions
Adding in Custom Extensions to the User Interface
Basics for Transport of One Identity Manager Schema Modifications
Creating a Transport Package with the Database Transporter
Importing Data
Transporting SQL Statements
Transporting Favorite Objects
Transport by Change Label
Transport by Change Information
Transporting Schema Extensions
Transporting Selected Objects and their Dependencies
Transporting System Configuration
Transporting System Files
Displaying Contents of a Transport Package
Importing a Transport Package with the Database Transporter
Displaying Transport History
Importing Data from CSV Files
Importing Data from a Database
Import Configuration
Web Service Integration
Assigning Target Tables and Columns
Assigning Target Columns with the Assignment Wizard
Specifying the Hierarchy
Options for Handling Records
Specifying Connection Variables
Importing Data
Using Import Definition Files
Binding a Web Service
SOAP Web Service
Generic Web Service Call
Direct Web Service Call
Self-Defined Web Service Call
Creating a Web Service Solution with the Web Service Integration Wizard
Changing a Web Service Solution
Deleting a Web Service Solution
Installing and Configuring the SOAP Web Service
One Identity Manager as SPML Provisioning Service Provider
Installing the SOAP Web Service
Configuring the SOAP Web Service
Displaying the Status of a SOAP Web Service
Uninstalling the SOAP Web Service
Examples of Calls
SPML Web Service
Installing and Configuring SPML Web Services
Configuring the One Identity Manager Schema
Testing SPML Web Service Functionality
Searching for Errors in the One Identity Manager
Monitoring Process Handling with Job Queue Info
Processing DBQueue Tasks
Working with Job Queue Info
Job Queue Info Views
Monitoring Process Execution
Error Messaging in the Error Message Window
Displaying Messages in the Error Log View
Logging Messages in the Database Journal
Writing the One Identity Manager Log
One Identity Manager Service Logging
Displaying Details of Process Handling
Displaying Details of Process Step Handling
Displaying Details of a Process Step Parameter
Reinstating Process Steps and Processes
Enabling Extended Logging of Process Steps
Determining the State of the Server
Displaying Entries in the DBQueue
Displaying Messages in the Database Journal
Displaying the Job Queue Sequence
Stopping the System (Emergency Stop)
Configuring the One Identity Manager Service Log File
Advanced Logging in the One Identity Manager Service
Displaying the One Identity Manager Service Log File
Extended Debugging in the One Identity Manager Service
Output of Extended Return Values from Individual Process Components
Outputting Custom Messages in the One Identity Manager Service Log File
Logging Messages in the Event View
HTTPLogPlugins Log File
Displaying One Identity Manager Application Server Status
Configuring the DBQueue Processor for Test and Development
Initializing the DBQueue Processor
Controlling Processing of DBQueue Processor Tasks
Processing DBQueue Processor Tasks
Reactivating DBQueue Processor Tasks
Bulk Processing in DBQueue Processor
How the Central Dispatcher Communicates with Individual Slots
Scheduled Maintenance Tasks
One Identity Manager Configuration Files
Reactivating DBQueue Processor Tasks
Reactivating DBQueue Processor Tasks
If a task has to be deferred, for example due to an error or if synchronization is running, the process sets the slot number in the table QBMDBQueueCurrent to "-1" on its own. These tasks are re-enabled if there are no more tasks in the DBQueue. At the very latest, these deferred tasks are reinstated into the DBQueue the next time the central dispatcher runs. This means deferred tasks are re-enabled at the latest once the maximum runtime has elapsed.
|
|
NOTE: Deferring DBQueue tasks is recorded in the system log. |
Related Topics
Bulk Processing in DBQueue Processor
Bulk Processing in DBQueue Processor
| Configuration parameter | Meaning |
|---|---|
| QBM\DBQueue\DefaultRuntime |
The configuration parameter species how the length of the DBQueue Processor run. The default value is 90 seconds. |
Some DBQueue Processor procedures are marked for bulk processing to reduce the total time required for processing DBQueue tasks. If a lot of entries are marked for bulk processing in the DBQueue, the DBQueue Processor switches from single to bulk processing.
There is a mechanism implemented that is used to decide whether switching to bulk processing as opposed to single processing would result in time savings. To do this, 25 single task processes are run and the processing time is recorded. All other entries for the task are processed in bulk and the minimum and maximum load time required for advantageous bulk processing is defined. A self optimizing calculation procedure updates the load times. As a result of this method, the DBQueue Processor needs to "kick in" after initial schema installation or after system changes, such as increased database memory. You can specify how long the DBQueue Processor runtime interval should be with the configuration parameter "Common\DBQueue\DefaultRuntime". The default value is 90 seconds. This corresponds to the time period that achieves the best load for the calculation procedure.
How the Central Dispatcher Communicates with Individual Slots
The table QBMDBQueueSlot is responsible for communication of the central dispatcher with individual slots. The maximum number of slots available is determined during DBQueue Processor initialization. One entry per slot is created in the table QBMDBQueueSlot. The table contains information about each slot and its status as well as currently running tasks.
| Status | Meaning |
|---|---|
| 0 | No activity required. Initial state (through initialization) or end state (set by process). |
| 1 | The process is triggered to prepared central temporary tables, for example. |
| 2 | Ready for operation. The process has started but the currently no tasks exist. This is the state in which tasks can be queued. |
| 3 | Transfer to table QBMDBQueueCurrent. The process has received tasks for processing and needs to begin. |
| 4 | The process has recognized the tasks and added them. |
| 5 | The process is handling the tasks. |
| -1 | The process was prompted to quit. Stop behavior by maximum timeout or abort on process error. |
Related Topics
Communication during Processing
Processing DBQueue Tasks > How the Central Dispatcher Communicates with Individual Slots > Communication during Processing
The following example show the entries in the table QBMDBQueueSlotduring processing.
- Slot initialization
Slot number Status Task name 001 0 - Starts the process using the central dispatcher.
Slot number Status Task name 001 1 - The process is operational. Preparations, for example, for temporary tables, are complete. The slot status is regularly tested.
Slot number Status Task name 001 2 - The central dispatcher distributes tasks. The central dispatcher checks slots for readiness and enters the task from table DialogDBQueue in the table QBMDBQueueCurrent with the slot number. The status of each slots is updated once the table QBMDBQueueCurrent has taken over.
Slot number Status Name of task 001 3 OrgRoot - The process recognizes a task on the basis of the status, starts processing and updates its slots' status.
Slot number Status Task name 001 4 OrgRoot - The process has completed processing and set the slot number in the table DialogDBQueueCurrent to "0". The process changes the status of its slots to operational.
Slot number Status Name of task 001 2
Stop behavior by maximum timeout
Once the maximum runtime has expired, the tasks of slots in the table QBMDBQueueCurrent currently in use are still processed. No new tasks are added from the table QBMDBQueue. All slots with a slot status of "2" are set to "-1" in the table QBMDBQueueSlot. This prompts the processes to finish and stop themselves. The central dispatcher checks whether all processes have completed and have stopped.