So I'm trying to import .csv file with 6000 emails. In Newsletter Studio import section I select that file and then choose "One email per row" option because that's what file contains (no separators). After I click Import I get browser pop-up with message: "failed!" (Progress bar is still spinning endlessly). So when i refresh the page i see that only 125 emails are imported. If I repeat the process for the same list it fails again and now there are 250 emails imported (with some duplicates as well). But if I try to import csv file with only 120 emails everything is working fine.
For those times that it fails (6000 emails csv) to import every time I check the log file in App_data/Logs I see System.Data.SqlServerCe.SqlCeException (0x80004005): Too many sessions are open.
Website is up and running for more than 4 years and this is the first time that these errors occured. We have Desktop Media Uploader and I tried to upload 200 images and it worked fine (if that is of any relevance).
I had some progress regarding the issue so here is what I've done.
(Newsletter Studio version is 2.1.6)
I migrated database from SQL CE to SQL Server.
Then I tried to upload same .csv file (120 emails) selecting the option "One email per row". I still got the browser popup "failed!" and it imported 117 emails (spinner still spinning endlessly). This time there was nothing in the log file in App_Data/Logs. Then I parsed my .csv and added semicolon after each email and the import worked! (with 6000 emails in file).
The file that I was initially trying to upload was in format like:
NewsletterStudio: SqlCeException: Too many sessions are open
Hi!
When I try to import .cvs file i get this error in SQL CE database. It manages to write to database only about 125 inputs and then I get this error.
Please help!
Thanks
Hi!
We are closing the connection during the import, I've answered your private support request so that we can talk about this.
// m
Thanks for the answer,
I'll be more specific: Umbraco version is: 7.5.8.
So I'm trying to import .csv file with 6000 emails. In Newsletter Studio import section I select that file and then choose "One email per row" option because that's what file contains (no separators). After I click Import I get browser pop-up with message: "failed!" (Progress bar is still spinning endlessly). So when i refresh the page i see that only 125 emails are imported. If I repeat the process for the same list it fails again and now there are 250 emails imported (with some duplicates as well). But if I try to import csv file with only 120 emails everything is working fine.
For those times that it fails (6000 emails csv) to import every time I check the log file in App_data/Logs I see System.Data.SqlServerCe.SqlCeException (0x80004005): Too many sessions are open.
Website is up and running for more than 4 years and this is the first time that these errors occured. We have Desktop Media Uploader and I tried to upload 200 images and it worked fine (if that is of any relevance).
Do you have an idea where the problem might be?
Hi!
We have tested imports with over 100 000 emails and it works fine in our tests.
Anyway - let's try to figure out why this is happening.
What version of the Newsletter Studio-package are you running?
Could you share the format that you are using as well? We will have to do some debugging and try to see if we can reproduce the issue.
// m
Hi,
I had some progress regarding the issue so here is what I've done. (Newsletter Studio version is 2.1.6)
I migrated database from SQL CE to SQL Server. Then I tried to upload same .csv file (120 emails) selecting the option "One email per row". I still got the browser popup "failed!" and it imported 117 emails (spinner still spinning endlessly). This time there was nothing in the log file in App_Data/Logs. Then I parsed my .csv and added semicolon after each email and the import worked! (with 6000 emails in file).
The file that I was initially trying to upload was in format like:
[email protected]
[email protected]
[email protected]
and so on..
saved as csv file (exported from Microsoft Excel).
So as far as I'm concerned this topic can be closed.
is working on a reply...