Kbase P132322: SQLLOAD fails with error when attempting to load table with large records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/13/2008 |
|
Status: Unverified
FACT(s) (Environment):
Windows
OpenEdge 10.x
OpenEdge Category: Migration
SYMPTOM(s):
SQLLOAD fails with error when attempting to load table with large records
Error inserting row <1> : sqlcode = -30034 : File <dsql_file_name>
Unable to connect to Server
Using SQLLOAD on some other tables in the same database works correctly
CAUSE:
The issue is related to the amount of data being sent by sqlload to the server. The server has a maximum packet size of 132,000 bytes. Anything larger than that will get rejected.
FIX:
As a workaround, use "hidden" option -c to limit the number of records in each packet sqlload passes to the server, for example:
sqlload -u <user> -a <password> -t <table> -c 15 progress:T:<host>:<port>:<dbname>