• Sweden edition
 

Patient records wiped out in system crash

Published: 17 Sep 2011 09:07 GMT+02:00
Updated: 17 Sep 2011 09:07 GMT+02:00

When the computer systems in Skåne crashed on August 22, not only did it take with it patient appointments and prescriptions, but it may have wiped out up to 50,000 patient records.

Region Skåne, the self-governing authority for south of Sweden, shipped the affected hard drives to a Norwegian company that specializes in data recovery in an attempt resuscitate vital patient information.

”The job is still on-going and they’ve had to bring in specialists from the United States,” Lennart Wallen, who, until earlier September served as the IT-Director for Region Skåne, told Dagen’s Nyheter (DN).

The cause of the system crash is still not known and the exact extent of lost information has yet to be determined, which has raised grave concern within the National Board of Health and Welfare’s (Socialstyrelsen) southern region’s branch.

”We have never before lost so much information,” Mette Marklund, director of the National Board of Health and Welfare’s Southern Region, told DN. ”It can be a great risk to patient safety when we do not have access to adequate information. But, we do not know yet what to rebuild.”

IT-departments in Skåne managed to rescue ’reading copies’ of patient records, but no one is able to confirm if this version of patient records is complete or identify what may be missing.

After the system-wide crash, medical staff resorted to pen and paper for medical notes and continues to manage lab results manually.

”The databases are still broken, so sometimes you cannot get hold of the data you are looking for. It is quite a sluggish job,” Marklund added. ”We believe that we have not really lost any data, but we won’t know with certainty until we hear from Norway.”

Region Skåne is scheduled to launch a central medical record system for the entire nation in 2012.

Karen Holst (kholstmedia@gmail.com)

Your comments about this article

10:02 September 17, 2011 by Keith #5083
ermm...uhhhmmmm...2 words.....BACK UP!!!!
10:33 September 17, 2011 by henryo
I can support the hospital to recover all the formatted data or patients' records from the hard-disk.

I have expertise in data recovery and have supported several organizations recover lost data in the past.

TheLocal, you can send my contact email to the hospital, I will fix the problem in 8 hours within the office of the hospital.

