Esteban_Child_of_the_Sun

looking at the errors, it looks like there is a mismatch between the version of the catalog (the files in the Discover Services folder), the version of the Discover Database (and/or config files) or the version of SIMS. For reference, the error "Warning: Data view has no icon attribute, using default." is one you will see at all sites. It is referring to parts of Discover that aren't visible to the end user and thus have never been assigned an icon (where as graphs, groups and menu headers all have icons) I would suggest starting again, while it is possible to track down the particular error(s) it is usually quicker to wipe it all out and re-install (then if you had been using it, restore the backup). 1. Unistall the Discover services (and not always needed but you could uninstall the client as well) from Control Panel 2. Delete the Discover Database from SQL Management Studio with the option to drop logins selected. 3. Delete C:\Program Files (x86)\SIMS\Discover* (or wherever the folders were installed to) 4. Delete the folder C:\ProgramData\Discover 5. Get the installation version of Discover that matches your current version of SIMS 6. Run the typical installation and make sure 'NT AUTHORITY\NETWORK SERVICE' is sues to run the services (you can use other account but that gets more complicated, and for now I'd recommend keeping it simple to prove it works) 7. Open the admin utility and run a transfer for the current year only. (I would give it a 40% chance of succeeding, if it fails run the script above and find the next set of error messages)

Assuming you are running the Discover services as NT AUTHORITY\NETWORK SERVICE then the following may help. Run from the server either through a batch file or manually on the command line. The pause commands are there for if you run it as a batch file, you can review the results before moving on to the next command. Depending on which (if any) commands fail and what error message they fail with should help identify your problem. I have assumed your Discover database is called Discover. I would suggest stopping the 2 Discover services, archiving the 2 Discover log files associated with the services and re-starting the services (if the services are active the files are locked) set SERVERNAME=MIS-Server set SQLINSTANCE=SIMS2012 set SAPASSWORD=Wouldn't_You_Like_To_Know set database=SIMS set DiscoInstall=C:\Program Files (x86)\SIMS Echo Create user in SIMS Database sqlcmd -S %SERVERNAME%\%SQLINSTANCE% -U sa -P %SAPASSWORD% -d %database% -Q"EXEC sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE'" pause Echo create the catalogue "%DiscoInstall%\Discover Services\Discover.CatalogLoader.Console.exe" /operation=create /AssemblyFileName="%DiscoInstall%\Discover Services\Discover.SIMS.Catalog.dll" -Server="%SERVERNAME%\%SQLINSTANCE%" -username="sa" -password="%SAPASSWORD%" -database="Discover" -verbose pause ECHO SIMS Discover Database User Transfer "%DiscoInstall%\Discover Services\Discover.SqlUserManager.Console.exe" /operation=synchronisewithsims -Server="%SERVERNAME%\%SQLINSTANCE%" -username="sa" -password="%SAPASSWORD%" -simsdatabase="%database%" -Discoverdatabase="Discover" -verbose pause ECHO SIMS Discover Grant Group Synchronisation Rights "%DiscoInstall%\Discover Services\Discover.SqlUserManager.Console.exe" /operation=GrantDataViewMonitorAccountRights -AccountName="NT AUTHORITY\NETWORK SERVICE" -Server="%SERVERNAME%\%SQLINSTANCE%" -Username="sa" -Password="%SAPASSWORD%" -SIMSdatabase="%database%" -Discoverdatabase="Discover" -verbose pause ECHO SIMS Discover Grant Transfer Rights "%DiscoInstall%\Discover Services\Discover.SqlUserManager.Console.exe" /operation=GrantTransferAccountRights -AccountName="NT AUTHORITY\NETWORK SERVICE" -Server="%SERVERNAME%\%SQLINSTANCE%" -Username="sa" -Password="%SAPASSWORD%" -SIMSdatabase="%database%" -Discoverdatabase="Discover" -verbose pause

You need to build a custom graph using the groups provided, so you'd start with an interval of 5 and add the first 3 data points to your graph, then create a discover group to combine point 20 and 25 to make your 16-25 and add that to you graph, etc. We have created a lot of those sort of graphs over the years for our schools, though mostly for Attendance.

There is a more recent CR (by 2 years) for the same sort of thing https://myaccount.capita-cs.co.uk/changerequests/changerequest/a49125b5-45a0-e611-80f4-5065f38a29d1 with almost as many votes

Yes Discover Dynamic Groups are what you need to generate SIMS messages for students getting more than X behavior points. As bobsmith said, you just need to select the option when setting the group up, and make the user who wants the messages a supervisor.

