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?