AM - ImportAD - Objects - Properties - imported empty "date" value is displayed as "01. 01. 1900"
This article is about product releases
ALVAO Asset Management 10.0 and higher
Symptoms
After importing data from AD, some of the "date" properties show value "01. 01. 1900". This value is visible in:
AM Console:
- Child objects tab
- Software tab (bottom table)
- Licences and Instalation overview window (bottom tab)
Query views (i.e. Query.ObjectEnu)
Cause
The cause is a bug in ALVAO products.
Solution
Fixed in release 11.0.2043 - 11.0/SP1 (2022-09-15)
Workaround
After importing data from AD using ImportAD utility, you can run following SQL script:
update p
set p.txtValue=null
from tblProperty p
join tblKind k on k.intKindId=p.lintKindId and k.KindDataTypeId=2
where p.txtValue=''
Steps to reproduce this behavior
Attachments
Issue number
T128364ALVAO