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 announces the upcoming release of RSA SecurID Access to accelerate and modernize MFA 18Number of Views RSA Governance & Lifecycle Recipes: Dormant Account Process 51Number of Views How to configure RSA Data Loss Prevention filtering on File Fingerprint Crawler using exclusions 19Number of Views RSA Governance & Lifecycle Recipes: Report - AD Group Summary 15Number of Views Configure Automatic Enablement for a Risk-Based Authentication Policy 5Number of Views
Trending Articles
Deploy an Identity Router Virtual Machine in Microsoft Azure How to Replace the Web Server Certificate for the RSA Identity Governance & Lifecycle Web Console How to download the RSA Authentication Manager Console Root Certificate in DER format How to Change the Token Lifetime Extension Window in Authentication Manager Using rsautil AFX Server and Remote Collection Agents fail to start after updating Java to version 1.8u241 (1.8.0_241) / 1.7u251 (1.7.0_…
Don't see what you're looking for?