When using the GIS Layer Tool to create an asset layer, following errors occur:
Case 1: The NTH_UK constraint violation means that the theme name(s) is trying to create already exist in the NM_THEMES_ALL table. Make sure you click on the [Get Themes] button before they try to create the theme from scratch. You probably have to delete them first.