Server Error in '/' Application.

Invalid column name 'JobTypeId'.

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.SqlClient.SqlException: Invalid column name 'JobTypeId'.

Source Error:


Line 115:        string catsDescriptions = String.Empty;
Line 116:        string locsDescriptions = String.Empty;
Line 117:        VacancyEntity vacancy = new VacancyEntity(Senior.Utils.DataUtil.SafeInt32(idataRecord["Id"]));
Line 118:        //SeniorCMS.BLL.Modules.Vacancy.VacancyHelper.GetCategoriesAndLocations(vacancy, out catsDescriptions, out locsDescriptions);
Line 119:        litCategories.Text = catsDescriptions;

Source File: e:\websites\WebApps\bpca.org.uk\web\ModuleLayoutTemplates\Content\VacancyCatalog\Default\ItemList.ascx.cs    Line: 117

Stack Trace:


[SqlException (0x80131904): Invalid column name 'JobTypeId'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +277
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +765
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4616
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +88
   System.Data.SqlClient.SqlDataReader.get_MetaData() +103
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +621
   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) +3382
   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) +707
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +302
   SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) +114

[ORMQueryExecutionException: An exception was caught during the execution of a retrieval query: Invalid column name 'JobTypeId'.. Check InnerException, QueryExecuted and Parameters of this exception to examine the cause of this exception.]
   SD.LLBLGen.Pro.ORMSupportClasses.RetrievalQuery.Execute(CommandBehavior behavior) +543
   SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.ExecuteSingleRowRetrievalQuery(IRetrievalQuery queryToExecute, ITransaction containingTransaction, IEntityFields fieldsToFill, IFieldPersistenceInfo[] fieldPersistenceInfos) +326
   SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.PerformFetchEntityAction(IEntity entityToFetch, ITransaction containingTransaction, IPredicateExpression selectFilter, IPrefetchPath prefetchPathToUse, Context contextToUse, ExcludeIncludeFieldsList excludedIncludedFields) +674
   SD.LLBLGen.Pro.ORMSupportClasses.DaoBase.FetchExisting(IEntity entityToFetch, ITransaction containingTransaction, IPrefetchPath prefetchPathToUse, Context contextToUse, ExcludeIncludeFieldsList excludedIncludedFields) +105
   SeniorCMS.DAL.EntityClasses.VacancyEntity.Fetch(Int32 id, IPrefetchPath prefetchPathToUse, Context contextToUse, ExcludeIncludeFieldsList excludedIncludedFields) +305
   SeniorCMS.DAL.EntityClasses.VacancyEntity.InitClassFetch(Int32 id, IValidator validator, IPrefetchPath prefetchPathToUse) +180
   SeniorCMS.DAL.EntityClasses.VacancyEntity..ctor(Int32 id) +72
   ModuleLayoutTemplates_Content_VacancyCatalog_Default_ItemList.ProcessRepeaterItem(Object sender, RepeaterItemEventArgs e) in e:\websites\WebApps\bpca.org.uk\web\ModuleLayoutTemplates\Content\VacancyCatalog\Default\ItemList.ascx.cs:117
   CoreCode_Modules_Content_VacancyCatalog_LayoutTemplates_ItemList.rptVacancy_OnItemDataBound(Object sender, RepeaterItemEventArgs e) in e:\websites\WebApps\bpca.org.uk\web\CoreCode\Modules\Content\VacancyCatalog\LayoutTemplates\ItemList.ascx.cs:111
   System.Web.UI.WebControls.Repeater.OnItemDataBound(RepeaterItemEventArgs e) +138
   System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +194
   System.Web.UI.WebControls.Repeater.AddDataItemsIntoItemsArray(IEnumerable dataSource, Boolean useDataSource) +297
   System.Web.UI.WebControls.Repeater.PostGetDataAction(IEnumerable dataSource) +113
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +80
   System.Web.UI.Control.DataBindChildren() +249
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +191
   CoreCode_Modules_Content_VacancyCatalog_LayoutTemplates_ItemList.Populate(Object parent, Object dataSource, Int32 pageNumber, Int32 totalNumberOfItems) in e:\websites\WebApps\bpca.org.uk\web\CoreCode\Modules\Content\VacancyCatalog\LayoutTemplates\ItemList.ascx.cs:123
   ModuleLayoutTemplates_Content_VacancyCatalog_Default_ItemList.Populate(Object parent, Object dataSource, Int32 pageNumber, Int32 totalNumberOfItems) in e:\websites\WebApps\bpca.org.uk\web\ModuleLayoutTemplates\Content\VacancyCatalog\Default\ItemList.ascx.cs:36
   SeniorCMS.BLL.Templating.Modules.CatalogModuleListTemplate.BasePopulate(Object parent, Object dataSource, Int32 pageNumber, Int32 totalNumberOfItems) +128
   SeniorCMS.BLL.Templating.Modules.CatalogModuleListTemplate.BasePopulate(Object parent, Object dataSource, Int32 totalNumberOfItems) +126
   CoreCode_Modules_Content_VacancyCatalog_VacancyCatalog_FrontEnd.ShowVacancies(Nullable`1 chosenCategory) in e:\websites\WebApps\bpca.org.uk\web\CoreCode\Modules\Content\VacancyCatalog\VacancyCatalog_FrontEnd.ascx.cs:235
   CoreCode_Modules_Content_VacancyCatalog_VacancyCatalog_FrontEnd.OnLoad(EventArgs e) in e:\websites\WebApps\bpca.org.uk\web\CoreCode\Modules\Content\VacancyCatalog\VacancyCatalog_FrontEnd.ascx.cs:138
   System.Web.UI.Control.LoadRecursive() +154
   System.Web.UI.Control.AddedControl(Control control, Int32 index) +642
   SeniorCMS.BLL.ModuleFramework.ModuleViewControlBase.AddUserControlToPlaceHolder(String viewControlUrl, Control placeHolder) +547
   SeniorCMS.BLL.ModuleFramework.ModuleViewControlBase.CreateViewUserControl(ModuleViewType viewType) +1296
   SeniorCMS.BLL.ModuleFramework.ModuleViewControlBase.CreateChildControls() +287
   System.Web.UI.Control.EnsureChildControls() +130
   System.Web.UI.Control.PreRenderRecursiveInternal() +66
   System.Web.UI.Control.PreRenderRecursiveInternal() +297
   System.Web.UI.Control.PreRenderRecursiveInternal() +297
   System.Web.UI.Control.PreRenderRecursiveInternal() +297
   System.Web.UI.Control.PreRenderRecursiveInternal() +297
   System.Web.UI.Control.PreRenderRecursiveInternal() +297
   System.Web.UI.Control.PreRenderRecursiveInternal() +297
   System.Web.UI.Control.PreRenderRecursiveInternal() +297
   System.Web.UI.<PreRenderRecursiveInternalAsync>d__249.MoveNext() +1442
   System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() +32
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +62
   System.Web.Util.WithinCancellableCallbackTaskAwaiter.GetResult() +32
   System.Web.UI.<ProcessRequestMainAsync>d__523.MoveNext() +11467


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4700.0