DBIF_RSQL_SQL_ERROR

[Former Member]

May you please help me resolve the following problem:

SQL error 1438 occurred when accessing table "GLT0 ".

What happened?

When writing a data record to the database (i.e. when

updating the database), only part of the data field was

written (updated). The rest was truncated.

Error analysis

The problem has arisen because, within the database interface,

one of the data buffers made available for the INSERT (UPDATE)

is longer than the maximum defined in the database.

On the other hand, it may be that the length in the NAMETAB

does not match the maximum length defined in the database.

(In this case, the length in the NAMETAB is longer.)

Information on where termination occurred

The termination occurred in the ABAP/4 program "SAPLGIVA" in

"UPDATE_TT_GLT0".

The main program was "RSM13000".

The termination occurred in line 542

of the source code of program "LGIVAF10" (when calling the editor 5420).

The program "SAPLGIVA" was started in the update system.

Source code extract

005120 HSL10 = HSL10 + TAB_GLT0-HSL10

005130 KSL10 = KSL10 + TAB_GLT0-KSL10

005140 TSL11 = TSL11 + TAB_GLT0-TSL11

005150 HSL11 = HSL11 + TAB_GLT0-HSL11

005160 KSL11 = KSL11 + TAB_GLT0-KSL11

005170 TSL12 = TSL12 + TAB_GLT0-TSL12

005180 HSL12 = HSL12 + TAB_GLT0-HSL12

005190 KSL12 = KSL12 + TAB_GLT0-KSL12

005200 TSL13 = TSL13 + TAB_GLT0-TSL13

005210 HSL13 = HSL13 + TAB_GLT0-HSL13

005220 KSL13 = KSL13 + TAB_GLT0-KSL13

005230 TSL14 = TSL14 + TAB_GLT0-TSL14

005240 HSL14 = HSL14 + TAB_GLT0-HSL14

005250 KSL14 = KSL14 + TAB_GLT0-KSL14

005260 TSL15 = TSL15 + TAB_GLT0-TSL15

005270 HSL15 = HSL15 + TAB_GLT0-HSL15

005280 KSL15 = KSL15 + TAB_GLT0-KSL15

005290 TSL16 = TSL16 + TAB_GLT0-TSL16

005300 HSL16 = HSL16 + TAB_GLT0-HSL16

005310 KSL16 = KSL16 + TAB_GLT0-KSL16

005320 WHERE

005330 RLDNR = TAB_GLT0-RLDNR AND

005340 RRCTY = TAB_GLT0-RRCTY AND

005350 RVERS = TAB_GLT0-RVERS AND

005360 BUKRS = TAB_GLT0-BUKRS AND

005370 RYEAR = TAB_GLT0-RYEAR AND

005380 RACCT = TAB_GLT0-RACCT AND

005390 RBUSA = TAB_GLT0-RBUSA AND

005400 RTCUR = TAB_GLT0-RTCUR AND

005410 DRCRK = TAB_GLT0-DRCRK AND

+>     RPMAX                   =  TAB_GLT0-RPMAX                  .+

005430 ENDFORM.

005440 *eject

005450 * *

005460 *

005470 * *

005480 * FORM UPDATE_TT USING UTP_TAB.

005490 * Diese Form fuehrt die Tabellenupdates durch

005500 * Dabei wird die optimierte Form von UPDATE

005510 * verwendet

005520 * *

005530

005540 FORM UPDATE_TT_GLT3 .

005550 DATA: W_0 LIKE GLU1-TSL VALUE 0.

[Former Member · Accepted solution]

Hi,

If you put in oracle forums then you will get reply immly.

Regards,

Anil