Corrupt Database?

Discussions around using and interfacing with the Church MLS program.
Locked
User avatar
utahtroutboy-p40
New Member
Posts: 3
Joined: Wed Oct 22, 2008 9:11 am
Location: Spanish Fork, UT

Corrupt Database?

#1

Post by utahtroutboy-p40 »

About two weeks ago, after we transmitted finance to CHQ, our MLS database seems to have been corrupted. The tithes and offerings data for one member completely disappeared and our Primary rolls are all messed up.

Anyone else experience this problem or know of a solution?
russellhltn
Community Administrator
Posts: 34418
Joined: Sat Jan 20, 2007 2:53 pm
Location: U.S.

#2

Post by russellhltn »

There's a few different things that you could try, but for these kinds of things I'd suggest you start with a call to clerk support. Otherwise there's a risk that things could get worse.
Have you searched the Help Center? Try doing a Google search and adding "site:churchofjesuschrist.org/help" to the search criteria.

So we can better help you, please edit your Profile to include your general location.
User avatar
aebrown
Community Administrator
Posts: 15153
Joined: Tue Nov 27, 2007 8:48 pm
Location: Draper, Utah

#3

Post by aebrown »

utahtroutboy wrote:About two weeks ago, after we transmitted finance to CHQ, our MLS database seems to have been corrupted. The tithes and offerings data for one member completely disappeared and our Primary rolls are all messed up.

Anyone else experience this problem or know of a solution?
The first thing I would try is to restore a current database backup. This forces MLS to rebuild the indexes, and could cure some kinds of problems.

You could consider restoring a backup that predates the problem, but of course that would require you to reenter all the donation batches and any other changes made to MLS after the time that backup was made -- that doesn't sound like fun. But if you haven't done a ton of work in MLS, that might be a reasonable approach.

Before you do that, you might want to call Clerk Support. If the database is truly corrupted, they have a means whereby they can set a flag in MLS so that your database will be transmitted to Clerk Support; they can then examine and hopefully fix it, and then transmit it back to you. Of course, that process takes longer than the few hours you have left in the work week, so you'd be faced with getting through another Sunday limping along as you have the last couple of weeks.
Locked

Return to “MLS Support, Help, and Feedback”