locked
There was insufficient disk space - TEMP RRS feed

  • Question

  • I am in process of parsing and loading XML files (17 folders, each has roughly 25 files so total 425 files & total size >15Gb&<25gb) and while running the SSIS package many files fails with the below message. So is there a way to overcome this.

    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{042E2673-F44A-4146-9CD1-EE602F83711B}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{E4C54C7C-F46B-40B5-B532-19A739F519FF}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{1934FF55-A234-496B-B0C2-AE62344B4FBA}.tmp" to length 10474604 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{6830B82D-882F-43E2-B4C5-439E5C1B7EB1}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{C63DEF0F-C5DD-42B5-9FDE-80EEDF40F65F}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{1C384053-4AFC-4E05-9A76-D874B68C8A6B}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{FD20A211-B247-4F28-B8E5-11EDCA66221D}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{1ED2977C-4FCE-47A4-8F3E-8D97BC9F0160}.tmp" to length 10474604 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{3BD6DFD8-83A6-4637-A971-B7B32CC2FAE6}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{C722662D-6A43-4098-A395-97F54181F1F9}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{142131A7-1004-4FA0-82F4-A188A960B3DE}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{7F044653-ECC0-4717-A5FF-187AA77B0FF9}.tmp" to length 9305716 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{B6F3DDF7-0C43-4F31-B602-9A17A4F5BF5C}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{BEFA3941-C5BD-41AD-8501-470555789FAB}.tmp" to length 10482212 bytes.  There was insufficient disk space.
    The buffer manager cannot extend the file "C:\Users\BIE4AA~1.VEN\AppData\Local\Temp\2\DTS{FD16CA75-B47E-4CF8-8994-89F406B38DC4}.tmp" to length 9305716 bytes.  There was insufficient disk space.

    Also found this error, [Log provider "SSIS log provider for SQL Server"] Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E14.
    An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 11.0"  Hresult: 0x80040E14  Description: "The transaction log for database 'EDW_STAGING' is full due to 'LOG_BACKUP'.".

    Logging is done using SSIS log provider for SQL Server and SSIS and SQL are in same server.


    Sarvan


    • Edited by on7june Tuesday, January 26, 2016 4:37 AM
    Tuesday, January 26, 2016 3:52 AM

Answers

All replies