Skip to Content

'Strange' behaviour in KMC

Hi experts,

We run into the following:

When we open a (wpc) webpage in our enterprise portal sometimes the responsetimes are well and sometimes really bad. This fluctuates continously, with no pattern what so ever (if executed twice right after another one can be slow and the other OK).

We have ran a Wily Introscope trace on it and found that whenever the page is slow additional actions are performed:

1. excessive database access on a few tables. It looks like it performs numerous queries which all look the same, e.g.:

38 times: SELECT "NODEID", "STRINGVALUE", "LARGESTRINGVALUE" FROM "KMC_DBRM_PROPS" WHERE "NAMESPACEID" = ? AND "LOCALNAMEID" = ? AND ("NODEID" = ? OR ...

957 times: SELECT "CHILDNODEID" FROM "KMC_DBRM_RELATIONS" WHERE "PARENTNODEID" = ? AND "HASHCODE" = ? AND "NAME" = ?

All individual SQLs are quite short, but since they are performed so many times this slows down the webpage.

2. SAP Portal|Applications|CM|Repository|Collection|TaxonomyCollection|getChildren

3. Some more actions

These additional actions cause the webpage to be slow and are not peformed when the responstime of the webpage is OK.

Does this ring a bell to anyone?

Can it have something to do with caching? Or content being changed in collaboration rooms?

Thanks,

Bart Groot

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 03:11 PM

    Hi,

    We had a similar issue with few selected WPCs which were taking really long (to an extend that our portal server use to crash after few mins)

    It seemed those WPCs were corrupted and we just deleted and created fresh one's. Do check if there are selected wpcs which are causing issues or all of them. If all are causing the wpcs are causing the issue then also check the wpc layout being used if its a custom one.

    -JJ

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.