MIS Systems Thread, [SIMS] Problem Creating CTF File "The ROLLBACK TRANSACTION request." Error [Solved] in Technical; My exams officer is trying to create a CTF file and her machines just hangs, it does the same thing ...
9th July 2010, 01:06 PM #1
[SIMS] Problem Creating CTF File "The ROLLBACK TRANSACTION request." Error [Solved]
My exams officer is trying to create a CTF file and her machines just hangs, it does the same thing even on the server.
She managed to create the CTF file on Weds butshe has ammended it and is now trying to recreate it.
Eventually it threw up this error on one attempt:
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
We have also had the odd problem with people over the last few days getting:
Connection to database timed out
I have increased the time out to 100000.
Anyone with any ideas on these issues?
IDG Tech News
10th July 2010, 09:42 AM #2
You might find it works if you don't include as many students in the ctf - they're big files and exporting everything in one file can fail. Also, you may not need to include all student data in the file - unticking the relevant boxes when producing the ctf may help.
If it still fails, even with just one student, it's probably a big in sims or corruption on your server! Have a word with support as there are things to try (detach db, etc)
13th July 2010, 09:32 AM #3
There are numerous issues with exporting CTF's which result in rollback transaction errors. There are also quite a few patches to resolve the issue so I'd recommend that you ask your local LA or Capita depending on who you're supported by as the chances are that there is a patch to resolve this.
13th July 2010, 10:10 AM #4
Yep, we had this problem the LA support team released he following patch to us Patch 14397 [643-644] (KB97609: unable create a CTF export file, the system hangs when user selected pupils in whole year group.) After applying this patch the CTF export was completed in seconds.
13th July 2010, 01:27 PM #5
By timbo343 in forum MIS Systems
Last Post: 7th June 2010, 09:58 AM
By aneena in forum MIS Systems
Last Post: 16th May 2010, 07:34 AM
By Little-Miss in forum Windows Server 2000/2003
Last Post: 20th August 2009, 02:43 PM
By localzuk in forum MIS Systems
Last Post: 29th June 2009, 10:45 AM
By appleman in forum MIS Systems
Last Post: 20th April 2009, 03:23 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)