dbptk-ui icon indicating copy to clipboard operation
dbptk-ui copied to clipboard

Published 20 hours ago • verified publisher icon keeps

Cannot resolve collation conflict in SQL Server 2008

Open gwpurnell opened this issue 2 years ago • 2 comments

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:

  • DBPTK Desktop: Operative System name and version
  • Windows version 2.5.10
  • DBPTK Enterprise: Browser name and version (Internet explorer, Chrome, Firefox, etc)

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 avatar Aug 04 '22 11:08 gwpurnell

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

gwpurnell avatar Aug 05 '22 08:08 gwpurnell

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.

hmiguim avatar Oct 06 '22 10:10 hmiguim