Could you cut the code down to the smallest that fails then run with DBI_TRACE env var set to 15 like this:

DBI_TRACE=15=x.log
export DBI_TRACE
run code
show us the last few hundred lines of x.log
[download]

<- fetchrow_array= ( '48044' 'URL_TEXT_1' undef '' undef undef 'A' '1226480' ) 8 items row1 at DB.pm line 962
<- STORE('private_dbdriver', 'DB2')= 1 at DB.pm line 964
<> FETCH('private_dbdriver')= 'DB2' ('private_dbdriver' from cache) at DB.pm line 965
<> FETCH('private_dbdriver')= 'DB2' ('private_dbdriver' from cache) at nl_asset_insert_test_err.pl line 94
<- FETCH('Database')= DME::DB::db=HASH(0x80861508) at DB.pm line 1011
<> FETCH('private_dbcharset')= 'UTF8' ('private_dbcharset' from cache) at DB.pm line 1015
<- execute(13453, "URL_TEXT_1", ...)= 1 at DB.pm line 1020
<> FETCH('private_dbdriver')= 'DB2' ('private_dbdriver' from cache) at nl_asset_insert_test_err.pl line 96
<- FETCH('Database')= DME::DB::db=HASH(0x80861508) at DB.pm line 957
<- STORE('private_dbdriver', 'DB2')= 1 at DB.pm line 964
<> FETCH('private_dbdriver')= 'DB2' ('private_dbdriver' from cache) at DB.pm line 965
<> FETCH('private_dbdriver')= 'DB2' ('private_dbdriver' from cache) at nl_asset_insert_test_err.pl line 94
<- FETCH('Database')= DME::DB::db=HASH(0x80861508) at DB.pm line 1011
<> FETCH('private_dbcharset')= 'UTF8' ('private_dbcharset' from cache) at DB.pm line 1015
<- execute(13453, "URL_LINK_1", ...)= 1 at DB.pm line 1020
<> FETCH('private_dbdriver')= 'DB2' ('private_dbdriver' from cache) at nl_asset_insert_test_err.pl line 96
<- FETCH('Database')= DME::DB::db=HASH(0x80861508) at DB.pm line 957 ----> $sth->SUPER::fetchrow_array();
<- HandleSetErr= 0 (err='', errstr='', state='00000', undef)
info: '' '' (err#0)
as you can see, it only loops up to 2 rows then raised an error after.

I would have preferred to see a bit more than this. I cannot help any further based on that log. Not enough context.