Reports Do Not Run after Restoring DB Backup - Collation Conflict in Logs

(Difference between revisions)

Revision as of 07:32, 21 March 2011

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: `"could not obtain information from database: the syntax of SQL command contains errors. check the log file for error 5048"` The log file will report collation conflicts: `21/07/2010 15:15:54 %CHC-LOG_SUBFAC-3-UNK:TraceDBError #1:(ADO Error# -2147217900\|Description [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for equal to operation.\|Source Microsoft OLE DB Provider for ODBC Drivers\|SQLState 37000\|NativeError 446) <code>`
Possible Cause	The data backup is from a system which was on locale A and is being restored on a system with locale B.
Recommended Action	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.
Release	Release 7.x
Associated CDETS #	None.

Rating: 0.0/5 (0 votes cast)

@@ Line 1: / Line 1: @@
 {{Template:Required Metadata}}
-== Reports don't run after restoring DB backup data - collation conflict seen in logs ==
+== Reports do not run after restoring DB backup data - collation conflict seen in logs ==
 {| border="1"
@@ Line 19: / Line 19: @@
 |-
 ! '''Possible Cause'''
-| The data backup is from a system which was on Locale A and is being restored on a system with locale B.
+| The data backup is from a system which was on locale A and is being restored on a system with locale B.
 |-
 ! '''Recommended Action'''
 |
-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.
+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.
 |-
 ! '''Release'''