Solution : https://service.sap.com/sap/support/notes/21495 (SAP Service marketplace login required)
Summary :
The SAP Note addresses the conversion of update tables VBHDR, VBMOD, and VBDATA to transparent tables in the SAP R/3 system. The note specifies that when an update request exceeds 7.5 MB, performance issues may arise due to the inability of a cluster record to handle large sizes. A detailed solution is provided, applicable to various database systems including INFORMIX, MS-SQL Server, and ORACLE, among others. It includes steps such as halting new update requests, ensuring VBLOG is empty, exporting and setting table transparency via the ABAP/4 Dictionary, and a final check to confirm proper functionality.
Key words :
menu extras --> change table category --> transparent database table --> choose --> activate 5, initext nextext minext maxext tablespace, ms-sql server database system, additional key words dbif_rtab_no_memory, --> change table <vb, converting totransparent update tables, 10240 10240 1 300 psapclud --> save --> index parameters, symptom update tables vbhdr, ms-sql server, create table statement
Related Notes :
| 138549 | DBIF_RTAB_NO_MEMORY error during Insert in VB* table |
| 128535 | CM25: DBIF_RTAB_NO_MEMORY |
| 108328 | DBIF_RSQL_NO_MEMORY during access to cluster table |
| 34985 | IL02/IE02:Lock problems in large object hierarchies |
| 34211 | FBRA - Update termination DBIF_RTAB_NO_MEMORY |