MIS Systems Thread, Facility/CMIS - Missing assessments in Technical; Hi everyone,
I am having huge problems with assessments in Facility, I already open a ticket on Serco's support site ...
22nd June 2010, 09:52 AM #1
- Rep Power
Facility/CMIS - Missing assessments
I am having huge problems with assessments in Facility, I already open a ticket on Serco's support site but as this is a matter of urgency as we are in the middle of writting the term reports, I am posting here as well.
This problem started last week. I've managed to put back all the missing reports but today I am having again problems with missing reports.
What I found out is that the data in the table STURESCOMM is there but the data on the NSTURESULTS table for some students (therefore for some subjects) is missing. It means that we are missing at random the reference from NSTURESULTS to STURESCOMM.
Did anyone have this problem before. Any help will be much appreciated. We are using Facility and ePortal version 10.1
Thanks in advance,
22nd June 2010, 10:17 AM #2
Are the complete records missing in the NSTURESULTS table, or is it that the entries are there and the criteria data field is blank / incomplete?
Also - is there any commonality at all in the reports that are missing, all one teacher, all one subject or student, all created at about the same time etc.
22nd June 2010, 10:52 AM #3
I have seen missing assessments before when printing reports, usually the groupid missing, but not rows missing from one table and not the other.
You could restore a backup of the dataset to an offline copy and have a look at when they went missing, also check the audit trail.
I would check the TG to see if staff have been overwriting each others assessments (shared group), but this shouldn't leave records in comments table.
Try logging in the eportal and checking help | about | I have seen a data server with a different version number to the eportal service.
22nd June 2010, 11:14 AM #4
- Rep Power
Thanks for you prompt response. the whole entries are missing in NSTURESULTS and no I couldn't find anything in common, they are different teachers from different years as well.
22nd June 2010, 11:19 AM #5
- Rep Power
Thanks Banjo, I did restore an old backup and I know when the data started dissapearing, it happened last Thursday and then again yesterday. Last thrusday it was only two teachesr and only two groups (44 records in total) but yesterday I had something like 12 different teachers and 15/20 groups (something like 400 records), plus some of the spring term reports that I had as read/only in ePortal are missing as well.
Teachers were not overwriting the reports to each other, they were only writing/updating their own reports.
The dataserver version is the same as ePortal service.
I will continue checking the logs and re-checking some older backups. Thanks.
By pauljonze in forum MIS Systems
Last Post: 9th July 2009, 09:04 PM
By NotSoFast in forum Network and Classroom Management
Last Post: 24th January 2008, 11:41 AM
By daveyboy in forum MIS Systems
Last Post: 9th October 2007, 08:13 PM
By bursar in forum MIS Systems
Last Post: 22nd May 2007, 05:36 PM
By CheeseDog in forum MIS Systems
Last Post: 14th February 2007, 01:25 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)