SAP Knowledge Base Article - Preview

2925528 - SQL30128 Data overflow During E2E Alert Collection from Alert History

Symptom

Error SQL30128 is seen in SM21 work process coming from ASE_ALERT_HISTORY

C ERROR: -1 in function RefillBuffer (fetch) [line 31554]
C (30128) [HY000] [SAP][ASE ODBC Driver]Data overflow. Increase specified column size or buffer si
C ze
C sql statement is ==> select cast(METRIC_ID as varchar(5)), ENTITY, METRIC_VALUE from saptools..ASE_AL
C ERT_HISTORY where SNAPSHOT_TIMESTAMP in (SELECT max(SNAPSHOT_TIMESTAMP) from sa
C ptools..ASE_ALERT_HISTORY) and (METRIC_ID in (92,93) or (METRIC_ID > 120 and MET
C RIC_ID < 141))
C /* R3:CL_SQL_STATEMENT==============CP:500 T:ASE_ALERT_HISTORY M
C :001 */
C
C dbdssyb: DBSL99 SQL30128
C [ASE Error SQL30128:HY000][SAP][ASE ODBC Driver]Data overflow. Increase specified column size or buffer size
B ***LOG BY2=> sql error 30128 performing FET [dbds 543]
B ***LOG BY0=> [ASE Error SQL30128:HY000][SAP][ASE ODBC Driver]Data overflow. Increase specified column size or buffer size [dbds 543]
C


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP Solution Manager (SOLMAN) 7.1
  • SAP Solution Manager (SOLMAN) 7.2
  • SAP NetWeaver (NW) - All versions 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions ; SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

Keywords

  SQL30128, ASE_ALERT_HISTORY, Data overflow , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Known Error

About this page

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

Search for additional results

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