Kristian Rink wrote: > > > Hi all; > > some time ago I was suffering from Error -1104 "Too complicated SQL > statement", which, after reading through the mailing list, I > resolved by > drastically increasing _PACKET_SIZE. So far, so good. > > Anyhow, now the problem is there again. _PACKET_SIZE is > increased to its > maximum value, and so I'm feeling pretty much lost. Are there > any other > options to get rid of that error? > > Just for your entertainment and perhaps any helpful hints, I attached > the SQL query to be responsible for causing this error. My problem is: > Building these queries is part of the logic provided by the DMS we run > atop MaxDB, and we don't have ways to change the way how that query is > built (otherwise I'd probably use some sort of JOIN for that). > > > However: Is there any help in that situation?
Yes, as Lars wrote: think about the statement or increase _MBLOCK_STACK_SIZE _MAXTASK_STACK has nothing to do with error -1104 KB !! stack overflow Elke SAP Labs Berlin > TIA and bye, > Kristian > > > > -- > Kristian Rink -- Programmierung/Systembetreuung > planConnect GmbH * Strehlener Str. 12 - 14 * 01069 Dresden > Tel: 0351 4657770 * Fax: 0351 4657778 * [EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
