Copied to clipboard

Flag this post as spam?

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


  • Peter Rombouts 71 posts 265 karma points
    Mar 28, 2014 @ 12:38
    Peter Rombouts
    0

    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.

    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)

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Mar 31, 2014 @ 10:26
    Markus Johansson
    0

    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

  • Peter Rombouts 71 posts 265 karma points
    Mar 31, 2014 @ 11:04
    Peter Rombouts
    0

    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

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Mar 31, 2014 @ 14:02
    Markus Johansson
    0

    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 

  • Peter Rombouts 71 posts 265 karma points
    Mar 31, 2014 @ 14:23
    Peter Rombouts
    0

    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

  • Markus Johansson 1936 posts 5864 karma points MVP 2x c-trib
    Mar 31, 2014 @ 15:04
    Markus Johansson
    0

    Could you send me the file so that I can have a look?

    markus [at sign goes here] enkelmedia.se

  • Peter Rombouts 71 posts 265 karma points
    Mar 31, 2014 @ 15:37
    Peter Rombouts
    0

    Hi Markus,

    Check your inbox!

    Kind regards,
    Peter Rombouts

Please Sign in or register to post replies

Write your reply to:

Draft