topic Re: Warning messages when CDC from Oracle to MS-SQL in Qlik Replicate

Warning messages when CDC from Oracle to MS-SQL

jinsam — Tue, 18 Apr 2023 06:08:10 GMT

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.

Re: Warning messages when CDC from Oracle to MS-SQL

Dana_Baldwin — Tue, 18 Apr 2023 17:49:07 GMT

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

Re: Warning messages when CDC from Oracle to MS-SQL

Heinvandenheuvel — Tue, 18 Apr 2023 21:11:45 GMT

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

Re: Warning messages when CDC from Oracle to MS-SQL

jinsam — Wed, 19 Apr 2023 01:08:03 GMT

Hi, Dana

thanks for the response.

Jinsam

Re: Warning messages when CDC from Oracle to MS-SQL

jinsam — Wed, 19 Apr 2023 01:09:38 GMT

Hi, Hein

I will test about your suggestion

thanks for your response.

Jinsam