Error Occured: System.Exception:
[DataConnection.HandleError]:
Query:
SELECT DISTINCT [mmtc_event_cat__c] FROM
(
SELECT View_CMS_Tree_Joined.NodeAliasPath,
View_CMS_Tree_Joined.DocumentName,
custom_MMTCClassType.Featured,
custom_MMTCClassType.ClassTypeImage,
custom_MMTCClassType.ClassTypeImagePageHeader,
custom_MMTCClassType.MMTCClassTypeID,
custom_MMTCClassType.MMTCClass_ProductCode,
custom_MMTCClassType.ClassTypeSummary,
custom_MMTCClassType.ClassTypeName,
lcl_web_events_vw.*
FROM View_CMS_Tree_Joined
JOIN custom_MMTCClassType
ON View_CMS_Tree_Joined.DocumentForeignKeyValue = custom_MMTCClassType.MMTCClassTypeID
LEFT JOIN lcl_web_events_vw
ON custom_MMTCClassType.MMTCClass_ProductCode = lcl_web_events_vw.ProductCode
WHERE View_CMS_Tree_Joined.ClassName ='custom.MMTCClassType'
AND lcl_web_events_vw.evt__Start__c> getDate()
--AND isNull(ProductCode,'') not like 'MKT-%'
) Data
WHERE (mmtc_event_cat__c <> '')
ORDER BY mmtc_event_cat__c
Caused exception:
Database 'salesforce_local' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
---> System.Data.SqlClient.SqlException: Database 'salesforce_local' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
--- End of inner exception stack trace ---
at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex)
at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)
at CMS.DataEngine.GeneralConnection.RunQuery(QueryParameters query)
at CMS.DataEngine.GeneralConnection.RunQueryWithRetry(QueryParameters query, Int32 retryCount)
at CMS.DataEngine.GeneralConnection.ExecuteQuery(QueryParameters query, Int32& totalRecords)
at CMS.DataEngine.DataQueryBase`1.GetDataFromDBInternal()
at CMS.DataEngine.DataQueryBase`1.GetDataFromDB()
at CMS.DataEngine.DataQueryBase`1.GetData()
at CMS.DataEngine.DataQueryBase`1.get_Result()
at CMSWebParts__Custom_filterClasses.SetupControl() in C:\inetpub\KenticoCMS\MMTC\CMS\CMSWebParts\_Custom\filterClasses.ascx.cs:line 51
The Center - Schedule