| 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.)
|
on Jul 10, 2020