When we try to add a part to our CIP Database from a Distributor Search, we get the following errors:
ERROR  [Microsoft][ODBC SQL Server Driver][SQL Server]An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.
ERROR  [Microsoft][ODBC SQL Server Driver][SQL Server]profile name is not valid
This error occurs when CIP has been configured for Email notifications, but the Email notification configuration is incomplete.
To resolve the errors, remove all checked boxes under the User section for notifications, this should resolve the issue.