Dan Packer
Member
I'm trying to troubleshoot Webspeed code that loads an item catalog from a .csv that has been placed on a server. If the .csv code is greater than about 850K and 5,000 records, the program stalls and I see the following message in the server log:
P-064472 T-1751873344 1 WS -- (Procedure: 'ad/ad_mnt_itemupload.html' Line:2418) SYSTEM ERROR: Input data too large, try to increase -s or/and -stsh. (63)
The offending code is pasted below; can anyone give any advice on:
1. How to determine what values to use for -s (currently set to 32768) and for -stsh?
2. Where to make those changes?
Any help would be greatly appreciated!
Thanks,
-Dan
P-064472 T-1751873344 1 WS -- (Procedure: 'ad/ad_mnt_itemupload.html' Line:2418) SYSTEM ERROR: Input data too large, try to increase -s or/and -stsh. (63)
The offending code is pasted below; can anyone give any advice on:
1. How to determine what values to use for -s (currently set to 32768) and for -stsh?
2. Where to make those changes?
Code:
input from value(kFileToUpload).
/*get rid of first line, column titles*/
import unformatted junk.
repeat on error undo, leave:
create tt_pt_mstr.
IMPORT DELIMITER "," tt_pt_mstr.
end.
input close.
Thanks,
-Dan