CSV-based Database Collections fail with 'java.lang.ClassCastException' in RSA Identity Governance & Lifecycle
Originally Published: 2020-07-08
Last Modified: 2022-06-20
Article Number
000044897
Applies To
RSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.1.1 P06+, 7.2.0 P01+
 
Issue
RSA Identity Governance & Lifecycle Database Collections defined as DB Type CSV fail. The following message is displayed in the user interface when testing the collector (Collectors > {Collector type} > {Collector Name} > Test button).

This statement type might not be supported, or it has syntax errors:
java.sql.SQLException: java.lang.ClassCastException

The following exception and collection failures are reported in the aveksaserver.log file ($AVEKSA_HOME/wildfly/standalone/log/aveksaServer.log.) Note the collection failure errors may differ depending on the collector type but the exception is the same:

Example from an IDC

07/06/2020 17:54:06.069 ERROR (ApplyChangesRegularThread-35933) [com.aveksa.client.datacollector.framework.DataCollectorManager] DCM281: Collection Failed: CollectionFailedEvent[cmi = CollectionMetaInfo[{ID=6, run_id=99999, collector_id=1, test-run=true, collector_name=WorkDay IDC, data_size=0, data_file=/home/oracle/wildfly-10.1.0.Final/standalone/tmp/vfs/deployment/deployment/aveksa.war-/WEB-INF/LocalAgent/collected_data/1.data}] message = null cause = com.aveksa.common.DataReadException: Could not create user data iterator!] com.aveksa.common.DataReadException: Could not create user data iterator!
     at com.aveksa.collector.userdata.DBUserIterator.<init>(DBUserIterator.java:105)
     at com.aveksa.collector.userdata.DBGenericReader.constructUserIterator(DBGenericReader.java:400)
     at com.aveksa.collector.userdata.DBGenericReader.getUserIteratorForTestData(DBGenericReader.java:423)
     at com.aveksa.client.datacollector.collectors.identitydatacollectors.IdentityDataCollector.writeData(IdentityDataCollector.java:368)
     at com.aveksa.client.datacollector.collectors.identitydatacollectors.IdentityDataCollector.collectData(IdentityDataCollector.java:346)
     at com.aveksa.client.datacollector.collectors.identitydatacollectors.IdentityDataCollector.collect(IdentityDataCollector.java:307)
     at com.aveksa.client.datacollector.collectors.identitydatacollectors.IdentityDataCollector.collectTestData(IdentityDataCollector.java:272)
     at com.aveksa.client.datacollector.framework.DataCollectorManager.collect(DataCollectorManager.java:481)
     at com.aveksa.client.component.collector.DefaultCollectorManager.actUpon(DefaultCollectorManager.java:204)
     at com.aveksa.client.component.collector.DefaultCollectorManager.handle(DefaultCollectorManager.java:102)
     at com.aveksa.client.component.event.DefaultEventManager.handle(DefaultEventManager.java:75)
     at com.aveksa.client.datacollector.framework.SimpleEventSource.notifyListeners(SimpleEventSource.java:67)
     at com.aveksa.client.component.communication.DefaultCommunicationManager.notifyEvent(DefaultCommunicationManager.java:377)
     at com.aveksa.client.component.communication.ChangeListHandler.applyChanges(ChangeListHandler.java:364)
     at com.aveksa.client.component.communication.ChangeListHandler.access$300(ChangeListHandler.java:58)
     at com.aveksa.client.component.communication.ChangeListHandler$ChangeApplyingRunnable.run(ChangeListHandler.java:275)
     at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: java.lang.ClassCastException

Example from an EDC:

