Error: Cannot insert the value NULL into column 'RELATIONSHIPSETID', table '[DBNAME].dbo.RELATIONSHIPORGANIZATION'; column does not allow nulls. INSERT fails. - When editing a constituent to organization relationship
When attempting to save an edited constituent to organization relationship the system gives the error:
Data could not be saved. Cannot insert the value NULL into column 'RELATIONSHIPSETID', table 'DB_Name.dbo.RELATIONSHIPORGANIZATION'; column does not allow nulls. INSERT fails.
Steps To Duplicate
1. Go to the individual constituent record. 2. Edit relationship to organization > Save > Notice the error occurs.
Answer:
Download and install the latest service pack/hotfix which contains all fixes from previous service packs.