+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Automated backup with dbAttach failing in Technical; Got a scheduled backup routine to run overnight but it's suddenly started failing in one school with the following error: ...
  1. #1
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0

    Automated backup with dbAttach failing

    Got a scheduled backup routine to run overnight but it's suddenly started failing in one school with the following error:

    Unhandled Exception: System.ComponentModel.Win32Exception: An attempt has been made to operate on an impersonation token by a thread that is not currently impersonating a client
    at System.Windows.Forms.NativeWindow.WindowClass.Regi sterClass()
    at System.Windows.Forms.NativeWindow.WindowClass.Crea te(String className, Int32 classStyle)
    at System.Windows.Forms.NativeWindow.CreateHandle(Cre ateParams cp)
    at System.Windows.Forms.Control.CreateHandle()
    at System.Windows.Forms.Application.ThreadContext.get _MarshalingControl()
    at System.Windows.Forms.WindowsFormsSynchronizationCo ntext..ctor()
    at System.Windows.Forms.WindowsFormsSynchronizationCo ntext.InstallIfNeeded()
    at System.Windows.Forms.Control..ctor(Boolean autoInstallSyncContext)
    at System.Windows.Forms.ScrollableControl..ctor()
    at System.Windows.Forms.ContainerControl..ctor()
    at System.Windows.Forms.Form..ctor()
    at DbAttach.BackupOnlyForm..ctor()
    at DbAttach.BackupOnlyForm.Main()
    Running dbAttach and backing up SIMS manually works fine. Even more oddly is that the SOLUS3 database is also backed up immediately after the SIMS database using the same process and the SOLUS3 database backs up with no problems at all! Any ideas? I'm at a loss with this one.
    Last edited by Rawns; 11th June 2013 at 10:27 AM.

  2. #2

    Join Date
    Apr 2007
    Location
    Cornwall
    Posts
    309
    Thank Post
    19
    Thanked 85 Times in 57 Posts
    Rep Power
    38
    Presumably your scheduled task that runs dbattach is a script? have you run this manually to see what happens?

    Meldrew

  3. #3
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    Quote Originally Posted by Meldrew View Post
    Presumably your scheduled task that runs dbattach is a script? have you run this manually to see what happens?

    Meldrew
    Yea, it's a scheduled batch file that runs via CentraStage. Tested the script manually on the server and also works fine. Only difference is CentraStage runs it as the system account.

  4. #4
    The_Windy_Miller's Avatar
    Join Date
    Aug 2007
    Posts
    25
    Thank Post
    0
    Thanked 2 Times in 2 Posts
    Rep Power
    15
    I think your clue is in the words "system account"

    We encourage our schools to use the administrator account

  5. #5
    Guest

    Join Date
    Jun 2009
    Posts
    3,754
    Thank Post
    1,458
    Thanked 491 Times in 375 Posts
    Rep Power
    0
    FAIL!

    I scheduled a server reboot last night in the hope it would fix it. I thought I scheduled it to run before last nights backup too but seems I actually scheduled it after! Just re-ran the task again via CentraStage and it's working.

    No issues using the system account here either. We run the backups in 250 schools using it via CentraStage for a few years now, never had a single problem.

    Thanks guys, off to refill my coffee I go!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SQL Backup with dbAttach [Solved]
    By Rawns in forum MIS Systems
    Replies: 5
    Last Post: 6th January 2011, 10:17 AM
  2. Replies: 5
    Last Post: 21st November 2008, 04:49 PM
  3. MySQL automated backup
    By contink in forum *nix
    Replies: 6
    Last Post: 4th January 2008, 09:35 PM
  4. Post SIMS migration backup with BackupExec
    By ndavies in forum MIS Systems
    Replies: 11
    Last Post: 21st November 2007, 03:13 PM
  5. MySQL Backup with phpMyAdmin
    By mark80 in forum How do you do....it?
    Replies: 5
    Last Post: 20th June 2007, 12:15 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
  •