Solution : https://service.sap.com/sap/support/notes/1178655 (SAP Service marketplace login required)
Summary :
SAP Note alerts users about the necessity of compressing data in E2E cubes to avoid database error ORA-14400 during INS access to tables like /BI0/F0SMD. It details that compression must be managed carefully, particularly in Oracle environments, and avoided for the last three days of data essential for E2E housekeeping. Recommendations include adjusting request statuses within InfoCubes and maintaining low partition counts in the database. Further guidelines for effective compression strategies and partition management are supplied, emphasizing regular housekeeping and review practices before scheduling data compression operations.
Key words :
/saphelp_nw70/helpdata/en/ca/aa6437e7a4080ee10000009b38f842/frameset, change real-time load behavior, real-time date target, [rsql/insr//bi0/f0smd_ea2d ], bi production support recommends, e2e housekeeping deletes data, e2e workload cube 0smd_pe2h, database error text ora-14400, support parallel write, 'runtime errors dbif_rsql_sql_error
Related Notes :
| 1637822 | SAP Solution Manager 7.* Administration on MS SQL Server |
| 1480588 | ST: E2E Diagnostics - BI Housekeeping - Information |
| 1013912 | FAQ: Oracle BW performance |
| 1010854 | SQL error 7719 |
| 590370 | Too many uncompressed request (f table partitions) |