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.
cmsimport.txt I don't know what that is but cmsimport,lic is ok.
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?
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[])'.
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 ?
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 ?
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
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
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
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.
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
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
I have my licence in the /bin folder.
There is two files
cmsimport.lic cmsimport.txt
cmsimport.txt I don't know what that is but cmsimport,lic is ok.
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?
Ok so it's happened again. This time I have checked the logs and this is what i'm getting
I tried to click on one of my saved definitions and this is the error I got
Any ideas?
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
In packages.config it was 3.7.5 but everywhere else was 3.7.6
I wonder if this is the difference I have updated this to 3.7.6
when you do please also upgrade the Umbraco dataprovider I think that is causing the issue.
There is no reference to Umbraco dataprovider in the packages.config what does it need to be?
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.
Yes it's now installed but the packages.config doesn't update does it need to be?
This has now stopped working again. Getting the same error Method Not Found.
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
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 :
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
is working on a reply...