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
- 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).
- Run the data warehouse export batch job.
Resolution
A hotfix to resolve this issue is available from the following article: 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)
Fix status
This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R2.1 / Feb 2021 (Cloud), 2021 R1 (On Premises)
Other information
Affected components: Database, Inventory import (read/write/export)
Master issue ID: IOJ-2169655
Also known as: FNML-73830
Related Articles
Hotfix for Known Issue: Data Warehouse export fails with error when locale date format differs 6Number of Views Known Issue: Data warehouse export step "Snapshot Optimization_Snapshot_FACT data" may fail with error: "Conversion failed… 14Number of Views Data warehouse export step "Snapshot Optimization_Snapshot_FACT data" may fail with error: "Conversion failed when convert… 8Number of Views Data warehouse export process may fail at step "Create Temp Table" with error: "Must declare the scalar variable "@ExportK… 4Number of Views Data Warehouse Export Task Fails When Executing Exporter 'SnapshotConsumptionData' 6Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago