- E2E BI HOUSEKEEPING job runtime is increaing continuously after system is upgraded to SAP Solution Manager 7.2 system to one of the following SAP BW releases:
SAP BW 7.01 SP19 or higher
SAP BW 7.02 SP19 or higher
SAP BW 7.30 SP17 or higher
SAP BW 7.31 SP20 or higher
SAP BW 7.40 SP17 or higher
SAP BW 7.50 SP7 or higher
SAP BW 7.51 SP2 or higher
- SAP application log shows the error message for the E2E BI HOUSEKEEPING job.
“You cannot use the same dimension on different axes"
- If you check the Spool for the job, you can see this error message for some Infocubes:
Target Infocube: 0DBH_C01D
Source Infocube: 0DBH_C01H
Destination : NONE
Delta : 90
HK: Calling SMD_HOUSEKEEPER at NONE
HK: Cube aggregation: SMD_HK_AGGREGATE_MDX
HK: Error detected by SMD_HK_AGGREGATE_MDX
HK: Status : 1-
Errors ( 1745 ) occured during transfer! See occured during transfer! See SLG1 in BI client (object: BW_PROCESS)
Runtime [s]: 99999
- If you check further in the SLG1, filtering by the Object as 'BW_PROCESS and the External ID as one of the affected Infocubes surrounded by *:
You will find this error message:
Error selecting data (RC = E):
You cannot use the same dimension on different axes
Cleaning up dimensions for infocube <infocube> skypped
- Db2 for LUW (Db6)
- Oracle 22.214.171.124.0
- SAP SOLUTION MANAGER 7.2
smd_hk_aggregated_mdx, MDX_ALLOW_DUPLICATE_USE, max_wprun_time , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-DB-ORA-CCM , (CCMS) Database Monitors , SV-SMG-DIA-SRV-EFW , Extractor Framework , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.