02-05-2018 01:42 PM
Running ACT v16 Premium. Attempting to unpack and restore a database, but it wouldn't restore. In ACTDIAG the database was initially listed as SUSPECT, but now says "RECOVERY-PENDING". Trying to detach database, but every time I select the database and click "Actions" I get an error message that says "Unable to cast object of type 'System.DBNull' to type 'System.String'. Have tried manually deleting the files but there was only the ALF file. Also tried stopping ACT 7 instance of SQL. Any suggestions would be greatly appreciated.
02-06-2018 03:01 AM - edited 02-06-2018 03:02 AM
I would recommend restoring from a recent backup if you have one.
If not, then you could try stopping the SQL instance - then physically moving the ADF and ALF files to another location and renaming them. Then restarting the instance and trying to attach them.
Sometimes methods like this will cause open transactions in the log file, which usually will require re-creation. I can provide steps on this if it becomes necessary.
02-06-2018 05:45 AM
What do you mean by "restore from a recent backup"?
I'm a little concerned that the only database file I can find is the ALF. The ADF is no where in sight.
02-06-2018 06:27 AM
03-11-2019 06:36 AM
You can go use Microsoft SQL Server Management Studio to connect to the ACT7 instance, and try backing up and recovering. If the database is not needed and more you can Drop the table, For example, a client had an old ACTDemo2014 which gave the above error in ACTDIAG.EXE Dropping the old demo removed it from the database list in ActDiag.
05-02-2019 01:05 AM
I also had same issue with one of my client, i would suggest to rename the .pad file to .pad.old and restart SQL (ACT7) services. After that open act and change extension open with to .ADF which will recreate your .Pad file and you are good to go..