[VCL-1111] statgraphcache table not correctly being used

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.5.1
• Component/s: web gui (frontend)
• Assignee: Unassigned
• Reporter: Josh Thompson
• Created: 31/Jan/19 15:49
• Updated: 01/Feb/19 17:13
• Resolved: 31/Jan/19 17:02

Description

There is a table in the database for caching computed values so that they don't have to be computed every time the data is needed for a graph. Values are only saved to it once they wouldn't be changed. There was a foreign key change change in a previous release that changed the provisioningid field in this table from being 0 to NULL which broke queries that select data from the table. The queries needs to be updated to account for the change.