Number of rows removed from this list by deletion or Security constraints: ##### - Support and Troubleshooting

Number of rows removed from this list by deletion or Security constraints: ##### Issue An error message "Number of rows removed from this list by deletion or Security constraints" populates under Analytics Hub --> Indicator --> Show Records. In some scenarios, even an admin/maint user is seeing this error

Release Any release version

Cause The possible causes for this error to show under "Show Records" are:

ACL restriction The records are deleted from the table (on which the indicator/indicator source are running) after the snapshot capture for the defined period. Admin/Maint users see the error message for this reason Cause1: For ACL concern,

Please work with the customer as per their requirement on ACL

Cause2: The records are deleted from the table (where the indicator/indicator source are running) after the snapshot capture for the defined period.

Resolution Steps to troubleshoot:

1. On instance, navigate to System Definition -> Scripts - Background

2. Run PASnapshot - getIDs(String sys_id, Number date) (Refer documentation: https://www.servicenow.com/docs/bundle/yokohama-api-reference/page/app-store/dev_portal/API_reference/PASnapshot/concept/PASnapshot.html ) for the respective indicator and date

Example script:

var snapshot1 = PASnapshot.getIDs('fb007202d7130100b96d45a3ce6103b4', 20160530); gs.info(snapshot1); 3. Capture the SysIDs returned from the script output

4. Navigate to the respective table (on which the indicator/indicator source are running) in list view

5. Validate if the SysIDs captured from Step 3 are present in the table

In case of records being deleted from the table, the system detects the snapshot is larger than the list and displays the message on the count difference to inform you that there was a change to the list view count. Once the snapshot containing SysIDs expire, the error message is no longer seen.

Alternative Approach:

The SysIDs can also be captured by:

- Navigating to pa_snapshots.list on instance

- Filter on respective fields such as 'Indicator', ' Start at'

- Open the record --> Show XML

- Get the list of SysIDs