Solution : https://service.sap.com/sap/support/notes/1637822 (SAP Service marketplace login required)
Summary :
This SAP Note specifically addresses administration details for managing SAP Solution Manager systems on Microsoft SQL Server, covering both versions 7.0 EHP1 and 7.1. It includes tailored information about handling issues such as excessive growth in InfoCube database tables (/BI0/F0MSS*) and resolving numerous partitions causing SQL error 7719 during partition functions. Key solutions include updating authorization roles for housekeeping tasks and enabling the InfoCube Compression feature to manage partitions effectively. Recommended practices stated involve increasing dialog process timeout and regularly scheduling BW Compression jobs to optimize performance and system management.
Key words :
note documents sql server specific administration information, authorization object s_rs_icubersinfoarea= rsinfocube= rsicubeobj=definitionactvt=23, sap bw feature called infocube compression, create/alter partition function failed, dialog process timeout rdisp/max_wprun_time, infocube database tables named, sap supported database platforms, standard sap bw systems, schedule bw compression jobs, sap solution manager systems
Related Notes :
| 1582842 | Profile parameters for Solution Manager 7.1 |
| 1570399 | Solution Manager BI reporting |
| 1510178 | Infocubes remain in loading mode after Housekeeping timeout |
| 1492999 | DB6: DPW - House keeper does not delete old data |
| 1480588 | ST: E2E Diagnostics - BI Housekeeping - Information |
| 1404478 | DB6: Database Performance Warehouse Aggregation Overflows |
| 1254977 | ST: Memory Problem for E2E Housekeeping job |
| 1178655 | E2E Diagnostics - BI InfoCube compression - information |
| 1010854 | SQL error 7719 |