Summary

The “Snapshot Optimization_Snapshot_FACT data” step of data warehouse export processes may fail with output in the export log file similar to:

2022-12-30 14:40:14,078 [INFO ]       Snapshot Optimization_Snapshot_FACT data
2022-12-30 14:40:14,078 [INFO ]         Failed to execute Exporter 'Snapshot Optimization_Snapshot_FACT data' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Exporter\fnmpdatawarehouse\MetricDataExport.xml, at step line 6
Error: Conversion failed when converting date and/or time from character string.
LatestSnapshotDate : 30/12/2022 0:00:00

Cause

This issue is caused by a logic error handling date values with various regional settings that use different date formats.

Mitigation

Hotfix 2 for FlexNet Manager Suite 2022 R2 has been published containing a fix for this issue.

An earlier mitigation published for this issue involved setting an internal configuration setting “KPIDataExport” to the value “0”. If this mitigation was applied, the setting should be reverted to its default value of “1” after applying Hotfix 2 by executing the following SQL statement against the data warehouse database:

UPDATE cts
SET SettingValue = '1'
FROM dbo.ComplianceTenantSetting cts
    JOIN dbo.SettingName sn ON sn.SettingNameID = cts.SettingNameID
WHERE sn.Name = 'KPIDataExport'

Affected versions

This issue affects FlexNet Manager Suite 2022 R2.