Software Files (Files Not Identified) won't load with UK date format.

  • 3288763
  • 22-Aug-2006
  • 27-Apr-2012


Novell ZENworks Asset Management 7 - ZAM7


Software Files (Files Not Identified) won't load with UK date format.
When the colleciton server has regional setting set to UK, a lot of FNIs will
fail to load. The error in the loader log looks like this:

< EVENT AT="08/08/2006 01:55:05" SEVERITY="Warning">
Loader Warning::Loader at 08/08/2006 01:55:05 on SLGWVM1T by ZAMMAN
Load FNI Data
[2.2.24] Cannot store FNIData #68 for WS SL094650

The persister log shows this query:

INSERT INTO NC_FNIData (FNIDataOID, DomainID, FileDate, FileSize, FileName,
SubDirectory, Extension, WorkstationOID, FileScanCategory, VICompanyName,
VIProductName, VIProductVersion, VILanguage, VIFileVersion, StartupCount,
TotalRuntimeSeconds, TotalActiveSeconds, InstanceVer) VALUES
HEXTORAW('00000000000000000000000000000000'), TO_DATE('28/02/2002
12:51:00','MM/DD/YYYY HH:MI:SS AM'), 36352, 'SPL2FILE','C:\Program
Files\Personal Communications\samples\spl2file', 'exe',
HEXTORAW('0ED01C9FA644464991A01A6083134EF7'), 3, NULL, NULL, NULL, NULL, NULL,
0, 0, 0, 0)

Note that the TO_DATE will fail.


As a short-term workaround create the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Tally Systems Corp.\TSCensus\Loader
and add "LoadFNIOption" (DWORD) value = 0

No need to restart the collection server
Code change is in IR8 ZAM 7


Reported to Engineering