Client Support
Showing results for 
Search instead for 
Do you mean 

Getting timeout expired error after dataset upgrade

Advisor

Getting timeout expired error after dataset upgrade

We have just upgraded from v7 to RM8.1

 

We are getting the 'Query timeout expired' for record search and when try to expand some sub classification.  This is only happen for some classification for certain record search. I believe that it is not happen all the time. When we logoff and logon again, sometimes it will ok.

 

 

What cause this error? What is the recommendation? Any fine tuning need to be done? 

1 REPLY
Honored Contributor

Re: Getting timeout expired error after dataset upgrade

If you have just run an upgrade, make sure you have run a full schema repair and that you are also running regular nightly maintenance on the database with the correct UPDATE STATISTICS script.

 

 



::::::::::::::::::::::
NOT A HP EMPLOYEE
::::::::::::::::::::::

Kapish.com.au