MIS Systems Thread, FMS problem in Technical; This is a long shot but someone may know the amswer. We have just had our main SIMS server fall ...
31st October 2008, 03:03 PM #1
This is a long shot but someone may know the amswer. We have just had our main SIMS server fall over and are restoring the backup onto a temporary alternative. SIMS is fine but when we try to log in to FMS i get
Exception EDBEngineError in module Finance.exe at 0007A2DE.
General SQL error.[Microsoft][SQL Native Client][SQL Server]Cannot roll back atomic. No transaction or savepoint of that name was found.
I've run the patch suggested by Capita without success, have reported this back to the support desk and am now waiting for them to get back to me .....and waiting........and waiting
IDG Tech News
31st October 2008, 03:11 PM #2
Get yourself a SupportNet user\pass:
Look up KB78030. Tis to do with your staff not all having a hours\week filled in, go into SIMS .net, look at ALL staff and check they have something in the hours\weeks at least a zero.
I believe patch 1273 can also sort this.
31st October 2008, 03:56 PM #3
patch 1273 is the one I've run and I can't find anything else relevant on supportnet - but I'll try looking at the staff hours
31st October 2008, 04:31 PM #4
There's a report you can run "Atomic Error" as a first step to make sure none of your current staff have a blank.
We had this last week and it turned out to be an issue with a new Service Term being for 0 hours which wasn't picked up on the report.
There's a nice sql patch you can request (not sure why its called a patch though) which will accurately determine the issue (well it did for us) in your data.
6th November 2008, 11:55 AM #5
Thanks for your suggestions. It turned out to be a fairly complex configuration problem which Capita eventually sorted for me
By tonijh in forum MIS Systems
Last Post: 26th February 2009, 02:21 PM
By madslug in forum MIS Systems
Last Post: 19th May 2008, 10:37 AM
By dezt in forum MIS Systems
Last Post: 7th May 2008, 12:21 PM
By seb_king in forum MIS Systems
Last Post: 1st November 2007, 01:47 PM
By edie209 in forum MIS Systems
Last Post: 7th October 2007, 07:58 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)