Can't complete upgrade v09.05.01

[jaxuk]

I've got an issue completing an upgrade to v09.05.01 on DNN 9.01.01

I see the message:

Error: System.Exception: Module upgrade did not complete (read more). Click to complete:

After click the "complete upgrade" button and clicking "ok" on the dialog I see the following error in console: GET http://ikon911.me/API/2sxc/view/module/finishinstallation 400 (Bad Request)

Response from the server is:

{"Message":"Bad Request","ExceptionMessage":"Sequence contains no elements","ExceptionType":"System.InvalidOperationException","StackTrace":" at System.Linq.Enumerable.Single[TSource](IEnumerable1 source)\r\n at lambda_method(Closure , QueryContext )\r\n at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass20_01.b0(QueryContext qc)\r\n at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.AttributeId(Int32 setId, String staticName) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 57\r\n at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.GetOrCreateAttributeDefinition(Int32 contentTypeId, AttributeDefinition newAtt) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 45\r\n at ToSic.Eav.Repository.Efc.Parts.DbContentType.ExtendSaveContentTypes(ContentType contentType, SaveOptions saveOptions) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbContentType_Modify.cs:line 113\r\n at System.Collections.Generic.List1.ForEach(Action1 action)\r\n at ToSic.Eav.Repository.Efc.Parts.DbRelationship.DoWhileQueueingRelationships(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbRelationship.cs:line 22\r\n at ToSic.Eav.Repository.Efc.Parts.DbContentType.ExtendSaveContentTypes(List`1 contentTypes, SaveOptions saveOptions) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbContentType_Modify.cs:line 99\r\n at ToSic.Eav.Apps.ImportExport.Import.<>cDisplayClass7_0.b2()\r\n at ToSic.Eav.Repository.Efc.Parts.DbVersioning.QueueDuringAction(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbVersioning.cs:line 56\r\n at ToSic.Eav.Apps.ImportExport.Import.<>cDisplayClass7_0.b__1()\r\n at ToSic.Eav.Repository.Efc.DbDataController.DoInTransaction(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\DbDataController.cs:line 242\r\n at ToSic.Eav.Repository.Efc.DbDataController.DoWithDelayedCacheInvalidation(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\DbDataController.cs:line 257\r\n at ToSic.Eav.Apps.ImportExport.XmlImportWithFiles.ImportXml(Int32 zoneId, Int32 appId, XDocument doc, Boolean leaveExistingValuesUntouched)\r\n at ToSic.SexyContent.Installer.Helpers.ImportXmlSchemaOfVersion(String version, Boolean leaveOriginalsUntouched) in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\Helpers.cs:line 59\r\n at ToSic.SexyContent.Installer.InstallationController.UpgradeModule(String version) in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\InstallationController.cs:line 184\r\n at ToSic.SexyContent.Installer.InstallationController.FinishAbortedUpgrade() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\InstallationController.cs:line 217\r\n at ToSic.SexyContent.WebApi.View.ModuleController.FinishInstallation() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\Sxc WebApi\View\ModuleController.cs:line 307\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>cDisplayClass10.b9(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Tracing.ITraceWriterExtensions.<TraceBeginEndAsyncCore>d__181.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.d0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Tracing.ITraceWriterExtensions.d18`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.d2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.d2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Filters.AuthorizationFilterAttribute.d2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ExceptionFilterResult.d0.MoveNext()"}

[iJungleboy]

thx, will look into it.

[jaxuk]

cheers...

On 21 September 2017 at 15:25, iJungleboy notifications@github.com wrote:

thx, will look into it.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/2sic/2sxc/issues/1306#issuecomment-331172740, or mute the thread https://github.com/notifications/unsubscribe-auth/ABc05fqZwPvpt4FGvMBQVCa91noA-D51ks5sknHDgaJpZM4PfT8p .

--

Jacques Woolston

Yedit.co.uk - Content Management, Web Development, Graphic Design, Web Hosting, SEO and much much more.

www.yedit.co.uk

Tel: 004420 8144 2716

[iJungleboy]

Officially released 9.6 - pls try and check debugging https://github.com/2sic/2sxc/releases/tag/v09.06.00 to see what's happening in web-apis, you must temporarily enable extensive logging, as explained inhttp://2sxc.org/en/blog/post/releasing-2sxc-9-6-with-extensive-logging This should help you find out more exactly what fails.

[jaxuk]

ok I'm still stuck with the same issue. Looks like you need a 2sxc interface to enable extensive logging. Obviously I don't have the interface because the upgrade hasn't completed - Is there another way to turn it on?

