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.

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2022 R2.1 / Jan 2023 (Cloud), 2023 R1 (On Premises)

Other information

Affected components: Inventory import (read/write/export), Software license management

Master issue ID: IOK-1005577

Also known as: FNML-77334