SAP Knowledge Base Article - Preview

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

Symptom

  • 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 *:

Screenshot_25.png

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


Read more...

Environment

  • Db2 for LUW (Db6)
  • Oracle 12.1.0.2.0
  • SAP SOLUTION MANAGER 7.2 

Product

SAP Solution Manager 7.2

Keywords

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 page

This 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.