SAP Knowledge Base Article - Preview

3580117 - SQL Error 274 "Inserted value too large for column" During Transport Import (S/4HANA)

Symptom

    During the import of a transport request in an SAP S/4HANA system, the following error occurs, causing the transport to fail:

    SQLCODE    : 274
    SQLERRTEXT : inserted value too large for column: TrexColumnUpdate failed on table 'SAPABAP1:TVGRT' with error: F\
                 ailed in "/1DH/USER" column with the value 'SAPServiceSID', rc=274
    statementHash=c3efde2a882c8a0e7ab0c027d0b16c02
    UPDATE "TVGRT" SET "BEZEI" = ? WHERE "MANDT" = ? AND "SPRAS" = ? AND "VKGRP" = ?;
    ***LOG BY4=>sql error 274    performing UPD on table TVGRT
    ***LOG BY0=>inserted value too large for column: TrexColumnUpdate failed on table 'SAPABAP1:TVGRT' with error: Failed in "/1DH/USER" column with the value 'SAPServiceSID', rc=274

    This error typically occurs when Change Data Capture (CDC) triggers are present on customizing tables, DDIC tables (like DD02L), or other tables whose content can be impacted by transports.


    Read more...

    Environment

    • SAP Landscape Transformation Replication Server (SLT)
    • SAP Data Intelligence / SAP Datasphere ABAP Integration

    Product

    SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

    Keywords

    SQL Error 274, inserted value too large for column, /1DH/USER, SAPServiceED2, TrexColumnUpdate, SAP Data Intelligence, SAP Datasphere, SAP S/4HANA, ABAP Integration , KBA , HAN-DB , SAP HANA Database , CA-DI-IS-ABA , ABAP Integration , Problem

    About this page

    This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

    Search for additional results

    Visit SAP Support Portal's SAP Notes and KBA Search.