First-time contributor to StackOverflow.

If it is only the PK in position 1 which prevents the automatic mapping, then either move the PK to the last column, or drop it prior to the INSERT INTO, but then add it again after the insert was successful.