Attempting to Generate Articles Report Results in Server Error

THIS ARTICLE APPLIES TO:

Knowledgebase 8.3.2 Hotfix 3

ISSUE DESCRIPTION:

Steps to replicate the issue:

1. Log in to Admin Panel
2. Go to Reports
3. Select Articles
4. Set Criteria
5. Author: Select a couple by using ctrl
6. Status: Select a couple of steps
7. Scroll to the bottom of the report, click search
8. Click the back button in the browser
9. Set other criteria and you get this error:

Server Error in '/' Application.
--------------------------------------------------------------------------------

ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.

Source Error:

Line 289:
Line 290:    If Len(CStr(display)) > 0 Then 
Line 291:       rs = dbconn.Execute(sqlstring)
Line 292: 
Line 293:    End If

Source File: C:\Program Files\KnowledgeBase.Net\knowledgebase\applicationprogram\ui\http\ClientPortal\reports\articles\search.aspx    Line: 291

Stack Trace:

[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.]
   System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode) +32
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +1189
   System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) +48
   System.Data.Odbc.OdbcCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
   System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
   KBDATA.Connection.Execute(String Sql) in C:\TFS_83\KnowledgeBase\NetComponents\KBDataClass\Connection.vb:74
   ASP.search_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in C:\Program Files\KnowledgeBase.Net\knowledgebase\applicationprogram\ui\http\ClientPortal\reports\articles\search.aspx:291
   System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27
   System.Web.UI.Control.Render(HtmlTextWriter writer) +7
   System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243
   System.Web.UI.Page.ProcessRequestMain() +1926

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2443; ASP.NET Version:1.1.4322.2460

RESOLVED IN:

Knowledgebase 8.3.2 Hotfix 4 or later

ADDITIONAL INFORMATION

TFS 15819

If you have additional questions, please contact our Support group at 877-373-7848 (option 2) or via email at cimsupport@moxiesoft.com.