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"

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"

Symptoms

When the date format for the locale of the user running the data warehouse export process is different to the date format for the locale for the data warehouse database, the data warehouse export process may fail.

Logging from the export processes shows output like the following when this occurs:

2020-12-14 13:32:07,207 [INFO ]       Delete Obsolete Snapshot_DIM data
2020-12-14 13:32:07,270 [INFO ]         Failed to execute Exporter 'Delete Obsolete Snapshot_DIM data' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Exporter\fnmpdatawarehouse\AnalyticsDataModel.xml, at step line 9
Error: The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
2020-12-14 13:32:07,270 [INFO ]         All retries have been attempted for Exporter 'Delete Obsolete Snapshot_DIM data'

Reproduction steps

  1. Set the default language of the database user to have a different date format compared to the date format of the user running ComplianceReader.exe. For example, invoke ComplianceReader.exe as a user with the default language US English (mm/dd/yyyy), and the database login using a default language of British English (dd/mm/yyyy).
  2. Run the data warehouse export batch job.

Solution

Download the attached file and unzip it to replace the following existing file:

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

Was this article helpful? Yes No
100% helpful (2/2)
Version history
Revision #:
4 of 4
Last update:
‎Aug 08, 2021 10:32 PM
Updated by:
 
Contributors