Question:
Hi all!
We detected a problem in CIC0 transaction. Several times the
transaction takes a long time to retrieve business partner activities
(45 seconds or more). This provoques a big problem in our firm bacuase
our clients are wainting on the phone.
We looked for some oss notes but we couldn't find anything at all about
this problem.
We found using transaction ST04 a poor performance in access to CRMD_ORDER_INDEX table (it is doing a secuential read fo
this table, that takes a long time). We attach the ST04 result data.
Does anybody know what is going on?
Thanks in advance!
Answer:
Have you tried re-indexing (full compile) the TREX knowledge base in question?
regards.
Answer:
Have you tried performing a runtime analysis on CIC0 (Txn SE30) ?
You can use this to find the bottle necks in the process. You will be able to see if the problem is in DataBase selects or an ABAP user exit.
if it's the DB, you will be able to determine which table and/or index.
Cheers
James