SQL*Loader - 404: Column present more than once in data_set INTO TABLE block

Technical Note 1.0.11142865.3489002
Created 03-Dec-2001

Applies To
DATABridge Client 4.0

non-DMS columns


Oracle

Symptoms

SQL*Loader - 404: Column present more than once in data_set INTO TABLE block

Error Loading table 'data_set' using sql*loader

Failure Occurs During Clone

Failure during bulk load

Cause

This error occurs where a script was written before DATABridge Client version 4.0 to insert a non-DMS column into the relational database. DATABridge Client 4.0 DATAITEMS Client Control table has 5 additional columns that did not exist in previous versions.

Fix

Update the script file to include the 5 additional columns and set their values to 0, unless specific values are known. Here are the names and order of the 5 columns, which should be included after dms_subtype, the previous last column:

sql_scale, dms_depends_num, da_options, changes, dms_link_ds_num