Base solution for your next web application
Ends in:
01 DAYS
01 HRS
01 MIN
01 SEC
Open Closed

error in generated project #4515

User avatar
0
avanekar02 created

i generate a app using "DEVELOPING STEP BY STEP CORE" but i get this error when dashboard loads , also i tried to proceed with phonebook i get these errors.

please assist me with this.

regards vanekar

Go to accepted answer
5 Answer(s)
  • User Avatar
    0
    aaron created
    Support Team

    Check the error in Logs.txt.

  • User Avatar
    0
    avanekar02 created

    (Noor.ClassMateDemo.Application) with arguments (Noor.ClassMateDemo.Notifications.Dto.GetUserNotificationsInput) - ModelState is Valid ERROR 2018-01-16 22:27:39,567 [21 ] Mvc.ExceptionHandling.AbpExceptionFilter - Incorrect syntax near 'OFFSET'. Invalid usage of the option NEXT in the FETCH statement. System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'OFFSET'. Invalid usage of the option NEXT in the FETCH statement. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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) 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, TaskCompletionSource1 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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(Boolean buffer) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_02.<Execute>b__0(DbContext c, TState s) at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, Func2 operation, Func2 verifySucceeded, TState state) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_TrackEntities>d__172.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Abp.Notifications.NotificationStore.GetUserNotificationsWithNotificationsAsync(UserIdentifier user, Nullable1 state, Int32 skipCount, Int32 maxResultCount) at Castle.Proxies.NotificationStoreProxy.GetUserNotificationsWithNotificationsAsync_callback(UserIdentifier user, Nullable1 state, Int32 skipCount, Int32 maxResultCount) at Castle.Proxies.Invocations.NotificationStore_GetUserNotificationsWithNotificationsAsync.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformAsyncUow(IInvocation invocation, UnitOfWorkOptions options) at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformUow(IInvocation invocation, UnitOfWorkOptions options) at Abp.Domain.Uow.UnitOfWorkInterceptor.Intercept(IInvocation invocation) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.NotificationStoreProxy.GetUserNotificationsWithNotificationsAsync(UserIdentifier user, Nullable1 state, Int32 skipCount, Int32 maxResultCount) at Abp.Notifications.UserNotificationManager.<GetUserNotificationsAsync>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Noor.ClassMateDemo.Notifications.NotificationAppService.<GetUserNotifications>d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at lambda_method(Closure , Object ) at Microsoft.Extensions.Internal.ObjectMethodExecutorAwaitable.Awaiter.GetResult() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeActionMethodAsync>d__12.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__14.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextExceptionFilterAsync>d__23.MoveNext() ClientConnectionId:1fd8bf50-ebde-4a7d-a275-b679f713d553 Error Number:102,State:1,Class:15 INFO 2018-01-16 22:27:39,759 [21 ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext. INFO 2018-01-16 22:27:39,767 [21 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Notifications.NotificationAppService.GetUserNotifications (Noor.ClassMateDemo.Application) in 1648.8107ms INFO 2018-01-16 22:27:39,768 [21 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 1674.7261ms 500 application/json; charset=utf-8 INFO 2018-01-16 22:27:40,006 [20 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Authorization.Users.UserLinkAppService.GetRecentlyUsedLinkedUsers (Noor.ClassMateDemo.Application) with arguments ((null)) - ModelState is Valid INFO 2018-01-16 22:27:41,449 [3 ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext. INFO 2018-01-16 22:27:41,467 [3 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Authorization.Users.UserLinkAppService.GetRecentlyUsedLinkedUsers (Noor.ClassMateDemo.Application) in 3348.449ms INFO 2018-01-16 22:27:41,467 [3 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 3373.7901ms 200 application/json; charset=utf-8 INFO 2018-01-16 22:27:43,537 [19 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/api/services/app/TenantDashboard/GetWorldMap?input=%5Bobject%20Object%5D">http://localhost:62114/api/services/app ... 0Object%5D</a> application/json INFO 2018-01-16 22:27:43,543 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:43,543 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:43,543 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:43,551 [19 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Tenants.Dashboard.TenantDashboardAppService.GetWorldMap (Noor.ClassMateDemo.Application) with arguments (Noor.ClassMateDemo.Tenants.Dashboard.Dto.GetWorldMapInput) - ModelState is Valid INFO 2018-01-16 22:27:43,553 [19 ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext. INFO 2018-01-16 22:27:43,557 [19 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Tenants.Dashboard.TenantDashboardAppService.GetWorldMap (Noor.ClassMateDemo.Application) in 12.0941ms INFO 2018-01-16 22:27:43,557 [19 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 20.5247ms 200 application/json; charset=utf-8 INFO 2018-01-16 22:27:47,676 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/App/ClassMate">http://localhost:62114/App/ClassMate</a> INFO 2018-01-16 22:27:47,681 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:47,681 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:47,682 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,075 [8 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Web.Areas.App.Controllers.ClassMateController.Index (Noor.ClassMateDemo.Web.Mvc) with arguments (Noor.ClassMateDemo.ClassMate.Dto.GetPeopleInput) - ModelState is Valid INFO 2018-01-16 22:27:48,475 [3 ] ViewFeatures.Internal.ViewResultExecutor - Executing ViewResult, running view at path /Areas/App/Views/ClassMate/Index.cshtml. INFO 2018-01-16 22:27:48,509 [19 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/api/services/app/TenantDashboard/GetWorldMap?input=%5Bobject%20Object%5D">http://localhost:62114/api/services/app ... 0Object%5D</a> application/json INFO 2018-01-16 22:27:48,514 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,514 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,514 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,524 [19 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Tenants.Dashboard.TenantDashboardAppService.GetWorldMap (Noor.ClassMateDemo.Application) with arguments (Noor.ClassMateDemo.Tenants.Dashboard.Dto.GetWorldMapInput) - ModelState is Valid INFO 2018-01-16 22:27:48,524 [19 ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext. INFO 2018-01-16 22:27:48,524 [19 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Tenants.Dashboard.TenantDashboardAppService.GetWorldMap (Noor.ClassMateDemo.Application) in 7.6863ms INFO 2018-01-16 22:27:48,524 [19 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 15.1058ms 200 application/json; charset=utf-8 INFO 2018-01-16 22:27:48,603 [8 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Web.Areas.App.Controllers.ClassMateController.Index (Noor.ClassMateDemo.Web.Mvc) in 919.5848ms INFO 2018-01-16 22:27:48,604 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 928.2793ms 200 text/html; charset=utf-8 INFO 2018-01-16 22:27:48,687 [4 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/Profile/GetProfilePicture?t=636517384685114246">http://localhost:62114/Profile/GetProfi ... 4685114246</a> INFO 2018-01-16 22:27:48,694 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,694 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,694 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,696 [4 ] uthorization.DefaultAuthorizationService - Authorization was successful for user: admin. INFO 2018-01-16 22:27:48,698 [4 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Web.Controllers.ProfileController.GetProfilePicture (Noor.ClassMateDemo.Web.Mvc) with arguments ((null)) - ModelState is Valid INFO 2018-01-16 22:27:48,736 [9 ] e.Mvc.Internal.VirtualFileResultExecutor - Executing FileResult, sending file as INFO 2018-01-16 22:27:48,738 [19 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Web.Controllers.ProfileController.GetProfilePicture (Noor.ClassMateDemo.Web.Mvc) in 43.1001ms INFO 2018-01-16 22:27:48,739 [19 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 52.4413ms 200 image/png INFO 2018-01-16 22:27:48,761 [4 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/AbpServiceProxies/GetAll?v=636517384274821317">http://localhost:62114/AbpServiceProxie ... 4274821317</a> INFO 2018-01-16 22:27:48,769 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,769 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,770 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,774 [4 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Abp.AspNetCore.Mvc.Proxying.AbpServiceProxiesController.GetAll (Abp.AspNetCore) with arguments (Abp.AspNetCore.Mvc.Proxying.ApiProxyGenerationModel) - ModelState is Valid INFO 2018-01-16 22:27:48,774 [4 ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext. INFO 2018-01-16 22:27:48,775 [4 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Abp.AspNetCore.Mvc.Proxying.AbpServiceProxiesController.GetAll (Abp.AspNetCore) in 2.3129ms INFO 2018-01-16 22:27:48,775 [4 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 14.2022ms 200 text/plain; charset=utf-8 INFO 2018-01-16 22:27:48,797 [20 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/AbpScripts/GetScripts?v=636517384274821317">http://localhost:62114/AbpScripts/GetSc ... 4274821317</a> INFO 2018-01-16 22:27:48,804 [20 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,804 [20 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,805 [20 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,806 [20 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Abp.AspNetCore.Mvc.Controllers.AbpScriptsController.GetScripts (Abp.AspNetCore) with arguments () - ModelState is Valid INFO 2018-01-16 22:27:48,863 [22 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/signalr/hubs">http://localhost:62114/signalr/hubs</a> INFO 2018-01-16 22:27:48,864 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/select2/dist/js/i18n/en.js">http://localhost:62114/lib/select2/dist/js/i18n/en.js</a> INFO 2018-01-16 22:27:48,864 [24 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/abp-web-resources/Abp/Framework/scripts/libs/abp.signalr.js">http://localhost:62114/lib/abp-web-reso ... signalr.js</a> INFO 2018-01-16 22:27:48,870 [22 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,870 [22 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,870 [22 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,871 [24 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,871 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,871 [22 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 7.7704ms 200 application/javascript; charset=UTF-8 INFO 2018-01-16 22:27:48,873 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,873 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,874 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 9.3764ms 404 INFO 2018-01-16 22:27:48,874 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/bootstrap-select/dist/js/i18n/defaults-en_US.js">http://localhost:62114/lib/bootstrap-se ... s-en_US.js</a> INFO 2018-01-16 22:27:48,882 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,882 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,883 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,883 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 8.9569ms 404 INFO 2018-01-16 22:27:48,885 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/timeago/locales/jquery.timeago.en.js">http://localhost:62114/lib/timeago/loca ... eago.en.js</a> INFO 2018-01-16 22:27:48,893 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,893 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,893 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,894 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 9.2336ms 404 INFO 2018-01-16 22:27:48,871 [24 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,899 [24 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,901 [24 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 36.5116ms 404 INFO 2018-01-16 22:27:48,918 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/famfamfam-flags/dist/sprite/famfamfam-flags.png">http://localhost:62114/lib/famfamfam-fl ... -flags.png</a> INFO 2018-01-16 22:27:48,920 [20 ] tCore.Mvc.Internal.ContentResultExecutor - Executing ContentResult with HTTP Response ContentType of application/x-javascript; charset=utf-8 INFO 2018-01-16 22:27:48,929 [24 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/view-resources/Areas/App/Views/ClassMate/Index.js?v=f8wPxe2feGxxWuMYj5vOLTzK1qJR_iBW1-_iIzfQ5CM">http://localhost:62114/view-resources/A ... -_iIzfQ5CM</a> INFO 2018-01-16 22:27:48,932 [23 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/font-awesome/fonts/fontawesome-webfont.woff2?v=4.7.0">http://localhost:62114/lib/font-awesome ... f2?v=4.7.0</a> INFO 2018-01-16 22:27:48,938 [24 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,938 [23 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,938 [24 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,938 [23 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,939 [24 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,939 [23 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,939 [24 ] NetCore.StaticFiles.StaticFileMiddleware - The file /view-resources/Areas/App/Views/ClassMate/Index.js was not modified INFO 2018-01-16 22:27:48,939 [24 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 9.8916ms 304 application/javascript INFO 2018-01-16 22:27:48,946 [23 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 13.5638ms 404 INFO 2018-01-16 22:27:48,949 [20 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Abp.AspNetCore.Mvc.Controllers.AbpScriptsController.GetScripts (Abp.AspNetCore) in 143.7618ms INFO 2018-01-16 22:27:48,952 [20 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 154.9659ms 200 application/x-javascript; charset=utf-8 INFO 2018-01-16 22:27:48,960 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,961 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,961 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:48,962 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 43.234ms 404 INFO 2018-01-16 22:27:49,160 [4 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/font-awesome/fonts/fontawesome-webfont.woff?v=4.7.0">http://localhost:62114/lib/font-awesome ... ff?v=4.7.0</a> INFO 2018-01-16 22:27:49,168 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,168 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,168 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,169 [4 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 8.8021ms 404 INFO 2018-01-16 22:27:49,722 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/font-awesome/fonts/fontawesome-webfont.ttf?v=4.7.0">http://localhost:62114/lib/font-awesome ... tf?v=4.7.0</a> INFO 2018-01-16 22:27:49,729 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,729 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,729 [8 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,730 [8 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 7.7236ms 404 INFO 2018-01-16 22:27:49,773 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/abp-web-resources/Abp/Framework/scripts/libs/abp.signalr.js">http://localhost:62114/lib/abp-web-reso ... signalr.js</a> INFO 2018-01-16 22:27:49,780 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,780 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,780 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,781 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 7.4605ms 404 INFO 2018-01-16 22:27:49,938 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/bootstrap-select/dist/js/i18n/defaults-en_US.js">http://localhost:62114/lib/bootstrap-se ... s-en_US.js</a> INFO 2018-01-16 22:27:49,953 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,953 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,954 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,954 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 16.0582ms 404 INFO 2018-01-16 22:27:49,973 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/timeago/locales/jquery.timeago.en.js">http://localhost:62114/lib/timeago/loca ... eago.en.js</a> INFO 2018-01-16 22:27:49,980 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,980 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,980 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:49,981 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 8.1719ms 404 INFO 2018-01-16 22:27:49,998 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/lib/select2/dist/js/i18n/en.js">http://localhost:62114/lib/select2/dist/js/i18n/en.js</a> INFO 2018-01-16 22:27:50,006 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,007 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,007 [9 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,007 [9 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 9.0308ms 404 INFO 2018-01-16 22:27:50,120 [3 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/api/services/app/UserLink/GetRecentlyUsedLinkedUsers">http://localhost:62114/api/services/app ... inkedUsers</a> application/json INFO 2018-01-16 22:27:50,122 [4 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/api/services/app/Notification/GetUserNotifications?maxResultCount=3">http://localhost:62114/api/services/app ... ultCount=3</a> application/json INFO 2018-01-16 22:27:50,127 [3 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,127 [3 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,127 [3 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,141 [3 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Authorization.Users.UserLinkAppService.GetRecentlyUsedLinkedUsers (Noor.ClassMateDemo.Application) with arguments ((null)) - ModelState is Valid INFO 2018-01-16 22:27:50,141 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,141 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,141 [4 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,155 [4 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Notifications.NotificationAppService.GetUserNotifications (Noor.ClassMateDemo.Application) with arguments (Noor.ClassMateDemo.Notifications.Dto.GetUserNotificationsInput) - ModelState is Valid INFO 2018-01-16 22:27:50,177 [19 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/api/services/app/Session/GetCurrentLoginInformations">http://localhost:62114/api/services/app ... formations</a> application/json INFO 2018-01-16 22:27:50,182 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,182 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,182 [19 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:27:50,255 [19 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Sessions.SessionAppService.GetCurrentLoginInformations (Noor.ClassMateDemo.Application) with arguments ((null)) - ModelState is Valid INFO 2018-01-16 22:27:50,276 [22 ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext. INFO 2018-01-16 22:27:50,276 [22 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Authorization.Users.UserLinkAppService.GetRecentlyUsedLinkedUsers (Noor.ClassMateDemo.Application) in 147.2849ms INFO 2018-01-16 22:27:50,277 [22 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 156.3769ms 200 application/json; charset=utf-8 ERROR 2018-01-16 22:27:50,440 [3 ] Mvc.ExceptionHandling.AbpExceptionFilter - Incorrect syntax near 'OFFSET'. Invalid usage of the option NEXT in the FETCH statement. System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'OFFSET'. Invalid usage of the option NEXT in the FETCH statement. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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) 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, TaskCompletionSource1 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.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader() at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary2 parameterValues) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.BufferlessMoveNext(Boolean buffer) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.<>c__DisplayClass12_02.<Execute>b__0(DbContext c, TState s) at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func3 operation, Func3 verifySucceeded) at Microsoft.EntityFrameworkCore.ExecutionStrategyExtensions.Execute[TState,TResult](IExecutionStrategy strategy, Func2 operation, Func2 verifySucceeded, TState state) at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable1.Enumerator.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.<_TrackEntities>d__172.MoveNext() at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor1.EnumeratorExceptionInterceptor.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source) at Abp.Notifications.NotificationStore.GetUserNotificationsWithNotificationsAsync(UserIdentifier user, Nullable1 state, Int32 skipCount, Int32 maxResultCount) at Castle.Proxies.NotificationStoreProxy.GetUserNotificationsWithNotificationsAsync_callback(UserIdentifier user, Nullable1 state, Int32 skipCount, Int32 maxResultCount) at Castle.Proxies.Invocations.NotificationStore_GetUserNotificationsWithNotificationsAsync.InvokeMethodOnTarget() at Castle.DynamicProxy.AbstractInvocation.Proceed() at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformAsyncUow(IInvocation invocation, UnitOfWorkOptions options) at Abp.Domain.Uow.UnitOfWorkInterceptor.PerformUow(IInvocation invocation, UnitOfWorkOptions options) at Abp.Domain.Uow.UnitOfWorkInterceptor.Intercept(IInvocation invocation) at Castle.DynamicProxy.AbstractInvocation.Proceed() at Castle.Proxies.NotificationStoreProxy.GetUserNotificationsWithNotificationsAsync(UserIdentifier user, Nullable1 state, Int32 skipCount, Int32 maxResultCount) at Abp.Notifications.UserNotificationManager.<GetUserNotificationsAsync>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter1.GetResult() at Noor.ClassMateDemo.Notifications.NotificationAppService.<GetUserNotifications>d__4.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at lambda_method(Closure , Object ) at Microsoft.Extensions.Internal.ObjectMethodExecutorAwaitable.Awaiter.GetResult() at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeActionMethodAsync>d__12.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeNextActionFilterAsync>d__10.MoveNext() --- End of stack trace from previous location where exception was thrown --- at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.<InvokeInnerFilterAsync>d__14.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.<InvokeNextExceptionFilterAsync>d__23.MoveNext() ClientConnectionId:4773d2f4-90d0-4fb6-a810-cb275bb371f6 Error Number:102,State:1,Class:15 INFO 2018-01-16 22:27:50,446 [3 ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext. INFO 2018-01-16 22:27:50,447 [3 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Notifications.NotificationAppService.GetUserNotifications (Noor.ClassMateDemo.Application) in 304.0326ms INFO 2018-01-16 22:27:50,447 [3 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 325.3584ms 500 application/json; charset=utf-8 INFO 2018-01-16 22:27:50,449 [20 ] etCore.Mvc.Internal.ObjectResultExecutor - Executing ObjectResult, writing value Microsoft.AspNetCore.Mvc.ControllerContext. INFO 2018-01-16 22:27:50,449 [20 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Sessions.SessionAppService.GetCurrentLoginInformations (Noor.ClassMateDemo.Application) in 265.5956ms INFO 2018-01-16 22:27:50,450 [20 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 272.8608ms 200 application/json; charset=utf-8 INFO 2018-01-16 22:29:19,623 [3 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 POST <a class="postlink" href="http://localhost:62114/App/ClassMate/CreatePersonModal">http://localhost:62114/App/ClassMate/CreatePersonModal</a> 0 INFO 2018-01-16 22:29:19,628 [3 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:19,628 [3 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:19,628 [3 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:19,645 [3 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.Web.Areas.App.Controllers.ClassMateController.CreatePersonModal (Noor.ClassMateDemo.Web.Mvc) with arguments ((null)) - ModelState is Valid INFO 2018-01-16 22:29:19,871 [4 ] tures.Internal.PartialViewResultExecutor - Executing PartialViewResult, running view at path /Areas/App/Views/ClassMate/_CreatePersonModal.cshtml. INFO 2018-01-16 22:29:20,325 [4 ] ore.Mvc.Internal.ControllerActionInvoker - Executed action Noor.ClassMateDemo.Web.Areas.App.Controllers.ClassMateController.CreatePersonModal (Noor.ClassMateDemo.Web.Mvc) in 693.0222ms INFO 2018-01-16 22:29:20,325 [4 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 701.7094ms 200 text/html; charset=utf-8 INFO 2018-01-16 22:29:20,335 [30 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 GET <a class="postlink" href="http://localhost:62114/view-resources/Areas/App/Views/ClassMate/CreatePersonModal.js?=1516121869455">http://localhost:62114/view-resources/A ... 6121869455</a> INFO 2018-01-16 22:29:20,343 [30 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:20,344 [30 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:20,344 [30 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:20,346 [30 ] NetCore.StaticFiles.StaticFileMiddleware - Sending file. Request path: '/view-resources/Areas/App/Views/ClassMate/_CreatePersonModal.js'. Physical path: 'E:\ClassMateDemo\src\Noor.ClassMateDemo.Web.Mvc\wwwroot\view-resources\Areas\App\Views\ClassMate_CreatePersonModal.js' INFO 2018-01-16 22:29:20,353 [30 ] soft.AspNetCore.Hosting.Internal.WebHost - Request finished in 17.9552ms 200 application/javascript INFO 2018-01-16 22:29:34,030 [30 ] soft.AspNetCore.Hosting.Internal.WebHost - Request starting HTTP/1.1 POST <a class="postlink" href="http://localhost:62114/api/services/app/Person/CreatePerson">http://localhost:62114/api/services/app ... eatePerson</a> application/json 66 INFO 2018-01-16 22:29:34,040 [30 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:34,040 [30 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:34,040 [30 ] tion.Cookies.CookieAuthenticationHandler - AuthenticationScheme: Identity.Application was successfully authenticated. INFO 2018-01-16 22:29:34,166 [30 ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method Noor.ClassMateDemo.ClassMate.PersonAppService.CreatePerson (Noor.ClassMateDemo.Application) with arguments (Noor.ClassMateDemo.ClassMate.Dto.CreatePersonInput) - ModelState is Valid ERROR 2018-01-16 22:29:34,451 [31 ] Mvc.ExceptionHandling.AbpExceptionFilter - Unmapped members were found. Review the types and members below. Add a custom mapping expression, ignore, add a custom resolver, or modify the source/destination type For no matching constructor, add a no-arg ctor, add optional arguments, or map all of the constructor parameters

    CreatePersonInput -> Person (Destination member list) Noor.ClassMateDemo.ClassMate.Dto.CreatePersonInput -> Noor.ClassMateDemo.ClassMate.Person (Destination member list)

    Unmapped properties: IsDeleted DeleterUserId DeletionTime LastModificationTime LastModifierUserId CreationTime CreatorUserId Id

    AutoMapper.AutoMapperConfigurationException: Unmapped members were found. Review the types and members below. Add a custom mapping expression, ignore, add a custom resolver, or modify the source/destination type For no matching constructor, add a no-arg ctor, add optional arguments, or map all of the constructor parameters

    CreatePersonInput -> Person (Destination member list) Noor.ClassMateDemo.ClassMate.Dto.CreatePersonInput -> Noor.ClassMateDemo.ClassMate.Person (Destination member list)

    Unmapped properties: IsDeleted DeleterUserId DeletionTime LastModificationTime LastModifierUserId CreationTime CreatorUserId Id

    at AutoMapper.ConfigurationValidator.AssertConfigurationIsValid(IEnumerable`1 typeMaps) at AutoMapper.MapperConfiguration.AssertConfigurationIsValid(TypeMap typeMap) at lambda_method(Closure , CreatePersonInput , Person , ResolutionContext ) at lambda_method(Closure , Object , Object , ResolutionContext ) at AutoMapper.Mapper.AutoMapper.IMapper.Map[TDestination](Object source) at Abp.AutoMapper.AutoMapperObjectMapper.Map[TDestination](Object source) at Noor.ClassMateDemo.ClassMate.PersonAppService.

  • User Avatar
    0
    aaron created
    Support Team

    ERROR 2018-01-16 22:27:39,567 [21 ] Mvc.ExceptionHandling.AbpExceptionFilter - Incorrect syntax near 'OFFSET'. Invalid usage of the option NEXT in the FETCH statement.

    Duplicate of #3380@6e406c7e-ef7e-4018-8495-c11435829223

    which db do you use ? Can you write it's version as well like SQL Server 2012 ?

    The SQL version is: SQL Server R2 2008. I have found out however that some features are not supported by the 2008 such as Take and Skip. This was what caused the 500 Error.

  • User Avatar
    0
    ferventcoder created

    For SQL Server 2008, what I've done is the following:

    • Find the EntityFrameworkCore project
    • Open {Name}DbContextConfigurer.cs
    • Change
    builder.UseSqlServer(connectionString);

    and

    builder.UseSqlServer(connection);

    to

    builder.UseSqlServer(connectionString, s => s.UseRowNumberForPaging());

    and

    builder.UseSqlServer(connection, s => s.UseRowNumberForPaging());

    See [https://github.com/aspnet/EntityFrameworkCore/issues/4616#issuecomment-221331425]) for details.

  • User Avatar
    0
    ismcagdas created
    Support Team

    @ferventcoder thanks a lot for sharing this :).

Assignee
No one
Labels
None yet