Добрый день!

у меня в Query происходит непонятная ошибка:

Selections в Query:
-Controlling Area
-Fiscal Year/Period
-Currency Type
-CostCenter Hierarchy
-CostCenter Hierarchy Node

Koгда я запускаю Query только с Selections БЕЗ CostCenter Hierarchy Node то всё быстро находится и показывается.

Если в Selections я задаю СostCenter Hierarchy Node то Query зависает и выдаёт ошибку.

Это происходит при вызове через Analyzer и через RSRT напрямую.

Что это может быть???

Заранее спасибо
Юлия

попробуйте в RSRT проверить по ноте:
2125357 - How to use transactions RSRT/RSRT2 to analyze unexpected query results

это была ORACLE установка неправильная
ответ SAP через OSS

1577484 Stabilizing Oracle parameter settings
_OPTIMIZER_MJC_ENABLED = FALSE
_OPTIMIZER_NEW_JOIN_CARD_COMPUTATION = FALSE

Full Answer:

Dear XXX,

Thank you for your detailed reply.

I have executed the described query scenario on your system and
identified the affected SQL-Statmement (see my attachment). As you can
see from the generated execution plan there are several MERGE JOIN
CARTESIAN operations including indicating a poor execution plan. So it
seems that there is still some problem with your database instance
being able to create an efficient execution plan for some
SQL-Statements.

As a short-term solution please first try to solve the actual issue by
setting the stabilizing Oracle Parameters as mentioned in SAP note
1577484:

1577484 Stabilizing Oracle parameter settings
_OPTIMIZER_MJC_ENABLED = FALSE
_OPTIMIZER_NEW_JOIN_CARD_COMPUTATION = FALSE

For a more general solution please check if the problem can be fixed
by applying the latest SBP for Oracle 11.2.0.3.0 (see SAP note
1631931) and afterwards adjusting the DB parameters according to the
SAP recommendations (see note 1171650). As you can see from your
attachment your database incsantce is currently based on outdated DB
Bundle Patch: 1303.

Many thanks and best regards,
XXX