This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

query on jobs for HelperAttestationPolicy

Hi ,
i am using v8.0. We have recently setup a new dev environment and migrated few attestation policies from our previous environment to new dev env. Now we are getting thousands of jobs in Job queue with the title- "Created by QBMDBQueueProcess:execute template for object type HelperAttestationPolicy"

Also in the DBqueue - the process is highlighted--" Fill Attestation rule auxiliary table"

They are taking so much time to complete with the jobs running from almost 15 hours now.This is nearly blocking any other Job from execution.

Can somebody please suggest what is meant by these jobs/process and what purpose are they serving ( i can see that records in HelperattestationPolicy tables are getting increased but i dont know the significance of this table as well in the overall attestation flow)

Looking for some details and pointers tp relevant documentation , if possible.

Thanks!

0 Markus Weiss-Ehlers over 6 years ago

To make it short, without the entries in HelperAttestationPolicy the attestation will not work.

If your development environment needs so much time to calculate the necessary data you should consider to either strip down the amount of content data to a feasible amount or ramp up your dev. environment to be able to handle the load.
Cancel
Up 0 Down

Cancel
0 saba.naaz over 6 years ago in reply to Markus Weiss-Ehlers

Thanks for the revert Markus,

Can you please suggest what should be the dev environment infa capacity to handle 50k users and 15-20 attestation policy.

As of now we have 16core CPU with 8 GB RAM for database server.

Thanks!

Saba
Cancel
Up 0 Down

Cancel
0 Markus Weiss-Ehlers over 6 years ago in reply to saba.naaz

Please see my answer on the recent thread https://www.quest.com/community/one-identity/identity-manager/f/identity-manager-forum/27441/how-to-improve-db-performance-can-we-add-index-on-db
Cancel
Up 0 Down

Cancel