When entering a search term on the Symantec Management Platform (SMP) console global search box (top right corner) the console indicates a failure, and search does not return any results.
IT Management Suite (ITMS) 8.0 Hot Fix (HF) 4.
Error occurred while building Search Panel.
Procedure or function spGetCategorizedSearchItems has too many arguments specified.
[System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider]
at Altiris.Console.WebControls.SearchPanelHelper.GetSearchResultHtml(String search, String locale)
The exact cause is unknown but something caused the stored procedure spGetCategorizedSearchItems to not to be properly updated during the upgrade process.
If you are seeing this error on 8.0 HF4 through HF6, you can run the attached SQL query to update the stored procedure to the correct version. If you are running into this error on any other version, you can use the following steps to update the stored procedure to match the one from a working database.
From SQL Server Studio Manager, run: sp_helptext spGetCategorizedSearchItems from a working SMP database.
Copy or move the results from the above query to the non-working server's SQL studio.
Change the word "Create" to: alter
Run the adjusted query to fix the issue.
SQL Query for updated stored procedure for versions 8.0 HF4, HF5 and HF6.