Community
Showing results for 
Search instead for 
Do you mean 
Reply

Purge Database from Act Diag

Copper Super Contributor
Posts: 281
Country: United States

Purge Database from Act Diag

I have two databases in Actdag that are marked "recovery".  I can't detach them.  When I try, I get a message saying Unable to cast object of type "System.DBNull" to type "System.String'

They are dead.  I don't need or want them  I just want to purge them from ACTDiag, and, I presume, from the SQL server.

 

How do I do that?

 

Roger

Silver Super Contributor
Posts: 2,328
Country: USA

Re: Purge Database from Act Diag

Shut down the SQL ACT7 instance using services.msc and delete the [database name].adf, [database name].alf, [database name].PAD and [database name]-database files folder.  Then start the service back up.  That should do it.

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
Copper Super Contributor
Posts: 281
Country: United States

Re: Purge Database from Act Diag

Already tried that. (I didn't actually delete the files, but I renamed the folder in which the database is located and uninstalled/reinstalled Act.)

Didn't work.
New Member
Posts: 1
Country: USA

Re: Purge Database from Act Diag

[ Edited ]

Had the same problem...multiple non-existent databases stuck in ActDiag, and unable to delete them.

 

FIX:

 

1) Create new empty database named Temp (I just named it Temp for this example)

 

2) Stop SQL service

 

3) Navigate to ACT databases folder

 

4) Copy all Temp files and matching 'database-files' folder

 

5) Rename Temp files and folder to match name of the missing database in ActDiag

 

6) Open the .pad file in notepad. On line 4, change ACTDatabase name="Temp" to match the missing database name. Close and save.

 

** Repeat steps 4-6 for all other DBs to remove

 

7) Restart SQL service

 

8) Start ACT, and open the problem database.

 

9) Navigate to Tools>Database Maintenance>Delete Database, and confirm

 

** repeat open/delete for all other problem DBs,  and Temp when finished

 

 

Loyal Listener
Posts: 76
Country: USA

Re: Purge Database from Act Diag

just has the same issue

went to cmd prompt

type cd C:\Program Files (x86)\ACT\Act for Windows delete "db name"

db removed from actdiag

Andrea Mahoney
Certified Computer Solutions
407-834-1191
Orlando, Fl
Nickel Super Contributor
Posts: 439
Country: USA

Re: Purge Database from Act Diag

[ Edited ]

that would be a simple solution, Andrea.

but when I try it, I get this error in command window 

"'delete' is not recognized as an internal or external command"

 

Daniel Graves . . . DesignR1, LLC . . . Los Angeles . . . 818-780-3201
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤
New Member
Posts: 1
Country: USA

Re: Purge Database from Act Diag

Romni314, your solution worked for me.  Slightly revised:

 

 

FIX:

 

1) Create new empty database named Temp (I just named it Temp for this example)

 

2) Stop SQL service

 

3) Navigate to ACT databases folder

 

4) Rename Temp files and folder to match name of the missing database

 

5) Open the .pad file in notepad. On line 4, change ACTDatabase name="Temp" to match the missing database name. Close and save.

 

** Repeat steps 4-6 for all other DBs to remove

 

6) Restart SQL service

 

7) Start ACTDiag, and highlight the problem database.

 

8) Navigate to Tools>Detach Database, and confirm (you might need to do this for the temp database as well)

 

Now you will be able to restore or complete your database move.

 

Highlighted
New Member
Posts: 1
Country: United_Kingdom

Re: Purge Database from Act Diag

I recently had this issue after changing a drive letter.

 

I spent the best part of a day trying to delete the database, but despite following the guidance here, whenever I selected the database in Actdiag, I got the error message "unable to cast object of type 'system.dbnull' to type 'system.string'".

 

Eventually, the only way to resolve the issue was to uninstall both Act Pro 2018 and Microsoft SQL Server 2008 R2 and reinstall.

 

Best of luck,

 

Jason Ball