Sage 50 Data Corruption

As a recent new user to Sage 50, I discovered today that the software crashed when I tried to process a recurring entry. After speaking to Sage, they told me that the data had somehow got corrupted. To fix it, they advised me to subscribe to their help desk, at a cost of £16.95 + VAT. This on top of the monthly licence fee. As I run a small company, where cash is very tight, I don't want to pay this. Can anybody help as to what I should do to try and resolve this?

Thank you

 

Comments

Sage Data Corruption

johndon68 | | Permalink

As a Sage Developer, I offer a 'no fix, no fee' data fixing service.  If the data can be fixed, I charge a lot less than Sage would and I can turn the data round far quicker than Sage.  I'd be more than happy to take a look at the data (which, of course, would be treat in the strictest confidence) if you want, email me a backup at jon dot donnelly@btinternet.com

John

corupt data

Beacon | | Permalink

Have you been doing back ups? If so print out the audit listing from your current program if you can, restore from the last backup prior to the crash, run a data check to see there are no problems then run an audit listing from the restored data and start re-entering the entries you have lost.

Most of us learn the hard way one time or another and suddenly running a backup becomes a "must do " job. I lost two chargable days when this happened to me so I now back up at the end of every posting session!

Data Corruption

johndon68 | | Permalink

You could also try the following which, depending on the corruption, may work:

1. Take a backup

2. Run the Clear Audit Trail routine with a date of 01/01/1980

3. In File -> Maintenance, run Reindex and Compress

4. Run Check Data - if you have no errors, you'll be good to go.

5. If you still have errors, you can either restore a clean backup and reenter all data since the backup or get the data fixed.

John

lindaluvdup's picture

Complain loudly!

lindaluvdup | | Permalink

I've been a Sage user for years and never suffered any data corruption - Sage 2010 did corrupt my data in recurring entries and I run data check every day.

Sage told me that a) the data on every pc suffers corruption every day and is nothing to do with Sage 50, and b) that recurring entries are not covered by the data check function in Sage. You may form your own views on these two statements.

At the time I had Sage Cover and still had to sort out my own problem with recurring entries. If you have a recent backup, you could use it, otherwise you'll be down to thoroughly checking the postings and making manual changes, as I did.

In light of this, I learned to take two backups every day and complain long and loud when necessary.

-- Lin

Sage Data Corruption

johndon68 | | Permalink

Whilst it is true that the Recurring Entries are not included in the Check Data routine, I think the issue here is not that the recurring entries are corrupt per se but that the system has crashed when the recurring entries are being posted which has then corrupted the Audit Trail.

If my earlier suggestion does not work then it is a case of either restore and re-enter or get the data fixed by either Sage or a third party.

John

petersaxton's picture

Recurring entries

petersaxton | | Permalink

If recurring entries are more likely to cause problems would it be better to not use them and enter them manually?

belgarboy's picture

Can't Clear Audit Trail

belgarboy | | Permalink

Hi John

Thanks for your reply. You've understood the problem exactly. I'm following the process you described, but can't set the start date to 1/1/1980. It seems only to allow me to set a date to clear up to. I put in tomorrow's date and ran the process - logically this should remove everything?. All it did was to remove 2 transactions (out of a total of 14). Could you explain to me how to clear the whole trail? After the deletion of the 2 transactions, I tried to process the recurring entry but the software crashed again. To answer some of the other replies, of course I do back ups every time I use Sage. This is the first time I have used the recurring entry. If I use back up data prior to creating the recurring entry, will this fix the problem? As an embedded systems software developer myself I am aghast that this sort of thing can happen.

-- Peter

belgarboy's picture

Sage 50 Data Corruption

belgarboy | | Permalink

Yes, you are probably right, and this is what I have resorted to doing. It's just that I paid for a service that I'm not getting, and it will take time to manually enter all of the monthly direct debits. I've got a niggling feeling that your solution will turn out to be the one I adopt, but I will try everything else first!

Thanks,

-- Peter

Clear Audit Trail Date

johndon68 | | Permalink

