We are seeing an error when importing members. We have a member type with maybe 20+ properties on it but whilst testing we are only importing members with and Email and Name and each time is seems to fail with the following error:
We are getting the following in the logs:
2017-10-18 16:33:27,166 [P7376/D2/T70] ERROR CMSImportLibrary.Providers.ImportProviders.Member.MemberImportProvider - CMSImport:CMSImport: A record failed to import for alias@@#Import_email
System.InvalidOperationException: Invalid attempt to call Read when reader is closed.
at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
at System.Data.SqlClient.SqlDataReader.Read()
at umbraco.DataLayer.RecordsReaderAdapter`1.Read()
at umbraco.cms.businesslogic.member.Member.PopulateGroups()
at umbraco.cms.businesslogic.member.Member.AddGroup(Int32 GroupId)
at umbraco.MemberExtensions.AddGroup(Member member, MemberGroup group)
at CMSImportLibrary.Providers.ImportProviders.Member.MemberImportProvider.ImportMembers(ImportState state, ImportStatistics importStatistics, User importAsUser)
2017-10-18 16:33:27,182 [P7376/D2/T70] INFO CMSImport.Extensions.Providers.ImportProviders.ImportProvider - CMSImport:Import finished, Records in datasource: 2, Records Added 0, Records Updated 0, Records skipped 0, Records deleted 0, Errors 2, duration 00:00:06
We have a Pro License so it can't be down to the amount we have imported. This also happens across all of our environments, Local, Dev, Test and Staging with different dbs.
The tool should have prompted that you should use the MembershipImport provider for this version of Umbraco (In V4 this will be the default provider). If not please let me know. You can download the mebershipimport provider from the downloads page https://soetemansoftware.nl/cmsimport/downloads
Error When Importing Members
Hi Guys,
We are seeing an error when importing members. We have a member type with maybe 20+ properties on it but whilst testing we are only importing members with and Email and Name and each time is seems to fail with the following error:
We are getting the following in the logs:
2017-10-18 16:33:27,166 [P7376/D2/T70] ERROR CMSImportLibrary.Providers.ImportProviders.Member.MemberImportProvider - CMSImport:CMSImport: A record failed to import for alias@@#Import_email System.InvalidOperationException: Invalid attempt to call Read when reader is closed. at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at umbraco.DataLayer.RecordsReaderAdapter`1.Read() at umbraco.cms.businesslogic.member.Member.PopulateGroups() at umbraco.cms.businesslogic.member.Member.AddGroup(Int32 GroupId) at umbraco.MemberExtensions.AddGroup(Member member, MemberGroup group) at CMSImportLibrary.Providers.ImportProviders.Member.MemberImportProvider.ImportMembers(ImportState state, ImportStatistics importStatistics, User importAsUser) 2017-10-18 16:33:27,182 [P7376/D2/T70] INFO CMSImport.Extensions.Providers.ImportProviders.ImportProvider - CMSImport:Import finished, Records in datasource: 2, Records Added 0, Records Updated 0, Records skipped 0, Records deleted 0, Errors 2, duration 00:00:06
We have a Pro License so it can't be down to the amount we have imported. This also happens across all of our environments, Local, Dev, Test and Staging with different dbs.
Has anyone seen this before?
Nathan
Hi Nathan,
The tool should have prompted that you should use the MembershipImport provider for this version of Umbraco (In V4 this will be the default provider). If not please let me know. You can download the mebershipimport provider from the downloads page https://soetemansoftware.nl/cmsimport/downloads
Hope this helps,
Richard
Hi Richard,
I got no prompt but after installing the provider it seems to be working fine.
Thanks for this.
Nathan
is working on a reply...