Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

continuing poor performance in ACT

I think I'm back to where I started in this question: poor performance for calendar functions.

After several days, manually rebuilding preferences doesn't seem to have had that much effect after all.

And, unfortunately, these two things are still true:
  • When I attempt to remove old cleared activities, the response is "There is no old data to remove."

Other suggestions?
0
Scott Helmers
Asked:
Scott Helmers
  • 7
  • 6
1 Solution
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Even after manually deleting the Preferences, the ACTDIAG reset Prefs still fails?
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperAuthor Commented:
Yes. I didn't re-import the saved prefs either, I just set a couple of options manually after the manual delete.

The crash message looks like a file is missing. Could it be because I'm running ACT 2011 and Actdiag 17.2?
actdiag-crash.png
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Sorry for the delay in responding...

I did quite a bit of research on that error and found that SmoLite is used in the later versions with .Net 4.0 ... v14, and earlier, didn't use it. You went to ACTDiag v17 for the table rowcount report...

You could try removing the prefs with the ActDiag download from the bottom of this page:
http://kb.act.com/app/answers/detail/a_id/27518
Hopefully, that should be v14 - let me know if not.

Let me know if you can then remove the prefs and then the Old Cleared activities

If you can remove the OC activities, do the clean, as per:
https://www.experts-exchange.com/questions/28938688/poor-performance-for-calendar-functions.html#a41709370

If you still can't remove the old-cleared activities, you'll need to get the database repaired.
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperAuthor Commented:
Thanks for spending so much time on this, Mike.

The good news is that ActDiag v14 does work with my database!

Here's what I did:
1.      ActDiag v14: Reset prefs
2.      ActDiag v14: Tools>Delete Preference Files
3.      Detach db (per http://kb.act.com/app/answers/detail/a_id/27518)
4.      Open database
5.      Set a few prefs

At this point I tried Tools>Database Maint>Remove Old Data -- to no avail. It still tells me there is no data to clear, which is where we started in the other thread. I'll see whether general performance is better as a result of the above, but it would be nice to be able to clear data and shrink the database.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Can you try the Remove Old Data on the demo database?
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperAuthor Commented:
Good question. I long ago deleted the demo database, however, I tried on a seldom used neighborhood database with only a few dozen contacts -- Remove Old Data works fine. Consequently, the issue must be in my primary database.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
Yes, you'll need to get the database repaired ... There must be some damage there.

I recommend TechBenders: http://techbenders.com/2010/07/act-database-repair-password-recovery/

Ask for Kim and tell her I said "Hi" and she'll give you a quote
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperAuthor Commented:
I just reran the following on the problem database, and Remove Old Data still fails.
Check Database
Repair Database
Reindex Database

Is there value in running any of the Database Rebuild functions in ActDiag? I haven't tried Rebuild Schema or any of the other functions yet, only because I'm not familiar with them and don't want to cause additional problems. But please recommend any that you think might make sense.
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperAuthor Commented:
Thanks for the recommendation above. I was just about to ask whether you could give me a quote to repair the database. But if you don't do that sort of work, I'll contact TechBenders.
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
I can do it, but Kim might be cheaper for you ...

I don't think any of the ACTDIAG fixes will resolve this issue ... It will need some manual repairs
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperAuthor Commented:
Mike -- Thanks for the referral to Kim but I have a certain loyalty to fellow EE experts who work hard at donating their time to solve problems. I'll PM you about database repair services.
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperAuthor Commented:
Exceptional thoroughness, as usual. Thanks
0
 
Mike LazarusAct! Evangelist - CRM ConsultantCommented:
I'm off to bed now (being after midnight in Sydney) ... I'll have a look in the morning
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now