+ Post New Thread
Results 1 to 5 of 5
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 ...
  1. #1
    Disease's Avatar
    Join Date
    Jan 2006
    Posts
    1,110
    Thank Post
    120
    Thanked 72 Times in 49 Posts
    Rep Power
    57

    [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?

    Thanks

  2. #2

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    275
    Thank Post
    27
    Thanked 40 Times in 30 Posts
    Rep Power
    22
    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)

  3. #3
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    16
    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.

  4. #4
    mounters's Avatar
    Join Date
    Mar 2006
    Location
    Northumberland
    Posts
    199
    Thank Post
    22
    Thanked 70 Times in 59 Posts
    Rep Power
    29
    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.

  5. #5
    Disease's Avatar
    Join Date
    Jan 2006
    Posts
    1,110
    Thank Post
    120
    Thanked 72 Times in 49 Posts
    Rep Power
    57
    Thanks



SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] NOVA T4 error - Help [Solved]
    By timbo343 in forum MIS Systems
    Replies: 1
    Last Post: 7th June 2010, 10:58 AM
  2. ctf file error while importing
    By aneena in forum MIS Systems
    Replies: 10
    Last Post: 16th May 2010, 08:34 AM
  3. BGInfo: Error creating the output bitmap file
    By Little-Miss in forum Windows Server 2000/2003
    Replies: 7
    Last Post: 20th August 2009, 03:43 PM
  4. SIMS.net CTF file
    By localzuk in forum MIS Systems
    Replies: 9
    Last Post: 29th June 2009, 11:45 AM
  5. Problem with SIMS CTF Import
    By appleman in forum MIS Systems
    Replies: 6
    Last Post: 20th April 2009, 04:23 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •