Hi Phil,
As you can see from below the Severity states Entire System is unavailable and was logged on February 6th. In fact I logged this the week before but your system could not handle the error notes I posted into it and so corrupted the case log. This is only a minor issue the fact that we have had no Sims for over a month is disgusting. I will be advising my Finance Manager to seek compensation for this loss of service.
This only strengthens my argument to move away from SIMS as Capita has clearly forgotten its main priorities. Customer Service and its inability to provide it. I have used Sims from the early days when it was Dos and was one of the first schools to move to the .Net platform. I find it amazing that even after 5 years you still cannot offer a quality service when the system fails.
I have removed some details but have included the case reference ID 0702-109104 and a log so other viewers can see the problems with Capita support.
Case Details
C9104etails of Issue 0702-109104
Site name: Issue type: Customer Case
Contact: Condition: Open
Product: SIMS .net Installation & Upgrade Your ref:
Severity: Entire system unavailable Currently: with the Development Escalation Team
Description: Upgrade Error Solutions Tried Unsuccessfully:
Status: Solution in progress
Notes: Upgrade error Your database has been restored correctly and can be used normally. The error reported was Violation of PRIMARY KEY constraint 'pk_adm_visit_school_representative'. Cannot insert duplicate key in object 'adm_visit_school_representative'. The SQL Batch which caused the error was : -- DO NOT CONVERT ANY DATA IF THE DATABASE IS AN OFFLINE DATABASE ------------------------------------------------------------------ if exists (select 1 from sims.db_version_info where offline = 0) begin -- TJF BEGIN Reg Fees \ Deposits ------------------------------------------ -- sims.adm_application_transaction_type-- ------------------------------------------ if not exists( select 1 from sims.adm_application_transaction_type) begin SET IDENTITY_INSERT sims.adm_application_transaction_type ON insert into sims.adm_application_transaction_type ( lookup_value_id ,code ,description ,external_code ,display_order ,system ,active ) select lookup_value_id ,code ,description ,external_code ,display_order ,system ,active from sims.ra_application_transaction_type SET IDENTITY_INSERT sims.adm_application_transaction_type OFF end
Issue History
Activity Date: 23/02/2007 11:44:53 Communication Type: E-mail
Activity by: Denise Green
Customer Update
Please note that the attached case is with the Escalation team for cases needing attention. However we currently have a back log of cases which we are working through as quickly as we can.
I will be tracking the progress of your case and will contact you with information, as it becomes available.
Please contact me if you have any further queries about this case.
Kind regards
Denise Green
Escalation Administrative Assistant
01234 832119
Activity Date: 13/02/2007 16:00:14 Communication Type: Phone call
Activity by: Ric Carson
BA Commnet
with helpdesk
Activity Date: 13/02/2007 14:35:19 Communication Type: Contact
Activity by: Eric De Souza
ESCALATION SUMMARY
Error when trying to upgrade sims.net. Client has nothing under visit just in interview.
-------------------------------- error -----------------------------------
Upgrade error Your database has been restored correctly and can be used normally.
The error reported was Violation of PRIMARY KEY constraint 'pk_adm_visit_school_representative'. Cannot insert duplicate key in object 'adm_visit_school_representative'.
The SQL Batch which caused the error was : -- DO NOT CONVERT ANY DATA IF THE DATABASE IS AN OFFLINE DATABASE ------------------------------------------------------------------ if exists (select 1 from sims.db_version_info where offline = 0) begin -- TJF BEGIN Reg Fees \ Deposits ------------------------------------------ -- sims.adm_application_transaction_type-- ------------------------------------------ if not exists( select 1 from sims.adm_application_transaction_type) begin SET IDENTITY_INSERT sims.adm_application_transaction_type ON insert into sims.adm_application_transaction_type ( lookup_value_id ,code ,description ,external_code ,display_order ,system ,active ) select lookup_value_id ,code ,description ,external_code ,display_order ,system ,active from sims.ra_application_transaction_type SET IDENTITY_INSERT sims.adm_application_transaction_type OFF end
Activity Date: 12/02/2007 15:59:17 Communication Type: E-mail
Activity by: Eric De Souza
DATA REQUESTED
Dear Les,
Regarding the above case, the symptoms described in your case indicate that we require your latest data to investigate this issue further. At this stage, I can only apologise for the problems but please be assured that once the data comes in, I will endeavour to find out the cause of the problem.
Please find below instructions on how to upload your database to our ftp site:
1) Copy your database files (.mdf and .ldf files or .bak file) from C:\Program Files\Microsoft SQL Server\MSSQL$SIMS\Data or D:\ depending on your server setup.
Put them on a zip file, please use your school name and case number to name the file.
2) Go to our ftp site (below) and upload your data. If asked the user name is: incoming and the password is: data.
Alternatively please put your data onto a CD and send it to us.
Our address is:
FAO: Eric De Souza
Capita Education Services
5 Mercian Close
Watermoor
Cirencester
GL7 1LT
Please ensure that any data sent to the helpdesk via FTP is also zipped and password protected.
Due to a recent security incident at a Capita office, can I ask that if you need to send data to us in the post, the envelope is clearly marked with the case reference number and your LA/School name. Any items received and not displaying this information may be delayed in processing or rejected.
Please accept my apologies for any inconvenience this may cause, but I hope you understand our reasons for this action.
Kind Regards,
Eric De Souza
Software Support Analyst
Capita Education Services
Independent Schools Division
Tel: 01285 647500 Fax: 01285 647599
[email protected]
Activity Date: 12/02/2007 15:55:57 Communication Type: Phone call
Activity by: Eric De Souza
information received
have nothing under visit just interview
Activity Date: 12/02/2007 11:03:25 Communication Type: E-mail
Activity by: Eric De Souza
solution sent
Dear Les,
This problem happens when a person is scheduled to attend an R+A meeting more than once with the same role. Could you please check all R+A meetings/visits to ensure that each person is down as being an attendee only once.
Please let me know how you get on
Kind Regards,
Eric
Activity Date: 06/02/2007 09:45:34 Communication Type: Web support
Activity by: Les Baker
Case logged by customer through WebSupport
System Generated Activity Tuesday, February 06 2007 09:45:33 by Les