06/30/2020 03:12:13.124 ERROR (ApplyChangesRegularThread-50982) [com.aveksa.client.datacollector.framework.DataCollectorManager] DCM281: Collection Failed: CollectionFailedEvent[cmi = CollectionMetaInfo[{ID=1942, run_id=248365, collector_id=2103, test-run=false, collector_name=Common_Membership_TableHandlers_HI_EDC, data_size=300, data_file=/home/oracle/wildfly-10.1.0.Final/standalone/tmp/vfs/deployment/deploymente68815b883f9b250/aveksa.war-8f59ee898d663ee5/WEB-INF/LocalAgent/collected_data/1942.data}] message = null cause = com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: ERROR: Could not get account bound entitlement data: ] com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: ERROR: Could not get account bound entitlement data:
     at com.aveksa.collector.entitlementdata.DBGenericEntitlementReader.collectEntitlements(DBGenericEntitlementReader.java:235)
     at com.aveksa.collector.entitlementdata.DBGenericEntitlementReader.collect(DBGenericEntitlementReader.java:137)
     at com.aveksa.client.datacollector.collectors.entitlementdatacollectors.EntitlementDataCollector.collectData(EntitlementDataCollector.java:328)
     at com.aveksa.client.datacollector.collectors.entitlementdatacollectors.EntitlementDataCollector.collect(EntitlementDataCollector.java:295)
     at com.aveksa.client.datacollector.collectors.entitlementdatacollectors.EntitlementDataCollector.collect(EntitlementDataCollector.java:262)
     at com.aveksa.client.datacollector.framework.DataCollectorManager.collect(DataCollectorManager.java:483)
     at com.aveksa.client.component.collector.DefaultCollectorManager.actUpon(DefaultCollectorManager.java:204)
     at com.aveksa.client.component.collector.DefaultCollectorManager.handle(DefaultCollectorManager.java:102)
     at com.aveksa.client.component.event.DefaultEventManager.handle(DefaultEventManager.java:60)
     at com.aveksa.client.datacollector.framework.SimpleEventSource.notifyListeners(SimpleEventSource.java:67)
     at com.aveksa.client.component.communication.DefaultCommunicationManager.notifyEvent(DefaultCommunicationManager.java:377)
     at com.aveksa.client.component.communication.ChangeListHandler.applyChanges(ChangeListHandler.java:364)
     at com.aveksa.client.component.communication.ChangeListHandler.access$300(ChangeListHandler.java:58)
     at com.aveksa.client.component.communication.ChangeListHandler$ChangeApplyingRunnable.run(ChangeListHandler.java:275)
     at java.lang.Thread.run(Thread.java:748) Caused by: com.aveksa.common.DataReadException: ERROR: Could not get account bound entitlement data:
     at com.aveksa.collector.entitlementdata.DBGenericEntitlementReader.extractUserEntitlements(DBGenericEntitlementReader.java:840)
     at com.aveksa.collector.entitlementdata.DBGenericEntitlementReader.extractUserEntitlements(DBGenericEntitlementReader.java:668)
     at com.aveksa.collector.entitlementdata.DBGenericEntitlementReader.collectEntitlements(DBGenericEntitlementReader.java:219) ... 14 more
Caused by: java.sql.SQLException: java.lang.ClassCastException


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
This is a known issue reported in engineering ticket ACM-106467 and introduced in the following versions of RSA Identity Governance & Lifecycle:
  • RSA Identity Governance & Lifecycle 7.1.1 P06
  • RSA Identity Governance & Lifecycle 7.2.0 P01
This issue occurs with the HXTT Text JDBC Driver: Implementation-Version: 7.0.067 on January 31, 2020 and later. To determine if you are having this issue, see RSA Knowledge Base Article 000039102 -- How to identify the deployed version of the HXTT Text JDBC Driver in RSA Identity Governance & Lifecycle to find the version of the HXTT Text JDBC Driver in your environment.
 
Resolution
This issue is being investigated by the Engineering team in order to provide a permanent resolution in a future release.
 
Workaround
Please contact RSA Identity Governance & Lifecycle Customer Support for a workaround and mention this RSA Knowledge Base Article ID 000039104 for reference.
 

Related Articles

Trending Articles

Don't see what you're looking for?