Hosted Discover Transfer Failing
We've just installed 22 new Discover databases into our hosted system. We've set up the 'Hosted.xml' with only 4 schools fdor the moment and when attempting to transfer data, every site fails for the same reason, (from the log file but formatted a little better):
There was an error transferring the data between the SIMS and Discover databases!
The INSERT statement conflicted with the FOREIGN KEY constraint "fk_UserDataViewCategoryCategoryId". The conflict occurred in database "discover494", table "dbo.Category", column "CategoryId".
Anyone seen this in a normal or hosted instance?