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
This issue is caused by a logic error handling date values with various regional settings that use different date formats.
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:
SET SettingValue = '1'FROM dbo.ComplianceTenantSetting cts
JOIN dbo.SettingName sn ON sn.SettingNameID = cts.SettingNameID
WHERE sn.Name = 'KPIDataExport'
This issue affects FlexNet Manager Suite 2022 R2.
This issue has been fixed in the following FlexNet Manager Suite releases: 2022 R2.1 / Jan 2023 (Cloud), 2023 R1 (On Premises)