'Out of stack space' error

[Michael Blake]

When calling for data from a SQL Server DB, I received the following error:

Microsoft VBScript runtime error '800a001c'
Out of stack space: 'BreakLine'
/RepGenInfo_w.asp, line 11

Can anyone help me figure out how to overcome this?

[Chad Myers]

"Michael Blake" <bl...@nccn.org> wrote in message
news:8s21ee$lkf$1...@bob.news.rcn.net...

Could you post some code so we can get some context?

Are you using a recursive function? Sometimes recursive functions,
if not controlled properly, will max out the stack and cause this error.

-Chad

[jim_w]

hi Michael,

I had one experience with running out of stack space. It happened with
"recursive" subroutine calls (you know, when a subroutine calls itself
repeatedly). The system was saving the "return" parameters in a "push down"
stack, and when I had done this too many times, it ran out of space.

I'm not sure how this experience might apply to your situation, but I
suspect that either your query is causing a loop calling subs, or it is
somehow too complicated for the stack space allocated on the server machine.
(And, don't ask me how to increase the stack space).

hth, jw

[Michael Blake]

I'm using a recursive function, which is the cause of the problem. I'm
trying to take data from a database and send it to a text file. With
certain lines, in order for them to wrap in the browser and not force the
user to scroll left-right, I call this function:

Function BreakLine(ObjFile, str)
length = Len(str)
If length < 80 Then
ObjFile.WriteLine str
Else
firstspace = InStr(80, str, " ")
line1 = Left(str, firstspace)
line2 = Right(str, (length - firstspace))
ObjFile.WriteLine line1
line2 = BreakLine(ObjFile, line2)
End If
End Function

It obviously is recursive, causing the problem. Any suggestions on
overcoming it? Thanks!

"Chad Myers" <cmy...@NOSPAM.austin.rr.com> wrote in message
news:OwwHcx5...@cppssbbsa02.microsoft.com...

>
> "Michael Blake" <bl...@nccn.org> wrote in message
> news:8s21ee$lkf$1...@bob.news.rcn.net...
> > When calling for data from a SQL Server DB, I received the following
error:
> >
> > Microsoft VBScript runtime error '800a001c'
> > Out of stack space: 'BreakLine'
> > /RepGenInfo_w.asp, line 11
> >
> > Can anyone help me figure out how to overcome this?
>

[smoothly...@gmail.com]

On Wednesday, October 11, 2000 at 3:00:00 AM UTC-4, Michael Blake wrote:
> When calling for data from a SQL Server DB, I received the following error:
>
> Microsoft VBScript runtime error '800a001c'
> Out of stack space: 'BreakLine'
> /RepGenInfo_w.asp, line 11
>
> Can anyone help me figure out how to overcome this?

I am getting the same error when trying to open a file on my hard drive.
In my situation, I get a popup that says;
Script: C:Users\Plee\Documents\Court_Notificatio...
Line: 1
Char: 17786
Error: Out of stack space
Code: 800A001C
Source: Microsoft JScript runtime error

Does anyone know what this file is or how I can get it open to find out?
Thanks in advance for any help. ALso;
SOrry to troll your thread man :-(
But this is the only closest result I could find after consulting google, it sent me here and I am computer illiterate, other than being able to write a simple program in BASIC many years ago as an elective course requirement in college for my business degree.

[Evertjan.]

smoothly...@gmail.com wrote on 29 mei 2015 in
microsoft.public.scripting.vbscript:

> Source: Microsoft JScript runtime error

Wrong NG, this is about VBScript, not JScript.

> I am getting the same error when trying to open a file on my hard drive.
> In my situation, I get a popup that says;
> Script: C:Users\Plee\Documents\Court_Notificatio...
> Line: 1
> Char: 17786
> Error: Out of stack space
> Code: 800A001C
> Source: Microsoft JScript runtime error

So, it looks like you are using a jscript script
on cscript or wscript, and the script errors out.

It probably means that a function is recursively calling itself in an
infinite loop and therefore the script has run out of stack space. If you
are calling a function recursively make sure that it returns at some point
of time.

<https://www.webmasterworld.com/forum47/227.htm> [2002!]

So understand and correct the script.

> I am computer illiterate

Scripts that you do not understand you should NEVER use,
as they could clean out your entire HD and your bank-account.

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[Todd Vargo]

On 5/29/2015 2:39 AM, smoothly...@gmail.com wrote:
> On Wednesday, October 11, 2000 at 3:00:00 AM UTC-4, Michael Blake wrote:
>> When calling for data from a SQL Server DB, I received the following error:
>>
>> Microsoft VBScript runtime error '800a001c'
>> Out of stack space: 'BreakLine'
>> /RepGenInfo_w.asp, line 11
>>
>> Can anyone help me figure out how to overcome this?
>
>
> I am getting the same error when trying to open a file on my hard drive.
> In my situation, I get a popup that says;
> Script: C:Users\Plee\Documents\Court_Notificatio...
> Line: 1
> Char: 17786
> Error: Out of stack space
> Code: 800A001C
> Source: Microsoft JScript runtime error
>
> Does anyone know what this file is or how I can get it open to find out?

No, we don't know what this file is or how you can get it open, because
you have not provided any details about the file. You have only provided
2 runtime error messages with no code. The first one appears to be only
a partial error message, generated from a VBScript involving some form
of recursion.

https://support.microsoft.com/en-us/kb/126090

The second error message appears to be a similar issue generated by a
Jscript. This one appears to be a single line file which may be caused
by saving the file in format/encoding other than ASCII or ANSI.

Keep in mind, my analysis may be incorrect due to insufficient details.

--
Todd Vargo
(Post questions to group only. Remove "z" to email personal messages)