Attempting to Generate Articles Report Results in Server Error
THIS ARTICLE APPLIES TO:
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:
ADDITIONAL INFORMATION
If you have additional questions, please contact our Support group at 877-373-7848 (option 2) or via email at cimsupport@moxiesoft.com.