Chat now with support
Chat with Support

Identity Manager 8.1.5 - Configuration Guide

About this guide One Identity Manager software architecture Customizing the One Identity Manager default configuration Customizing the One Identity Manager base configuration One Identity Manager schema basics Editing the user interface
Object definitions for the user interface User interface navigation Forms for the user interface Statistics in One Identity Manager Extending the Launchpad Task definitions for the user interface Applications for configuring the user interface Icons and images for configuring the user interface Using predefined database queries
Localization in One Identity Manager Process orchestration in One Identity Manager
Setting up Job servers Configuring the One Identity Manager Service Handling processes in One Identity Manager
Tracking changes with process monitoring Conditional compilation using preprocessor conditions Scripts in One Identity Manager
Using scripts Notes on message output Notes on using date values Using dollar ($) notation Using base objects Calling functions Pre-scripts for use in processes and process steps Using session services Using #LD-notation Script library Support for processing of scripts in Script Editor Creating and editing scripts in the Script Editor Copying scripts in the Script Editor Testing scripts in the Script Editor Testing script compilation in the Script Editor Overriding scripts Permissions for executing scripts Editing and testing script code with the System Debugger Extended debugging in the Object Browser
Reports in One Identity Manager Adding custom tables or columns to the One Identity Manager schema Web service integration SOAP Web Service One Identity Manager as SPML provisioning service provider Processing DBQueue tasks One Identity Manager Service configuration files

Using Common Table Expressions in read-only database views

In One Identity Manager 7.0, the behavior was changed for Common Table Expressions (CTEs) with the with keyword as condition for view definitions in Read-only database views. Conditions for view definitions are embedded in a summarized query. This means, there is no guarantee that CTEs are placed right at the top of the query.

Possible error messages

(execute slot single)50000 0 re-throw in Procedure QBM_ZViewBuildR, Line 1050000 0 rethrow in Procedure QBM_PViewBuildR_intern, Line 10250000 0 re-throw in Procedure QBM_PViewBuildR_intern, Line 8250000 0 re-throw in Procedure QBM_PViewBuild_FromAddOn, Line 6550000 0 re-throw in Procedure QBM_PSQLCreate, Line 26156 0 detected in (...) Procedure ..., Line 6156 0 Incorrect syntax near the keyword 'with'

Recommended action
  1. Create a database view using the CTE.

    Example:

    create view CCC_Vxy as

    with myWithClause (column1, column2) as (

    select 1 as column1, 2 as column2

    )

    select * from myWithClause

    go

  2. Use the database view in the additional view definition (QBMViewAddon) of Read-only database views.

    select * from CCC_Vxy

Creating database views with Union type

Technical details
  • The technical identifier for the database view is automatically formed according to the schema CCC<Table name>.

  • As the first column of the database query (view definition), the object key (XObjectKey) must be referenced. The object key allows faster access to a single object with its valid permissions.

  • If you want to index the database view for the full-text search, the XDateInserted, XDateUpdated, and XObjectKey columns must be available.

To create a database view of Union type in the Schema Extension

  1. Start the Launchpad and log in to the One Identity Manager database.

  2. Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.

  3. Click Next on the start page.

  4. On the Database connection page, check the connection data for the One Identity Manager database.

  5. On the Select method page, select Create union view.

  6. On the Create union view page, enter the following information.

    Table 175: Database view properties
    Property Description

    Table

    A technical name for the database view.

    Display name

    Name displayed for the database view. The display name is used, for example, to identify the database view in a database search or error output.

    Description

    Comments on using the database view.

    View definition

    Enter the database query as a Select statement.

Related topics

Creating new assignment tables

Technical details
  • The technical identifier for the table is automatically formed according to the schema CCC<Table name>.

  • The XObjectKey and XMarkedForDeletion columns are automatically generated.

  • The table relations and column relations are generated automatically.

To create a new assignment (many-to-many) table in the Schema Extension.

  1. Start the Launchpad and log in to the One Identity Manager database.

  2. Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.

  3. Click Next on the start page.

  4. On the Database connection page, check the connection data for the One Identity Manager database.

  5. On the Select method page, select New relation table.

  6. On the Create a relation table page, enter the following information.

    Table 176: Assignment table properties
    Property Description

    Table

    A technical name for the table.

    Display name

    Displays table name The display name is used, for example, to identify the table in a database search or for error output.

    Description

    Comments on using the table.

    Create XOrigin column (for assignment requests)

    You can create the origin column (XOrigin) optionally. The origin of an assignment is stored in this column as a bit field. Each time an entry is made in the assignment table the bit position is changed according to the assignment type.

    Related tables

    Use the Left table and Right table menus to specify which tables are included in the relation table.

    Column names

    In Column name fields, enter the relevant columns for each side of the table. Select the table’s primary key column.

  7. On the Configure columns page, enter the display name of the columns.

  8. (Optional) Click to configure more column properties. For more information, see Advanced configuration of columns.

Related topics

Creating indexes

Define indexes to optimize access to database columns. An index can contain one or more database columns.

NOTE: For tables that you create using the Schema Extension program, indexes are automatically created for the primary key column and the object key column (XObjectKey).

To create a new index in the Schema Extension

  1. Start the Launchpad and log in to the One Identity Manager database.

  2. Open the Launchpad and select the One Identity Manager Schema Extension entry. This starts the Schema Extension program.

  3. Click Next on the start page.

  4. On the Database connection page, check the connection credentials for the One Identity Manager database.

  5. On the Select method page, select Create index

  6. On the Extend Table page, under Table, select the table for which you want to create an index.

  7. On the Create index page, define the columns for the index definition.

    1. Click the button.

      This opens a dialog box where you can define the columns for the index. You can see all the columns in the table on the right-hand side of the dialog window. The columns on the left-hand side of the window belong to the index.

    2. Enter the name of the index in the Index name input field.

      A name is already suggested. You can change this as required.

    3. On the right-hand side of the dialog window, select the column you want to add to the index.

    4. Use the button to add the column to the index.

      Change the order of the columns in the index definition as required or remove a column from the index using the relevant button.

    5. Click OK.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating