June 6, 2006 at 8:37 am
Does anyone else get constant errors when using the search facility? Is there a posting or notice somewhere that it's been intermittant for months?
No Script Results Found
Microsoft OLE DB Provider for ODBC Drivers
error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Error executing extended stored procedure xp_tdbExecuteReturnSql Result set too large to fit in memory. Use CACHE SIZE to limit memory use. Trying to allocate 524304 bytes (Module:FreeItem,Method:AllocateMemory)
/search/turbo.asp, line 211
June 9, 2006 at 8:00 am
This was removed by the editor as SPAM
June 9, 2006 at 5:52 pm
It's a bug in the Surfinity/Imceda/Quest product. We got it from Surfinity and now Quest is not providing support without a large $$ fee that I'm not sure I want to pay. Especially since I advertise their product.
They say to upgrade, but we can't work out the licensing and they're not sure the upgrade will work since the product was rebranded.
It's a problem with large searches being too broad and I suspect memory is leaking though it doesn't seem easy to find. SQL is poking along with 1.6GB of memory and everything runs fine except for that stored proc.
I'll reboot. I haven't scheduled one, but maybe I should each weekend until we work things out or get support.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 9, 2006 at 7:04 pm
Thanks for the answer. I didn't think it was me.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply