REVERTING TO PREVIOUS SAVED VERSION OF QUERY LIST

Amy Plourde

I had been working on a query list over several weeks. I just added a new constituent and then clicked save...it asked me twice if i wanted to save it and at this point my computer was freezing up a little so I was worried. When I opened the query list back up there is only the one constituent that I added last (the 2000+ others disappeared). Not sure what went wrong but is there any way I can revert backto the list I had a couple minutes ago? It would be several hours of lost work if not

EDIT: Just noticed on the main query page it says there are 1791 records in this query list still but when I open it only says 1

Aaron Rothberg

Hi Amy-


I hate to say it, but given it still says there are 1791 records in there, if you don't see those constituents in the results your query list is likely corrupted and lost forever.


You could do a couple of things here. Assuming you are hosted you could ask to have your database restored to just before your computer froze. The downside with this is that if you are an NXT user, you'll lose all NXT settings and all attachments made via NXT. Those are wiped out and unrecoverable. Another option, if you are hosted, is to ask for a copy of the backup so you can get the data you need from that backup, but since NXT users aren't allow to have stand-alone clients to load that backup, you'll have to pay for a 1-month subscription for a second hosted database ($200/month) and have your backup restored to that second database instance.


If you are self-hosted, you'll need to work with IT to see if they are able to restore the database for you.


Short of that I'd say your work is lost. Sorry for the bad news.

Steven Cinquegrana 2

Hi Amy,


Further to Aaron's post, I was wondering if you'd checked the Change Log on the Query List (View/Change Log from the QL window)? If so, did it provide any clues as to what occurred? (It's a pity that one can't simply select a change in the log and roll back to just before it.)


Also, assuming you based the QL on a Query (or Queries, with Add To List/A Group of Constituents), does that Query still run ok if run directly?


I'll admit to not having done too much with Query Lists, but I'm interested in the mechanism of the failure. I've run into catastrophic failures with VBA before, where RE won't even start, and lost hours messing about to get back to scratch, so I know how you feel.


Cheers,

Steve Cinquegrana | CEO and Principal Developer | Protégé Solutions

 

Stephanie Crawley

Amy Plourde:

I had been working on a query list over several weeks. I just added a new constituent and then clicked save...it asked me twice if i wanted to save it and at this point my computer was freezing up a little so I was worried. When I opened the query list back up there is only the one constituent that I added last (the 2000+ others disappeared). Not sure what went wrong but is there any way I can revert backto the list I had a couple minutes ago? It would be several hours of lost work if not

EDIT: Just noticed on the main query page it says there are 1791 records in this query list still but when I open it only says 1

Are you hosted or on-premise (not hosted)?  I find that I had this exact problem when in an on-premise arrangement - several times.  Someone else brought it up at bbcon in a large question and answer session, and the Blackbaud moderators said they'd never heard of such a thing and were kind of shruggingly dismissing it, so I stood up and said I knew exactly what the lady was talking about, and then the Blackbaud moderators were stymied.  The way I would recover the list is to use the Change Log to backtrack and re-add the missing constituents.  It's time-consuming, but it was the only way I found to retrieve the constituents for the list.  I was also dealing with a large database (400,000+ constituent records) and pretty large lists in the thousands.  I ultimately decided that Lists was apparently not really capable of handling large volumes with multiple changes.  But now at a different organization with RE NXT, I wonder if it was actually the on-premise non-hosted situation that was causing the Lists to crash and lose the data.  But the organization I'm at now also has a much, much smaller database less than 20,000 constituent records, so maybe that's the reason I haven't had any issues at the second organization.  I'd be interested to know your hosting circumstances and size of your database, so maybe we can narrow down the cause of the problem.