Kbase P8039: Limitation of a Temp-table generates error (4955)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/09/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Table signatures do not match in RAW-TRANSFER operation. (4955)
CAUSE:
Limitation of the temp-table. The problem is that the temp-table is incapable of supporting holes in the position, where database tables can.
CAUSE:
When the table definition was dumped, it included the position. In current versions of the data administration tool, this can be deselected, but it is default.
When the table was reloaded, it maintained the position from the .df file.
Ex. the position started at 12, which means that 11 fields prior to this had been deleted at one time or another.
When the temp-table was built, it started with position 1, therefore when the raw-transfer was done, the positions could not be synchronized, thus the error.
FIX:
To resolve this, dump the table with the 'Include POSITION for .r compatibility' option deselected and reload it