search

keeps / dbptk-ui

DBPTK base UI for both Desktop and Enterprise
https://database-preservation.com
GNU Lesser General Public License v3.0
23 stars 9 forks source link

Cannot resolve collation conflict in SQL Server 2008 #327

Open gwpurnell opened 2 years ago

gwpurnell commented 2 years ago

Description: RESTException: Remote exception caused by GenericException: Cannot resolve the collation conflict between "Latin1_General_CIAS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.

Context:

Steps required to reproduce the bug:

  1. Connect to SQL Server 2008 R2
  2. Try to import SQL Server database

Attach any related screenshots below.

Attach any relevant logs below.

Find DBPTK Desktop logs at Help -> Logs menu. Find DBPTK Enterprise logs with docker logs command. dbvtk-2022-06-23.0.log.gz dbptk_collation_conflict

SQL Server 2008
gwpurnell commented 2 years ago

The unzipped version of the log dbvtk-2022-06-23.0.log .

hmiguim commented 1 year ago

Hi,

Searching the error message it seems that you have different collations. DBPTK doesn't cope with this kind of situation.

You could see if this is the case and normalize the collations across the database or create a custom view to archive the data and resolve the collation via query.