slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

External Development Forums - SalesLogix OLEDB Provider
Forum to discuss using the SalesLogix OLE DB Provider from external applications (including usage of built-in provider procedures). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to SalesLogix OLEDB Provider | New Thread

View: Search:

Author

Thread: Is it possible to disable the SlxSearchTrigger or something equivalent or maybe something else is going on?

Shane
Posts: 38

Is it possible to disable the SlxSearchTrigger or something equivalent or maybe something else is going on? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 04 Aug 10 10:56 AM

We have a set of scheduled tasks that run background operations and every so often they become completely unresponsive and have to be killed and restarted.... Through stack dumps and such I've figured out the problem comes from the SlxSearchTrigger displaying a message box from a critical section of code meaning everything just halts....

This occurs pretty randomly
There's not a specific query we're executing that causes this to happen every time it freezes like this it's from a different query

Any ideas?

Thread 11 - System ID 1968
Entry point mscorwks!Thread::intermediateThreadProc
Create time 8/1/2010 9:16:02 PM
Time spent in user mode 0 Days 00:10:39.375
Time spent in kernel mode 0 Days 00:09:21.328

This thread is displaying a message box. The call to display the message box originated from user32!NtUserWaitMessage+c.

The text of the message being displayed is:

Function Source
ntdll!KiFastSystemCallRet
user32!NtUserWaitMessage+c
user32!InternalDialogBox+d0
user32!SoftModalMessageBox+94b
user32!MessageBoxWorker+2ba
user32!MessageBoxTimeoutW+7a
user32!MessageBoxTimeoutA+9c
user32!MessageBoxExA+1b
user32!MessageBoxA+45
SlxSearchTrigger+497d
ntdll!ExecuteHandler2+26
ntdll!ExecuteHandler+24
ntdll!KiUserExceptionDispatcher+e
SlxSearchTrigger+212a
SlxSearchTrigger+2ad3
SlxSearchTrigger+4b29
SlxSearchTrigger+5697
SlxSearchTrigger+5621
SlxSearchTrigger+56fc
SlxSearchTrigger+e82e
SlxSearchTrigger+46a3
SlxSearchTrigger+46bb
SlxSearchTrigger+46bb
SlxSearchTrigger+46bb
SlxSearchTrigger+49ea
ntdll!LdrpCallInitRoutine+14
ntdll!LdrUnloadDll+41a
kernel32!FreeLibrary+41
SLXDBEngine!boost::shared_in_base::_shared_release+119f
SLXDBEngine!boost::shared_in_base::_shared_release+a6e

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Is it possible to disable the SlxSearchTrigger or something equivalent or maybe something else is going on? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Aug 10 3:19 AM

If you don't use speedsearch then do this:

update slxtriggers set enabled = 'F' where path = 'SlxSearchTrigger.dll'

Then, truncate the INDEXUPDATE table which I bet has thousands of rows in it !

[Reply][Quote]

Shane
Posts: 38

Re: Is it possible to disable the SlxSearchTrigger or something equivalent or maybe something else is going on? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Aug 10 10:29 AM

Cool good to know

I'll have to verify if anyone uses it...

The Indexupdate table seems to stay around 1700 records
is that bad?

[Reply][Quote]

Mike Spragg
Posts: 1226

Re: Is it possible to disable the SlxSearchTrigger or something equivalent or maybe something else is going on? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Aug 10 10:48 AM

No, that's fine - it's normally a LOT more ! This is where delta changes are placed with the assumption that the SS engine will consume them and then delete them. If SS isn't running - the table simply grows. I've seen system with 100's of thousands of rows !

[Reply][Quote]

Shane
Posts: 38

Re: Is it possible to disable the SlxSearchTrigger or something equivalent or maybe something else is going on? Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 05 Aug 10 11:47 AM

Hey look at that our staging server has a million rows in that table :-/

Well good to know ...

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/22/2024 4:53:15 PM