AM - Power BI report - Software usage - shows records with the date "1899-12-30" in the column "Last run"
This article is about product releases
ALVAO Asset Management 10.4 and higher
Symptoms
Power BI report - Software usage or Query.ExecutedSoftwareEnu view shows records with the date "1899-12-30" in column "Last run"
Cause
The cause is a bug in ALVAO products.
Solution
Fixed in release 11.1.2214 - 11.1/SP1 FIX7 (2023-12-07)
Workaround
To clear the nonsense data, run the following SQL script:
update df
set LastRun=null,
RunCount=null
from tblDetFile df
where datepart(year,df.LastRun)=1899
and datepart(month,df.LastRun)=12
and datepart(day,df.LastRun)=30
and isnull(df.RunCount,0)=0
Note: Until the AM Agent is patched, the script can be run regularly (nonsense data may reappear)
Steps to reproduce this behavior
Attachments
Issue number
T149554ALVAO