Error in univ. designer - 'Query rejected because plan exceeds stack space'

[Former Member]

Hi,

I am using BO XI R2, and trying to create an object in the universe designer. The object is complicated to a certain extent, since it is using fields from three different tables, and is performing mathematical operations on them. The object is thereby a measure object, and basically, is a combination of multiple (about 60) nested 'CASE WHEN THEN ELSE END's. Now, when I am writing the script in the 'SELECT' box, everything is OK upto 25 or 30 nested 'CASE WHEN...'s. However, when I try to add a couple of more 'CASE WHEN...' statements, I get the following error : ' Parse Failed:Exception:DBD[Sybase][ODBC Driver][Adaptive Server Anywhere] Query rejected because plan exceeds stack space --(df_Heap.cxx 1078) State :HY000 '

Any help on this issue would be appreciated.

Regards,

Alok.

[Former Member · Accepted solution]

ALok, this error is coming for the Sybase open client driver, possibly too many joins or some other limitation. See if you can take the SQL and run this directly via isql.