Since we've installed a new package (1.4) we keep getting the following errors when importing CSV files.
NewletterStudio: Could not parse CSV.The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100.. Inner:
NewletterStudio: Could not parse CSV.Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. Inner: System.ComponentModel.Win32Exception (0x80004005): Time-out van wachtbewerking
The previous version (1.2) did not show this problem.
Also very strange: Not all CSV files show this problem; of the 10 or so files (all with approx 4000 lines) some will timeout, and others don't.
Any ideas anyone?
Kind regards, Peter Rombouts
(Umbraco 6.1.6 / MSSQL2008 / Newsletter Studio 1.4.4.1) (Brand new installation - Not upgraded the old version)
I've created a support ticket with more detailed information. The problem seems to occur with files with over a couple of thousand records. Splitting all files into batches of 800 or 900 lines fixes the issue (but obviously is pretty tedious for us...).
It has been tested with over 100 000 addresses so I don't think that thats the issues. How much memory do you have on the machine? How long time does the parsing take?
Old version 1.2 did not have this problem. New version installed on new website on same machine, so specs are the same:
Quadcore AMD with 6GB of RAM
Parsing takes somewhere between 2 and 8 seconds, but it just quits with an error message. Splitting files into smaller files fixes the issue, which is strange if you say testing has been done with 100K lines.
FYI: the CSV is semicolon separated with name;emailaddress format.
Timeout importing Mailing lists
Hi all,
Since we've installed a new package (1.4) we keep getting the following errors when importing CSV files.
The previous version (1.2) did not show this problem.
Also very strange: Not all CSV files show this problem; of the 10 or so files (all with approx 4000 lines) some will timeout, and others don't.
Any ideas anyone?
Kind regards,
Peter Rombouts
(Umbraco 6.1.6 / MSSQL2008 / Newsletter Studio 1.4.4.1)
(Brand new installation - Not upgraded the old version)
Hi!
Strange that this works for some file but not all. Are you sure that they are saved with the same encoding? ANSI or UTF8?
// m
Hi Markus,
I've created a support ticket with more detailed information.
The problem seems to occur with files with over a couple of thousand records.
Splitting all files into batches of 800 or 900 lines fixes the issue (but obviously is pretty tedious for us...).
Kind regards,
Peter Rombouts
Hi!
It has been tested with over 100 000 addresses so I don't think that thats the issues. How much memory do you have on the machine? How long time does the parsing take?
// m
Hi,
Old version 1.2 did not have this problem.
New version installed on new website on same machine, so specs are the same:
Quadcore AMD with 6GB of RAM
Parsing takes somewhere between 2 and 8 seconds, but it just quits with an error message.
Splitting files into smaller files fixes the issue, which is strange if you say testing has been done with 100K lines.
FYI: the CSV is semicolon separated with name;emailaddress format.
Kind regards,
Peter Rombouts
Could you send me the file so that I can have a look?
markus [at sign goes here] enkelmedia.se
Hi Markus,
Check your inbox!
Kind regards,
Peter Rombouts
is working on a reply...