E2E BI HOUSEKEEPING

[shradhasampat]

Hello,

In our solman 7.1 system the job E2E BI HOUSEKEEPING finished but the spool has different errors & there st22 dumps too.

Found this note 1844955 but my question is :

1. We have not been using End to End analysis tab in solman workcenter tcode -> root cause analysis  so is this job still necessary to run in solman ?

2. If not, its been running for a while what would be the affect of un-scheduling the job now ?

3. Do I have to carry out any steps to check if doesn't affect any steps in solman or connected systems ?

Spool Errors :

*********************************************************************************************

Target Infocube: 0DB4_C04D

Source Infocube: 0DB4_C04H

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 :     3-

HK: Message:

Target 0DB4_C04D does not exist

Runtime [s]:   0

Target Infocube: 0ORA_C03D

Source Infocube: 0ORA_C03H

Destination    : NONE

Aggregator     :

E2E_HK_AGGREGATE_MDX

Delta          :         90

HK: Calling SMD_HOUSEKEEPER at NONE

HK: Cube aggregation: SMD_HK_AGGREGATE_MDX

System Failure:

Time limit exceeded.

Runtime [s]:      17.985

***********************************************************************************************

ST22 ( two dumps)

***********************************************************************************************

Category	ABAP Programming Error
Runtime Errors	DBIF_RSQL_TABLE_UNKNOWN
ABAP Program	SAPLRSDRD

Application Component  BW-BEX-OT

Date and Time

03/19/2014 05:31:31

Short text

A table is unknown or does not exist.

What happened?

Error in the ABAP Application Program

	The current ABAP program "SAPLRSDRD" had to be terminated because it has
	come across a statement that unfortunately cannot be executed.

What can you do?

Note down which actions and inputs caused the error.

	To process the problem further, contact you SAP system
	administrator.

	Using Transaction ST22 for ABAP Dump Analysis, you can look
	at and manage termination messages, and you can also
	keep them for a long time.

Error analysis

	A table is referred to in an SAP Open SQL statement that either does not
	exist or is unknown to the ABAP Data Dictionary.
	The table involved is "/BI0/F0ORA_C02D" or another table accessed in the
	statement.

*********************************************************************************************************

Category	ABAP Programming Error
Runtime Errors	TIME_OUT
ABAP Program	SAPLRSDRD

Application Component  BW-BEX-OT

Date and Time

03/19/2014 05:30:23

Short text

Time limit exceeded.

What happened?

	The program "SAPLRSDRD" has exceeded the maximum permitted runtime without
	interruption and has therefore been terminated.

************************************************************************************************************

Thanks

Shradha

[Former Member]

Hi Shradha,

E2E BI HOUSEKEEPING is must run job in solution manager. it is actually needed for your BI house cleaning.

1. We have not been using End to End analysis tab in solman workcenter tcode -> root cause analysis  so is this job still necessary to run in solman ?

In 7.1, there is no dedicated guided concept for RCA, if you have done managed system configuration iteself, most of the extractors were active for the system, the data collection and storing to BI has started. You must have this housekeeping job. Recently solution manager has UPL integration too. All these features would go long term if you have proper housekeeping activity scheduled. hence please make this job running without fail.

2. If not, its been running for a while what would be the affect of un-scheduling the job now ?
3. Do I have to carry out any steps to check if doesn't affect any steps in solman or connected systems ?

This is the independent job, will not affect any other scheduled jobs.

Refer my blog and the sap note 1480588 - ST: E2E Diagnostics - BI Housekeeping - Information

Please check

Thanks

Jansi