
jjgarcia_sia asked a question.
Good morning/afternoon for everyone.
We are facing errors on the processes of datawarehouse that are being executed nightly.
The actual error appears to be this one:
Failed to execute Exporter 'SnapshotLocationData' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Exporter\fnmpdatawarehouse\BusinessIntelligenceData.xml, at step line 1
Error: The locale id '1033' of the source column 'Level1Name' and the locale id '3082' of the destination column 'Level1Name' do not match.
Maybe there is something duplicated? Any help much appreciated.
Thanks in advance.
Can you run the following SQL Query and verify that all of the databases have the same collation, including the TEMPDB?
select name, collation_name from sys.databases
Please look at the following KB Article that I found related to your issue:
https://community.flexera.com/s/FNMS-Internal-Knowledge-Base/Data-warehouse-export-fails1373