MIS Systems Thread, Hosted Discover Transfer Failing in Technical; We've just installed 22 new Discover databases into our hosted system. We've set up the 'Hosted.xml' with only 4 schools ...
21st June 2012, 04:50 PM #1
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?
Last edited by Rawns; 21st June 2012 at 05:04 PM.
21st June 2012, 04:54 PM #2
hosted - looks like all your databases are pointing at the same discover database - called discover.
Just a guess.
21st June 2012, 04:56 PM #3
In the Hosted.xml file? All the database references are unique and pointing to each individual sims/discover DB, hence the log extract referring to discover494.
Originally Posted by matt40k
Unless there is somewhere else I should be looking?
Last edited by Rawns; 21st June 2012 at 05:06 PM.
Reason: Tidied up original log post
22nd June 2012, 10:22 AM #4
Yer, yer, we all know you add that 494 to the log
22nd June 2012, 10:28 AM #5
3rd October 2012, 02:06 PM #6
- Rep Power
Did you get this to work?????
If so when your school were doing the transfer did it pull down the performance???
3rd October 2012, 03:06 PM #7
Yes we did, forgot to update the post. Needed to run the grant user command against the databases.
The transfers (automated or user initiated) have no impact on performance at all. If anything, it's lightening fast!
By kabuki in forum MIS Systems
Last Post: 17th December 2012, 10:56 PM
By lollettuk in forum MIS Systems
Last Post: 2nd April 2012, 10:19 PM
By Cruiser_Scotland in forum MIS Systems
Last Post: 22nd January 2012, 09:24 PM
By blackbean in forum MIS Systems
Last Post: 10th October 2011, 10:47 AM
By FragglePete in forum South West Grid for Learning (SWGfL)
Last Post: 17th December 2010, 04:22 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)