You should be able to enter any date you want into the field to clear the audit trail - using 01/01/1980 means that no transactions will be removed (as you won't have any prior to that date) but the audit trail is rebuilt which can correct the corruption you have.

I'm not aware of any issues specifically with the posting of Recurring Entries - I use them every month and I've not had any issues.

John

lindaluvdup's picture

Recurring entries

lindaluvdup | | Permalink

Recurring entries have always saved me a lot of time. I believe my problem was caused by something in Sage 2010, which has a few niggles, so I take your point and you may now well be right. But, so far, it's proved to be a one off problem, and I protect the data by taking at least two backups each day, so I'd rather stick with it - especially as the next Sage upgrade may leave recurring entries unscathed but cause problems with journal entries.

Taking this to a ridiculous conclusion, I could end up journalling everything directly into the nominal ledger and keeping sales and purchase ledgers manually!

Just one tip for anyone new to Sage - sometimes it appears to have hung hopelessly; just stick with it and go to lunch if it's really bad. More often than not it will sort itself out given enough time and you won't have to risk the possible damage to your data caused by using Task Manager to shut it down.

-- Lin

lindaluvdup's picture

Recurring entry problems with Sage

lindaluvdup | | Permalink

One of the first reported problems I read about with Sage 2010 was something to do with recurring entries, but Sage issued a fix when they became aware of it.

From what Sage said, I'm assuming belgarboy's copy has had that issue fixed.

-- Lin

belgarboy's picture

Sage 50 Data Corruption

belgarboy | | Permalink

Firstly thanks to everybody for their comments. The problem has now been fixed; a massive thank you to the witch-queen for taking me through the steps required to sort the problem. Rebuilding the data fixed the problem. Thanks again witch-queen!

-- Peter

Witch-Queen's picture

Re: Sage Data Corruption

Witch-Queen | | Permalink

You're very welcome Peter.

Good luck with Sage and if you need further help you know where to find me

-- Witch-Queen

John Stokdyk's picture

Point of information: recurring entries bug

John Stokdyk | | Permalink

Just to confirm, a problem was spotted shortly after the release of Sage 50 2010 Accounts with recurring entries in the Bank module, but this was fixed a week or so later.

It would be interesting to know if belgarboy's troubles occurred when entering direct debits in this module, or as general transactions.

Witch-Queen's picture

Recurring enteries bug

Witch-Queen | | Permalink

jstokdyk the recurring enteries bug was not the problem as this is a new install, not an upgrade, and it is the up to date version.

Yes it was a direct debit entry but the problem was caused by data coruption in the nominals not the transactions. How this happened I've no idea.

Luckily there were only a few enteries in the audit trail which can easily be re-input, so a Rebuild/Reindex/Compress fixed the problem and the Suppliers details, which needed to be kept, were re-imported via CSV.

-- Witch-Queen

petersaxton's picture

Backups

petersaxton | | Permalink

“so I'd rather stick with it - especially as the next Sage upgrade may leave recurring entries unscathed but cause problems with journal entries.”

Then would be a good time to start doing recurring entries again! If journal entries become a problem I think Sage would send out an update pretty fast.

“Taking this to a ridiculous conclusion, I could end up journalling everything directly into the nominal ledger and keeping sales and purchase ledgers manually!”

That’s right. They key is to take it only so far and not until it’s ridiculous.

Rather than taking two backups (there’s nothing wrong with two or more!) a day why don’t you take a backup immediately prior to doing recurring journals and then ensure everything is ok before continuing?

Glad it's sorted

johndon68 | | Permalink

Glad you got it sorted although I would have expected Sage to have told you about the rebuild/reimport option when you spoke to them - I assumed that they must have done hence my original offer of the data fixing service.

John

belgarboy's picture

Sage 50 Data Corruption

belgarboy | | Permalink

Hi John

I can categorically assure you and everyone that Sage did not offer any help whatsoever. Their helpdesk support involved asking me to run the demonstration data inbuilt into Sage, which I did. Because this allowed recurring entries, they diagnosed the problem to be with my data. At that point, they withdrew their support and said the only way they could continue the investigation would be if I signed up to £16.95/month + VAT. I am extremely displeased with this, as I am paying for a monthly licence already and I would have expected at least some basic support. They didn't even suggest restoring the last known backup and trying that. It's pretty poor really. Thank you very much for your interest and ideas,

Best regards,

-- Peter

AccountingShield's picture

I know this is an old post,

AccountingShield | | Permalink

I know this is an old post, but for anyone who is interested in avoiding this situation themselves should try the Accounting Shield software, which automates the backups of your Sage data. Don't want to hijack this thread and will leave the URL if anyone is interested in more information: http://accountingshield.com

Add comment
Log in or register to post comments
Group: Sage 50 Accounts discussion group
An independent forum for Sage users to share ideas, tips and gripes