Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm trying to load my data from my SAP system to my SQL server 2016 database. The tasks and CDC are working well but there are some non unicode characters that I am not able to store correctly in my target database.
Example of these special characters are:
Ğ
Ç
Ö
Ü
They are stored in my SQL server database with this character "?".
Those values are stored in some primary fields and give me the following error:
"Handling End of table *TABLE_NAME* loading failed by subtask 1 thread 1
Commit rows failed
RetCode: SQL_SUCCESS SqlState: 23000 NativeError: 2627 Message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint *TABLE_NAME*. Cannot insert duplicate key in object *TABLE_NAME*. The duplicate key value is (XXX, XXX, XXX, ?)."
Can anyone point me one direction to check what can be done to solve this?
Many thanks in advance.
Hi,
Did you check your SQL server collation? Are you able to manually enter the unicode characters into your tables?
Thanks,
Madhavi
Hello Madhavi,
yes I tried to change SQL server collation and I tested these characters into my tables. I used another extractor and it works. Do you know if there is a Attunity internal parameter to change the default utf-16 encoding in Attunity?
Many thanks for your reply,
Luigi
Hi Luigi,
Please open a support case. Thank you