Absent Member.. Absent Member..
Absent Member..
2760 views

enabling text search on a project.

I recently installed HP ALM 12 on one of our servers, Windows Server 2012 and MS SQL  2012 and set up a project.

 

However, I wish to turn on the text search function.

 

When I click on "Text Search" in the DB Servers area, I get the error "Failed to Set DBServers Properties".

 

In the HP ALM Admin Guide it states that the EXEC sp_fulltext_database 'enable' function must be used first, but Microsoft website states full text indexing is automatically turned on in MS SQL 2012 and can't be turned off, therefore the command is not used.

 

Any ideas on what is wrong? ps I'm no DB expert so please don't baffle me with techno-speak 😉

 

 

 

P.S. This thread ahs been moved from Community Feedback & Suggestions to Quality Center Support and News Forum. - Hp Forum Moderator

Tags (1)
0 Likes
3 Replies
Fleet Admiral
Fleet Admiral

As far as I know, full text search needs to be switched on even in SQL Server 2012. See for example this discussion

Jan Czajkowski

[Please do not contact me off line for receiving support. Use the forum!]
Cadet 3rd Class
Cadet 3rd Class

Hello Jan,

We are performing a 2 fold migration from QC 11 to ALM 12.21 and from 12.21 to 12.53 where DB is Oracle 12C(12.1.0.2) for both ALM versions.

Upgrade from 11 to 12.21 was successful and failing for 12.53..

Restored Project > Ran Verify Project...

Error:
******************************************************************************************
2017-09-07 08:55:31.0 Check text search feature configuration
2017-09-07 08:55:31.0 Check that proper role is granted
2017-09-07 08:55:31.0 Passed


2017-09-07 08:55:31.0 Check that text search indexes are valid
2017-09-07 08:55:31.0 Passed


2017-09-07 08:55:31.0 Check that only valid fields are included in text search
2017-09-07 08:55:31.0 Passed


2017-09-07 08:55:31.0 Is text search enabled only on supported fields
2017-09-07 08:55:31.0 Passed
2017-09-07 08:55:31.0 Check that text search feature works properly

2017-09-07 08:55:36.0 ALM-V10051: Failed. The current text search feature is not configured well.
.
.
.
.
Verify found some problem that cannot be fixed by Repair tool.

******************************************************************************************

Text Search on the DB is Enabled.
CTXAPP role is granted to Project Schema with Admin Option.

Can you suggest what could be the issue and how to resolve the same?

Thanks,
Ashwini

0 Likes
Admiral
Admiral

From the verify log, looks like there is no issue with roles or indexes and supported fields.

ALM-V10051: Failed. The current text search feature is not configured well

The error is thrown for couple of reasons/.

pls raise a support case and provide SA logs during the verify, to pin point what exactly causing the issue.

alternatively, you can switchoff the text search for the DB server ( by setting the flag) and enable it from siteadmin and see if it helps.

 

Cheers
-------------
When your problem has been solved, accept the solution by clicking the "Accept as Solution" button to help other members in the future!

Clicking the "Kudos star" is a great way to say thanks! 🙂
--------------
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.