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

Document created by RSA Customer Support Employee on Sep 21, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034044
Applies ToRSA Product Set: Identity Management and Governance
RSA Product/Service Type: Enterprise Software
RSA Version/Condition: 6.9.1
 
IssueTesting 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)
...

 
CauseThis issue happens when the columns in the CSV input file are not matching what was defined in the SQL SELECT statement.
ResolutionVerify 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. 

Attachments

    Outcomes