Solution : https://service.sap.com/sap/support/notes/568632 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues encountered with BW queries, including navigational attribute activation and DataMart extraction, specifically when exceeding maximum extents in Oracle (ORA-01631) or encountering errors in DB2/UDB (SQL0289). The problem stems from BW temporary tables being generated from the table template QUERY_TABL_MODEL, which uses predefined data classes and size categories. The resolution involves adjusting the size category and data class for QUERY_TABL_MODEL within the R/3 data dictionary to better accommodate the expected data records, ensuring the settings align with your system's largest dimension table or master data SID table specifics.
Key words :
terms disk storage tablespace container datafile psappoold query_tabl_model /bi0/01xxx reason, /bi0/01xxx db2/udb, temporary sid tables /bi0/06, prerequisites bw temporary tables, master data sid table, normal bw queries, 0b sp 24 / bw 3, master data entries, table template query_tabl_model, data records expected
Related Notes :
| 666061 | FAQ: Database objects, segments and extents |