Project

General

Profile

Actions
Copy link

Task #2865

closed

The report "Identities and their account changes on a system" fails or doesn't include deleted identities

Added by Alena Peterová over 3 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Tomáš Doischer
Target version:
2.3.0
Start date:
06/28/2021
Due date:
% Done:

100%

Estimated time:
Owner:

Description

Tested on 2.2.1 with core 11.0
Identities and their account changes on a system (identity-account-changes-report):
  • if the identity was deleted together with its accounts, then the report fails to generate completely (entity_identifier is empty)
  • if the account was deleted first and the identity afterwards, then the report doesn't include the identity; it's visible only as a difference in the count of the processed items
Actions
Copy link
 #1

Updated by Tomáš Doischer about 3 years ago

  • Assignee set to Tomáš Doischer
  • Target version set to 271
Actions
Copy link
 #2

Updated by Tomáš Doischer about 3 years ago

  • Status changed from New to In Progress
Actions
Copy link
 #3

Updated by Roman Kučera about 3 years ago

If you want to check how many rows has null in "entity identifier" column you can use following SQL

select count(*) from sys_provisioning_archive where entity_identifier is null;

After that at your own responsibility you can delete these rows

delete from sys_provisioning_archive where entity_identifier is null;

After that the report will be generated without any issue.

Actions
Copy link
 #5

Updated by Tomáš Doischer about 3 years ago

The same issue will arise in 'identity-password-changes-report'.

Actions
Copy link
 #6

Updated by Tomáš Doischer about 3 years ago

  • Status changed from In Progress to Needs feedback
  • % Done changed from 0 to 80
Actions
Copy link
 #7

Updated by Tomáš Doischer about 3 years ago

  • Target version changed from 271 to 2.3.0
Actions
Copy link
 #8

Updated by Roman Kučera about 3 years ago

Thx for fix, I did review, LGTM.

Actions
Copy link
 #9

Updated by Tomáš Doischer about 3 years ago

  • Status changed from Needs feedback to Resolved
  • % Done changed from 80 to 100

Released.

Actions
Copy link
 #10

Updated by Tomáš Doischer about 3 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF