Error when saving to clob field

Posted by Andrei Popa on 06-Sep-2017 07:12

Hi,

When I try saving a longchar to a clob field I get the following error:

Error reading socket, ret=10054, errno=2. (778)
** Incomplete write when writing to the server. (735)
Failure in large object operation, error = -1218 (16683)
Could not update large object segment during copy. (11322)
** Unable to update lbTxt Field. (142)

This is the assignment that generates the error:
ASSIGN
   lbTxt.txtASCIIx = pcTextASCII
   lbTxt.txtHTMLx  = pcTextHTML
   .

I have also tried using COPY-LOB:
MESSAGE "Before first copy-lob".
COPY-LOB pcTextASCII TO lbTxt.txtAsciix.
MESSAGE "Before second copy-lob".
COPY-LOB pcTextHTML TO lbTxt.txtHTMLx.
MESSAGE "After assign".

This is what I get now in the logs:
Before first copy-lob
Before second copy-lob
Error reading socket, ret=10054, errno=2. (778)
** Incomplete write when writing to the server. (735)
Failure in large object operation, error = -1218 (16683)
Could not update large object segment during copy. (11322)

More information: pcTextASCII is empty and I am running on 11.7.1.

All Replies

Posted by Brian K. Maher on 06-Sep-2017 07:16
Google...
 
site:knowledgebase.progress.com 16683 1218
 
You will find KB articles giving answers.
Posted by Andrei Popa on 06-Sep-2017 08:19

I have been searching for an article for some time but I cannot find an anything about 16683 with error=-1218.

Posted by Brian K. Maher on 06-Sep-2017 08:28
Can you give me more details on the code?  Is it running within a database trigger?  How large is the clob data?
 
 
Posted by Andrei Popa on 06-Sep-2017 08:50

The code is being run from a PASOE.

It's located in a static method.

This would a short version of the method:

---------------------------------------------------------------------------------------

Parameters:

  ... AS CHARACTER

  ... AS CHARACTER,

  ... AS CHARACTER,

  pcTextASCII AS LONGCHAR,

  pcTextHTML AS LONGCHAR,

  ... AS CHARACTER

---------------------------------------------------------------------------------------

/* define variables */

DEFINE BUFFER lbTxt FOR txt.

/* some assignments to the variables */

DO FOR lbTxt TRANSACTION:

FIND lbTxt WHERE ... EXCLUSIVE-LOCK NO-ERROR.

IF NOT AVAILABLE lbTxt THEN

DO:

CREATE lbTxt.

/* assignment of lbTxt's character fields */

END.

ASSIGN

lbTxt.txtASCIIx = pcTextASCII

lbTxt.txtHTMLx = pcTextHTML

/* assignment of another character field */

.

/* execution doesn't reach the next statements */

END.

---------------------------------------------------------------------------------------

The longchar contains information from a text file, which has 2893 characters

Let me know if there is additional information I should provide!

This thread is closed