Hotfix for Known Issue: Data Warehouse export fails with error when locale date format differs between the database user & Windows account used for running the export: "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value" (IOJ-2169655)

Yes

Summary

This article contains details of a hotfix for the following known issue:

Known Issue: Data Warehouse export fails with error when locale date format differs between the database user & Windows account used for running the export: "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value" (IOJ-2169655)

Installations steps

To apply the hotfix, download the attached AnalyticsDataModel_DR.zip file and unzip its contents to replace the following existing file on your batch server:

C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Exporter\FNMPDataWarehouse\AnalyticsDataModel.xml

Compatible versions

This hotfix is suitable for use with FlexNet Manager Suite 2020 R2.

Hotfix for Known Issue: Data Warehouse export fails with error when locale date format differs between the database user & Windows account used for running the export: "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value" (IOJ-2169655)

Hotfix for Known Issue: Data Warehouse export fails with error when locale date format differs between the database user & Windows account used for running the export: "The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value" (IOJ-2169655)

Summary

Installations steps

Compatible versions

Data Warehouse Export

Defect Report

FlexNet Manager Suite 2020 R2