Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


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


I did so and it helped.

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



Not what you were looking for? View more on this topic or Ask a question