• State Suggested Answer
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 95 subscribers
  • Views 401 views
  • Users 0 members are here
Options
Related

Clean up product nodes in the IT Shop shows up in the DB Queue and it takes a long time

kilitac889
6 months ago

Hello everyone,

In the DB queue, the process "Clean up product nodes in the IT Shopt" (UID_Task QER-K-Org-AutoChild) takes a very long time.

In QBMDBQueueCurr, there is only one line and it goes to the reset. (column Generation over 20 times) At the same time, System Journal does not write the reason for the reset of the process

There are fixes on the One Identity Community:

support.oneidentity.com/.../qer-k-orgautochild-task-blocks-dbqueue-processing

But we use Version 9.2 and this version already includes these fixes.

From IT Shop Administration Guide:

"Information on bulk processing
If products are added in bulk to the IT Shop by automatic processes, you can specify how
many product nodes are created in one DBQueue Processor run in the QER | ITShop |
LimitOfNodeCheck configuration parameter. Once this number has been exceeded, the
task is closed and queued again in the DBQueue for generating the rest of the product
nodes. By default, 500 objects are processed in one run. The number of requests submitted
in bulk can be considerably larger than other processes.
Set a lower value if performance issues arise when running the QER-K-OrgAutoChild
process task."

We reduced this number to 50, but this did not help

How can I resolve this issue?

Thanks!

Parents
  • 0 6 months ago

    Hi,

    Run this SQL against your OI DB:

    Select ito1.Ident_Org,ito.UID_ParentITShopOrg,count(*) from ITShopOrg ito
    join ITShopOrg ito1 on ito.UID_ParentITShopOrg = ito1.UID_ITShopOrg
    group by ito1.Ident_Org,ito.UID_ParentITShopOrg
    order by 3 desc

    If you get results where a single shelf has >10k objects assigned then that could be your issue.  We have found that QER-K-OrgAutoChild doesn't do so well in these circumstances.  We ended up creating multiple shelves and distributing the products.

    You can find out which shelf is tripping you up by getting the value of UID_Parameter from the entry in QBMDBQueueCurrent ..... then query ITShopOrg where UID_ITShopOrg is the value from UID_Parameter.

    HTH, B.

  • 0 6 months ago in reply to Barry Jackson

    Thanks for the answer, Barry!

    We have on the Active Directory Groups shelf (ADS-ITSHOPORG-ADGROUPS-BO) 115771 objects, but everything worked well

    And also, when we publish on a shelf with more than 50k + objects, inheritance occurs correctly

    UPD now is working well

Reply Children
No Data