Hi All,
We recently updated our mysql driver to "mysql-connector-java-5.1.39-bin.jar" after which we are getting below error while testing our mysql collectors. we reverted the mysql driver to old version but still facing the same issue.
Collector test failed:
com.aveksa.server.runtime.ServerException: Test request failed with response: com.aveksa.server.runtime.ServerException: com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by com.aveksa.common.DataReadException: ERROR: Could not get accounts data: . Caused by com.aveksa.common.UnsupportedAttributeException: The Account ID column "accountid" is not supported by accounts data query "select distinct usr_id_no as accountid from xyz.file. Caused by com.aveksa.common.UnsupportedAttributeException: Unsupported attribute: "accountid". TO FIX: Please use from the valid supported attributes: [usr_id_no] Caused By Stack com.aveksa.sdk.collector.CollectionException: com.aveksa.common.DataReadException: ERROR: Could not get accounts data: at com.aveksa.collector.accountdata.DBGenericAccountReader.collectAccounts(DBGenericAccountReader.java:213) at com.aveksa.collector.accountdata.DBGenericAccountReader.collectTestData(DBGenericAccountReader.java:141) at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collectData(AccountDataCollector.java:358) at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collect(AccountDataCollector.java:302) at com.aveksa.client.datacollector.collectors.accountdatacollectors.AccountDataCollector.collectTestData(AccountDataCollector.java:277) at com.aveksa.client.datacollector.framework.DataCollectorManager.collect(DataCollectorManager.java:533) at
Hi Boris,
Sorry for the delayed response. Issue was occurring due to driver version, as our aveksa environments are 6.9 and 6.9.1. We changed the driver and it worked.
Thanks
Yogesh Mishra