[andrea.bbbs]

I got an error running a query today - Out of Stack Space. I ran the exact same query on Friday with no problems, and have run other queries today that worked just fine.

We have no maintenance contract with Blackbaud - couldn't afford to renew - so I would really appreciate any suggestions or assistance.

Thanks all,

[Michael Sherman]

I've gotten this message before and was told to just re-boot. They really don't know why. At least at the CS level.

[andrea.bbbs]

Thanks for the quick reply - I really appreciate it. I will most likely have to wait until tomorrow to try again - we are guests on a hosted server and I could never ask for a re-boot.

I am going to try to tweak the query - maybe that will help.....

[Michael Sherman]

Sorry I wasn't clearer, Andrea. All I had to do was re-boot my workstation not the server to clear the error message.

[andrea.bbbs]

I actually did try that. And the server got re-booted - but that didn't solve it. The query I was writing was a nested query - the first I have tried in RE and I have been here nearly 2 years. I was trying to create a mailing list query, and I based it on a query that pre-filtered for zip codes. I tried rewriting the 2nd query and got the same error. When I removed the "select from query" selection in Tools it ran fine.

I added the pre-filter to the mailing query and got it to work. I guess I won't be writing nested queries - if I need them I will just keep doing what I have done - dump into Access and nest my queries there.



Maybe it has to do with my antiquated version of RE - 7.61?