Reports Do Not Run after Restoring DB Backup - Collation Conflict in Logs
Reports do not run after restoring DB backup data - collation conflict seen in logs
|Problem Summary||Once data has been restored from a backup onto a new system, cannot generate historical reports.|
|Error Message|| Look for the following error messages:
|Possible Cause||The data backup is from a system which was on locale A and is being restored on a system with locale B.|
Ensure that the new system on which the DB backup is being restored has the same locale as the source system. Ex. If the backup is from a system with UK locale, then it must get restored onto another system which also has UK locale. If the destination system has US locale, then this causes problems when trying to generate reports.
|Associated CDETS #||None.|