RSA Via Lifecycle & Governance: Reviewer Coverage File does not import more then 10.000 items
Originally Published: 2016-07-26
Article Number
Applies To
RSA Version/Condition: 6.8, 6.9.1, 7.0.0
Issue
When importing a Reviewer Coverage File to a user review, you may found that importing such a coverage file with 143588 items can't be imported.
After the import, only 10000 items are shown in the "View" field. The problem was first noticed in Aveksa 6.8.1 P11 HF1 then in IMG 6.9.1 P02 HF6.
I replicated the issue in house and I tested from version 6.8.1, 6.9.1 and 7.0 but could only see 10.000 items from a Coverage File that has more than 10.000 items.
I ran an SQL query to determine whether it's a UI or system issue but the record count shows that it's not UI related as shown below:
Using username "oracle". Last login: Fri Aug 28 14:49:38 2015 from jumphost.vcloud.local Kickstart-installed SuSE Linux Mon Mar 2 10:05:20 EST 2015 oracle@acm-691:~> sqlplus SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 14 09:24:32 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter user-name: avuser Enter password: Connected to: Oracle Database 11g Release 11.2.0.3.0 - 64bit Production With the Automatic Storage Management option SQL> select count(*) from T_AV_REV_COMPONENT_COVERAGE where covering_user_role = 'R' and review_def_version_id in (select current_version_id from t_av_entitlementreviewdef where name = 'Test User Review with default options'); COUNT(*) ---------- 10000The issue as presented:
1. Test Review Created
2. A coverage file which has 143588 items uploaded
3. Click on "View" to view to view the Reviewer Coverage File.
Expected Result: All 143588 items to be displayed
Actual Result: Only 10000 items are displayed
Cause
Via L&G works as designed and eliminates duplicates and only imports the 10000 distinct items that are there.
Resolution
Notes
The issue is caused by duplicate rows in the file, and the number of duplicates seems to be exactly 10, which is why you will see a count of 10K.
When you add another distinct row to the file, the row count increases by 1 as expected.
The file with the 143588 has been checked and there where 133588 duplicates, so Via L&G works as designed and eliminates duplicates and only imports the 10000 items that are there.
An extra 100015 items have been added to the file (without duplicates) and it got imported correctly.
Make sure there are no duplicates when importing Coverage Files, Via Lifecycle & Governance will eliminate duplicates and only import what needs to be imported, and that can give a false impression of missing items after the import!
