Error Occured: System.Exception:
[DataConnection.HandleError]:
Query:
SELECT [Industry] FROM
(
SELECT View_CMS_Tree_Joined.NodeAliasPath,
View_CMS_Tree_Joined.DocumentName,
View_CMS_Tree_Joined.NodeOrder,
custom_MMTCSuccessStories.SFStoryID,
custom_MMTCSuccessStories.IsFeatured,
custom_MMTCSuccessStories.StoryTitle,
custom_MMTCSuccessStories.StorySummary,
custom_MMTCSuccessStories.StoryImageMain,
custom_MMTCSuccessStories.StoryImageInner,
--custom_MMTCClassType.MMTCClassTypeID,
--custom_MMTCClassType.MMTCClass_ProductCode,
--custom_MMTCClassType.ClassTypeName,
lcl_web_success_stories.*
FROM View_CMS_Tree_Joined
JOIN custom_MMTCSuccessStories
ON View_CMS_Tree_Joined.DocumentForeignKeyValue = custom_MMTCSuccessStories.MMTCSuccessStoriesID
LEFT JOIN lcl_web_success_stories
ON custom_MMTCSuccessStories.SFStoryID = lcl_web_success_stories.id
WHERE View_CMS_Tree_Joined.ClassName ='custom.MMTCSuccessStories'
) Data
ORDER BY Industry
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_filterStories.SetupControl() in C:\inetpub\KenticoCMS\MMTC\CMS\CMSWebParts\_Custom\filterStories.ascx.cs:line 74
The Center - Michigan Manufacturing Technology Center Success Stories - Myron Zucker, Inc.