Environment
Novell ZENworks Asset Management 7 - ZAM7
IR7 Situation
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('DF4DD717349B2642B71F14B07AAA9CED'),
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.
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('DF4DD717349B2642B71F14B07AAA9CED'),
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.
Resolution
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