topic Re: Load Failing in Qlik Replicate

Load Failing

haiderpasha — Mon, 22 Sep 2025 18:52:40 GMT

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-to-different-data/ta-p/1945224), 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)

Re: Load Failing

Dana_Baldwin — Mon, 22 Sep 2025 23:26:39 GMT

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

Re: Load Failing

narendersarva — Mon, 22 Sep 2025 23:30:45 GMT

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