Here's the full current error from the admin logs:

AbsoluteURL:/API/2sxc/view/module/finishinstallation DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke ExceptionGUID:3ea42926-2de7-4821-a9da-c6c0829ec8be AssemblyVersion: PortalId:-1 UserId:-1 TabId:-1 RawUrl: Referrer: UserAgent: ExceptionHash:Lgx+JVufI78sMDo0XQgHxsBtcoU= Message:error getting attribute - content-type/setid: 33; optional attributeId: 0; optional name: Attribute StackTrace: at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.GetAttribute(Int32 attributeSetId, Int32 attributeId, String name) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 61 at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.AttributeId(Int32 setId, String staticName) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 66 at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.GetOrCreateAttributeDefinition(Int32 contentTypeId, AttributeDefinition newAtt) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 45 at ToSic.Eav.Repository.Efc.Parts.DbContentType.ExtendSaveContentTypes(ContentType contentType, SaveOptions saveOptions) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbContentType_Modify.cs:line 113 at System.Collections.Generic.List1.ForEach(Action1 action) at ToSic.Eav.Repository.Efc.Parts.DbRelationship.DoWhileQueueingRelationships(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbRelationship.cs:line 24 at ToSic.Eav.Repository.Efc.Parts.DbContentType.ExtendSaveContentTypes(List1 contentTypes, SaveOptions saveOptions) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbContentType_Modify.cs:line 99 at ToSic.Eav.Apps.ImportExport.Import.<>c__DisplayClass10_0.b__2() at ToSic.Eav.Repository.Efc.Parts.DbVersioning.QueueDuringAction(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbVersioning.cs:line 55 at ToSic.Eav.Apps.ImportExport.Import.<>c__DisplayClass10_0.b__1() at ToSic.Eav.Repository.Efc.DbDataController.DoInTransaction(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\DbDataController.cs:line 253 at ToSic.Eav.Repository.Efc.DbDataController.DoWithDelayedCacheInvalidation(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\DbDataController.cs:line 269 at ToSic.Eav.Apps.ImportExport.XmlImportWithFiles.ImportXml(Int32 zoneId, Int32 appId, XDocument doc, Boolean leaveExistingValuesUntouched) at ToSic.SexyContent.Installer.Helpers.ImportXmlSchemaOfVersion(String version, Boolean leaveOriginalsUntouched, Log parentLog) in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\Helpers.cs:line 60 at ToSic.SexyContent.Installer.InstallationController.UpgradeModule(String version) in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\InstallationController.cs:line 187 at ToSic.SexyContent.Installer.InstallationController.FinishAbortedUpgrade() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\InstallationController.cs:line 220 at ToSic.SexyContent.WebApi.View.ModuleController.FinishInstallation() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\Sxc WebApi\View\ModuleController.cs:line 309 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.b__9(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary2 arguments, CancellationToken cancellationToken) --- 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.Web.Http.Tracing.ITraceWriterExtensions.d18`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.Web.Http.Controllers.ApiControllerActionInvoker.d0.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.Web.Http.Tracing.ITraceWriterExtensions.d18`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.Web.Http.Filters.ActionFilterAttribute.d5.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Web.Http.Filters.ActionFilterAttribute.d5.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.Web.Http.Filters.ActionFilterAttribute.d0.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.Web.Http.Controllers.ActionFilterResult.d2.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.Web.Http.Filters.AuthorizationFilterAttribute.d2.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.Web.Http.Filters.AuthorizationFilterAttribute.d2.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.Web.Http.Controllers.ExceptionFilterResult.d0.MoveNext() InnerMessage:Sequence contains no elements InnerStackTrace: at System.Linq.Enumerable.Single[TSource](IEnumerable1 source) at lambda_method(Closure , QueryContext ) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass20_01.b__0(QueryContext qc) at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.GetAttribute(Int32 attributeSetId, Int32 attributeId, String name) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 53 Source:ToSic.Eav.Repository.Efc FileName: FileLineNumber:0 FileColumnNumber:0 Method: Server Name: RIG

[iJungleboy]

I think i found it...

[iJungleboy]

I created a mini-release just for you, it's a pre-release of 9.6.1 - I think it fixes everything - pls try and give feedback :) 2sic_2SexyContent_09.06.00_Install.zip

[Fraraven]

Is it possible that #1295 is the same issue

[jaxuk]

Nice one... That worked :)

[iJungleboy]

@Fraraven you could be right - pls test again!

[Fraraven]

Hi The conversion is going well now - so that looks be fixed, only after it I get an error

---

in the interface

Error: System.NullReferenceException: Object reference not set to an instance of an object. at BprVisie.Models.BasicContents.BasicExtentions.ReadString(DynamicEntity pDyn, String pFieldName) in d:_src\DNN\BPRvisie\Sites\BprVisie_V1\trunk\BprVisie.Models\BasicContents\Basic.cs:line 136 at BprVisie.Models.BasicContents.PresentationOfList.ReadPresentation() in d:_src\DNN\BPRvisie\Sites\BprVisie_V1\trunk\BprVisie.Models\BasicContents\PresentationOfList.cs:line 186 at BprVisie.Models.BasicContents.PresentationOfList..ctor(DynamicEntity dynEntity) in d:_src\DNN\BPRvisie\Sites\BprVisie_V1\trunk\BprVisie.Models\BasicContents\PresentationOfList.cs:line 17 at CallSite.Target(Closure , CallSite , Type , Object ) at ASP._Page_Portalsdefault_2sxc_ContentBaseDefaultContentImplemetation_cshtml.Execute() in c:\root\LocalUser\fullyin\Portals_default\2sxc\Content_BaseDefaultContentImplemetation.cshtml:line 11 at System.Web.WebPages.WebPageBase.ExecutePageHierarchy() at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) at ToSic.SexyContent.Engines.RazorEngine.Render(TextWriter writer) in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\2Sexy Content Razor\RazorEngine.cs:line 53 at ToSic.SexyContent.Engines.RazorEngine.RenderTemplate() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\2Sexy Content Razor\RazorEngine.cs:line 65 at ToSic.SexyContent.Engines.EngineBase.Render() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Engines\EngineBase.cs:line 91 at ToSic.SexyContent.SxcInstance.Render() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\SxcInstance.cs:line 221

---

ion the log

AbsoluteURL:/Default.aspx DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke ExceptionGUID:220a7454-1d22-4087-a12d-14ff61ec263a AssemblyVersion: PortalId:-1 UserId:-1 TabId:-1 RawUrl: Referrer: UserAgent: ExceptionHash:HUXBbKZX2hYyfzGjUFq91/X4aZI= Message:Object reference not set to an instance of an object. StackTrace: at BprVisie.Models.BasicContents.BasicExtentions.ReadString(DynamicEntity pDyn, String pFieldName) in d:_src\DNN\BPRvisie\Sites\BprVisie_V1\trunk\BprVisie.Models\BasicContents\Basic.cs:line 136 at BprVisie.Models.BasicContents.PresentationOfList.ReadPresentation() in d:_src\DNN\BPRvisie\Sites\BprVisie_V1\trunk\BprVisie.Models\BasicContents\PresentationOfList.cs:line 186 at BprVisie.Models.BasicContents.PresentationOfList..ctor(DynamicEntity dynEntity) in d:_src\DNN\BPRvisie\Sites\BprVisie_V1\trunk\BprVisie.Models\BasicContents\PresentationOfList.cs:line 17 at CallSite.Target(Closure , CallSite , Type , Object ) at ASP._Page_Portalsdefault_2sxc_ContentBaseDefaultContentImplemetation_cshtml.Execute() in c:\root\LocalUser\fullyin\Portals_default\2sxc\Content_BaseDefaultContentImplemetation.cshtml:line 11 at System.Web.WebPages.WebPageBase.ExecutePageHierarchy() at System.Web.WebPages.WebPageBase.ExecutePageHierarchy(WebPageContext pageContext, TextWriter writer, WebPageRenderingBase startPage) at ToSic.SexyContent.Engines.RazorEngine.Render(TextWriter writer) in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\2Sexy Content Razor\RazorEngine.cs:line 53 at ToSic.SexyContent.Engines.RazorEngine.RenderTemplate() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\2Sexy Content Razor\RazorEngine.cs:line 65 at ToSic.SexyContent.Engines.EngineBase.Render() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Engines\EngineBase.cs:line 91 at ToSic.SexyContent.SxcInstance.Render() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\SxcInstance.cs:line 221 InnerMessage: InnerStackTrace: Source:BprVisie.Models FileName: FileLineNumber:0 FileColumnNumber:0 Method:

[iJungleboy]

This looks completely foreign to me - I actually think it doesn't have to do with 2sxc. To me it looks like this is some of your own code BprVisie. Could you look into that and find out if it's even related to 2sxc?