Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Chris Van Oort 93 posts 351 karma points
    Feb 19, 2018 @ 17:26
    Chris Van Oort
    0

    InvalidOperationException running in Umbraco 7.8.1?

    Hi -- I just upgraded everything to Umbraco 7.8.1 and am running the latest v3.11 of 301 URL Tracker.

    In my UmbracoTraceLog, it's packed full of these InvalidOperationExceptoin errors:

    System.InvalidOperationException: Invalid attempt to call MetaData when reader is closed.
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlDataReader.CheckMetaDataIsReady()
       at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
       at umbraco.DataLayer.RecordsReaderAdapter`1.GetOrdinal(String fieldName)
       at umbraco.DataLayer.RecordsReaderAdapter`1.GetBoolean(String fieldName)
       at InfoCaster.Umbraco.UrlTracker.Modules.UrlTrackerModule.LoadUrlTrackerMatchesFromDatabase(HttpRequest request, String urlWithoutQueryString, Boolean urlHasQueryString, String shortestUrl, Int32 rootNodeId, String& redirectUrl, Nullable`1& redirectHttpCode, Boolean& redirectPassThroughQueryString) in D:\kipusoep\Documents\GitHub\UrlTracker\Modules\UrlTrackerModule.cs:line 447
       at InfoCaster.Umbraco.UrlTracker.Modules.UrlTrackerModule.UrlTrackerDo(String callingEventName, Boolean ignoreHttpStatusCode) in D:\kipusoep\Documents\GitHub\UrlTracker\Modules\UrlTrackerModule.cs:line 206
       at InfoCaster.Umbraco.UrlTracker.Modules.UrlTrackerModule.context_EndRequest(Object sender, EventArgs e) in D:\kipusoep\Documents\GitHub\UrlTracker\Modules\UrlTrackerModule.cs:line 60
       at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
     2018-02-19 00:13:03,224 [P9336/D3/T99] ERROR Umbraco.Core.UmbracoApplicationBase - An unhandled exception occurred
    System.InvalidOperationException: Invalid attempt to call MetaData when reader is closed.
       at System.Data.SqlClient.SqlDataReader.get_MetaData()
       at System.Data.SqlClient.SqlDataReader.CheckMetaDataIsReady()
       at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
       at umbraco.DataLayer.RecordsReaderAdapter`1.GetOrdinal(String fieldName)
       at umbraco.DataLayer.RecordsReaderAdapter`1.GetBoolean(String fieldName)
       at InfoCaster.Umbraco.UrlTracker.Modules.UrlTrackerModule.LoadUrlTrackerMatchesFromDatabase(HttpRequest request, String urlWithoutQueryString, Boolean urlHasQueryString, String shortestUrl, Int32 rootNodeId, String& redirectUrl, Nullable`1& redirectHttpCode, Boolean& redirectPassThroughQueryString) in D:\kipusoep\Documents\GitHub\UrlTracker\Modules\UrlTrackerModule.cs:line 447
       at InfoCaster.Umbraco.UrlTracker.Modules.UrlTrackerModule.UrlTrackerDo(String callingEventName, Boolean ignoreHttpStatusCode) in D:\kipusoep\Documents\GitHub\UrlTracker\Modules\UrlTrackerModule.cs:line 206
       at InfoCaster.Umbraco.UrlTracker.Modules.UrlTrackerModule.context_EndRequest(Object sender, EventArgs e) in D:\kipusoep\Documents\GitHub\UrlTracker\Modules\UrlTrackerModule.cs:line 60
       at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
     2018-02-19 00:13:32,390 [P9336/D3/T91] ERROR Umbraco.Core.UmbracoApplicationBase - An unhandled exception occurred
    

    Does anyone know how to solve this error? When I try to navigate to an old URL that should have a redirect from 301 URL Tracker, I end up with a YSOD with the same SQL error:

    enter image description here

  • Chris Van Oort 93 posts 351 karma points
    Feb 19, 2018 @ 19:15
    Chris Van Oort
    101

    For anyone who reads this, the issue was solved by upgrading to version 3.15 (only available on Nuget). I also found the same issue here: https://github.com/kipusoep/UrlTracker/issues/163

    It appears this project is no longer maintained by the original developer, so things have moved a bit:

  • Arunabha Das 37 posts 150 karma points
    Aug 20, 2018 @ 14:02
    Arunabha Das
    0

    Hi Chris,

    I want to install in umbraco through backoffice. How do I do it.

  • Daniel Chenery 119 posts 465 karma points
    Aug 20, 2018 @ 14:04
    Daniel Chenery
    0

    As mentioned above, the version on Our (backoffice package manager) is no longer supported. Please use NuGet for the latest version :)

  • Arunabha Das 37 posts 150 karma points
    Aug 20, 2018 @ 14:07
    Arunabha Das
    0

    Hi Daniel,

    Thanks for the reply

    I am not using VST for Umbraco development. Is there any other way to install it.

  • Arunabha Das 37 posts 150 karma points
    Aug 20, 2018 @ 14:32
    Arunabha Das
    0

    Hi Daniel,

    Thanks for the reply.

    However I am not using VST for umbraco development. Is there any other way to install the package

  • Daniel Chenery 119 posts 465 karma points
    Aug 20, 2018 @ 14:35
    Daniel Chenery
    1

    Urm, you should be able to download it directly from NuGet It might give you a nuspec file. Just rename to .zip extract and drop the dll into your bin folder

  • Arunabha Das 37 posts 150 karma points
    Aug 23, 2018 @ 06:04
    Arunabha Das
    0

    Thanks Daniel. It worked.

  • Daniel Chenery 119 posts 465 karma points
    Feb 19, 2018 @ 23:27
    Daniel Chenery
    0

    Glad you fixed it :) You're right, things have moved around indeed!

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies