jamasoftware-ps / community-reports Goto Github PK

When running Usage Over Time with Percona 5.7, on Jama 8.31.3 we get the following errors

The following items have errors:

Table (id = 1379):

• Cannot get the result set metadata.
  org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
  SQL error #1:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'total.licenseType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  ;
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'total.licenseType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  Data (id = 1382):
• Invalid bound column name: Aggregation.
  Table (id = 1388):
• Cannot get the result set metadata.
  org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
  SQL error #1:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'total.licenseType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  ;
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'total.licenseType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  Data (id = 1391):
• Invalid bound column name: Aggregation.
  ReportDesign (id = 1):
• An exception occurred during processing. Please see the following message for details:
  exception.error
  Error happens when create hierarchy:Created Date.NewTabularHierarchy.
  Cannot get the result set metadata.
  org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
  SQL error #1:Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jama_prod.p.createdDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  ;
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jama_prod.p.createdDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  Cannot get the result set metadata.
  org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
  SQL error #1:Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jama_prod.p.createdDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  ;
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'jama_prod.p.createdDate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
• An exception occurred during processing. Please see the following message for details:
  exception.error
  Error happens when create hierarchy:Login Type.NewTabularHierarchy2.
  Cannot get the result set metadata.
  org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
  SQL error #1:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'total.licenseType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  ;
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'total.licenseType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  Cannot get the result set metadata.
  org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.
  SQL error #1:Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'total.licenseType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  ;
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'total.licenseType' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by