RSA Product Set: RSA Governance & Lifecycle
RSA Version/Condition: 6.9.1, 7.0.x, 7.1.x, 7.2.x, 7.5.x, 8.0

• The collector fails during the first task of data collection.
• The raw data and database logs of the run are empty.
• The aveksaServer.log shows one of the following exceptions, with ORA-12899 or ORA-01722, at the time of the failure:

06/03/2025 07:08:13.413 ERROR (Exec Task Consumer#3 - Main) [com.aveksa.server.xfw.TaskExecutor] Failed method=Execute ExecutionTask[TaskID=1178533 RunID=635740 Source=27 Type=DataPreProcessing Status=InProgress] 
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: Loading of user & group data into DB failed. User data file=635767UserData.data & group data file=635767GroupData.data
	at com.aveksa.server.xfw.DataPreProcessingExecutor.executeFullTask(DataPreProcessingExecutor.java:156) ~[server.jar:?]
	at com.aveksa.server.xfw.DataPreProcessingExecutor.executeTask(DataPreProcessingExecutor.java:65) ~[server.jar:?]
	at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:101) ~[server.jar:?]
	at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:137) ~[server.jar:?]
	at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_442]
Caused by: com.aveksa.server.collector.DataProcessorException: Loading of user & group data into DB failed. User data file=635767UserData.data & group data file=635767GroupData.data
	at com.aveksa.server.xfw.SAXUserDataPreProcessingFilter.createSTXTables(SAXUserDataPreProcessingFilter.java:189) ~[server.jar:?]
	at com.aveksa.server.xfw.SAXUserDataPreProcessingFilter.process(SAXUserDataPreProcessingFilter.java:133) ~[server.jar:?]
	at com.aveksa.server.xfw.SAXUserDataPreProcessingFilter.process(SAXUserDataPreProcessingFilter.java:382) ~[server.jar:?]
	at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:85) ~[server.jar:?]
	at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:64) ~[server.jar:?]
	at com.aveksa.server.xfw.DataPreProcessingExecutor.executeFullTask(DataPreProcessingExecutor.java:145) ~[server.jar:?]
	... 4 more
Caused by: java.sql.BatchUpdateException: ORA-12899: value too large for column "AVUSER"."STX_USR_27_635740"."TERMINATION_DATE" (actual: 65, maximum: 50)

	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:9711) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
	at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1447) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
	at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9487) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
	at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:237) ~[ojdbc8-19.3.0.0.0.jar!/:19.3.0.0.0]
	at org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1180) ~[?:?]
	at com.aveksa.server.db.FileToTable.commitBatchToDB(FileToTable.java:429) ~[server.jar:?]
	at com.aveksa.server.db.FileToTable.process(FileToTable.java:404) ~[server.jar:?]
	at com.aveksa.server.xfw.SAXUserDataPreProcessingFilter.createSTXTables(SAXUserDataPreProcessingFilter.java:181) ~[server.jar:?]
	at com.aveksa.server.xfw.SAXUserDataPreProcessingFilter.process(SAXUserDataPreProcessingFilter.java:133) ~[server.jar:?]
	at com.aveksa.server.xfw.SAXUserDataPreProcessingFilter.process(SAXUserDataPreProcessingFilter.java:382) ~[server.jar:?]
	at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:85) ~[server.jar:?]
	at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:64) ~[server.jar:?]
	at com.aveksa.server.xfw.DataPreProcessingExecutor.executeFullTask(DataPreProcessingExecutor.java:145) ~[server.jar:?]
	... 4 more

05/30/2018 14:32:31.820 ERROR (Exec Task Consumer#1) [com.aveksa.server.xfw.TaskExecutor] 
Failed method=Execute ExecutionTask[TaskID=50 RunID=28 Source=3 Type=DataObjectProcessing Status=InProgress] 
com.aveksa.server.xfw.ExecutionException: com.aveksa.server.collector.DataProcessorException: 
com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "AVUSER.IDC_NORMALIZE", line 203
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195
ORA-06512: at line 1

	at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeFullTask(DataObjectProcessingExecutor.java:121)
	at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeTask(DataObjectProcessingExecutor.java:58)
	at com.aveksa.server.xfw.TaskExecutor.execute(TaskExecutor.java:99)
	at com.aveksa.server.xfw.ExecutionTaskQueue$Worker.run(ExecutionTaskQueue.java:116)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.aveksa.server.collector.DataProcessorException: 
com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "AVUSER.IDC_NORMALIZE", line 203
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195
ORA-06512: at line 1

	at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.loadData(DefaultIdentityObjectDataFilter.java:134)
	at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.process(DefaultIdentityObjectDataFilter.java:71)
	at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.process(DefaultIdentityObjectDataFilter.java:144)
	at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:85)
	at com.aveksa.server.xfw.DataProcessor.process(DataProcessor.java:64)
	at com.aveksa.server.xfw.DataObjectProcessingExecutor.executeFullTask(DataObjectProcessingExecutor.java:116)
	... 4 more
Caused by: com.aveksa.server.db.PersistenceException: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "AVUSER.IDC_NORMALIZE", line 203
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195
ORA-06512: at line 1

	at com.aveksa.server.db.PersistenceManager.runStoredProcedure(PersistenceManager.java:267)
	at com.aveksa.server.xfw.DefaultIdentityObjectDataFilter.loadData(DefaultIdentityObjectDataFilter.java:116)
	... 11 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "AVUSER.IDC_NORMALIZE", line 203
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 105
ORA-06512: at "AVUSER.IDC_DATA_COLLECTOR", line 195
ORA-06512: at line 1

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:220)
	at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:48)
	at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:938)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1150)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798)
	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:4901)
	at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:5631)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1385)
	... 15 more

Please refer to RSA Knowledge Base Article 000067335 -- Artifacts to gather in RSA Identity Governance & Lifecycle to find the location of the log files for your specific deployment.

The collection agent first collects the data into a temporary datafile which uses the UTF-8 character xC2AA (also represented as Âª) as an internal separator in the datafile. If the collected data contains the same character, then the datafile structure becomes invalid and importing it fails with the above error.