Kbase P125609: Error 1410 dumping records from a big table through Oracle data server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/08/2007 |
|
Status: Unverified
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
Oracle 8.x
Oracle 9i
SYMPTOM(s):
Error 1410 dumping records from a big table through Oracle data server
Error code <number> returned from fdfnd. (1410)
Error code -1234 returned from fdfnd. (1410)
The dump errors out at different records
"For each.. export" also produces the same error at different records
All other tables dump OK
This specific table has a LONG column
CAUSE:
The exact cause is unknown at the time of writing.
The data server code errors out when the internal held record length is smaller than odefine returned record length when dealing with LONG columns. The internal held record lenght is returned when we use ROWID to refetch record when the record's LONG column is greater than 256. This code is only executed when using lookahead cursors which is default.
FIX:
Use following export code to export records
FOR EACH Table QUERY-TUNING(no-lookahead) where ... NO-LOCK:
Export ...