Copied to clipboard

Flag this post as spam?

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


  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 09:08
    Barry Corrigan
    0

    Method not found - Every morning I use the CMSImport tool

    Hi There,

    Loving the CMSImport tool but every morning I have to uninstall the package and reinstall it because I always get this error after I input my connection string

    Server Error in '/' Application.
    
    Method not found: 'System.Collections.Generic.List`1<System.String> CMSImportLibrary.Helpers.SqlServerHelper.GetStringList(System.String, System.String, System.Data.SqlClient.SqlParameter[])'.
    
    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 
    
    Exception Details: System.MissingMethodException: Method not found: 'System.Collections.Generic.List`1<System.String> CMSImportLibrary.Helpers.SqlServerHelper.GetStringList(System.String, System.String, System.Data.SqlClient.SqlParameter[])'.
    
    Source Error: 
    
    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
    
    Stack Trace: 
    
    
    [MissingMethodException: Method not found: 'System.Collections.Generic.List`1<System.String> CMSImportLibrary.Helpers.SqlServerHelper.GetStringList(System.String, System.String, System.Data.SqlClient.SqlParameter[])'.]
       CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntity.(String ) +0
       CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntity.(String ) +1147
       CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntity.() +948
       CMSImport.UmbracoDataProvider.Export.ExportEntities.Content..(Object , Int32 ) +124
       System.Linq.<SelectIterator>d__5`2.MoveNext() +387
       System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +436
       System.Linq.Enumerable.ToList(IEnumerable`1 source) +70
       CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntities.() +212
       CMSImport.UmbracoDataProvider.Content.UmbracoContentDataProviderForm.() +124
       System.Web.UI.WebControls.TextBox.OnTextChanged(EventArgs e) +137
       System.Web.UI.Page.RaiseChangedEvents() +156
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4593
    
    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3282.0
    

    It only happens after I input my connection string (remember it was working the previous day)

    Does anyone know why this happens and how I can get it to stop? So I don't have to keep uninstalling this and reinstalling.

    Thanks Barry

  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Dec 19, 2018 @ 09:14
    Richard Soeteman
    0

    HI Barry,

    Looks like a dll is changed during the day. I assume you have saved the definitions as well and do you have the same issue then?

    Great you like the tool by the way. This issue must be a config mismatch, let's find out what happened.

    Best,

    Richard

  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 09:21
    Barry Corrigan
    0

    I haven't saved any definitions. I will uninstall this and re-install and then save the import definitions and see does that fix it.

  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 09:59
    Barry Corrigan
    0

    I've just reinstalled this package and it is now working again.

    But when I go through the Import Data steps there is nothing for me to save a definition.

    How would I go about getting this sorted so I don't have to uninstall in the morning?

    Thanks Barry

  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Dec 19, 2018 @ 10:04
    Richard Soeteman
    0

    Hi Barry,

    When you use the Pro version you should always see the save button in the upper right corner on the summery screen.

    Best,

    Richard

  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 10:19
    Barry Corrigan
    0

    I have my licence in the /bin folder.

    There is two files

    cmsimport.lic cmsimport.txt

  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Dec 19, 2018 @ 10:36
    Richard Soeteman
    0

    cmsimport.txt I don't know what that is but cmsimport,lic is ok.

    enter image description here

    This is what you should see on the last screen before import. But starting a new definition also works out of the box on my and. Could it be that a version mismatch between the Umbraco import provider and cmsimport exists? Did you download them both at once? Could it be that old dll's come in via version control perhaps?

  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 14:31
    Barry Corrigan
    0

    Ok so it's happened again. This time I have checked the logs and this is what i'm getting

    2018-12-19 14:27:33,563 [P61956/D65/T335] ERROR CMSImport.Controls.CMSImport - CMSImport:Error during load of wizard
    System.MissingMethodException: Method not found: 'System.Collections.Generic.List`1<System.String> CMSImportLibrary.Helpers.SqlServerHelper.GetStringList(System.String, System.String, System.Data.SqlClient.SqlParameter[])'.
       at CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntity.(String )
       at CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntity.(String )
       at CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntity.()
       at CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntities..(Object , Int32 )
       at System.Linq.Enumerable.<SelectIterator>d__5`2.MoveNext()
       at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
       at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
       at CMSImport.UmbracoDataProvider.Export.ExportEntities.Content.ContentTypeEntities.()
       at CMSImport.UmbracoDataProvider.Content.UmbracoContentDataProviderForm.()
       at CMSImport.UmbracoDataProvider.Content.UmbracoContentDataProviderForm.OnInit(EventArgs e)
       at System.Web.UI.Control.InitRecursive(Control namingContainer)
       at System.Web.UI.Control.AddedControl(Control control, Int32 index)
       at CMSImport.Controls.ImportSteps.SelectDataSource.()
       at CMSImport.Controls.CMSImport.(Int32 )
       at CMSImport.Controls.CMSImport.OnPreRender(EventArgs e)
    

    I tried to click on one of my saved definitions and this is the error I got

    Error during load, check the logfile for details Method not found: 'System.Collections.Generic.List`1 CMSImportLibrary.Helpers.SqlServerHelper.GetStringList(System.String, System.String, System.Data.SqlClient.SqlParameter[])'.
    

    Any ideas?

  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Dec 19, 2018 @ 14:35
    Richard Soeteman
    0

    Looks like that either you cmsimport.library.dll (cmsimport) is out of date or your Umbraco data provider. Can you download and install them from https://soetemansoftware.nl/cmsimport/downloads ?

    Thanks,

    Richard

  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 15:25
    Barry Corrigan
    0

    In packages.config it was 3.7.5 but everywhere else was 3.7.6

    <package id="CMSImport" version="3.7.5" targetFramework="net452" />
    

    I wonder if this is the difference I have updated this to 3.7.6

  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Dec 19, 2018 @ 15:37
    Richard Soeteman
    0

    when you do please also upgrade the Umbraco dataprovider I think that is causing the issue.

  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 15:40
    Barry Corrigan
    0

    There is no reference to Umbraco dataprovider in the packages.config what does it need to be?

  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Dec 19, 2018 @ 15:52
    Richard Soeteman
    0

    You need to install it from the link above. That is the package throwing the error. There is only the latest version on the site.

  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 16:00
    Barry Corrigan
    0

    Yes it's now installed but the packages.config doesn't update does it need to be?

    enter image description here

  • Barry Corrigan 32 posts 145 karma points
    Dec 19, 2018 @ 16:21
    Barry Corrigan
    0

    This has now stopped working again. Getting the same error Method Not Found.

  • Richard Soeteman 4045 posts 12898 karma points MVP 2x
    Dec 20, 2018 @ 09:56
    Richard Soeteman
    0

    Hi Barry,

    Really weird but must be something in your config. Can you send met all cmsimport binaries in the /bin folder?

    My email is [email protected]

    Best,

    Richard

  • Laureline 20 posts 161 karma points
    Oct 15, 2019 @ 13:36
    Laureline
    0

    Hi All,

    We have similar error on our umbraco site (7.12.3). We are using pro version of CMS import (3.7.8). Each 2 or 3 months, for no apparent reason the daily skeduled imports just stop to work, with the following error :

    "ERROR CMSImportLibrary.Scheduler.Scheduler - CMSImport:error during execute of scheduled Items System.MissingMethodException: Method not found: 'System.Collections.Generic.List`1

    The only way the make it work again is to uninstall and reinstall CMS import. Do you know how I can get it to stop ?

    Thanks a lot !

    CB

Please Sign in or register to post replies

Write your reply to:

Draft