cancel
Showing results for 
Search instead for 
Did you mean: 

Early watch alert + Error

Former Member
0 Kudos

Hi All,

In our landscape early watch alert session will generate TIME_OUT dump for DLD_SQL_STMTS_ORA step.

Below are the logs which are mentioned as error and warning in Early watch alert session logs (in SDCCN)

********

ERROR: 10.07.2008 05:31:42 DLD_SQL_STMTS_ORA : Time limit exceeded. on scdbwtst_TBW_00 /BDL/SAPLBDL3

Warning:

10.07.2008 05:32:30 > ARCH_OBJECTS_TOP_GET : # of exp params in funcmod > # of exp params in mod 000070 /BDL/SAPLBDL3

10.07.2008 05:32:30 > ARCH_OBJECTS_TOP_GET : inconsistency in # of exp params found for mod 000070 /BDL/SAPLBDL3

10.07.2008 05:32:47 > FILL_SNAPSHOT_DATA : # of tables in funcmod > # of tables in mod 000605 /BDL/SAPLBDL3

10.07.2008 05:32:47 > FILL_SNAPSHOT_DATA : inconsistency in # of tables found for mod 000605 /BDL/SAPLBDL3

10.07.2008 05:32:47 > FILL_SNAPSHOT_DATA : # of exp params in funcmod > # of exp params in mod 000605 /BDL/SAPLBDL3

10.07.2008 05:32:47 > FILL_SNAPSHOT_DATA : inconsistency in # of exp params found for mod 000605 /BDL/SAPLBDL3

10.07.2008 05:32:47 EWA_GET_PARAMETER_DATA_I : Approximate Download with module 000119 /BDL/SAPLBDL3

*********

We ran pgm RTCCTOOL as mentioned in Early watch report and status is showing green fro all notes.

***********

Checks were not performed. This is most likely due to a problem with data collection or transfer. The overall report has a yellow rating due to these unperformed checks.

Recommendation: Check the "log" for this session in the Service Data Control Center (call transaction SDCC or the new SDCCN in your system). If an error is listed, perform the Service Preparation Check. You can execute this check in the SDCC by choosing "Information -> Service prep. check", or by creating a new "Service Preparation Check" task in SDCCN.

If the check displays a missing SAP Note, implement this Note.

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

******

Status List

No. Missing addon/ transport / note Transport log

Description Implementation

Successfully implemented addons/ transports/ notes

[Note 69455 ] Addon ST-A/PI 01K_BCO700

Note 69455

[Note 539977 ] Addon ST-PI 2005_1_700

Note 539977

Note 12103

Note 883111

***********

We are in BI 7.0 SPS 14 and Oracle DB 10.2.0.2. PLease help me on this. We are using SOLMAN to generate Early watch report.

Regards

Preethish,

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Preethish,

for the TIME_OUT dump for DLD_SQL_STMTS_ORA I would recommend checking that the statistics described in note 8387250 have been created.

Does the report say which checks were not performed? Without this information, it's difficult to guess which data might be missing.

It's probaby also a good idea to check the topics mentioned in note 762696 - some of the causes may be the same for the problem you describe.

best regards,

-David.

Former Member
0 Kudos

Hi David,

EW report has message

***

The table below lists all of the checks that are not performed automatically.

Rating Not Performed Checks

-- History of Activity and Average Response Times

-- Plug-In release Configuration

***

Thanks..

Preethish

Former Member
0 Kudos

Hi Preethish,

I don't know which version of ST is on your Solution Manager...if it's an older version, then perhaps note Number 1082176 might be of assistance.

best regards,

-David.

Former Member
0 Kudos

reference should be to note 838725