The errors when adjusting parameters of BTEQ Import PACK clause

Tools & Utilities
N/A

The errors when adjusting parameters of BTEQ Import PACK clause

Hey Guys,

I executed two bteq scripts with different parameters of PACK. One ran correctly while the other meeted some errors reporting "CLI error: CLI2: BADPARCEL(306): Invalid parcel received". please help me find the reason.

The contents of "wrong" script are:
.set sessions 8
.logon 127.0.0.1/au,educate
.import indicdata file=C:\scripts_data\trandata
.quiet on
.repeat * pack 10
using trano (integer)
,trndte (date)
,tracno (integer)
,trnid (char(4))
,trnamt (decimal(10,2))
insert into trans
values (:trano,:trndte,:tracno,:trnid,:trnamt);
.quit

The contents of "correct" script are:
.set sessions 8
.logon 127.0.0.1/au,educate
.import indicdata file=C:\scripts_data\trandata
.quiet on
.repeat * pack 100
using trano (integer)
,trndte (date)
,tracno (integer)
,trnid (char(4))
,trnamt (decimal(10,2))
insert into trans
values (:trano,:trndte,:tracno,:trnid,:trnamt);
.quit

when running the first script, the cmd window returned
*** CLI error: CLI2: BADPARCEL(306): Invalid parcel received.

*** Return code from CLI is: 306
*** CLI error: CLI2: BADPARCEL(306): Invalid parcel received.

*** Return code from CLI is: 306
*** Failure 2828 Request was rolled back during system recovery.
Statement# 1, Info =0

*** Warning: Attempting to resubmit last request.
*** Error 2825 NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC RESTART

*** Warning: Attempting to resubmit last request.
*** Error 2825 NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC RESTART

*** Warning: Attempting to resubmit last request.
*** Error 2825 NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC RESTART

*** Warning: Attempting to resubmit last request.
*** Error 2825 NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC RESTART

*** Warning: Attempting to resubmit last request.
*** Error 2825 NO RECORD OF THE LAST REQUEST WAS FOUND AFTER DBC RESTART

*** Warning: Attempting to resubmit last request.
*** CLI error: CLI2: BADPARCEL(306): Invalid parcel received.

*** Return code from CLI is: 306
*** CLI error: CLI2: BADPARCEL(306): Invalid parcel received.

*** Return code from CLI is: 306
*** CLI error: CLI2: BADPARCEL(306): Invalid parcel received.

*** Return code from CLI is: 306
*** Failure 2828 Request was rolled back during system recovery.
Statement# 1, Info =0

*** Warning: Attempting to resubmit last request.
*** Error 2826 Request completed but all output was lost due to DBC restar
t.
Statement# 1, Info =0

*** Error 2826 Request completed but all output was lost due to DBC restar
t.
Statement# 1, Info =0

*** Warning: Out of data.
*** CLI error: Completed Successfully.

*** Return code from CLI is: 311

Thanks in advance

Tarzan