Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
jinsam
Partner - Contributor
Partner - Contributor

Warning messages when CDC from Oracle to MS-SQL

Hello,

I am using Log Stream to CDC from Oracle to MS-SQL on qlik replicate.

I have several questions, while i am testing.

1. When i run the task, i got warning message about 

"The Truncation might be incorrect due to unexpected codepage 949 for column 'attrep_apply_exceptions.ERROR', 'attrep_apply_exceptions.TABLE_NAME', 'attrep_apply_exceptions.STATEMENT', 'attrep_apply_exceptions.TABLE_OWNER', 'attrep_apply_exceptions.TASK_NAME'".

Could you give a solution to solve the warning message?

 

2. How can i store [Decimal] data type to mssql database?

i looked qlik documentation, but i couldn't find the data type that support [Decimal] data type.

 

thank you.

 

1 Solution

Accepted Solutions
Dana_Baldwin
Support
Support

Hi @jinsam 

This may require modifying the provider syntax file for SQL Server. I suggest to open a support case to go through the steps.

Thanks,

Dana

View solution in original post

4 Replies
Dana_Baldwin
Support
Support

Hi @jinsam 

This may require modifying the provider syntax file for SQL Server. I suggest to open a support case to go through the steps.

Thanks,

Dana

Heinvandenheuvel
Specialist III
Specialist III

1) That's such an odd message. It doesn't say columnS, yet provides a whole list of columns. One wonders whether this is a single column name or multiple.

Was there perhaps an existing 'attrep_apply_exceptions' on the target db/schema? Can you delete or rename that and try again? Can you try without having 'attrep_apply_exceptions' activated?

To help you it would be best to share (critical parts) of the exported task  json. (feel free to generously trim table lists and transformations).

Anyway, I suspect the warning is just that, a warning which you evaluate once and then ignore going forward as this is not business data as such, just error handling background information.

2) Why do you need 'decimal' data?

According to Microsoft "Decimal and numeric are synonyms and can be used interchangeably."  msSQL decimal-and-numeric  . For other SQL's there may be a difference in  precision handling according to other decimal vs numeric . The Replicate Userguide shows decimal(p,s) source columns to be mapped on numeric(p,s) on target and why not?!

If need be, can you try pre-creating the target table with decimal(p,s) column(s) and use 'truncate' or 'do nothing' in the full-load settings? Does that work for you?

hope this helps,

Hein

 

jinsam
Partner - Contributor
Partner - Contributor
Author

Hi, Dana

thanks for the response.

Jinsam

 

jinsam
Partner - Contributor
Partner - Contributor
Author

Hi, Hein

I will test about your suggestion

thanks for your response.

Jinsam