Update statistics failed for livecache

[Former Member]

Dear all,

Update statistic failed for livecache.Can some body help to find out the cause.

-

---

Start Update Statistik (CREATE_ESTIMATE) : Sun Jun 17 02:00:19 2007

-

---

DATABASE : SAPOGD@mou094-OGD

MAXDB version : Kernel 7.6.01 Build 009-123-141-487

trace level : 0

UPDATE STAT "SAPOGD"."/SAPAPO/OM_LCPROFDATA" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/OM_UPL" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/ORDKEY" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/ORDMAP" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/STOCKANC" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."/SAPAPO/UPGR_LC_ANCH" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."LCAALERTS" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."MATRIXINDEXTAB" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."MMRP_DATEVECS" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."RPM_PERF_DATA" ESTIMATE , rc = 0

UPDATE STAT "SAPOGD"."RPM_PLAN_FILE" ESTIMATE , rc = 0

-

---

executed : 11 tables | UPD STAT COLUMN : 0 tables

UPD STAT errors : 0 tables | UPD STAT TABLE : 11 tables

UPD STAT excluded : 0 tables |

-

---

End Update Statistik (CREATE_ESTIMATE), rc = 100 : Sun Jun 17 02:00:22 2007

Regards,

Tushar Chavan

[Former Member · Accepted solution]

Hello Natalia,

Thanks a lot for information.

Addition information you asked for:

DBSDBSLIB : version 700.08, patch 0.095 (Make PL 0.95)

livecache version : KERNEL 7.6.01 BUILD 009-123-141-487

SAP_BASIS: 700 SP 11

LCAPPS 2005_700 SP 4

SCM_BASIS 500 SP 8

Thanks and Best Regards,

Tushar

[former_member229109 · Accepted solution]

Plese review the SAP Note No. 1041547.

Thank you and best regards, Natalia Khlopina

[former_member229109]

Hello Chavan,

in liveCache, the user SAPOGD has more as one schema: SAPOGD, ....

The schema SAPOGD contains 11 tables while the others are empty.

The rc=100, which means 'Row not found', comes from the select statement for the another schemas which does not contain a table. This is a problem in the dbsl code and needs to be repaired. The error will be corrected in a future patch.

In the meantime, please ignore the rc=100 error. This problem is only a 'display' problem. The update statistics in liveCache is done correctly.

Please provide additional information:

-> What version of the dbsdbslib do you have on your system?

< See in dev log of the WP 0 >

-> What version of the liveCche do you have?

-> What version of SAP Basis SP?

Thank you and best regards, Natalia Khlopina