Article

COPY-LOB from database CLOB field to a file corrupts the XML

« Go Back

Information

 
Article Number000034144
EnvironmentProduct: OpenEdge
Version: 11.1
OS: Windows (client), Linux 32-bit (database)
Question/Problem Description
When using COPY-LOB to copy data from a database CLOB field to a file, the data is corrupted.  For example if the data represents an XML file, then a few characters are missing from the beginning.  Instead of:
 
<?xml version="1.0"?>

the file begins:
 
l version="1.0"?>

The problem can be reproduced with code similar to:
 
DEFINE VARIABLE lcLob AS LONGCHAR   NO-UNDO.
 
COPY-LOB file "C:\Results.xml" to lcLob.
COPY-LOB lcLob to file "C:\ResultsAfterCopyToLongChar.xml".
 
CREATE XMLRecord.
COPY-LOB lcLob to XMLRecord.valueclob.  /* vlaueclob is an iso8859-1 CLOB field */
 
COPY-LOB contextvalue.valueclob to file "C:\ResultsAfterCopyToCLOB.xml".
Steps to Reproduce
Clarifying Information
The problem only happens:

- When the client is an OE 11.1 Windows client connecting to an OE 11.0 database on Linux.
- The database product version is OE 11.0 32-bit.

The problem does not happen:

- When the database is on a Windows platform.
- When the database version is OE11.1.
- When the database product version is 64-bit.
Error Message
Defect/Enhancement NumberDefect PSC00246965/OE00224001
Cause
Regression caused by fix for defect PSC00241767/OE00217889. Calculation of the size of an internal structure is incorrect for this combination of platforms due to differing boundaries.
Resolution
Upgrade to OpenEdge 11.2 or later.
Workaround
Use an 11.1 64-bit database on Linux.
Notes
References to Other Documentation:

Progress Articles:

000028528, WIN32 client crashes when COPY-LOB from Unix db server
 
Attachment 
Last Modified Date4/14/2016 5:55 PM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025