Unknown Error Just Started Today on Daily/weekly scheduled reports

[Singh1]

This error is being thrown with schedules. It only began today and no changes have been made to the schedule or report recently. When opening the report through looker it works fine no tiles are broken but not able to schedule it.

Error occurred while generating this dashboard - contact administrator (error: Render job 550c1f35b2c1c49978da43c5ce8f165b[136293] failed [query failed: Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum.])

[Singh1]

Solved. It was to do with the LookML. A sum was done in the SQL of a measure with type number i.e.

measure: My_Measure {
type:number
sql: SUM(...) 

}
Instead of setting the type on the measure to sum i.e.

measure: My_Measure{
type: sum
sql: ...
}
Don’t understand why it suddenly broke though