Office365 Collector fails to process 'Is Disabled' and 'Is Locked' flags and Admin Error 'ORA-01722: invalid number' in RSA Identity Governance & Lifecycle
Originally Published: 2020-07-28
Last Modified: 2023-10-06
Article Number
Applies To
RSA Version/Condition: 7.x
Issue
The following Admin Error is reported in the user interface:
ORA-01722: invalid number
The same error is logged to the aveksaServer.log file ($AVEKSA_HOME/wildfly/standalone/log/aveksaServer.log) :
com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException:
ORA-01722: invalid number
ORA-06512: at "AVUSER.ADC_NORMALIZE", line 148
ORA-06512: at "AVUSER.ADC_NORMALIZE", line 1451
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 218
ORA-06512: at "AVUSER.ADC_DATA_COLLECTOR", line 481
ORA-06512: at line 1
Please refer to RSA Knowledge Base Article 000030327 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the aveksaServer.log file for your specific deployment, if you are on a WildFly cluster or a non-WildFly platform. The aveksaServer.log may also be downloaded from the RSA Identity Governance & Lifecycle user interface (Admin > System > Server Nodes tab > under Logs.)
Cause
Resolution
Related Articles
JVM crash during verification process of upgrade 23Number of Views AFX Requests fails to process as the Usage Store Manager is full in RSA Governance & Lifecycle 196Number of Views How to resolve ORA-22285 error thrown in the Data Archiving process of RSA Identity Governance & Lifecycle 29Number of Views Microsoft Office365 Account Data Collector (ADC) takes a long time to complete in RSA Identity Governance & Lifecycle 122Number of Views EnVision 4 sp1 patch 6: "NIC" webserver is hung in starting state 39Number 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?