My mobile is 0735910086.
11:15 September 17, 2011 by vancer
I will do it in 4 hours and half the price of henryo
12:20 September 17, 2011 by Opinionfool
I'll reduce Keith's comment to one word: backup. And to Marilyn, you have no experience of hynryo's professional competencies in dealing with this issue. Data recovery is a difficult and expensive task. He may have the necessary skills but, as an IT consultant myself, his figure of 8 hours is over optimistic. Some simple maths is all that is necessary to show so. 50,000 records all needing to be examined to ensure that nothing has been obviously corrupted. At a very conversative 1 minute per record-check that's 833 hours (105 working days; no single person could work consistently for 35 days 24 hours a day) ... after the information has been recovered. Noice the "obviously" that's simply a scan to check that doctor's notes are text, and that scanned material (X-rays, MRIs, consultant's reports, etc) look as they should. It will take longer to ensure that this apparently correct text, scan, (repeat) prescriptions are linked to the correct person. Plus did this crash corrupt the disk(s), the file system or the database. Finding an answer to that will require several hours of highly intensive forensic work. But the question implicit in Keith's comment remains why did no one do regular backups? Professional organisations do daily backups, whether these are always full backups or a weekly full with daily incremental backups (only modified files/records are backuped) is irrelevant. There must be backups. If they had then the problem reduces to what was changed since the last backup was completed and the moment the system crashed. Real-time systems, which appointment bookings are, need specialist backup mechanisms. And why wasn't the system "mirrored"? For those who understand I don't mean RAID 1 mirror (one disk to another) but whole system mirroring. These days of off-the-shelf systems with open source operating systems bring the cost of total system duplication down to levels that even a start-up company can afford to install. And mature open source SQL databases such as MySQL and postrgreSQL have replication as standard features. There really is no excuse for a simple systems failure like this to take out an organisaiton. If the health districts wants so real IT consutancy to make sure such a situation never happens again then The Local can send *my* contact details on.
14:22 September 17, 2011 by Scepticion
I agree with Opinionfool.

In fact, I have seen incompetent IT administration in several other public organizations. Heads should roll, this should not happen for such sensitive material.
14:48 September 17, 2011 by Opinionfool
While I didn't mention recrimination I agree with Scepticion those responsible for this debacle should lose their jobs. Whether software architect who "designed" the system, the system managers who should have followed standard operating procedures by taking backups, or accountants who insisted on lowest bid (aka least functioning system).

Systems design is not easy. It requires a mind that says "what can go wrong?" not one that says "this is the functionality required that's what we will deliver." And as Scepticion says the information being handled here is sensistive -- life and death even; well would you want to be given the wrong drugs/treatment because your record was corrupted and linked to the wrong medical protocol? We trust too much to the technology rather than thinking about the issues involved.

Complex computer systems are hard, very hard, to get right and it doesn't need people saying "I could've fix that in N hours." getting the design right in the first place means that failures do not have such aweful consequences. Pareto's rule applies; spend 80% of the project on design and 20% on implementation and debugging. Sadly most projects are driven by those who want code or to code so 20% of a project is spent in design and 800% (sic) is spent in programming and debugging.

A rider to my comment above. Even The Local's database system gets corrupted. When I commenced typing that commentI was logged in but when I clicked the "Submit" button a few minutes later it had lost my status. It then stopped me from adding this paragraph as a comment until others had submitted their comments.
15:14 September 17, 2011 by Opinionfool
Indeed one should backup data. Even householders using their own home machines should do so. It is clear however that in this case no one bothered. If they had have done so then most of the records would be recovered back to no later than the close of business the day before the crash.

As to virus protection anyone who runs a sensistive-data system on an operating system that requires virus protection should also lose their job for just suggesting such a thing. (And yes there are operating systems out there that do not require virus protection at all. We don't all lamely follow Microsoft.) Plus what **** is a system holding personal and deeply sensistive data doing being connected to the Internet anyway? Put a gateway between it in a DMZ maybe, but never ever run such a service on a system so easily susceptible to security breaches as one requiring anti-virus software.

I agree with you, backups must be done regularly at least daily. Better if the system is designed to do real-time backups for example through replication of data to a separate parallel system. But as is clear to anyone with the modicum of systems management experience the backups simply weren't being done in this situation.

As to "making money" I never said any such thing in my own offer. I had typed but then expunged "pro bono provided that food, drink, accommodation, and all expenses are included" but that would have reduced it to the same childish level as the original. And the second offer is clearly meant sarcastically to show up the stupid of the "I can do it in 8" claim. I had no thought of making money; I'm not driven by such capitalistic notions. But don't you mean "profit". The people who will pay as a consequence of such mis-management are the patients whose treatment is now disrupted because their information has to be recovered after someone's negligence.

(By the way I work on data-in-the-huge database projects.)
16:34 September 17, 2011 by Addendum
Who do you have to blow to get an MRI, X-ray, etc.?
18:45 September 17, 2011 by AnnicaE
@Addendum

Never tried to see a doctor? Or have you diagnosed yourself and want an MRI or X-ray to confirm? I don't even think you have to give anyone a blow!
19:06 September 17, 2011 by Opinionfool
@Marilyn vos Savant

"Refreshing"? In what way refreshing? Someone posts that they could solve the intricate repair problem in 8hours, when even a back-of-the-fag-packet calculation would show that such a time period is simply non-sense.

Refreshing? In what way refreshing? That someone posts a random mobile number on a public comment forum so you believe they are competent.

As to jumping to conclusions, well maybe but those are conclusions based on a career in IT dealing with systems design and systems management. I think my conclusions are based on something more solid than "refreshing".
21:38 September 17, 2011 by Keith #5083
Perhaps instead of 'rolling heads' those with direct managerial responsibility for this infantile situation should at least be required to pay for the sys restoration!

Once the lesson is learnt, perhaps it won't ever happen again.
21:39 September 17, 2011 by Addendum
If

If you can keep your head when all about you

Are losing theirs and blaming it on you;

If you can trust yourself when all men doubt you,

But make allowance for their doubting too;

If you can wait and not be tired by waiting,

Or, being lied about, don't deal in lies,

Or, being hated, don't give way to hating,

And yet don't look too good, nor talk too wise;

If you can dream - and not make dreams your master;

If you can think - and not make thoughts your aim;

If you can meet with triumph and disaster

And treat those two imposters just the same;

If you can bear to hear the truth you've spoken

Twisted by knaves to make a trap for fools,

Or watch the things you gave your life to broken,

And stoop and build 'em up with wornout tools;

If you can make one heap of all your winnings

And risk it on one turn of pitch-and-toss,

And lose, and start again at your beginnings

And never breath a word about your loss;

If you can force your heart and nerve and sinew

To serve your turn long after they are gone,

And so hold on when there is nothing in you

Except the Will which says to them: "Hold on";

If you can talk with crowds and keep your virtue,

Or walk with kings - nor lose the common touch;

If neither foes nor loving friends can hurt you;

If all men count with you, but none too much;

If you can fill the unforgiving minute

With sixty seconds' worth of distance run -

Yours is the Earth and everything that's in it,

And - which is more - you'll be a Man my son!

R. Kipling
21:47 September 17, 2011 by Opinionfool
Keith #5083

I too would like to believe that but there's a huge pile of anecdotal literature in computer science that says the exact opposite. These failures happen time and time and time again without the necessary lessons being learned.

Penalising the current management team might make them get it right next time. The problem is they should never have got it (so) wrong this time.
13:04 September 18, 2011 by Keith #5083
Yes, it's so good that many offer to help.......so here's my FREE offer: for the expertise, professional qualifications, impressive customer list (leading companies e.g. Apple, Sony, etc.), and proven superb rebuild program - check out Gibson Research's Spinrite prog.

Oh, but if you are not smart enough to BACKUP maybe you shouldn't try to use a prog like this - better to contract the rescue out - then you have someone else to blame if it can't be recovered.

Oh, and just a side note about facts: phone numbers that do not register with orgs like hitta.se don't inspire one to make contact with an unknown ´professional', though the offer to help was still an apparently worthy attitude.
14:48 September 18, 2011 by Opinionfool
Wow thanks Marilyn for your fantastic insight into how to identify properly qualified IT professionals, all it takes is to come here and give one's phone number. Thanks I'll remember that in future. It is the IT version of "trust me I'm a doctor."
18:55 September 18, 2011 by Opinionfool
MvS I suggest that before you suggest where anyone goes that you check henryo's profile. It was created yesterday and they have posted exactly one message; the one above. That's the hallmarks of a troll.

But hey I'm happy to take the intelligence prize --- if you'll accept both the gullibility and naivety awards.
01:21 September 19, 2011 by Keith #5083
#MVS

Yes, I stand corrected. It does show on Eniro..but did not show on hitta at the time of my posting - nor does the name/address listed at eniro show on hitta at the time of this posting.

My profound thanks for your analysis of my motives/methodologies/prejudices. I am sure you enjoyed writing it as much as I was amused reading it.
12:42 September 19, 2011 by Keith #5083
#MVS

as with many old things, updates are necessary (as we 65 year olds know) for the modern technological age.So if you will kindly permit, I would respectfully suggest:

" A wise person changes their mind when the experiential evidence suggests it is necessary. A fool is forever changing minds".

I have removed the 'sexist' element from the 'old proverb' in the interests of equality.Not everything that is old is necessarily beneficial today - though perhaps clerks instead of computers may have served these 14 clinics and 2 major hospitals better in the light of events.
20:59 September 19, 2011 by Keith #5083
#MVS

In order to concede your point we would have to agree on the definition of a proverb.wikipedia definition suggests a common acceptance and/or practical experience. Unless, of course, you are referring to some Biblical 'proverb' which was written in stone thousands of years ago.

As for change, well the only constant is change.

If change had been applied to the thinking behind the debacle to which this article refers, perhaps a backup in time would save nine re-writes.
23:33 September 19, 2011 by Keith #5083
#MVS

If you are the real MVS then arrogance is probably the wrong terminology, I respectfully suggest :-)

But it was nice to reach a point where we could both say 'agreed'.Many thanks for a stimulating discussion.

Have it good.
Today's headlines
Malmö
Rat invasion closes Malmö preschool
Rats like this one have been found in a kindergarten. Photo: TT

Rat invasion closes Malmö preschool

Children in central Malmö are staying at home on Tuesday after a rat infestation was discovered at their kindergarten. READ  

National
Website problems plague Sweden's benefit agency
Sweden's Social Insurance Agency is experiencing problems. Photo: TT

Website problems plague Sweden's benefit agency

UPDATED: Sweden's Social Insurance Agency website was out of action for a second day on Tuesday, but officials have suggested the problem could be fixed by lunchtime. READ  

Presented by West Sweden
Live Blog: West Coast lobster season begins
We'll be hoping for one of these later. Photo: West Sweden

Live Blog: West Coast lobster season begins

The Local's Oliver Gee reports live as he joins fishermen on Sweden's west coast seeking the first lobster catch of 2014. READ  

Swedish teenagers abused on Secret app
File photo: Fredrik Sandberg/Scanpix

Swedish teenagers abused on Secret app

Swedish police are struggling to know what to do with a new batch of criminal reports filed by teenagers upset about a controversial app that allows users to post comments and pictures anonymously. READ  

National
Swedish man beats bus in video challenge

Swedish man beats bus in video challenge

UPDATED: A Swedish runner who filmed himself beating his bus in Sundbyberg in north west Stockholm over the weekend is now planning to a similar challenge on the capital's Metro system. READ  

Regional
Rain causes power cuts across east Sweden
Strong winds are battering Stockholm and the east coast of Sweden. Photo: TT

Rain causes power cuts across east Sweden

Heavy rain and wind have left thousands without electricity in eastern Sweden, with ferries also disrupted by the storm. READ  

Elections 2014
Budget headache for new coalition partners
Social Democrat economic spokesperson Magdalena Andersson with Per Bo from the Green Party. Photo: TT

Budget headache for new coalition partners

UPDATED: The Social Democrats have been holding talks with the Green party to try and agree on a future coalition budget. But questions remain over how they will work together on issues including defence and nuclear power. READ  

National
US runaway banned from name change in Sweden
'Wanted' photograph of David Hemler used by US Air Force Office of Special Investigations. Hemler lives and works in Uppsala. Photo: Shutterstock

US runaway banned from name change in Sweden

A US airman who deserted from the military three decades ago and moved to Sweden has failed in his bid to get his old name back, because a Swedish court says he can’t prove his identity. READ  

My Swedish Career
Plucked out of Canada for love and guitars
Sharleen in action. Photo: Sebastian Bularca

Plucked out of Canada for love and guitars

For this week's My Swedish Career we meet a Canadian who came to Sweden for love and now works in Lidköping, custom-making guitars. READ  

Regional
Flood and high wind warning in east Sweden
Stockholm experienced heavy rain on Sunday. Photo: TT

Flood and high wind warning in east Sweden

After heavy rain broke off the September sunshine in eastern Sweden on Sunday, forecasters warn more bad weather is on the way. READ  

RECEIVE OUR NEWSLETTER AND ALERTS
Finest
Gallery
People-watching: September 20th
The 'black gold' of Sweden's west coast.
National
West Sweden prepares for the 2014 lobster premiere
Society
What's on in Sweden
Politics
How Sweden Democrats went mainstream
Politics
Scandinavia and Scotland: closer links?
Blog updates

22 September

Welcome National Geographic! (Stockholm in my American Heart) »

"What comes to mind when you think of the “The Arctic”? Crystal-encased cliffs jutting from the sea, baronial Polar bears scavenging over sheets of cracked ice or a lone explorer heading north into the night. The image my mind invokes is of three sparkling green lines splashed across the sky like graffiti— the Aurora Borealis— our..." READ »

 

19 September

Editor’s blog (The Local Sweden) »

"Happy Friday readers! It sure has been a exciting week in Sweden, where we’re set to get a new Prime Minister after Fredrik Reinfeldt stepped down following Sunday’s elections. The Local blogged live from the key political gatherings across Stockholm. Why not re-visit the action by taking a look at our photos, tweets, videos and analysis? Since the..." READ »

 
 
 
Gallery
Property of the week - Eskilstuna
Sponsored Article
How to start a business in Stockholm
Society
How I became a surf blogger when I moved to Sweden
Gallery
People-watching: September 13th
Society
Why is Stockholm's Södermalm so cool?
Gallery
People-watching: September 11th
Gallery
People-watching: September 13th
Politics
Five possible election outcomes
Politics
Sweden elections: How do they work?
Politics
Sweden elections: Who's who?
Gallery
Property of the week - Hornstull, Stockholm
Analysis
Five differences between the UK and Sweden
Welshman Jonny Luck is now a chef in Sweden
Society
How I opened my own restaurant in Sweden's Malmö
Sponsored Article
Stockholm tech fest: relive the magic
Gallery
People-watching September 8th
Photo: TT
Politics
Feminists fight for first seats
Politics
Immigration cut push from Sweden Democrats
Sheryl Sandberg says women have "low expectations"
Tech
Facebook exec talks women's limits in Swedish business
Politics
Left Party calls for justice and equality
Politics
Green Party wants 'better world' for kids
Sponsored Article
Introducing… Insurance in Stockholm
Sponsored Article
Graduates: Insure your income in Sweden with AEA
Latest news from The Local in Austria

More news from Austria at thelocal.at

Latest news from The Local in Switzerland

More news from Switzerland at thelocal.ch

Latest news from The Local in Germany

More news from Germany at thelocal.de

Latest news from The Local in Denmark

More news from Denmark at thelocal.dk

Latest news from The Local in Spain

More news from Spain at thelocal.es

Latest news from The Local in France

More news from France at thelocal.fr

Latest news from The Local in Italy

More news from Italy at thelocal.it

Latest news from The Local in Norway

More news from Norway at thelocal.no

848
jobs available
Swedish Down Town Consulting & Productions
Swedish Down Town Consulting & Productions is an innovative business company which provides valuable assistance with the Swedish Authorities, Swedish language practice and general communications. Call 073-100 47 81 or visit:
www.swedishdowntown.com
PSD Media
PSD Media is marketing company that offers innovative solutions for online retailers. We provide modern solutions that help increase traffic and raise conversion. Visit our site at:
http://psdmedia.se
If you want to drink, that’s your business.
If you want to stop, we can help.

Learn more about English-language Alcoholics Anonymous in Sweden. No dues. No fees. Confidentiality assured.
AA-EUROPE.ORG/SWEDEN