• Observation when updating to version 9.2.2

    Hello,

    We are in the process of upgrading our environments from Version 9.0 LTS to version 9.2.2.

    We would also like to use new servers for this - from WinServer 2019 & MSSQL 2019 to new WinServer 2022 & MSSQL 2022. 
    We are currently in the development…

  • error when requesting DB Queue from Job Server

    Hi everybody!

    We’ve encountered a critical error while requesting the database queue from the Job Server.
    The process failed and generated multiple errors related to transaction handling, lock timeouts, and retry failures.

    This is now blocking all…

  • Operation "Procedures for creating approval methods" stuck in DBQueue, shown as IsReset=1

    Hello,

    We are using version 9.0 LTS and getting below error in system journal.

    (execute slot single)50000 0 re-throw in Procedure QER_ZPWODecisionRuleMakeProc, Line 10850000 0 re-throw in Procedure QBM_PSQLCreate, Line 2750000 0 re-throw in Procedure…

  • Get Approver for Request shows up in the DB Queue and it takes a long time

    Hello everyone,

    In the DB queue, the process "Get approver for request" takes a very long time (more than 30 minutes for ~200 lines) and stops the execution of the entire queue

    There are fixes on the One Identity Community:

    https://support…

  • Observation during update to version 9.2

    Hello,

    We are currently setting up the new environments for the planned update from version 8.1.5 to version 9.2.

    We are using a SQL Server 2022 as platform for OneIM.

    We are currently at the point in the schema installation where the DBQueue operation…

  • "The DB queue processer is disabled" after Database move, preventing compilation version 9.2

    The situation is this:

    • We are running OIM v9.2, and we've been on 9.x for a while now.
    • But when we put the database into an Always-On availability Group, OIM saw this as a database move.
    • Ok, no problem so far. We got prompted about if we had moved…

  • database compilation stuck at "Wait for DBQueue processor"

    when I try to compile the database from designer it stucks at "Wait for DBQueue processor" and never go forward with the compilation and when I examined the JobQueue

    it has no Processes running and the DBQueue shows the same message "Wait for…

  • Create trigger to record changes - Turned on Log changes

    Hello,

    I recently added log changes to a template and in my DB Queue I see "Create trigger to record changes". It sit there and Is Reset is yes and does not go away.

    Is there something I need to do for this to clear? Or should I log a ticket…

  • DB Queue slow processing version 8.1.2

    Hi All,

    I would like to know what is the best thing to look at, and or solution for the DB queue that has been processing slowly we have lots of pending processes in job queue and it has been 2 days.

    Hope someone can enlighten me in resolving this issue…

  • What does this status of the QBM_PDBQueueProcess mean?

    Hello,

    We are currently using version 8.0.5 of the Identity Manager.

    In the system log we noticed entries of the application QBM_PDBQueueProcess which contain the following MessageString invalid RunningState -1.

    What does this mean? What could have caused…

  • Step by step execution of DBQueue tasks

    Hi Team,

    I'm trying to troubleshoot why an Attestation Approval Procedure is failing to determine an Approver. We can run the Query using Object Browser and return the expected Approvers. But when the Attestation run, the approvers aren't being determined…

  • DBQueue processor was not active

    Hi,

    I've just installed One Identity Manager on a Server and when I try to compile database by Designer I receive the following warning: "The DB Queue processor was not active for more than one hours...".

    Could you help me?

    If it can help…

  • SAPRoles are not getting tagged with ORG

    There are some sap roles(Entitlement's) which are assigned to a System role(Eset), so records in EsetHasEntitlement exists.

    When I assign the system role(Eset) to the business role(Org), records gets inserted in OrgHasEset table, but the Sap roles…

  • Prod dbqueue is not working

    Hello Guys,

    My prod dbqueue is always showing as waiting for dbqueue processor.

    QBM-K-JobqueueOverviewInvalid task is running in dbquuecurrent from yesterday.

    I tried restarting job services and did a full DB compile but still  the same issue.

    Could…

  • Auditing an executed job to find who or what triggered an event.

    Hello Experts,

    I am in need of some assistance.  We had an incident where a few users got removed from a group and i've been tasked to find out how and who did it.  i found the job that did it but it says it was done by "sa" and when i look at created…

  • HistoryDB / DBQueue does not process any entries

    Hi ,
    after the first problem has been solved, historization does not seem to be going smoothly. We are using version 8.0.3. 

    If we start the schedule "Import process information directly" manually, the job "VI_SourceDatabase_Import" is set…

  • Is there a way to kick-off inheritance calculations?

    I'm using version 8.0.1. I've just done a transport of a lot of Business Roles and System Roles as well as entries from OrgHasEset. The business role structure is hierarchical and set to inherit top down. The problem is, none of the inheritance is working…

  • DB Queue Tasks are populated and running for more than a day (Dynamic Role check)

    Hi There,

    In a Cloud App Integration, we have synced the new users from a secondary system (authoritative source) to our CSM database, creating new identities. However the sync is done. But there are 7 dynamic roles in system and lots of DB Queue tasks…

  • Database CPU requirements to use SAP functions

    Hi all,

    I imported 2 SAP functions using the plugin called "Import SAP functions definition" from a CSV file with 70 rows. After that I created the correspondent SAP function instances but I can see on JobQueueInfo that the DB processes "Interim calculation…

  • A "Recalculate approvers" task is stuck in DBQueue

    Hello.

    We have a "Recalculate approvers" task in DBQueue that stuck there for several days. Other tasks appears and disappears but this one is present in queue all the time with the same parameters. And the approvers does not looks recalculated.…

  • Why DBQueue gets stuck again and again?

    Hi,

    I am using version 8.0 and I am facing this issue that DBqueue gets stuck again and again. I have to reinitialize dbqueue then only it works. What can be the reasons for this? How can I resolve this issue?

  • Existing processes while DB compiling

    Hi,

    What will happen if we use the Emergency Stop in JobQueue to stop the processes before DB compiling?

    Can they all be re-initiated?

  • Dbqueue is not processing

    Hello experts,

    (Ver. 7.1.2)

    I come to you with a technical issue that we are experiencing and that is blocking all the processing in one of our environments.

     

    We currently have the DBqueue that seems like it is not processing anything at all. We have…

  • How to find each job details in "DialoguDBQueue"

    I need to find what are jobs are executing in "DialogDBQueue".I could see that there are 10 task to process  in "Active Directory user account  membership in Active Directory groups" .How to find the details in that task like,for which user…

  • How to see more detilas in pending DBQueue process

    Hi,

    Is there any way to find more details on DBQueue. In pending DBQueue  i could see "Active Directory Group Assignments" task is pending for long time.How can i see that which AD group is pending a,d for which user it is pending .

    Is there…