2647508 - Job 'E2E BI HOUSEKEEPING' is running for a long time

• 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
Aggregator :
E2E_HK_AGGREGATE_MDX
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-
HK: Message:
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 12.1.0.2.0
• SAP SOLUTION MANAGER 7.2 

smd_hk_aggregated_mdx, MDX_ALLOW_DUPLICATE_USE, max_wprun_time, e2e_hk_controller , KBA , BC-DB-DB6-CCM , CCMS/Database Monitors , BC-DB-ORA-CCM , (CCMS) Database Monitors , SV-SMG-DIA-SRV-EFW , Extractor Framework , Problem