Our special schools used to use CASPA but have now developed their own trackers in SIMS. You'd be better off asking other special schools who use SIMS to share a copy of their resources and work with your school to develop them further.

You can use AD authentication for a backup account in SIMS and use trusted on the command line instead of putting in a username and password.

We set up a simple backup for our schools 1. Weekly re-integrate the SIMS / FMS usernames and passwords in to their respective databases, and make a backup of the Docstorage folder to a backup drive (usually robocopy and that way it only updates changed files) 2 Twice daily:- backup the SIMS database(s) using DB attach calling the backup file Mon AM, Mon PM, etc. and save it to the backup drive 3. Daily:- backup FMS using FMS's DBAttach (yes they are different) and the Discover backup utility to backup discover (makes the backups a couple of MB instead of a few hundred MB) and backup all changed files in Docstorage in the last 24 hours to the backup drive (in a folder for the day backed up). Also make a backup of the shared SIMS folder. All these backups overwrite the previous week's backups for the same period so we only ever store a weeks worth of backups on the backup drive, then we set our backup software to backup the drive while it's inactive for more than 10 minutes (i.e. after any backup)

I've seen this error only once before and not in SIMS but another .net application. It had to do with a query to a database server returning more information than the client could contain in memory which caused the stream to prematurely close resulting in a null pointer in the variable. Then if the variable was read you'd see this error. How much RAM does the machine have?

If it's for behavior, why not use the right click behavior events from the registers instead?

if the setup all looks fine, have you tried running validate memberships?

Download the manual SOLUS3 upgrade files and manually do the database upgrade then run the deployment in SOLUS3 to do the rest. I've found that to be the easiest way to resolve this issue.

Capita have attached a signature tot he template so any changes to it stop it running at all.

There are a couple of ways you could do this, unfortunately they aren't built in to SIMS. The first is you could have a word Macro that you manually run on each generated report that truncates the table of results returned to 5 rows, this is time consuming. You could export the reports in to a folder and have a quick PowerShell script iterate over all the reports in a given directory doing the same as the Macro using embedded VB script, but they then aren't in SIMS.

There are reports of the Today's register report not running after the upgrade. Evidence seems to point to temporary files in the user's SIMS profile being the issue, as clearing them and re-logging in to SIMS appears to resolve the issue. I've not encountered this my self but many other people have posted on MyAccount about it

There isn't a start date. When one of our schools wanted to do the same a few years ago, they had to pay Capita to create a bespoke patch which gave each student a 'special behavior' incident with the exact negative points value of the behavior incidents up to the point they wanted it re-setting.

Did his old PC have FMS (any version) on it? If so does his new PC also have FMS on? I've come across issues before where FMS installs the Borland Database engine better than the SIMS installer, so installing FMS, then re-installing SIMS can in some circumstances resolve this sort of issue.

You should probably delete those graphs from Discover. Also in the SIMS.net reporting engine you can do Assessment related reports, have you made any to identify the aspects in question and things that may potentially be using them?

Do you have any discover resources linked to them?

Also, some Support teams provide schools with reports for various things, if they contain Macros then it may be that the support team has decided to stop supporting 2010 as I know the VB does change between versions as we have similar issues.

Also, you could try re-setting you local SIMS profile. By closing SIMS, rename the tmpsimsrtp and 'My SIMS Document' folders (in your My Documents folder) then launching SIMS, it will re-generate those folders with a default profile.

The error is usually caused by Windows not having the correct program association with .csv files. Have you had different versions of MS Office installed on your PC in the past which have since been uninstalled? If you manually try and open a .csv file from windows explorer by double clicking on it, does it open automatically in excel without and additional intervention?

Do you use SmoothWall by any chance?

Given the setup you describe, SOLUS3 is a redundant system in that scenario unless you have some additional legacy databases (e.g. from historical school merges, etc) that you are wanting to keep up to date. If no other databases then it's not a system you need to touch as it isn't doing anything useful.

We've had a Vulnerability Index for a few years now, ours has a simple implementation in assessment manager where by each category (e.g. Young Carer, police record, etc) can have 1 of 3 values (Y = applies in the current academic year, U = applied in previous academic years, or blank if it has never applied). Most schools are happy for all staff to be able to see this level of information and the actual details are stored in confidential documents attached to the pupil's record. I agree that your CR would be a nice feature (and have voted for it) and help a lot with this sort of scenario, but I don't realistically see it being implemented in SIMS 7 (SIMS .net) without a mammoth effort from the SIMS community, but it may well make it's way in to SIMS 8 with enough votes.