ORA-01403 no data found error in Account Data Collectors (ADC) in Step 10/11 in RSA Governance & Lifecycle
Last Modified: 2024-01-16
Article Number
Applies To
This is a known issue in the following version.
- SecurID Governance & Lifecycle 7.5.2
- RSA Governance & Lifecycle 8.0.0
Issue
Account Data Collectors (ADC) may fail in Step 10/11 Post-Processing: Tag Affected User Relationships.
The aveksaserver.log file will generate the following ERROR level log message
11/29/2023 20:32:30.278 INFO (Exec Task Consumer#1 - Main) [com.aveksa.server.db.persistence.PersistenceServiceProvider] executeCallableStatement giving up after hitting SQLException: ORA-01403: no data found ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 66 ORA-06512: at "AVUSER.UNFC_USERS", line 1970 ORA-06512: at "AVUSER.UNFC_USERS", line 1970 ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 304 ORA-06512: at "AVUSER.UNFC_PROCESSOR", line 41 ORA-06512: at line 1
Cause
Resolution
This is resolved in the following versions which makes a change to Data Purging to preserve at least one data run for every ADC regardless of the time of the last collection.
- SecurID Governance & Lifecycle 7.5.2 P09
- RSA Governance & Lifecycle 8.1.0
Workaround
- Navigate to the Participating Collectors tab under the Collectors Unification menu and select "Run Unification".
- For each of the ADC's run a new ADC collection.
Related Articles
RSA Governance & Lifecycle Recipes: Report - AD Group Summary 15Number of Views RSA Governance & Lifecycle Recipes: Telemetry Chart - Daily Rule Processing Summary 12Number of Views KB-1664 Analyzing Oracle AWR Reports to troubleshoot Performance Issues for RSA Via L&G appliances 187Number of Views Service Brief Quick Start Implementation for RSA Governance & Lifecycle 27Number of Views RSA Governance & Lifecycle Recipes: Chart - AD Admin Groups 22Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?