Solution : https://service.sap.com/sap/support/notes/1425175 (SAP Service marketplace login required)
Summary :
The SAP Note addresses flaws with the SAP_NOT_NULL_REPAIR_ORACLE program involving incorrect time measurements, statistic sample settings, parallelism, TEMPSPACE consumption, and COUNT(*) selection. Solutions involve adjusting time to seconds, reconfigurable statistic sampling, a new RSADMIN parameter for setting parallelism, and modifying the INSERT-SELECT statement to reduce TEMPSPACE issues. Relevant for SAP NetWeaver BW from versions 7.00 to 7.20, updates are available through specific Support Packages which are detailed in supplementary SAPBINews notes. Immediate action through advance correction is possible by referring to Note 875986 on using transaction SNOTE.
Key words :
tempspace problem sap netweaver bw 7, insert-select statement avoids, sap netweaver bw 7, sap nw bw 7, statistics- tempspace consumption, sapbinews nw bi 7, input parameter i_perc, symptom program sap_not_null_repair_oracle, 00import support package 24, import support package 07
Related Notes :
| 1419541 | Preliminary version SAPBWNews NW BW 7.10 ABAP SP10 |
| 1407600 | SAPBWNews NW BW 7.02 ABAP SP03 |
| 1407599 | Preliminary Version SAPBWNews NW BW 7.20 ABAP SP03 |
| 1407598 | SAPBWNews NW BW 7.0 ABAP SP 24 |
| 1392433 | SAPBINews NW7.11 BW ABAP Support Package 05 |
| 1383233 | SAP_NOT_NULL_REPAIR_ORACLE generates invalid SQL statement |
| 1369294 | SAPBINews NW7.01 BW ABAP Support Package 07 |
| 1287382 | Extending BW objects on Oracle with large tables |