How can I rectifie C/AL stack error

ajaybabuCh

Hi

While I am executing the follwoing

SQLString1 and SQLString2 of length 1024

ADORecSet.Open('SELECT '+SQLString1+SQLString2+' FROM '+ FORMAT(SQLTableID),ADO);

It throws me the error

There is not sufficient space in C/AL stack memory to execute this task.

There are two many simultaneous activities, due to the way recursive function calls is used in the programs. The problem can be solved temporarly by shutting down some of the open activities(but the function still cannot be executed)

how can i rectifie this error.

ajaybabuCh

can anybody give me an idea

garak

whats the stringlenght of the sql command :?:

ta5

Do you get the same error if this command is executed without any other commands (e.g. in a test code unit)? This way we can avoid some side effects.

Thomas

Saint-Sage

This sounds like you are either getting too many records from your query to hold in memory (HUGE recordset), or your error is being generated somewhere else in your code. I have only had this error when I set up a recursion with no ending.


I.E. Codeunit A calls Codeunit A, over, and over, and over again...


You should do some test by either restricting your query to a single record, I.E. WHERE keyname = 'xxx', or check over your report/codeunit/form and look for calls to itself, or another codeunit that will call the original.

I.E. Codeunit A calls Codeunit B which then calls Codeunit A.

ajaybabuCh

I am not running any recursive procedures.

I am generating the sql string dynamically , instead of hardcoding it

i have two string with 1024 of length

if try to execute like this

ADORecSet.Open('SELECT '+SQLSTRING1+SQLSTRING2+ ' FROM '+FORMAT(SQLTABLEID),ADO).

I am getting stack overflow error.

ta5

Does it work with shorter sql strings (shorter than 254)?
Of course this is not the solution, but we get closer to the problem =P~
Thomas

matteo_montanari

ta5 wrote:

Does it work with shorter sql strings (shorter than 254)?
Of course this is not the solution, but we get closer to the problem =P~
Thomas

Hi

Try a temporary variable text length 1024

tmp := 'SELECT '+SQLSTRING1;
tmp := tmp + SQLSTRING2;
tmp := tmp + ' FROM '+FORMAT(SQLTABLEID);

ADORecSet.Open(tmp ,ADO).

Matteo

ajaybabuCh

the problem here is if it exceeds like 20000 characters

its throwing the stack overflow error.

not with 1024 characters.