Load Failing

[haiderpasha]

Hello Team

We have a task that writes data to Oracle, but it’s failing with the error below. I tried the solution suggested here (https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Oracle-Character-Set-leading-...), but it didn’t resolve the issue. The column is of type STRING(16).

Direct Path error: Failed converting column 'NAPOCD' data
ORA-12899: value too large for column NAPOCD (actual: 25, maximum: 16)

[Dana_Baldwin]

Hi @haiderpasha 

What is the source endpoint type?

What is the data type & length of the source column NAPOCD?

What is the full version number of Qlik Replicate that you are using?

We may need you to open a support case and attach a diagnostics package to look into this further.

Thanks,

Dana

[narendersarva]

Hi @haiderpasha 

The link you tried usually applies when the byte length vs character length mismatches. But here, it looks like the actual data exceeds the defined size.

Try to alter table to make to Varchar2(25)

Thanks
Naren