LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Output Excel node error with No Space left on device

    Employee
    Posted 05-01-2014 13:44

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: spalluru

    Hi ,
    We have 3 input pins going into one of Output Excel node , node works when total number of records from 3 pins are small in size.
    But same node errors out when total number of records ( total 3 input pins) are large ex: more than 200k .
    Is there any limit on number of records for output excel node ? we use enterprise license and version is 4.6.0
    I can say we have got enough free disk space and RAM while this graph runs.

    Appreciate your quick response on this
    -Sreekanth


  • 2.  RE: Output Excel node error with No Space left on device

    Employee
    Posted 05-02-2014 12:21

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: DanRosenblatt

    Hi Sreekanth--what is the error message you are receiving? Are you using a template input file?

    The Excel output node should be able to handle 200,000 records, but if the output file you named has the extension .xls, you could receive an error like "Invalid row number" due to the Excel 2003 limitation of 65536 rows.


  • 3.  RE: Output Excel node error with No Space left on device

    Employee
    Posted 05-06-2014 08:08

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: spalluru

    Hi Dan,
    Thanks for the reply. I am using xlsx format in outputexcelnode.
    Is there any limit on number rows that can be inserted into xlsx file ? please note I am not using any template.
    Message I receive is
    "ERROR : Unexpected exception running the output excel node
    javaExceptionDetail:java.lang.RuntimeException:'ja va.io.IOException: No space left on device';
    -Sreekanth


  • 4.  RE: Output Excel node error with No Space left on device

    Employee
    Posted 05-06-2014 08:19

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: stonysmith

    "No space left on device" means that you filled up the disk drive.

    There was a limit of 65,535 rows in the XLS format.. that was increased to 1m rows for XLSX, but it's still "a limit".


  • 5.  RE: Output Excel node error with No Space left on device

    Employee
    Posted 05-07-2014 05:29

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: spalluru

    Hi ,
    While running the graph we ensured there are not disk issues on LAE temporary storage or output directory where the file is getting produced.
    What could be be reason in getting this No space left on device error ?

    -Sreekanth