Error in query. Query:select 'B' as OrderByColumn, Html.Html, View1.ViewName, View1.Secured, View1.EnforceRoleSecurity, View1.UIType, View1.Template, Html.Title, View1.ScannerEventName, Html.DesignMode, Html.ViewBuilderHtml, Html.ViewBuilderPhoneHtml, Html.RawHtml, Html.BuiltDateTime, Html.SavedDateTime, Html.ViewId, Html.SiteId, Html.Device, Html.Version, Html.LanguageId, Html.ViewBuilderHtmlXslt, Html.ViewBuilderPhoneHtmlXslt, View1.UseMultiThreading, View1.NumberOfThreads, View1.Cache, Html.TranslationDocument, Html.TranslationDocumentPhone, View1.MenuDescription from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html Html Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Sites Site On Html.SiteId = Site.SiteId and Site.SiteId = 1 Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Views View1 On View1.ViewId = Html.ViewId and ( Device ='All' Or Device = '' Or Device IS NULL) Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html_DefaultVersion DefaultHtml On Html.Version = DefaultHtml.DefaultVersion and Site.SiteId = DefaultHtml.SiteId AND Html.ViewId = DefaultHtml.ViewId where View1.ViewId = @ViewId AND Html.LanguageId = @LanguageId UNION ALL select 'D' as OrderByColumn, Html.Html, View1.ViewName, View1.Secured, View1.EnforceRoleSecurity, View1.UIType, View1.Template, Html.Title, View1.ScannerEventName, Html.DesignMode, Html.ViewBuilderHtml, Html.ViewBuilderPhoneHtml, Html.RawHtml, Html.BuiltDateTime, Html.SavedDateTime, Html.ViewId, Html.SiteId, Html.Device, Html.Version, Html.LanguageId, Html.ViewBuilderHtmlXslt, Html.ViewBuilderPhoneHtmlXslt, View1.UseMultiThreading, View1.NumberOfThreads, View1.Cache, Html.TranslationDocument, Html.TranslationDocumentPhone, View1.MenuDescription from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html Html Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Sites Site On Html.SiteId = Site.SiteId and Site.SiteId = 1 Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Views View1 On View1.ViewId = Html.ViewId and ( Device ='All' Or Device = '' Or Device IS NULL) where View1.ViewId = @ViewId and Html.Version = (select min(version) from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html where SiteId = 1) AND Html.LanguageId = @LanguageId order by OrderByColumn. Error: Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. See inner exception for stack trace.
KRise.EASYProcess.Exceptions.DatabaseException: Error in query. Query:select 'B' as OrderByColumn, Html.Html, View1.ViewName, View1.Secured, View1.EnforceRoleSecurity, View1.UIType, View1.Template, Html.Title, View1.ScannerEventName, Html.DesignMode, Html.ViewBuilderHtml, Html.ViewBuilderPhoneHtml, Html.RawHtml, Html.BuiltDateTime, Html.SavedDateTime, Html.ViewId, Html.SiteId, Html.Device, Html.Version, Html.LanguageId, Html.ViewBuilderHtmlXslt, Html.ViewBuilderPhoneHtmlXslt, View1.UseMultiThreading, View1.NumberOfThreads, View1.Cache, Html.TranslationDocument, Html.TranslationDocumentPhone, View1.MenuDescription from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html Html Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Sites Site On Html.SiteId = Site.SiteId and Site.SiteId = 1 Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Views View1 On View1.ViewId = Html.ViewId and ( Device ='All' Or Device = '' Or Device IS NULL) Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html_DefaultVersion DefaultHtml On Html.Version = DefaultHtml.DefaultVersion and Site.SiteId = DefaultHtml.SiteId AND Html.ViewId = DefaultHtml.ViewId where View1.ViewId = @ViewId AND Html.LanguageId = @LanguageId UNION ALL select 'D' as OrderByColumn, Html.Html, View1.ViewName, View1.Secured, View1.EnforceRoleSecurity, View1.UIType, View1.Template, Html.Title, View1.ScannerEventName, Html.DesignMode, Html.ViewBuilderHtml, Html.ViewBuilderPhoneHtml, Html.RawHtml, Html.BuiltDateTime, Html.SavedDateTime, Html.ViewId, Html.SiteId, Html.Device, Html.Version, Html.LanguageId, Html.ViewBuilderHtmlXslt, Html.ViewBuilderPhoneHtmlXslt, View1.UseMultiThreading, View1.NumberOfThreads, View1.Cache, Html.TranslationDocument, Html.TranslationDocumentPhone, View1.MenuDescription from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html Html Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Sites Site On Html.SiteId = Site.SiteId and Site.SiteId = 1 Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Views View1 On View1.ViewId = Html.ViewId and ( Device ='All' Or Device = '' Or Device IS NULL) where View1.ViewId = @ViewId and Html.Version = (select min(version) from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html where SiteId = 1) AND Html.LanguageId = @LanguageId order by OrderByColumn. Error: Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. See inner exception for stack trace. ---> System.Data.SqlClient.SqlException: Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. 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 KRise.EASYProcess.Tools.EP.DatabaseAgent.InquireOneRow(Query query) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\EP\DatabaseAgent.cs:line 399 --- End of inner exception stack trace --- at KRise.EASYProcess.Tools.EP.DatabaseAgent.InquireOneRow(Query query) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\EP\DatabaseAgent.cs:line 419 at KRise.EASYProcess.MVC.View.InquireViewHtml(String viewId, EPContext epContext, Boolean isTemplate) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\MVC\View.cs:line 673 at KRise.EASYProcess.MVC.View..ctor(String viewId, EPContext epContext, Log parentLog, Boolean isTemplate, Boolean ignoreSSL, KViewController kvc) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\MVC\View.cs:line 366 at EASYProcessEnterpriseServer.Service.GetMVCHtml(EPMessage& message, Log& log, Dictionary`2& cachesToSave, List`1& languageUtilityToCleanUp, ProcessHtml& process) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\EASYProcessEnterpriseServer\Service.cs:line 3598 : Error in query. Query:select 'B' as OrderByColumn, Html.Html, View1.ViewName, View1.Secured, View1.EnforceRoleSecurity, View1.UIType, View1.Template, Html.Title, View1.ScannerEventName, Html.DesignMode, Html.ViewBuilderHtml, Html.ViewBuilderPhoneHtml, Html.RawHtml, Html.BuiltDateTime, Html.SavedDateTime, Html.ViewId, Html.SiteId, Html.Device, Html.Version, Html.LanguageId, Html.ViewBuilderHtmlXslt, Html.ViewBuilderPhoneHtmlXslt, View1.UseMultiThreading, View1.NumberOfThreads, View1.Cache, Html.TranslationDocument, Html.TranslationDocumentPhone, View1.MenuDescription from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html Html Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Sites Site On Html.SiteId = Site.SiteId and Site.SiteId = 1 Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Views View1 On View1.ViewId = Html.ViewId and ( Device ='All' Or Device = '' Or Device IS NULL) Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html_DefaultVersion DefaultHtml On Html.Version = DefaultHtml.DefaultVersion and Site.SiteId = DefaultHtml.SiteId AND Html.ViewId = DefaultHtml.ViewId where View1.ViewId = @ViewId AND Html.LanguageId = @LanguageId UNION ALL select 'D' as OrderByColumn, Html.Html, View1.ViewName, View1.Secured, View1.EnforceRoleSecurity, View1.UIType, View1.Template, Html.Title, View1.ScannerEventName, Html.DesignMode, Html.ViewBuilderHtml, Html.ViewBuilderPhoneHtml, Html.RawHtml, Html.BuiltDateTime, Html.SavedDateTime, Html.ViewId, Html.SiteId, Html.Device, Html.Version, Html.LanguageId, Html.ViewBuilderHtmlXslt, Html.ViewBuilderPhoneHtmlXslt, View1.UseMultiThreading, View1.NumberOfThreads, View1.Cache, Html.TranslationDocument, Html.TranslationDocumentPhone, View1.MenuDescription from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html Html Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Sites Site On Html.SiteId = Site.SiteId and Site.SiteId = 1 Join EP_Platform_DV.AWSEast_MVCMockups_System.MVC_Views View1 On View1.ViewId = Html.ViewId and ( Device ='All' Or Device = '' Or Device IS NULL) where View1.ViewId = @ViewId and Html.Version = (select min(version) from EP_Platform_DV.AWSEast_MVCMockups_System.MVC_View_Html where SiteId = 1) AND Html.LanguageId = @LanguageId order by OrderByColumn. Error: Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. See inner exception for stack trace. Exception Data: Inner Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. 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 KRise.EASYProcess.Tools.EP.DatabaseAgent.InquireOneRow(Query query) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\EP\DatabaseAgent.cs:line 399 ClientConnectionId:59aac2a8-b3ff-44c3-9daf-4f78badb0d33 Error Number:207,State:1,Class:16 : Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. Invalid column name 'ViewBuilderHtmlXslt'. Invalid column name 'ViewBuilderPhoneHtmlXslt'. Invalid column name 'UseMultiThreading'. Invalid column name 'NumberOfThreads'. Invalid column name 'Cache'. Invalid column name 'TranslationDocument'. Invalid column name 'TranslationDocumentPhone'. Invalid column name 'MenuDescription'. Exception Data: HelpLink.ProdName: Microsoft SQL Server HelpLink.ProdVer: 14.00.3281 HelpLink.EvtSrc: MSSQLServer HelpLink.EvtID: 207 HelpLink.BaseHelpUrl: http://go.microsoft.com/fwlink HelpLink.LinkId: 20476 Stack Trace: at KRise.EASYProcess.Tools.EP.DatabaseAgent.InquireOneRow(Query query) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\EP\DatabaseAgent.cs:line 419 at KRise.EASYProcess.MVC.View.InquireViewHtml(String viewId, EPContext epContext, Boolean isTemplate) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\MVC\View.cs:line 673 at KRise.EASYProcess.MVC.View..ctor(String viewId, EPContext epContext, Log parentLog, Boolean isTemplate, Boolean ignoreSSL, KViewController kvc) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\MVC\View.cs:line 366 at EASYProcessEnterpriseServer.Service.GetMVCHtml(EPMessage& message, Log& log, Dictionary`2& cachesToSave, List`1& languageUtilityToCleanUp, ProcessHtml& process) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\EASYProcessEnterpriseServer\Service.cs:line 3598 Inner Exception: 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 KRise.EASYProcess.Tools.EP.DatabaseAgent.InquireOneRow(Query query) in C:\EASYProcess\EPSources\Git\EASYProcess5_RunTime\EP\DatabaseAgent.cs:line 399