?
Solved

continuing poor performance in ACT

Posted on 2016-08-15
13
Medium Priority
?
269 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 31

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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
LVL 31

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 31

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
 
LVL 30

Accepted Solution

by:
Mike Lazarus earned 2000 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 31

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 31

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 31

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 31

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As most of my regular readers and followers know, I do a lot of on-line technical support as well as providing support services to our resellers and ACT! Certified Consultants and one of the things I notice is that I regularly need to ask users the …
Article by: Dermot
The life of crime is over for 22 year-old Christian Ian Salvador, a student from Isabela State University in the Philippines.
Progress
Starting up a Project

719 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