+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, SIMS Validate Memberships in Technical; Heads up guys and girls I just thought I'd point this out, as it took us by surprise and I ...
  1. #1
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60

    SIMS Validate Memberships

    Heads up guys and girls

    I just thought I'd point this out, as it took us by surprise and I hadn't heard...

    it seems that the "Validate Memberships" routine in SIMS .Net, that runs before you can set up the promotion mapping for next year, was upgraded in the March 09 release and now may take an hour or more to run for the first time since!

    From Supportnet:

    KB75012 - Validate Memberships takes a long time to run after an upgrade
    Created 17/11/2007
    Last Updated 22/06/2009

    Affected Products SIMS .net System Maintenance & Utilities
    Notes Tools | Validate Memberships

    Running Validate Memberships takes a long time

    Why is this routine taking a long time to run?

    What does it do differently than before?

    Data has been changed since running the new Validate Memberships routine
    Advice The New Validate Memberships Routine has been re-designed and now carries out a lot more checks and applies automatic fixes where it can.

    Validate Memberships will only take a long time to run if the Academic Year has been edited or The first time this routine is run after upgrading it could take up to an hour or more to run depending on the size of the schools database.

    Any subsequent runs can take as little time as 20 seconds.

    We also advise to run the latest VM Patch before upgrading to ensure that the Validate memberships Routine runs the correct checks. An upgrade resets the checksums so when VM is run it doesn't check all the records.

    Patch 11055 has been written which can be applied to the schools data so that when the Validate Memberships Routine is run it will check 1000 records at a time making the process less disruptive for the schools. This solution will be updated once the Patch is finished.

    Validate Memberships will check every record the first time it is run and memberships that have been inactive for 400 days or more will be ignored the next time unless the membership becomes active, making it a lot quicker.

    Validate Memberships will produce an SQL Report of the fixes it has carried out and a list of Warnings which the user will need to apply manually.

    The Reports are written to an SQL table SIMS .net, within the SIMS .net folder there are two scripts:-

    Validation_Fixes_Report_Concise - Automatic Fixes
    Validation_Warnings_Report - List of Warnings the user must manually fix in SIMS

    These Reports need to be run through DBDiagnose which will translate them. DBDiagnose is also available from the SIMS .net folder. If this cannot be located please contact the Service Desk and request.

    If you do not look at the Warnings Report for the manual fixes that need to be applied and Validate Memberships is re-run, it will list the issues again until they are resolved.

  2. #2
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    This was discussed on one of the SupportNet Forums. I did point out that time would be saved if the Validate Memberships was run BEFORE doing so as part of the Pastoral Promotion.
    Running it this way, though time consuming, does avoid the problem that some schools found where it was taking several hours when run during the Pastoral Promotion.

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,434
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Or could be ran as a scheduled task [wish]. It takes 4 hrs for me, there are a few patches you can try if it takes too long.

  4. #4
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    ... and a little change to the "this might take a few minutes" message box wouldn't have hurt (cue the flying pigs)

    I'm sorted now - took about 25 mins (small school) just wanted to give everyone else a warning

  5. #5
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    The SupportNet Thread is: March Upgrades - Slowing Promotions Routine (22576)
    First Post on 22nd April - but the solution was available before then.
    There have been several posts since this on the same theme.

  6. #6

    Sylv3r's Avatar
    Join Date
    Jul 2005
    Location
    Co. Durham
    Posts
    3,215
    Thank Post
    372
    Thanked 380 Times in 338 Posts
    Rep Power
    148
    We set this away here and the person in the office responsible for this said it took nearly an hour to work. 1400 students.

    Just as well I wasn't hanging about waiting for it!

  7. #7

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    You could try taking out course memberships?

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 29th July 2009, 02:49 PM
  2. SIMS edit pupils' details crashing SIMS.net
    By CadlaM in forum MIS Systems
    Replies: 12
    Last Post: 13th January 2009, 02:20 PM
  3. Replies: 3
    Last Post: 18th June 2007, 02:51 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
  •