The status of Generating new Reports are not consistent.
Generating one report displays as "Running" and then "Completed".
Generating another report, immediately after the one that Completed, remains in a status of "Not Generated", when it has in fact generated.
It is shown in the UNI_EVT_REPORTS table and the report was emailed.
Release: 6.x
Component: Reporter Server
Database: MS SQL Server
description EN:
Milliseconds were not compared correctly in SQL request using hibernate while generating Reports.
Update to a fix version listed below or a newer version if available.
Fix version(s):
Component: Reporter.Server
Dollar Universe 6.10.51 - Released 28th October 2020
Workaround:
You can see old reports by updating the database with this request :
update [REPORTER_DATABASE_NAME].[dbo].[UNI_EVT_REPORTS] set START_TIMESTAMP = CAST(FORMAT(START_TIMESTAMP,'yyyy-MM-dd HH:mm:ss') AS datetime)
WHERE
START_TIMESTAMP in ( SELECT max([START_TIMESTAMP])
FROM [REPORTER_DATABASE_NAME].[dbo].[UNI_EVT_REPORTS]
group by [REPORT_DEFINITION_NAME],[STATUS] )