Full-text search functionality in Acumatica makes finding what you are looking for faster and more efficient way.
The full-text search functionality of Acumatica decreases the users’ time to find the required information. Whether it is finding the site maps or transactions or help topics, or even files/docs attached, we can search all with the help of the universal search bar.
But sometimes, upon upgrading the system/database, restoring the snapshot, or searching for some info, the following error might get triggered: An issue might be prompted if the Full-Text Search feature is inactive/disabled on the server. Hence, the system shows the warning message to the users, as shown above.
But this feature can be enabled/activated by restarting the Full-text Search command.
For the Acumatica 2022R2 ERP version, they have added the command to the Rebuild Full-Text Search Entity Index (SM209500) form to restart. However, for the earlier versions, users must run MS-SQL scripts to enable/activate the Full-Text Search command on the server.
Below are the steps:
The procedure involves modifications to be made directly in the database server. Hence, it is required for the users to have database administrator permissions to execute the SQL queries. The steps are mentioned below:
SELECT *FROM sys.fulltext_indexes |
EXEC Pp_disablefulltext go EXEC Pp_enablefulltext |
And hence, the Full-Text Search command is enabled/activated.
To learn more capabilities of Acumatica, contact us at info@breakdance.dreamhosters.com.
Copyright GerminIT © 2024. All Rights Reserved.