+ Post New Thread
Results 1 to 14 of 14
MIS Systems Thread, SIMS.NET Solus 3 Change Request - Please Vote!! in Technical; Hi Everyone All schools that use Solus 3 for deploying SIMS workstation updates - please review and vote for the ...
  1. #1

    Join Date
    Apr 2011
    Location
    Lincs
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS.NET Solus 3 Change Request - Please Vote!!

    Hi Everyone
    All schools that use Solus 3 for deploying SIMS workstation updates - please review and vote for the change I have requested.

    It will useful for all solus 3 admins, so please login to Supportnet and view the following url:

    http://support.capitaes.co.uk/Change...9E%C3%98%C3%A0

    or search for change request number: 1212-1156615

    we are the end users so should get our feedback noticed for product improvement, as we all know what a great product SIMS is!! **Laughs**

  2. #2

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,488
    Thank Post
    527
    Thanked 876 Times in 683 Posts
    Blog Entries
    15
    Rep Power
    438
    is it a button which does it all for you without the unnecessary hype and pomp requiring a degree in deciphering bovine excrement?

  3. #3
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,116
    Thank Post
    414
    Thanked 149 Times in 147 Posts
    Blog Entries
    3
    Rep Power
    59
    Not exactly what your after but would achieve it for you.

    If you go into Reports within Solus 3, you can pull up a report which will tell you the SIMS Workstation version. It can get screwed up if your deployment messes up somehow as happened to us during the main summer deployment.

  4. #4

    Join Date
    Apr 2011
    Location
    Lincs
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Oh yeah - so it does!!
    After being on the phone to capita Support they told me the only way to view all workstations version is to click on the agents part, select a computer and view the agent details. Was advised to put in a change request.

    Didnt even tell me you could do it within the reports - although I did have a quick browse before I was only select Update Deployment, and not Deployed Environment - thanks!

    I think SIMS should follow the saying - If it ain't broke, dont fix it - as they always seem to release half-written software!! Too many fingers in one pie!! lol

    Quote Originally Posted by Cache View Post
    Not exactly what your after but would achieve it for you.

    If you go into Reports within Solus 3, you can pull up a report which will tell you the SIMS Workstation version. It can get screwed up if your deployment messes up somehow as happened to us during the main summer deployment.

  5. #5
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,116
    Thank Post
    414
    Thanked 149 Times in 147 Posts
    Blog Entries
    3
    Rep Power
    59
    No problem, we've had various issues with different parts of SIMS recently where Capita say it isn't possible or doesn't do something (I was arguing on the phone for 20 minutes over something last week which I knew it did but they insisted it didn't, still isn't fixed yet though)

  6. #6

    Join Date
    Apr 2011
    Location
    Lincs
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We have an issue whereby offline clients that have the solus 3 agent on do not detect a new update is required when they come online. So when i do the update, it only updates those workstations which are currently online.

    I then have to manually deploy the update from the server when the offline clients come online.

    Capita's response "This will be fixed in the next version of solus release due in february" - Really?! I'll wait to see that happen! Do they not test these things?! As a VB/SQL Programmer in previous years I like to put my 2 cents worth across to them! lol


    Quote Originally Posted by Cache View Post
    No problem, we've had various issues with different parts of SIMS recently where Capita say it isn't possible or doesn't do something (I was arguing on the phone for 20 minutes over something last week which I knew it did but they insisted it didn't, still isn't fixed yet though)

  7. #7
    Cache's Avatar
    Join Date
    Apr 2008
    Location
    Cumbria
    Posts
    1,116
    Thank Post
    414
    Thanked 149 Times in 147 Posts
    Blog Entries
    3
    Rep Power
    59
    See our's do (or did) do that for SIMS and Solus updates, but didn't for Discover updates. It's just not instant (which is a pain and causes problems). Maybe mine just does weird things which Capita fixes and then it stops mine....

    Change Request 1206-1111593, while not mine, I would like to see implemented.

    People leaving SIMS open despite being told there's an update is my major problem normally.
    Last edited by Cache; 5th December 2012 at 09:03 PM.

  8. #8

    Join Date
    Apr 2011
    Location
    Lincs
    Posts
    4
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Solus 3 is not suited for our school - staff expect to boot up, login, and go straight into SIMS for morning registration - they liked how the update RAN when they double clicked SIMS and then could just login as normal.

    With the agent, if the update hasnt ran (or fails) its the good old incompatible database and they are stuck until I set the update to install remotely! Why can't they let you use an older version of SIMS when its updated - even if its just 1 version behind - surely every version still pulls data from the same tables!! lol.

    Never Mind...we have to live with Capita's ways of life!


    Quote Originally Posted by Cache View Post
    See our's do (or did) do that for SIMS and Solus updates, but didn't for Discover updates. It's just not instant (which is a pain and causes problems). Maybe mine just does weird things which Capita fixes and then it stops mine....

    Change Request 1206-1111593, while not mine, I would like to see implemented.

    People leaving SIMS open despite being told there's an update is my major problem normally.

  9. #9

    Join Date
    Sep 2006
    Location
    London
    Posts
    1,248
    Thank Post
    33
    Thanked 335 Times in 225 Posts
    Rep Power
    75
    Running an application against a database that is not in step is just far too risky there would be data corruption.

    SOLUS 3 is designed specifically to allow teachers to boot and go straight into SIMS having downloaded the upgrade in the background i.e. no waiting around.

  10. #10

    Join Date
    Nov 2011
    Location
    Rayleigh
    Posts
    95
    Thank Post
    13
    Thanked 13 Times in 13 Posts
    Blog Entries
    1
    Rep Power
    7
    Quote Originally Posted by PhilNeal View Post
    Running an application against a database that is not in step is just far too risky there would be data corruption.

    SOLUS 3 is designed specifically to allow teachers to boot and go straight into SIMS having downloaded the upgrade in the background i.e. no waiting around.
    That may have been how it was designed but in reality it just doesn't work like that and we get all the flack because Teacher's, etc. can't access SIMS until numerous attempts to push out the update finally reach the end user's machine!

  11. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    +2 on both CRs.

  12. #12
    jwonnacott's Avatar
    Join Date
    Jul 2008
    Location
    Callington, Cornwall, UK
    Posts
    3
    Thank Post
    0
    Thanked 4 Times in 2 Posts
    Rep Power
    0
    I've cobbled together a bit of SQL to list all stations that have not yet got their update.
    No doubt an SQLer will find it amusing (and hopefully improve it) but for what it's worth here it is.
    Just replace the package name in two places.

    Code:
    SELECT 
    	[agent].[name] AS [name],
    	[package].[description] AS [description2]
    	FROM           (SELECT DISTINCT * FROM [solus3].[agent_package_site] WHERE success =0) AS [aps]
    	INNER JOIN [solus3].[agent_package] AS [ap] ON [aps].[agent_package_id] = [ap].[agent_package_id]
    	LEFT OUTER JOIN [solus3].[distributed_deployment_plan] AS [dpp] ON [aps].[distributed_deployment_plan_guid] = [dpp].[distributed_deployment_plan_guid]
    	LEFT OUTER JOIN [solus3].[agent_package] AS [ap1] ON [aps].[agent_package_id] = [ap1].[agent_package_id]
    	LEFT OUTER JOIN [solus3].[target] ON [ap1].[target_guid] = [target].[target_guid]
    	LEFT OUTER JOIN [solus3].[agent] ON [ap1].[agent_guid] = [agent].[agent_guid]
    	LEFT OUTER JOIN [solus3].[target] AS [target1] ON [ap1].[target_guid] = [target1].[target_guid]
    	LEFT OUTER JOIN [solus3].[recompiled_package] AS [rp] ON [ap1].[recompiled_package_guid] = [rp].[recompiled_package_guid]
    	LEFT OUTER JOIN [solus3].[recompiled_package] AS [rp1] ON [ap1].[recompiled_package_guid] = [rp1].[recompiled_package_guid]
    	LEFT OUTER JOIN [solus3].[package] ON [rp1].[package_guid] = [package].[package_guid]
    	WHERE [package].[description] LIKE 'SIMS 2012 Autumn%' AND agent.name NOT LIKE '%removed%'
    EXCEPT 
    SELECT 
    	[agent].[name] AS [name],
    	[package].[description] AS [description2]
    	FROM           (SELECT * FROM [solus3].[agent_package_site] WHERE success =1) AS [aps]
    	INNER JOIN [solus3].[agent_package] AS [ap] ON [aps].[agent_package_id] = [ap].[agent_package_id]
    	LEFT OUTER JOIN [solus3].[distributed_deployment_plan] AS [dpp] ON [aps].[distributed_deployment_plan_guid] = [dpp].[distributed_deployment_plan_guid]
    	LEFT OUTER JOIN [solus3].[agent_package] AS [ap1] ON [aps].[agent_package_id] = [ap1].[agent_package_id]
    	LEFT OUTER JOIN [solus3].[target] ON [ap1].[target_guid] = [target].[target_guid]
    	LEFT OUTER JOIN [solus3].[agent] ON [ap1].[agent_guid] = [agent].[agent_guid]
    	LEFT OUTER JOIN [solus3].[target] AS [target1] ON [ap1].[target_guid] = [target1].[target_guid]
    	LEFT OUTER JOIN [solus3].[recompiled_package] AS [rp] ON [ap1].[recompiled_package_guid] = [rp].[recompiled_package_guid]
    	LEFT OUTER JOIN [solus3].[recompiled_package] AS [rp1] ON [ap1].[recompiled_package_guid] = [rp1].[recompiled_package_guid]
    	LEFT OUTER JOIN [solus3].[package] ON [rp1].[package_guid] = [package].[package_guid]
    	WHERE [package].[description] LIKE 'SIMS 2012 Autumn%' AND agent.name NOT LIKE '%removed%'
    ORDER BY [agent].[name] ASC
    Just bung it in a query in SQL Server Management Studio.

    Hope it helps someone.

    James

  13. Thanks to jwonnacott from:

    Rawns (18th December 2012)

  14. #13

    Join Date
    Feb 2008
    Location
    Wiltshire
    Posts
    860
    Thank Post
    273
    Thanked 130 Times in 110 Posts
    Blog Entries
    26
    Rep Power
    39
    Quote Originally Posted by PhilNeal View Post
    Running an application against a database that is not in step is just far too risky there would be data corruption.

    SOLUS 3 is designed specifically to allow teachers to boot and go straight into SIMS having downloaded the upgrade in the background i.e. no waiting around.
    Well, it doesn't work does it. And today, my morning will be wasted dealing with teachers and machines that haven't updated.

    Ran the Autumn update, and largely it went ok. But, even me asking teachers to quit SIMS and leave their machines on there was a handful that didn't.

    As a result, they come in this morning, log on, start SIMS and get this incompatible database error, phone me up and get all shouty.

    I have to then do a redeploy to try and get the machines running, but even this takes time. Time wasted and as a result, a handful of teachers will miss the legally obliged requirement to register first thing.

    Why oh why can't it be like how it was; the teacher starts SIMS and a check is performed, if not the latest version, it processes the upgrade? Stupid, stupid, stupid.

    Pete

  15. #14

    synaesthesia's Avatar
    Join Date
    Jan 2009
    Location
    Northamptonshire
    Posts
    5,488
    Thank Post
    527
    Thanked 876 Times in 683 Posts
    Blog Entries
    15
    Rep Power
    438
    The idea is certainly right - if there's a particular problem with your update then surely get in touch with Capita support.
    Teachers not coming out of SIMS will always be a problem though. I often just copy a working and updated SIMS folder from a working machine to ones that failed. If anyone wants to get shouty, I will not hesitate in pointing out their failure after several warnings.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Sims.Net & Solus 2 - Phantom Users Issue
    By tech_guy in forum MIS Systems
    Replies: 3
    Last Post: 10th October 2012, 12:28 PM
  2. [SIMS] SIMS.net change request
    By Benmorgan86uk in forum MIS Systems
    Replies: 28
    Last Post: 27th February 2012, 06:13 PM
  3. [SIMS] Sims Analysis - Change request to vote on please
    By BatchFile in forum MIS Systems
    Replies: 7
    Last Post: 29th July 2010, 02:20 PM
  4. If your board Vote for my SIMS Change Requests
    By Stuart_C in forum MIS Systems
    Replies: 1
    Last Post: 15th September 2009, 10:42 AM
  5. SIMS change requests - Vote please!
    By park_bench in forum MIS Systems
    Replies: 4
    Last Post: 30th October 2008, 11:58 AM

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
  •