Community
Showing results for 
Search instead for 
Do you mean 
Reply

Fixing ACT Diag and Scheduler after a disk crash

Accepted Solution Solved
Copper Elite Contributor
Posts: 158
Country: Brazil
Accepted Solution

Fixing ACT Diag and Scheduler after a disk crash

Hi,

I use to have tree disk in my computer.

One for "Program Files" (C) where I have ACT and SQL installed, another one for data files (D) where I have ACT database and another external disk for back up purposes.

Disk D had a crash. I replaced and tried to restore ACT database and got message "Database already exists". I restore "as" a new name and I can access and use database normally but...

- I can't not run actdiag as one database I did not back up and was not restored.

- Also Scheduler is running but is not able to perform task I use to (database maintenance and back up). I am able t running this two task from ACT in active database.

Question:

To reinstall SQL is enough to solve this problems ?

When I try to run actdiag I get the following error message:

=============

: System.Data.SqlClient.SqlException: Unable to open the physical file "D:\ACT_2009\Treinamentos.ADF". Operating system error 2: "2(O sistema não pode encontrar o arquivo especificado.)".
Database 'Treinamentos' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.
File activation failure. The physical file name "D:\ACT_2009\Treinamentos.ALF" may be incorrect.

=============

Also in actdiag status line I can see "Not connected"

 

I appreciate any tips. Thanks

Mac, Jorge A. Mac Genity
Using ACT! by Sage 2013 Pro Version 15.1.108.0, on Windows 7
Intel Core I7-2600 CPU @ 3,40 GHz
12,0 GB - 64 bits - NVidia GForce GTX 360 SE

Accepted Solutions
Solution
Accepted by topic author McGnity
‎09-25-2015 03:20 AM
Copper Elite Contributor
Posts: 158
Country: Brazil

Re: Fixing ACT Diag and Scheduler after a disk crash

Hello again Neil,

Just to infom you about my problem.

Well, to be honest I considered easier to re-install Windows (after back up, of coarse) instead of trying (again and again) to deal, edit Windows registers.

In a brand new environment installation process is a piece of cake.

It is now everything in order.

Thank you anyway for your advice.

Regards,

Mac, Jorge A. Mac Genity
Using ACT! by Sage 2013 Pro Version 15.1.108.0, on Windows 7
Intel Core I7-2600 CPU @ 3,40 GHz
12,0 GB - 64 bits - NVidia GForce GTX 360 SE

View solution in original post


All Replies
Copper Elite Contributor
Posts: 127
Country: Australia

Re: Fixing ACT Diag and Scheduler after a disk crash

It is most likely that Windows cannot successfully resolve the path to the new drive. Your best option would be to backup your database files and then uninstall and reinstall ACT! This would ensure that ACT! and SQL both have the correct pointers to the files they need. See the Knowledgebase article 22957.
Regards
Neil Gilford
ACT! Certified Consultant
Gilford Computer Solutions
neil@gilford.com.au
Copper Elite Contributor
Posts: 158
Country: Brazil

Re: Fixing ACT Diag and Scheduler after a disk crash

Hello Neil,
I would not let you without an answer. Not good news.
I am always afraid of dealing with ACT install/uninstall so I postponed to a calm day to deal with.
Not good news!
I followed instructions in knowledge base 24366 to uninstall SQL

After I also followed 19386. With this last one I was able to reach step 14.
I have also uninstalled ACT (I guess, take a look at piece of log below):
This is the Manual Uninstaller for ACT for Windows
=============
MachineName:
31/05/2009 00:00:00

Desktop path is C:\Users\Jorge A. Mac-Genity\Desktop
Program Files path is C:\Program Files
Desktop dir is C:\Users\Jorge A. Mac-Genity\Desktop
Personal folder is C:\Users\Jorge A. Mac-Genity\Documents
User is an Administrator
System32 is C:\Windows\system32
Windows Directory is C:\Windows
OS Architecture is 32-bit
Root Drive is C:
OS is Microsoft® Windows Vista™ Business

bAct6Exists is False
SQL Version is NullCheck


Language is pt-BR
Didn't find the language directory for pt-BR
ACT version is 11.1.183.0
ACT subversion is 11.1
Doing a delete of policy files False
Not ACT installed
ACT! product is ACT11Standard

User verified the readme.
Delete MSSQL is False
Delete Demo is False
=============
It took me a long time since, as a rule, I reboot computer after every uninstall, and checked and stopped services whenever necessary.
I have created a restore point before all tasks and tried to recover after failing but now I get the message:
“Object reference not set to an instance of an object”. Now I can not run ACT not access my database !
Do you know if there is one (two) application to completely remove ACT 11.1 and all sql services related to ACT ?
Thank you for taking your time with this matter.

Mac, Jorge A. Mac Genity
Using ACT! by Sage 2013 Pro Version 15.1.108.0, on Windows 7
Intel Core I7-2600 CPU @ 3,40 GHz
12,0 GB - 64 bits - NVidia GForce GTX 360 SE
Copper Elite Contributor
Posts: 127
Country: Australia

Re: Fixing ACT Diag and Scheduler after a disk crash

There is a Manual Uninstall utility available in KB 19338, which will completely uninstall ACT! and SQL, then reinstall ACT!

 

In an unrelated matter, I do not believe it is a good idea to  place full stops (.) in folder names, as in C:\Users\Jorge A. Mac-Genity\Documents

Regards
Neil Gilford
ACT! Certified Consultant
Gilford Computer Solutions
neil@gilford.com.au
Solution
Accepted by topic author McGnity
‎09-25-2015 03:20 AM
Copper Elite Contributor
Posts: 158
Country: Brazil

Re: Fixing ACT Diag and Scheduler after a disk crash

Hello again Neil,

Just to infom you about my problem.

Well, to be honest I considered easier to re-install Windows (after back up, of coarse) instead of trying (again and again) to deal, edit Windows registers.

In a brand new environment installation process is a piece of cake.

It is now everything in order.

Thank you anyway for your advice.

Regards,

Mac, Jorge A. Mac Genity
Using ACT! by Sage 2013 Pro Version 15.1.108.0, on Windows 7
Intel Core I7-2600 CPU @ 3,40 GHz
12,0 GB - 64 bits - NVidia GForce GTX 360 SE