SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
540 questions
SSMA Db2 to Sql Server Save workspace error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 7.000000000000001%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXK%3C/text%3E%3C/svg%3E)
Xavier Klausener
6
Reputation points
When saving my workspace on Sql Server Migration Assistant for DB2 the following error show on the log:
[Error: Gui] [1072400/38] [2022-08-18 11:24:40]: Inner Exception #1: The surrogate pair (0xD9E3, 0xC9D5) is invalid. A high surrogate character (0xD800 - 0xDBFF) must always be paired with a low surrogate character (0xDC00 - 0xDFFF).
How can i save my workspace without hitting this error?
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 28.999999999999996%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
PrasannaSridharan-MSFT 96 Reputation points Microsoft Employee2022-08-19T05:13:57.13+00:00 Hello @Xavier Klausener - would it be possible to share more info on following:
- which version of SSMA are you using?
- What is the OS & the language/culture on which the SSMA being used?
- Does the source database have any characters from language other than English?
If you believe this is confidential info, then you may prefer to share it via email ssmahelp.at.microsoft.com
-
Xavier Klausener 6 Reputation points
2022-08-19T07:05:45.657+00:00 Hi @PrasannaSridharan-MSFT
Here's the details:
SSMA Version: 9.0 from 6/6/2022
OS & Language/culture: Windows 10 20H2 English US
Source database can contains english, french and germanThanks
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 72%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
PETER TOWNSEND 0 Reputation points2024-09-09T19:13:05.6533333+00:00 @Xavier Klausener Were you ever able to resolve this issue? I have encountered the same problem running SSMA Version 9.5
Sign in to comment
Sign in to answer