Project

General

Profile

Actions
Copy link

Defect #2033

closed

Provisioning queue cannot be deleted

Added by Petr Michal about 4 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Radek Tomiška
Category:
Provisioning
Target version:
Rhyolite (9.7.15)
Start date:
02/03/2020
Due date:
% Done:

100%

Estimated time:
Affected versions:
Owner:

Description

On project (IDM version 9.7.14; Windows) I cannot delete or archive provisioning queue from GUI.
I tried it on 8000 items and 900 items.

In one usecase I used truncate on sys_provisioning_operation and that was being processed for a long time, when I stopped tomcat, than truncate was immediately completed.

Actions
Copy link
 #2

Updated by Radek Tomiška about 4 years ago

  • Assignee changed from Vít Švanda to Radek Tomiška

I suspect database bytea column usage with big provisioning context => even truncate of table took long, but i can look at it.

Actions
Copy link
 #3

Updated by Petr Michal about 4 years ago

On mentioned project every provisioning contains 200 - 300 roles, so its probably bigger than usual object.

Actions
Copy link
 #4

Updated by Radek Tomiška about 4 years ago

  • Related to Feature #2040: Provisioning system timeout - Execute provisioning synchronously from long running task is stucked added
Actions
Copy link
 #5

Updated by Radek Tomiška about 4 years ago

  • Status changed from New to In Progress

I've created 10k provisioning operations with a big context (provisioning with merge attribute with ~700 values in context) and delete all operations - works correctly (took 1s).

Actions
Copy link
 #6

Updated by Radek Tomiška about 4 years ago

  • Status changed from In Progress to Needs feedback
  • Assignee changed from Radek Tomiška to Vít Švanda
  • % Done changed from 0 to 90

The issue is conected with newnly added provisioning attributes used for filtering empty provisioning.
I improved query for deleting provisioning attributes, when operations are deleted, commit:

https://github.com/bcvsolutions/CzechIdMng/commit/c86272ce533949445c8401f58b545d78c144efc2

I tested it on 150k deleted provisioning attributes.
Could you provide me a feedback, please?

Note: Thx @kopro for help with explain old query on old PosgreSql database 9.x, cannot be reproduced on PosgreSql 11.x (old query has even better cost).

Actions
Copy link
 #7

Updated by Radek Tomiška about 4 years ago

  • Related to deleted (Feature #2040: Provisioning system timeout - Execute provisioning synchronously from long running task is stucked )
Actions
Copy link
 #8

Updated by Vít Švanda about 4 years ago

  • Status changed from Needs feedback to Resolved
  • Assignee changed from Vít Švanda to Radek Tomiška
  • % Done changed from 90 to 100

I tested this and delete of provisioning queue works correctly. Thanks

Actions
Copy link
 #9

Updated by Radek Tomiška about 4 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF