Skip Navigation LinksALVAO 11.0Known Issues Skip Navigation Links.


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

 

Did not find what you were looking for? Ask our technical support team.