ERROR [42603] [IBM][DB2/NT64] SQL0010N The string constant beginning with "')" does not have an ending string delimiter. SQLSTATE=42603
at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method, DB2CursorType reqCursorType, Boolean abortOnOptValueChg, Boolean skipDeleted, Boolean isResultSet, Int32 maxRows, Boolean skipInitialValidation) at IBM.Data.DB2.DB2Command.ExecuteReaderObject(CommandBehavior behavior, String method) at IBM.Data.DB2.DB2Command.ExecuteReader(CommandBehavior behavior) at IBM.Data.DB2.DB2Command.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at MicroD.Database.DBConnection.ExecuteSQLReader(SqlStr sql, IDbTransaction dbTxn) in C:\dev\prevue5\Database\DBConnection.cs:line 326 at MicroD.DataAccess.AttributeValueDO.GetAttributeValueIDs(DBConnection connection, IntList catalogIDlist, Int32 attributeID, String valueNames) at MicroD.BusinessLogic.ItemInformation.GetAttributeValueIDs(IntList catalogIDlist, Int32 attributeID, String valueNames) at MicroD.ePrevue.Controllers.BaseController.AddAttributeNameFilter(Int32& moreFilterID, IntStrList& filtersList, Dictionary`2& uniqueValues) in C:\dev\prevue5\Controllers\Controllers\BaseController.cs:line 1791 at MicroD.ePrevue.Controllers.BaseController.GetAllSearchFilters(NameValueCollection parameters, String typeFilter, String subTypeFilter, Boolean nonBrowserPageFilter, Boolean IsPostBack, eComponentType compType) in C:\dev\prevue5\Controllers\Controllers\BaseController.cs:line 1610 at MicroD.ePrevue.Controllers.BaseController.GetAndCacheAttributeFilterValues(NameValueCollection parameters, Int32 AttributeID, String typeFilter, String subtypeFilter, String filterComponentType, Boolean useCounts, Boolean showitemcounts, Boolean nonBrowserPageFilter, Boolean IsPostBack, ValueListAction valueListAction, String[] attributeValues) in C:\dev\prevue5\Controllers\Controllers\BaseController.cs:line 1485 at MicroD.ePrevue.AttributeFilterControl.get_GetAttributeValues() at MicroD.ePrevue.AttributeFilterControl.BindDataToDisplay() at MicroD.ePrevue.AttributeFilterControl.OnPreRender(EventArgs e) at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Control.PreRenderRecursiveInternal() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Please email us at websupport@eprevue.net and copy the stack trace into your email. Also tell us what you were doing before the error occured, being more specific will result in our ability to fix the errors faster.