Notices



Reply
 
LinkBack Thread Tools Display Modes

Old 01-15-2008, 09:25 AM   #1 (permalink)
annieb

andrea.bbbs's Avatar

Join Date: Dec 2006
Location: Venice, Florida
Posts: 314
Rep Power: 2 andrea.bbbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

Crazy Error Message - Please Help!

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,
__________________
Andrea Shlasko
Database Manager
Big Brothers Big Sisters of the Sun Coast Inc.

"Just another day in Paradise, where every meal's a banquet and every day's a holiday"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 01-15-2008, 09:39 AM   #2 (permalink)
ah one, and ah two

Michael Sherman's Avatar

Join Date: May 2006
Location: Sarasota, FL
Posts: 431
Rep Power: 3 Michael Sherman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- Patron's Edge (PE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)

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.
__________________
Michael J. Sherman
Database Administrator
Sarasota Orchestra (name change 9/3/08)
The new Florida West Coast Symphony

msherman "at" SarasotaOrchestra "dot" org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 01-15-2008, 09:54 AM   #3 (permalink)
annieb

andrea.bbbs's Avatar

Join Date: Dec 2006
Location: Venice, Florida
Posts: 314
Rep Power: 2 andrea.bbbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

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.....
__________________
Andrea Shlasko
Database Manager
Big Brothers Big Sisters of the Sun Coast Inc.

"Just another day in Paradise, where every meal's a banquet and every day's a holiday"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 01-16-2008, 01:19 PM   #4 (permalink)
ah one, and ah two

Michael Sherman's Avatar

Join Date: May 2006
Location: Sarasota, FL
Posts: 431
Rep Power: 3 Michael Sherman is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- Financial Edge (FE)
- Patron's Edge (PE)
- Blackbaud Analytics/Researcher's Edge (BBA/TRE)

Sorry I wasn't clearer, Andrea. All I had to do was re-boot my workstation not the server to clear the error message.
__________________
Michael J. Sherman
Database Administrator
Sarasota Orchestra (name change 9/3/08)
The new Florida West Coast Symphony

msherman "at" SarasotaOrchestra "dot" org
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 01-17-2008, 08:27 AM   #5 (permalink)
annieb

andrea.bbbs's Avatar

Join Date: Dec 2006
Location: Venice, Florida
Posts: 314
Rep Power: 2 andrea.bbbs is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

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?
__________________
Andrea Shlasko
Database Manager
Big Brothers Big Sisters of the Sun Coast Inc.

"Just another day in Paradise, where every meal's a banquet and every day's a holiday"
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
error message, stack space


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Cheap Gas - Loans - United Specialties - Loans
All times are GMT -6. The time now is 07:00 PM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70