Kbase P99962: "Strent request for more than 64KB" when dumping a table from MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
OpenEdge 10.0A
MS SQL
SYMPTOM(s):
SYSTEM ERROR: strent request for more than 64K. (9874)
Trying to dump table contents in Data Administration Utility from MS SQL Server Database
The table contains a character field longer than 16K but smaller than 32K
The field is shown in schema holder as longvarchar
CAUSE:
Bug #20040422-030
CAUSE:
Progress MS SQL DataServer has a maximum field length of 16K by default
FIX:
Upgrade to Progress 9.1E or later
Upgrade to OpenEdge 10.0B or later
To workaround the issue, increase the maximum field length with MAX_LENGTH parameter as follows:
1) Disconnect from the schema holder and MS SQL Server database in Data Administration (menu option "Database" - "Disconnect")
2) Connect to the schema holder again (menu option "Database" - "Connect). In the connection window, click "Options" and add string "-Dsrv MAX_LENGTH,32000" to the field called "Other CONNECT Statement Parameters".
3) Reconnect to MS SQL Server database when prompted.
4) Dump table contents in the Data Administration tool (menu option "Admin" - "Dump Data Definitions" - "Table Contents")