Kbase P23070: Error 444 when migrating Progress table into MS SQL Server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
26/10/2009 |
|
Status: Verified
SYMPTOM(s):
Migrating Progress database to MS SQL Server
Using the Schema Migration tool, Progress To MS SQL Server
** Attempt to expand record beyond the maximum allowed size. (444)
970 fields has been created into the MS SQL Server table
FACT(s) (Environment):
MS SQL DataServer
Progress 9.x
OpenEdge 10.x
CAUSE:
The 32K restriction for accessing a SQL Server Table has been reached.
See below how to calculate a Tables Maximum size when using the MS SQL Server Dataserver:
Column Names - C bytes Length of all column names separated by commas
Header - 4 bytes
Column Descriptor - (20 * n) bytes where n is number of fields
Extension - ( 5 * n) bytes
Terminator - 2 bytes
For example:
Column Names: 9609
Header: 4
Column Descriptor: 20 * 970 = 19400
Extension: 5 * 970 = 4850
Terminator: 2
---------------------------------------
Total: 33865 which exceeds 32000 and causes an error
FIX:
Reduce the number of fields in the Progress table in order to avoid the 32K limit.