CSV Collector StackOverflowError at com.hxtt.sql.d2.a in RSA Identity Governance and Lifecycle 6.9.1

[#1]

Article Number

000034044

Applies To

RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9.1
 

Issue

Testing a new collector using CSV as a SQL database is getting the following error in the aveksaServer.log and in a popup screen:

09/16/2016 11:26:47.187 ERROR (ApplyChangesRegularThread-20533) [com.aveksa.client.datacollector.framework.DataCollectorManager] DCM281: 
Collection Failed: CollectionFailedEvent[cmi = CollectionMetaInfo[{ID=474, run_id=1474043207160, collector_id=801, test-run=true, 
collector_name=Accounts Payable Approvers EDC, 
data_file=/home/oracle/jboss-4.2.2.GA/server/default/./deploy/aveksa.ear/aveksa.war/WEB-INF/LocalAgent/collected_data/474.data}] 
message = null cause = java.lang.StackOverflowError]
java.lang.StackOverflowError
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source)
	at com.hxtt.sql.d2.a(Unknown Source) 
...

 

Cause

This issue happens when the columns in the CSV input file are not matching what was defined in the SQL SELECT statement.

Resolution

Verify the the input file specified by the table name of the SQL SELECT statement has the columns defined in the first row of the input CSV file. Ensure you have the correct file with the correct columns defined.