Teradata TPT Error :: TPT10508: RDBMS error 3812: The positional assignment list has too few values.

Tools
Enthusiast

Teradata TPT Error :: TPT10508: RDBMS error 3812: The positional assignment list has too few values.

Hi,

When i ran the TPT script i got below error.

LOAD_OPERATOR: connecting sessions

EXPORT_OPERATOR: connecting sessions

LOAD_OPERATOR: preparing target table

LOAD_OPERATOR: entering Acquisition Phase

LOAD_OPERATOR: TPT10508: RDBMS error 3812: The positional assignment list has too few values.

Am using Source as Teradata View

Target : Teradata table.

( show sel * from  table tablename-- 179 rows( view)

  Help table tablename -- 178 rows(table))

when i ran the above queries on source tables i got like this.

Thanks

Anil

1 REPLY
Enthusiast

Re: Teradata TPT Error :: TPT10508: RDBMS error 3812: The positional assignment list has too few values.

The view might be having an additional column which is not existing in the table. might be a calculated value. Please select specific columns from the view.