• Install Identity Manager with script, quantum.migratorcmd.exe

    Hi everyone,

    I've been facing challenges with the script-based installation of Identity Manager using the quantum.migratorcmd.exe tool. However, everything proceeds smoothly when I use the Configuration Wizard for installation.

    From what I understand…

  • SQL Server 2022 support for Identity Manager 9.0 LTS CU3.

    The supported SQL version mentioned in the original Identity Manager 9.0 LTS Release Notes is SQL Server 2019, which is at this moment already some 5 years old. So for newly installing or upgrading from 8.x to 9.0 LTS, it would be preferred to use a more…

  • Azure AD authentication against Azure SQL Database

    Hello OIM community,

    We are using One Identity, running the database as an Azure SQL Database, with OIM servers running containerized on Azure cloud. We would like to start authenticating with Azure SQL Database using Azure Active Directory instead of…

  • How to run a prepared statement (QBMLimitedSQL) with parameters from a process step?

    Hi One Identity Manager Community,

    We have some complex SQL scripts that are run from processes that we would like to store as prepared statements (QBMLimitedSQL) rather than as the parameter to a SQLComponent task.

    So far I have not been able to find…

  • Need Assistance with SQL Query Interview Questions

    Hello,

    I am currently preparing for SQL interviews and have come across a resource that contains SQL query interview questions. The resource can be found here SQL Query-based Interview Questions I believe this will be helpful for others as well.

    However…

  • How to convert a query from SQL to be inserted in the condition of a Case in Web Designer?

    In One Identity Manager 8.2 I would like to edit the (viewing) condition of a Case inside a Switch in the Web Designer:

    The problem is that I don't know how to convert the query from SQL to the language supported by the condition. The docs says it's…

  • SQL for Dynamic Role to exclude members of a group.

    I'm working on a Dynamic Role for users that are currently not members of a group that begins with specific value.  An example would be an SQL statement that excludes all users that are in groups beginning with "ARS."  I've tried to use the…

  • How to create a View on the database without having a UID field to refer to?

    Hello, everyone,
    I am using One Identity - Identity Manager v. 8.2.
    I would like to create a View on the Database using the launchpad's 'Extend Schema' tool.
    The query that generates the view is very complex and requires many JOINs. The tool…

  • Reason for names longer than 30 characters?!

    Hello Community,

    we are using One Identity Manager version 8.1.5

    we have created our own table indexes for some tables. In doing so, we noticed the following message in the system journal

    Element name longer then 30 chars ... from the Application QBM_PCustomSQLFill…

  • Permission error to sync Active Directory

    I have these problems, has anyone experienced this? I'm using version 8.1.4, sql server 2017 and windows server 2016, I also tried it on another system with version 2019 and got the same problems.

    when trying to modify permissions or synchronize…

  • Could not find referenced assembly VI.TSUtils.Dll

    I'm compiling the database on a sql server 2017, installed on a windows server 2019 and I get the following message during compilation: "Could not find referenced assembly VI.TSUtils.Dll.", when I close the error message is prompted for a authentication…

  • How to reindexing large tables?

    Hello,

    we are preparing the update of our environments to version 8.1.5. In the development environment we have noticed that within the daily maintenance work not all table indexes are
    being rebuilt. A look into the Relase Notes explained us why this…

  • Fetching Data from standard view going into infinite loop for some users during Web Portal login, no issue during tool login

    Currently a few test users in one of our Pre-production environment are having logon issues while logging on to the web portal. The issue is that once they try to logon using their username and password (authentication method - Employee (role based) they…

  • Database compilation error

    Hi everyone,

    I installed One Identity Manager 8.1.4 on a machine and when I try to compile the DB I get the error in the image below

    Here some information:

         - Job Server status is up and running

         - service is running

        - log file contains only "Requesting…

  • Execute a SQL query in object browser and return data results automatically?

    Hello - we are currently using OneIM 8.1.3 and have a question regarding executing a SQL query automatically and exporting data results.  As of right now, we use Object Browser to manually execute a SQL query that essentially runs a comparison between…

  • Need help with custom code for writing data to sql database using ADO.net connector and stored procedure

    Hi, I am trying to write the data to SQL target using ADO.net connector since I need to use stored procedure and direct db access is not available. I need a sample code to write code in Multiple Processing steps to create, update and delete user. We are…

  • MakeDecision job stuck in "processed" state.

    Hello,
    recently was found that all makedecision jobs just stuck in processing state and nothing happens.
    All other jobs successfuly executes and there is no isReset in dbqueue. Which means that object layer don't see any "contested" operations.…

  • SQL Server 2017 Developer Edition

    Hi,

    I try to install a demonstration envionment with SQL Server Developer Edition, but it does not work.

    Processing step 'ATT CheckInsertJob (insert post processing jobs)' failed.
    4 - Sql command failed.
    Error during execution of statement: exec…

  • Two Cloud Access Manager on one SQL Instancecloud

    Hi,

    We need to install 2 CAM and we would like to know if is it possible to install them on the same SQL instance but in a different DB.

    Thanks

  • Creating a new One IM Database via the command Line

    Hi,

        Hoping a quick question, How do you create a new database via the Cli?

    I'm trying to replicate the functions of the ConfigWizard "Create and install database function/feature within a deployment script. I've found information that points…

  • Migrating OneIM DB for upgrade to 8.1

    Hi All, 

    I am working with a customer to upgrade their installation to 8.1 (from 7.1.2).  To do so SQL had to be upgraded to 2016 and they chose to create a new server and migrate teh DB. 

    Now the DB is on the new host, we are able to connect, and need…

  • Is it possible to log or debug outgoing SQL queries in a satabase syncproject?

    Hello community,

    imagine you have a sync-project between IDM and a Microsoft SQL server.

    Is it possible to log or debug the dynamicly genereated queries that are send to the target database?

    For example in a "Insert" provisioning job?

    Version…

  • Approval procedure for delegations

    (Ver 7.1.2)

    Hello again experts,

     

    Let me explain what we want to do and how have we tried to do so.

    So our aim is to create an approval workflow for delegations in which the person you are delegating to has to approve it (“accept” that delegation). Sounds…

  • Expression Clauses in a query

    Hello

    We are trying to use a join clause in a script on 1IM. The problem we have is that when we are using classes .Join and .On of the object Query, .On class only admit ExpressionClause Type. Is there any example of how to declare and initialize this…

  • 1IM V7.1 Synchronisation Projects - One to Many Relationships

    I'm in the process of creating a connector to an application that has a specific use case; and wanted to see if anybody else has done anything similar.

    The application in question uses a simple SQL database that doesn’t have any primary keys set as…