Ray thank you for your support. The level of support you give continually throughout the lifecycle of these products is exhausting.
My issue turned out to be something odd with the database import export, as on my new server I went in and set a default value for a column i wasnt setting a value on.
not sure why or how this creeped up but its working now.