All Forums Tools
padhia 35 posts Joined 06/10
12 Feb 2016
$LOAD: TPT10507: CLI Error 302: CLI2: BADBUFRQ(302): Invalid buffer size.

Using TPT loader and DataConnector version 15.10.01.00 produce above error. I am using following script to load about 100M rows
 

DEFINE JOB test_tbl
(
    SET TargetWorkingDatabase     = 'DLABDVTPTTEST';

    SET DCPFormat                 = 'Delimited';
    SET DCPOpenMode               = 'Read';
    SET DCPTextDelimiterHEX       = 'ED';
    SET DCPDirectoryPath          = 'data/';
    SET DCPNullColumns            = 'Yes';
    SET DCPTruncateColumnData     = 'Yes';

    SET LoadErrorLimit            = 1;
    SET DDLErrorList              = ['3807','3624'];

    STEP TruncTbl (
        APPLY ('DELETE FROM test_tbl;')
            TO OPERATOR ($DDL);
    );

    STEP Load_test_tbl (
        APPLY $INSERT
            TO OPERATOR (
                 $LOAD ATTR( TargetTable='test_tbl',
                              QueryBandSessInfo='JobId=' || $JOBID || ';UtilityDataSize=MEDIUM;' )
            )
            SELECT *
              FROM OPERATOR (
                 $FILE_READER(DELIMITED 'DLABDVTPTTEST.test_tbl') ATTR(FileName='test_tbl_20160211.txt.gz')
            );
    );
);

 
Any clue on what could be wrong?
 
Thanks

You must sign in to leave a comment.