ERROR [21S01] The positional assignment list has too many values

Database
Visitor

ERROR [21S01] The positional assignment list has too many values

Hi, 

I keep receiving 'ERROR [21S01] The positional assignment list has too many values'. I have checked the indexes (?,?) and they have the correct variables in match with the columns however this message keeps appearing. 

 

Anyone aware of this error code? 

 

Thanks

3 REPLIES
Enthusiast

Re: ERROR [21S01] The positional assignment list has too many values

It should be a mismatch in number of columns in your insert statement. You might be trying to insert more columns than your target can actually have.

 

For reference on this error:

http://community.teradata.com/t5/Database/RDBMS-error-3813-The-positional-assignment-list-has-too-ma...

http://community.teradata.com/t5/UDA/The-positional-assignment-list-has-too-many-values/td-p/7284

SR
Teradata Employee

Re: ERROR [21S01] The positional assignment list has too many values

can you post the DDL of the table you're inserting into, as well as the insert statement?

Re: ERROR [21S01] The positional assignment list has too many values

Hello all,
Probably is too late for Lingeswd but I hope that I can be useful to the people that have the sane problem.
So I get the same error message but I didn't had any SQL statements. So at first I had "The positional parameter list has too few values." the I checked if all of my target tables ports are properly connected.
The I ran the session again and it failed with error message "The positional parameter list has too many values.".
I spend alot of time to search for it and at the end I found out that I had to drop all of my INFA_tables(LT,ET1,ET2) for this session and it succeeded.

I hope I was useful.