Qlik Replicate: Task from SQL Server source to Oracle target stuck after Oracle duplicate column name error

shashi_holla — Tue, 27 Jun 2023 12:42:46 GMT

A Qlik Replicate task replicating from an SQL server to an Oracle target may fail/get "stuck" with a duplicate column name error.

Resolution

Verify that no duplicate column names exist.

This can be done from the Qlik Replicate console:

Open the Task in Designer mode
Open the Global Rules
Verify that no duplicate column names exist in the Global Rules
Navigate to Table Settings
Open Transform and verify that no duplicate column names exist there either.
Address any potential duplications.

Cause

A possible root cause may be global rules set to add columns to the target table with a modified data type, but those columns were already part of the table and had to be removed from the table settings. An instance where this may occur could be code being moved from a development to a production environment. It is always recommended to test all possible scenarios before moving to production.

article Qlik Replicate: Task from SQL Server source to Oracle target stuck after Oracle duplicate column name error in Official Support Articles

Qlik Replicate: Task from SQL Server source to Oracle target stuck after Oracle duplicate column name error

Resolution

Cause

Environment