On the Case Searching screen an error message (similar to those shown below) is encountered when sorting the result columns in Standard Search and Full-Text Search

Standard Search:

An exception occurred while retrieving the records.

Source:
 	.Net SqlClient Data Provider
Message:
	Incorrect syntax near ','.

Full-Text Search:

An exception occurred while retrieving the records.

Source:
 	.Net SqlClient Data Provider
Message:
 	Invalid column name 'Subject'. ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

There are two ways to resolve this issue:

Option 1 - The Quick Fix
Remove the versaSRS-related cookies from the browser then reload versaSRS. This will clear the sorting preferences and allow the Case Searching results to be viewed again.

Please refer to the following KB article if you require instructions for removing versaSRS Cookies
NOTE: This is not a permanent solution. Do not attempt to sort the result columns again or the same error will occur.

Option 2 - The Resolution
If Custom Columns are used in the application, updating the current stored procedure will resolve this issue permanently. As the Database Admin, download the required zip file and follow the below instructions: NOTE: This will modify the below mentioned Custom Stored Procedures, we recommend saving the original files first. We also recommend applying to the application in a test environment (where possible) to verify it is successful before trying on the Production environment.

1. Access the versaSRS database, search for the following Custom Stored Procedures:
   (YourDataBase > Programmability > Stored Procedures)
   sp_Call_Search_By_Page
   sp_Full_Text_Call_Search_With_Attachments_By_Page

2. Right click the above Custom Stored Procedures and select Modify.

3. Copy the content in the corresponding attached file and paste it in the Custom Stored Procedures. If there are previous custom scripts, replace the content with the previous scripts.
   NOTE: The first line in the file will need to be changed if the database being modified is NOT named 'versaSRS'

4. Select Execute to Save.

568 Removing versaSRS Cookies

Did the information in this article help answer your question?

Yes
No
Did not apply