Disappearing Applications / Import Lost Project State

I finished work on a 95th application last night, generated ALL the code, tested it, exported the project, and logged off.

I’m the only developer. I work at home.

This morning, the new application was not in the project. The grid links I had created to that application were gone.

PANIC MODE.

I imported the project from last night’s export. The application is back :smiley: but the links are still gone :mad:. Having generated all the code before backing up the project, I was surprised when all of the applications appeared “outdated”.

This is local machine development on Win7 w/ SC 7.01.0021 Enterprise. No one else has access. The computer is firewalled.

There are two critical problems, and one moderate problem here:

  1. Critical: an application disappeared when I logged off.
  2. Critical-as-it-gets: project import with overwrite did not restore the project to the same state it was in when backup was performed.
  3. Moderate: generated code doesn’t get backed up?

Backup/restore is Class-1A-Critical to developers. You should focus on that first. The disappearing app is bad too; I doubt that anyone would be happy if they lost a day’s work because they logged off.

I agree, it’s very annoying to loose work. It’s also very easy to point to SC as there can be many causes. But if it’s SC, then it’s bad.

It shouldn’t be possible to lose an application unless it is intentionally deleted. I kind of understand the links disappearing, given that the linked app disappeared, but even that should throw an error.

Scientific method prevails:
I was wrong. Importing the project does not recover the application I last worked on. Not exactly. It’s there in its folder after restore, but when I generate all the source code, that application is gone.

So…I conclude that the application became corrupted somehow, either during logoff last night, or during login this morning, and generating the code silently removes the offending application. That’s an interesting way to deal with an error. I can’t say that I’ve seen that in any other software.

The application configuration is stored in the repository which is a sqlite database. Although SQLite is an Acid database is still depends on the php processes and OS to get things stored away. I have had samples of bad cache causing trouble. I expect that while saving the config into the sqlite database things went corrupt. Not funny and no excuse as it costs you a lot of time. Not a real comfort too but it happens in any environment sometimes. What you might be able to try is to open the sqlite database with a db tool and try to find out what went wrong. I managed to repair issues sometimes. But sometimes redoing the job goes faster. SQLite expert is a good and free program of doing that.

I’m re-doing what I did yesterday, but I’ll investigate the SQLite db tonight. Thanks for the tip! I have a feeling you’re right.

Maybe I’ll move to a linux dev environment and start snapshotting the SC folder every 30 minutes w/ Git, from cron, and just forget about SC’s “backup”. Disk is cheap.

QA is expensive. But, it often pays for itself. Just found another obvious bug. Groan.

[QUOTE=Giblet535;23368]I’m re-doing what I did yesterday, but I’ll investigate the SQLite db tonight. Thanks for the tip! I have a feeling you’re right.

Maybe I’ll move to a linux dev environment and start snapshotting the SC folder every 30 minutes w/ Git, from cron, and just forget about SC’s “backup”. Disk is cheap.

QA is expensive. But, it often pays for itself. Just found another obvious bug. Groan.[/QUOTE]

I do a full xcopy backup of the scriptcase directory every day. But in the two and a half years I’m working with SC, i have had only one issue of this kind. Every half an hour…

Try Git. It can snapshot the changes only, or do nothing if there were no changes. WinGit is free (if you’re dev’ing on Windows).

30-minute “undo”.

Hello,

Issue reported to our bugs team.

regards,
Bernhard Bernsmann