+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, Peculiar error after migrating SIMS to SQLE2005 in Technical; Last night i did the sql changeover - all prereq's were fine, several dozen backups taken, process carried out smoothly. ...
  1. #1
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Peculiar error after migrating SIMS to SQLE2005

    Last night i did the sql changeover - all prereq's were fine, several dozen backups taken, process carried out smoothly. Everyone's happy And I can still login.

    So this morning I run SOLUS for the September update. However part way through running it just bottoms out. After it finishes restoring i get the attached error

    When running solus I am using a SQL login (my personal login which has sysman rights and always has). The database is running in mixed authentication mode as per Capita's guidelines

    I can still use SIMS as normal using my login. It's just this damn september update that is failing
    Attached Images Attached Images

  2. #2

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,326
    Thank Post
    36
    Thanked 353 Times in 238 Posts
    Rep Power
    79

    Re: Peculiar error after migrating SIMS to SQLE2005

    I don't recognise this problem so please log a call.

  3. #3
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: Peculiar error after migrating SIMS to SQLE2005

    OK will do.. just thought I'd try here first

  4. #4
    Quatermass's Avatar
    Join Date
    Mar 2007
    Posts
    84
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Peculiar error after migrating SIMS to SQLE2005

    I just got that exact error too! SIMS fine, SQL fine, but September update procedure takes a successful backup, then crashes out and gives that screen. I've logged with LEA too but incredibly annoying! Argh!!!

  5. #5
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    Re: Peculiar error after migrating SIMS to SQLE2005

    By any chance were you performing the update via remote desktop?

    Had a similar error when using remote desktop, worked fine with VNC though.

  6. #6
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,456
    Thank Post
    10
    Thanked 494 Times in 434 Posts
    Rep Power
    113

    Re: Peculiar error after migrating SIMS to SQLE2005

    And actually on the server itself?

  7. #7
    steve's Avatar
    Join Date
    Oct 2005
    Location
    West Yorkshire
    Posts
    1,043
    Thank Post
    22
    Thanked 177 Times in 123 Posts
    Rep Power
    52

    Re: Peculiar error after migrating SIMS to SQLE2005

    DMcCoy is right, you must upgrade now only on the server:

    Quote Originally Posted by August Release notes
    IMPORTANT NOTES: The SIMS 2007 August Main Release should only be applied to existing installations by running SOLUS on the SIMS SQL Server. The changes to the Security Model for August mean that some database changes have to be registered on the server before dbUpgrade can be run. This can only be done by running the upgrade on the SIMS SQL Server. If users try to apply the upgrade by running SOLUS on a SIMS client, the upgrade will fail and the database will be rolled back to the previous version..

  8. #8
    Quatermass's Avatar
    Join Date
    Mar 2007
    Posts
    84
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Peculiar error after migrating SIMS to SQLE2005

    This wasn't via Remote Desktop or even VNC. It was on the server, direct. Yes, thanks, I did see the Capita caveat... it's in the September release notes too

  9. #9
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,456
    Thank Post
    10
    Thanked 494 Times in 434 Posts
    Rep Power
    113

    Re: Peculiar error after migrating SIMS to SQLE2005

    I know thats for august, but I'd run the september one on the server too

  10. #10
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: Peculiar error after migrating SIMS to SQLE2005

    I *always* do updates on the server. This was via dameware - which is just the same as being sat in front of the server so it's not like a TS session or anything. Ran it this morning too physically sat in front of the server and same issue.

  11. #11
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,456
    Thank Post
    10
    Thanked 494 Times in 434 Posts
    Rep Power
    113

    Re: Peculiar error after migrating SIMS to SQLE2005

    Something else broken then :|

    I had 10 cases in 14 days this month. Something is always broken

  12. #12
    Quatermass's Avatar
    Join Date
    Mar 2007
    Posts
    84
    Thank Post
    7
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Peculiar error after migrating SIMS to SQLE2005

    Hi guys

    I've just had a reply from my LEA about this. They tested our data and got similar problems, so sent it to Capita. Capita's final reply is that there is an "issue" in the current version of DBUpgrade - they are testing a fix which they hope to include in the November release (out 5/11/07). Sigh...

  13. #13
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: Peculiar error after migrating SIMS to SQLE2005

    Quote Originally Posted by Quatermass
    November release (out 5/11/07)
    Hmm.. I hope it's only a coincidence that it's out on guy fawkes :bom:

  14. #14
    Oops_my_bad's Avatar
    Join Date
    Jan 2007
    Location
    Man chest hair
    Posts
    1,738
    Thank Post
    438
    Thanked 53 Times in 50 Posts
    Rep Power
    30

    Re: Peculiar error after migrating SIMS to SQLE2005

    Got this sorted

    For anyone else having this error i removed the read only attribute of all files in the setups and setups\<random number> folder. Then i ran SOLUS and the database upgrade went ahead without problems and am now running the september update.

    i would only do this AFTER you have tried out the things in KB73455 but for now I'm happy.. FMS migration next

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Error message on SIMS
    By Gatt in forum MIS Systems
    Replies: 12
    Last Post: 17th October 2013, 10:49 AM
  2. SIMS Install Error
    By danIT in forum MIS Systems
    Replies: 4
    Last Post: 7th December 2007, 04:23 PM
  3. Sims error - Reason 5???
    By cophighschool in forum MIS Systems
    Replies: 12
    Last Post: 4th October 2007, 01:22 PM
  4. SIMS Error
    By Jon1 in forum MIS Systems
    Replies: 5
    Last Post: 19th June 2007, 02:43 PM
  5. SIMS .Net Error
    By wesleyw in forum Educational Software
    Replies: 6
    Last Post: 1st December 2006, 03:49 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
  •