Report status shows as Not Generated even though they Completed

Products

• CA Automic Dollar Universe

Issue/Introduction

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.

Environment

Release: 6.x

Component: Reporter Server

Database: MS SQL Server

Cause

 description EN:

Milliseconds were not compared correctly in SQL request using hibernate while generating Reports.

Resolution

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

 

Additional Information

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] )