Error when importing a use case – DbUpdateExeption

Problem

When attempting to import a use case, you may receive the following exception:

System.Data.Entity.Infrastructure.DbUpdateException: An error occurred while updating the entries.
See the inner exception for details. ---> System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. 
See the inner exception for details. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with 
the FOREIGN KEY constraint "FK_StreamObject_Agent". The conflict occurred 
in database "XMIoT", table "dbo.Agent".
The statement has been terminated

This can occur when there is a mismatch of agents in the target environment. For the import to work, the environment you are importing the streamConsists of a combination of Stream Objects allowing real-time data to flow through. It is created to address a particular use case. into needs to have the exact same version of all agents uploaded.

Solution

Review the agents loaded in the target environment and upload any missing versions of agents, then import the use case again.