AnsweredAssumed Answered

MySQL collectors are not working after updating the driver

Question asked by Yogesh Mishra on Jul 21, 2016
Latest reply on Jul 28, 2016 by Boris Lekumovich

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

Outcomes