Community
Showing results for 
Search instead for 
Do you mean 
Reply

20100121-ACT2010 hotfix 4 Lookup by example and user delete problems

Tuned Listener
Posts: 35
Country: Belgium

20100121-ACT2010 hotfix 4 Lookup by example and user delete problems

[ Edited ]
Dear,
 
1)
We have upgraded from ACT2008 to ACT2010 Hotfix4, and since we can't use lookup "by example". We always get the message that there is nothing that meets the specified criteria.
We found a post on the knowledge base from Sage. But it was posted on 21/10/2009. We use this option a lot and know it is very unhandy to work with this version of ACT.
Can you tell us when there will be a solution to this problem?
 
 
2)
Also there are some stations that are very slow when execute a lookup. Not on all records but some records. And the same lookup on another station is very fast. We have read the post on the Sage website to optimize Windows and that we did as best as possible to us. What can be the solution with this?
 
3)
We also can't remove a login user. We get a time out message. How can we solve this?
 
Kind regards
 
Jurgen Poelmans / Edwin Stas
 
Message Edited by dlunceford on 01-21-2010 09:08 AM
Moderator
Posts: 4,395
Country: USA

Re: 20100121-ACT2010 hotfix 4 Lookup by example and user delete problems

1- Issue is targeted to be fixed in the next update.  I currently do not have a release date.

 

2- Make sure all users are on hot fix 4.  You can verify by going to Help > About ACT!

How to Download and Apply the ACT! by Sage 2010 Hot Fix 4

 

3- Increase timeout values on the server from actdiag.

How to Change the Time Out Settings in ACT! Diagnostics Tool

Tuned Listener
Posts: 35
Country: Belgium

Re: 20100121-ACT2010 hotfix 4 Lookup by example and user delete problems

I've increased the timeout as followed:

 

 Databasecommandtimeout.default: 500sec

 Databaseconnectiontimeout.default: 500sec

 Databasecommandtimeout.long: 3600sec

 SData.BigreadTimeoutminutes: 20min

But we still keeps getting the timeout message.

We made the user first inactive and than we try to delete the user. We have 4 user who we want to delete but non of the users can be deleted.

 

Moderator
Posts: 4,395
Country: USA

Re: 20100121-ACT2010 hotfix 4 Lookup by example and user delete problems

1- Have everyone close ACT!.

2- On the server, restart SQL Service (ACT7) service.

3- Open the database on the server and attempt to remove the user.

Tuned Listener
Posts: 35
Country: Belgium

Re: 20100121-ACT2010 hotfix 4 Lookup by example and user delete problems

I've done everything you told me, but still no results. The complete message is "Timeout expired. The timeout period elapsed prior the completion of the operation or the server is not repsondig". I also ran all the repairs that are possible true actdiag. We can make the user inactive, but we want them to be deleted as login users.

 

Jurgen Poelmans