Add strictures to the start of your code: use strict; use warnings;. That may not help your immediate problem (unless one of the variables you are concatenating together are undefined), but it will save you mega time in the future.

Turn on your debugging (look for a commented out $debug1 = 1; and uncomment it or add my $debug1 = 1; just after the strictures) so you can see the contents of $FinalInsertSQL. If you can't see the error in the SQL, update your node to include that vital piece of information.

BTW, there are two errors there - one reported by DBD and one reported by Perl so the answer to your actual question is: "Both!"