• 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…

  • 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…

  • 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…

  • 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…

  • 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…