May 31, 2018 at 03:06 AM

SQL Error -99999 when accessing table ACCTIT

771 Views Last edit May 31, 2018 at 06:08 AM 2 rev

Dear Gurus,

Need your help.

When I running tcode MIGO or VL02N document was posted but pop up 'Update was terminated' has occured. Check on ST22, this is what happened :

"CLI0109E String data right truncation. | | SQLSTATE=22001 row=1 col=124"

here is part of the ST22 :

Category Installation Errors

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Date and Time 24.05.2018 09:43:21

|Short text | | SQL error "-99999" when accessing table "ACCTIT".

|Error analysis | | An exception occurred that is explained in detail below. | | The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught | | in | | procedure "AC_DOCUMENT_MM_UPDATE" "(FUNCTION)", nor was it propagated by a | | RAISING clause. | | Since the caller of the procedure could not have anticipated that the | | exception would occur, the current program is terminated. | | The reason for the exception is: | | Error Text of the Database: "CLI0109E String data right truncation. | | SQLSTATE=22001 row=1 col=124"

Source Code Extract

FUNCTION ac_document_mm_update.

| 19| ENDIF. |

|>>>>>| INSERT acctit FROM TABLE t_acctit. |

| 21| IF NOT sy-subrc IS INITIAL. |

| 22| MESSAGE a401.

Have any of you ever experienced this? this error only occurs in Development area.

additional info of environtment:

ECC6

SAP APPL 605-0007 (SAPKH60507)

DB2 LUW

please enlightened me.

Thank you,

Sty