Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..
314 views

SQL Search timeout when applying a search filter

Hi All

We are currently experiencing an issue where the search will time out if we apply a Record type filter or in the case of Audits an Event type filter

If we leave all types/events tagged there is no issue

DB stats are updated each night and we have just ran an update stats just in case but the issue continues.

Search timeout is set to 3 minutes

Currently running 9.3.1.300

Cheers

0 Likes
5 Replies
Highlighted
Outstanding Contributor.
Outstanding Contributor.

Re: SQL Search timeout when applying a search filter

How many History type objects do you have?

I have seen some CM datasets with 100s of millions of rows of History objects, and usually organisations don't provision their CM SQL server to be able to handle searching over a table that large...

You may see some improvement for that specific filter by adding an index to the oaEvent column on TSONLINEAU

Highlighted
Respected Contributor.
Respected Contributor.

Re: SQL Search timeout when applying a search filter

Hi Andrew,

Couple of questions..

When the system was last upgraded, did you run the Security Filter Converter?

Does the search speed/time behave differently for an Administrator to a different user type?

What is the setting in the Enterprise Studio properties for the server on the Options tab for the checkbox "Use filter function for security filtering"?

Looking forward to your reply,

Cheers

Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: SQL Search timeout when applying a search filter

Thanks for that I have passed it on to our DB team 

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: SQL Search timeout when applying a search filter

Our last upgrade was conducted by our Statewide team and their vendor so I will have to ask them.

I have also lost my TES access with the last upgrade so I ask the Statewide team on that as well 

Search and Speed time does behave differently over different user types since the last upgrade 

Will post the answers up once the Statewide team gets back to me 

 

Thanks again 

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

Re: SQL Search timeout when applying a search filter

I would like to thank everyone their help. In the end we asked the user to break up the search into two parts. This produced the results required 

 

Thanks again 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.