CODEWITHSUNDEEP
wso2wso2-api-managerwso2-das
J.P.
J.P.

Reputation: 117

Error viewing API Manager Statistics using WSO2 DAS

I'm attempting to use AM 1.9.1 and Store statistics in DAS 3.0.0. I'm using a mysql database to house my WSO2AM_STATS_DB instance.

Data is being stored successfully in the database. I have records indicating that attempts were throttled out and requests were made successfully. Unfortunately, when I attempt to view any of the statistics in either the store or the publisher application, the logs show this error:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'TempTable.apiPublisher' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Can anyone provide some guidance on how to resolve this?

Upvotes: 1

Views: 184

Answers (1)

J.P.
J.P.

Reputation: 117

I was able to resolve this issue by removing the ONLY_FULL_GROUP_BY from the configuration for MySQL.

Upvotes: 1

Related Questions