SICSR-17723

[SICSR-17723] Log system in SICS is producing unwanted entries for collection attributes  
Product Line: P&C
Component/s: Security
Affects Version/s: SICS 4.9.3
Fix Version/s: SICS 20.1
Customer: Milli Re
External Issue ID: MILI-1897

Problem:
When simply adding one usecase to user role and do changes on another uescase in that role, then a lot of unnessecary log entries are produced in table BUS_COND_LOG. To be precise: Instead of 5 entries (which would be expected due to 5 changes from an Access Rights perspective – see yellow marked entries in screenshot below), the log system produces 178 entries.
The remaining 173 entries are senseless as Old Value and New Values are the same

Solution:
When logging changes to a collection object then only the changes should be logged, not items that were present and still are.
Removed entries will be listed with a new value of null and added entries with an old value of null

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected