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?
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:
can you post the DDL of the table you're inserting into, as well as the insert statement?
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.