You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 reduce service calls - prevent sync status checks on self #1:Expression Create CoverageReport #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 Create CoverageReport #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 reduce service calls - prevent sync status checks on self #1:Expression Create CoverageReport #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 Create CoverageReport #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 reduce service calls - prevent sync status checks on self #1:Expression Add note clarifying limitations #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 Add note clarifying limitations #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 reduce service calls - prevent sync status checks on self #1:Expression Add note clarifying limitations #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 Add note clarifying limitations #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 reduce service calls - prevent sync status checks on self #1:Expression Create CoverageReport #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 Create CoverageReport #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 reduce service calls - prevent sync status checks on self #1:Expression Create CoverageReport #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 Create CoverageReport #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
The text was updated successfully, but these errors were encountered:
When running Usage Over Time with Percona 5.7, on Jama 8.31.3 we get the following errors
The text was updated successfully, but these errors were encountered: