When archiving data using Archive Manager (formerly known as DIET) from an Oracle database containing records with fields of type LONG having more than 32K of data you will get the following error:

ERROR  - ORA-01406: fetched column value was truncated

Only the first 32K of data from the LONG field for the record will be written to the archive.

Archive Manager allocates a buffer of 32K for LONG data. This is consistent with Clarify's 32K limit for LONG columns.  Later versions of Clarify have replaced the use of LONG types with CLOBs.

If you need to archive records having LONGs with greater than 32K of data you should consider converting all fields that are of type LONG to CLOB.

For more information on how to do this we recommend searching the Internet for:  "Converting LONG to CLOB"

We are also considering approaches to allow Archive Manager to handle this situation better.

• ArchiveManager – Dovetail ArchiveManager (formerly Data Import Export Tool)