Activities of "riaan"

Hi @ismcagdas,

The assistance you provided in solving the "INTERNAL SERVER ERROR" was invaluable and solved our 1st issue :)

Thanks for the feedback. I will look at the HTTPS redirects as suggested.

Kind Regards,

Riaan

Hi,

I've migrated the v4.1.1 code into my current application but encountered an Internal Server Error in the Host Admin Site. Thinking I made a mistake, I've downloaded the latest v4.1.1 code and ran it as a clean installation (without any modifications) and still encountered the Internal Server Error when signing into the Host Admin site.

Below traces of the web requests that gives the Internal Server Error, as well as a log extract, and the code portion I was able to trace where the exception occurs.

HTTP/1.1 500 Internal Server Error
Transfer-Encoding: chunked
Content-Type: application/json; charset=utf-8
Server: Kestrel
X-SourceFiles: =?UTF-8?B?QzpcVGVtcFxhc3BuZXQtY29yZVxzcmNcTXlDb21wYW55TmFtZS5BYnBaZXJvVGVtcGxhdGUuV2ViLk12Y1xhcGlcc2VydmljZXNcYXBwXFRlbmFudFxHZXRUZW5hbnRz?=
X-Powered-By: ASP.NET
Date: Tue, 27 Jun 2017 20:58:55 GMT

cf
{"result":null,"targetUrl":null,"success":false,"error":{"code":0,"message":"An internal error occurred during your request!","details":null,"validationErrors":null},"unAuthorizedRequest":false,"__abp":true}
0

INFO  2017-06-27 22:24:54,089 [93   ] ore.Mvc.Internal.ControllerActionInvoker - Executing action method MyCompany.AbpZeroTemplate.MultiTenancy.HostDashboard.HostDashboardAppService.GetDashboardStatisticsData (MyCompany.AbpZeroTemplate.Application) with arguments (MyCompany.AbpZeroTemplate.MultiTenancy.HostDashboard.Dto.GetDashboardDataInput) - ModelState is Valid
ERROR 2017-06-27 22:24:55,420 [102  ] Mvc.ExceptionHandling.AbpExceptionFilter - Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.
System.Data.SqlClient.SqlException: Incorrect syntax near 'OFFSET'.
Invalid usage of the option NEXT in the FETCH statement.
   at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__107_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.<ExecuteAsync>d__26.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable.AsyncEnumerator.<BufferlessMoveNext>d__9.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Storage.Internal.SqlServerExecutionStrategy.<ExecuteAsync>d__6`2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncQueryingEnumerable.AsyncEnumerator.&lt;MoveNext&gt;d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.SelectAsyncEnumerable`2.SelectAsyncEnumerator.<MoveNext>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.SelectAsyncEnumerable`2.SelectAsyncEnumerator.&lt;MoveNext&gt;d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.Query.Internal.AsyncLinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.<MoveNext>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.<ToListAsync>d__129`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()
   at MyCompany.AbpZeroTemplate.Authorization.Users.UserLinkAppService.<GetRecentlyUsedLinkedUsers>d__8.MoveNext() in MyCompany.AbpZeroTemplate.Application\Authorization\Users\UserLinkAppService.cs:line 95
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.AspNetCore.Mvc.Internal.ObjectMethodExecutor.<CastToObject>d__38`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.&lt;InvokeActionMethodAsync&gt;d__27.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.&lt;InvokeNextActionFilterAsync&gt;d__25.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   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.&lt;InvokeNextExceptionFilterAsync&gt;d__24.MoveNext()
ClientConnectionId:f4add014-f6fe-4e6c-a301-971708f04b74
Error Number:102,State:1,Class:15

I was able to trace the exception to this section of the code:

public async Task<GetNotificationsOutput> GetUserNotifications(GetUserNotificationsInput input)
        {
            var totalCount = await _userNotificationManager.GetUserNotificationCountAsync(
                AbpSession.ToUserIdentifier(), input.State
                );

            var unreadCount = await _userNotificationManager.GetUserNotificationCountAsync(
                AbpSession.ToUserIdentifier(), UserNotificationState.Unread
                );

            var notifications = await _userNotificationManager.GetUserNotificationsAsync(
                AbpSession.ToUserIdentifier(), input.State, input.SkipCount, input.MaxResultCount
                );  // <-- This is where the exception occurs

            return new GetNotificationsOutput(totalCount, unreadCount, notifications);
        }

Any assistance would be appreciated

Thanks,

Riaan

Hi,

Herewith my SQL version

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64) Mar 29 2009 10:11:52 Copyright (c) 1988-2008 Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

Thanks.

I will upgrade to a newer version. Luckily my other dev machine and our production environment is on a higher version of SQL.

Thanks for the assistance.

Riaan

Success !!! Upgraded SQL 2008 to SQL 2014 and the Internal Server Error issue has been resolved. Thanks for the assistance.

Riaan

Hi,

I've just upgraded our site to 4.1.4 with the new public website. After logging in form the public website I'm redirected back to the public website. Is this correct? Since the App site is running on a different port, should I not be redirected there after login, or must I do it myself (and how)?

(or is there something wrong with my setup?)

Hi,

Thanks for the reply.

The issue I have is that after the user signs in from the public website (although the publi and admin function as one) he is redirected to the public website after a successful sign in. From the public website, the user can then only sign out. There is no way for him to get to the Admin site unless he changes the url in the browser manually to the admin site url:port. Should one not be able to browse from the public site to the admin site after login, even if redirected to the public site, or am I missing something?

Thanks Matt, for the feedback and solution.

:D

Hi,

I want to create menu items for the ASPNETZERO CORE MVC/JQUERY Public wesite similar to those of <a class="postlink" href="http://www.aspnetzero.com">http://www.aspnetzero.com</a>.

For example, if the user clicks on the "About" menu item, it should scroll to the About section on the HomePage, same with the "Packages" menu.

Herewith my current FrontEndNavigationProvider. Each menu item is currently its own page (which is working as expected).

//HOME
                .AddItem(new MenuItemDefinition(
                    FrontEndPageNames.Home,
                    L("HomePage"),
                    url: ""
                    )

                //ABOUT - Should navigate to ABOUT section in HomePage
                ).AddItem(new MenuItemDefinition(
                    FrontEndPageNames.About,
                    L("AboutPage"),
                    url: "About"
                    )

                //PACKAGES - Should navigate to PACKAGES section in HomePage
                ).AddItem(new MenuItemDefinition(
                    FrontEndPageNames.Packages,
                    L("PackagesPage"),
                    url: "Packages"
                    )

                //CONTACT 
                ).AddItem(new MenuItemDefinition(
                    FrontEndPageNames.Contact,
                    L("ContactPage"),
                    url: "Contact"
                    )

Thanks in advance,

Riaan

@ismcagdas, thank you very much for this. :D I will look into the theme