Solved

continuing poor performance in ACT

Posted on 2016-08-15
13
123 Views
Last Modified: 2016-08-24
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
Comment
Question by:Scott Helmers
  • 7
  • 6
13 Comments
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 41757344
Even after manually deleting the Preferences, the ACTDIAG reset Prefs still fails?
0
 
LVL 30

Author Comment

by:Scott Helmers
ID: 41757705
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 41766804
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
 
LVL 30

Author Comment

by:Scott Helmers
ID: 41767901
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 41768169
Can you try the Remove Old Data on the demo database?
0
 
LVL 30

Author Comment

by:Scott Helmers
ID: 41768795
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 500 total points
ID: 41768805
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
 
LVL 30

Author Comment

by:Scott Helmers
ID: 41768815
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
 
LVL 30

Author Comment

by:Scott Helmers
ID: 41768820
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
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 41768834
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
 
LVL 30

Author Comment

by:Scott Helmers
ID: 41768868
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
 
LVL 30

Author Closing Comment

by:Scott Helmers
ID: 41768873
Exceptional thoroughness, as usual. Thanks
0
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 41768875
I'm off to bed now (being after midnight in Sydney) ... I'll have a look in the morning
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
ACT contact Layout 4 784
Cannot run or restore ACT! 2010 database 2 634
ACT for Sage 2013 6 901
How to setup PLEX PLUS on 2 computers 2 14
A lot of users new to ACT!, especially those who don't get the benefit of a consultant, seem confused between when to share on a network and when to sync ... or, in fact, how to do either. So I thought I would attempt to explain the various options …
With users like the Professional Sales Road Warriors that made up much of ACT!'s early user base to field service technicians, trades-people, telecommuters who work from home, remote offices and others who need access to their data while out of the …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now