RE: KB-stack overflow

Dmitry Melekhov wrote:

> I'm newbiew with SAP DB.
> We try to migrate to SAP DB from Oracle.
> 
> Here is error we got:
> 
>   General error;-1104 POS(2048) Too complicated SQL statement 
> (KB-stack 
> overflow).
> 
> Is there any way to increase stack?

The only way to increase the stack which is relevant for this 
error message is to increase the database parameter _PACKET_SIZE.

Following dependency exist between _PACKET_SIZE and the stack size
_PACKET_SIZE <= 16384 -> stack size: 8192
_PACKET_SIZE <= 65536 -> stack size: 16384
_PACKET_SIZE >  65536 -> stack size: 32768

But I'm interested in the command which will result in this stack 
problem. Perhaps you could post it here.

Best regards,
Holger
SAP Labs Berlin