on 07-15-2008 1:22 PM
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,
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.