Project

General

Profile

Actions
Copy link

Defect #1984

closed

Leftover records in sys_provisioning_attribute

Added by Alena Peterová about 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Low
Assignee:
Radek Tomiška
Category:
Provisioning
Target version:
10.1.0
Start date:
12/10/2019
Due date:
% Done:

100%

Estimated time:
Affected versions:
Owner:

Description

Version 9.7.11
When one provisioning which changes one attribute is created, there exist 2 records in the table sys_provisioning_attribute:
  • first which is linked by provisioning_id to sys_provisioning_archive
  • second which is linked to nothing - its provisioning_id doesn't exist in any of the provisioning tables

Found by accident when checking the SQL here: https://wiki.czechidm.com/devel/documentation/application_configuration/dev/scheduled_tasks/task-scheduler#deleteprovisioningarchivetaskexecutor (but I don't know if the LRT would solve this).

Actions
Copy link
 #1

Updated by Radek Tomiška about 5 years ago

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

Attributes are cleared by mechanism "delete every attributes which not have any operation or archive". I developed it this way to prevent to find all atributes, when operation is executed and moved into archive (=> slows down all operations). But I could revise this mechanism.

Actions
Copy link
 #2

Updated by Radek Tomiška about 5 years ago

  • Tracker changed from Task to Defect
  • Status changed from New to Needs feedback
  • Assignee changed from Radek Tomiška to Vít Švanda
  • Target version set to 10.1.0
  • % Done changed from 0 to 90

I checked current behavior and fixed deleting provisioning attributes (it should work), when active operation is archived. Attributes related to provisioning archive is preserved until archive is deleted.

Commit:
https://github.com/bcvsolutions/CzechIdMng/commit/2e8366c3e5fae17c11771a90be23441ad92f129e

Could you give me a feedback, please?

Note: LRT properly clears forgetten attributes.

Actions
Copy link
 #3

Updated by Vít Švanda almost 5 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 did review and test. After executing of provisioning, only one record for attribute is created in sys_provisioning_attribute now. Thanks for this fix.

Actions
Copy link
 #4

Updated by Radek Tomiška almost 5 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF