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.) |