[BEXIS2-Dev] Upgrade from 2.11 to 2.11.1 View dataset SQL error

[bexis2-dev at listserv.uni-jena.de]

Hi,

I am trying to update from 2.11 to 2.11.1. After replacing the Postsharp.dll with version 5.0.44 it starts now (see previous message).

When I am trying to view a dataset I get a HTTP 500 due to an SQL error (see below). Do I need to execute something to update my database?

PostgresException (0x80004005): 42P01: Relation »mvdataset8« existiert nicht]
   Npgsql.<DoReadMessage>d__148.MoveNext() +188
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +99
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +61
   System.Runtime.CompilerServices.ValueTaskAwaiter`1.GetResult() +65
   Npgsql.<ReadMessage>d__147.MoveNext() +463
   Npgsql.<ReadMessage>d__147.MoveNext() +750
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +99
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +61
   System.Runtime.CompilerServices.ValueTaskAwaiter`1.GetResult() +65
   Npgsql.<ReadExpecting>d__154`1.MoveNext() +404
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +99
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +61
   System.Runtime.CompilerServices.ValueTaskAwaiter`1.GetResult() +65
   Npgsql.<NextResult>d__32.MoveNext() +1823
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +99
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +61
   Npgsql.NpgsqlDataReader.NextResult() +167
   Npgsql.<Execute>d__71.MoveNext() +1201
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +99
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +61
   System.Runtime.CompilerServices.ValueTaskAwaiter`1.GetResult() +65
   Npgsql.<ExecuteDbDataReader>d__92.MoveNext() +351
   System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) +99
   System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) +61
   System.Runtime.CompilerServices.ValueTaskAwaiter`1.GetResult() +65
   Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +207
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +12
   Vaiona.PersistenceProviders.NH.NHibernateUnitOfWork.ExecuteQuery(String queryString, Dictionary`2 parameters) +944

[Exception: Failed for execute the submitted native query.  Reason: '42P01: Relation »mvdataset8« existiert nicht']
   Vaiona.PersistenceProviders.NH.NHibernateUnitOfWork.ExecuteQuery(String queryString, Dictionary`2 parameters) +1229
   BExIS.Dlm.Orm.NH.Utils.MaterializedViewHelper.retrieve(String queryStr, Int64 datasetId) in D:\BEXIS APP\GIT\Code\Components\DLM\BExIS.Dlm.Orm.NH\Utils\MaterializedViewHelper.cs:50

[Exception: Could not retrieve data from dataset 8. Check whether the corresponding view exists and is populated with data.]
   BExIS.Dlm.Services.Data.DatasetManager.GetLatestDatasetVersionTuples(Int64 datasetId, Int32 pageNumber, Int32 pageSize, Boolean useFallback) in D:\BEXIS APP\GIT\Code\Components\DLM\BExIS.Dlm.Services\Data\DatasetManager.cs:796
   BExIS.Modules.Ddm.UI.Controllers.DataController.ShowPrimaryData(Int64 datasetID) in D:\BEXIS APP\GIT\Code\Console\BExIS.Web.Shell\Areas\DDM\Controllers\DataController.cs:259
   lambda_method(Closure , ControllerBase , Object[] ) +100
   System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +14
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +157
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
   System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +22
   System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +32
   System.Web.Mvc.Async.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d() +50
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +228
   System.Web.Mvc.Async.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +34
   System.Web.Mvc.Async.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() +26
   System.Web.Mvc.Async.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult) +100
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +27
   System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +13
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +36
   System.Web.Mvc.Controller.<BeginExecute>b__15(IAsyncResult asyncResult, Controller controller) +12
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +22
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +26
   System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) +10
   System.Web.Mvc.MvcHandler.<BeginProcessRequest>b__5(IAsyncResult asyncResult, ProcessRequestState innerState) +21
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +29
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +49
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +28
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +9748665
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +48
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +159


Thans

Johannes
-------------- nächster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <https://lserv.uni-jena.de/pipermail/bexis2-dev/attachments/20180301/ad0f689c/attachment-0001.html>