-9211 POS(1) System error: KB Stack type illegal. + OPTIMIZE_AGGREGATION NO

[Former Member]

Hello!

I have a query like this:

SELECT businessinvocation1.COMP_ID as x0_0_, count(businessinvocation1.COMP_ID) as x1_0_ FROM BUSINESS_INVOCATIONS businessinvocation1 WHERE businessinvocation1.COMP_ID in

(SELECT DISTINCT d.ID FROM J2EE_CONFIGURATION_BEAN dwhere d.J2EECOMPONENTID!=0 and d.J2EECOMPONENTID!=d.ID AND d.J2EECOMPONENTID=306245313679589393 ) GROUP BY businessinvocation1.COMP_ID HAVING (Count(businessinvocation1.COMP_ID)>0 ) ORDER BY Count(businessinvocation1.COMP_ID)Desc

Sometimes it throws exception like this:

-9211 POS(1) System error: KB Stack type illegal.

In one of the "google" post it was recomendet to set

OPTIMIZE_AGGREGATION NO

I did so and it helped.

What can be problems by seting OPTIMIZE_AGGREGATION NO??? (lower performance???)

Thanks,

Anya

[Former Member]

Hello,

yes, it can lower the performance for some SQL statement. That's why the upgrade of the database to the version where the bud is resolved is the better solution. Please check the SAP note 708163 whether it matches your situation.

Kind regards,

Oksana Alekseious