Missing Applications that do exist on the Scriptcase Dev server

Scriptcase 9 General
#1

Good afternoon,

I have been working for the last two days on a new interface that had 4 applications. I had them in a sub directory of root in the project. I was working on them until about 3 hours ago and then logged out and rebooted my Scriptcase development VM for something else. When I log back into the project, that sub directory is no longer visible and neither are the applications. In the 10+ years with Scriptcase, this has never happened to me.

When I SSH into the server and navigate to /opt/Scriptcase/v9-php81/wwwroot/scriptcase/app/MyProject, I can see the 4 application directories in there - which helped a bit because I thought I was losing my mind. So the applications still exist in the project directory, but are not showing in the Scriptcase project interface.

Has anyone ever seen this or have any ideas on how to get them to show back up? I do have a backup from last night so could restore and lose a day’s work for today, but I’m concerned on what would have caused this and if it will happen again.

Are there any reindexing things or something I can do?

Thanks in advance for any feedback / advice.

Mark.

#2

I wanted to post the resolution in case it helps someone else.

I had several applications disappear from the Scriptcase project tree/GUI even though I had just been working on them.

What I found:

• the generated application folders still existed on disk in the project directory
• the applications were still present in Scriptcase’s SQLite database (nm_scriptcase.db), in the table named sc_tbapl

So the apps were not actually gone — Scriptcase had apparently gotten out of sync between the GUI/project tree and the generated application folders.

What fixed it:

• I logged out of Scriptcase web dev GUI
• I backed up the SQLite database
• I backed up the affected generated app folders
• then I removed/deleted the affected app folders from the project directory
• after reopening/checking Scriptcase, the missing applications reappeared in the GUI

In my case, the metadata was still intact in the database, so Scriptcase was able to recover/rebuild from that.

So if apps disappear from the GUI, it may be worth checking:

  1. whether the app folders still exist in your project’s directory
    On linux that’s probably: cd /opt/Scriptcase/version#/wwwroot/scriptcase/app/project_name
  2. whether the apps still exist in the sc_tbapl table in the sqlite database
    On linux, something like: /opt/Scriptcase/version#/wwwroot/scriptcase/devel/conf/scriptcase/nm_scriptcase.db
  3. and only after backup, delete the app folders in question and open up Scriptcase to see if they get regenerated. Before I deleted the directories, I rebooted the Scriptcase dev server to make sure nothing was locked / in use.

That solved it for me.