Project

General

Profile

Actions
Copy link

Bug #4089

closed

A query about execution date of reports still use old parameters

Added by Vincent MEMBRÉ about 11 years ago. Updated about 11 years ago.

Status:
Released
Priority:
1 (highest)
Assignee:
Nicolas CHARLES
Category:
Web - Compliance & node report
Target version:
2.8.0~rc1
Pull Request:
https://github.com/Normation/rudder/p...
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:

Description

When the function to get execution date of nodes from the database is called there is an error launched:

bad SQL grammar [select distinct date from reportsexecution where nodeId = ? and date
 >= ? and executiontimestamp < ? order by executiontimestamp ]; nested exception is org.postgresql.util.PSQLExceptio
n: ERREUR: la colonne ? executiontimestamp ? n'existe pas

the column executiontimestamp does not exists in the new reportsExecution table (#3945]

change executionTimestamp to date repair the query

Actions
Copy link

Also available in: Atom PDF