I am sure this problem begins with datatype , any constraints missing between Pub. DB to sub. DB tables , please recreate the table from Pub DB and ran it on Sub db..

or find out the differences between the tables and do it manually.. surely the problem will be solved 🙂