Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Monday, November 25, 2024 
 
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!
 Administration Forums - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to General Administration | New ThreadView:  Search:  
 Author  Thread: Event Logging
Mike Allen
Posts: 7
 
Event LoggingYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 23 Jun 15 12:34 PM

Hello,


  Pretty new to the forum, so please forgive me if I'm posting in the wrong area.


  I have a user that is locking up when opening up his Activities section.  The screen begins to open and then just appears as a shadow and completely hangs saleslogix.  I can duplicate it on multiple workstations and am looking for a way to see any errors that might be occurring when opening up the Activities.


  Any assistance would be greatly appreciated


Thanks,


Mike Allen


 

[Reply][Quote]
Adam Travers
Posts: 113
 
Re: Event LoggingYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 24 Jun 15 3:36 AM

You should run the SLXProfilier to help troubleshoot this issue. You can locate the SLXProfilier.exe within C:\Program Files (x86)\SalesLogix (If you are not familiar with the SLXProfiler the help menu will provide you will all of the relevant information)


Also, what version of SLX are you running?

[Reply][Quote]
Mike Allen
Posts: 7
 
Re: Event LoggingYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 16 Jul 15 3:43 PM

Thanks for the reply.


 


We are running 7.5.3.4233.


 

[Reply][Quote]
Mike Allen
Posts: 7
 
Re: Event LoggingYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 07 Aug 15 4:22 PM

I was able to run the profiler and the below capture shows the result.  It hangs on the one SQL statemtent for about 28 minutes before bringing up the activities.


 


Time Stamp SQL Type Parse(ms) Prepare(ms) Secure(ms) Execute(ms) GetRows(ms) Log(ms) Rows User ID Process ID Machine Cursor Client SQL


2015/08/07 13:41:04.934 USER 0.0783 0.0241 0.0016 2.3368 121.9587 0.0000 10292 dennis 2688  1.  0.  0.127 FORWARD ONLY SELECT NOTIFYID, FROMUSERID, TYPE, ACTIVITYID,   NOTES, SENDDATE  FROM USERNOTIFICATION  WHERE ((USERNOTIFICATION.TYPE = 'Deleted')   OR (USERNOTIFICATION.TYPE = 'Completed'))  AND (TOUSERID = 'U6UJ9A00000Q')  



Time Stamp SQL Type Parse(ms) Prepare(ms) Secure(ms) Execute(ms) GetRows(ms) Log(ms) Rows User ID Process ID Machine Cursor Client SQL

2015/08/07 14:04:58.022 USER 0.0725 0.0237 0.0022 7.4137 0.0099 0.0000 0 dennis 2688  1.  0.  0.127 FORWARD ONLY SELECT A1.ACTIVITYID, A1.LONGNOTES FROM ACTIVITY A1 WHERE (A1.ACTIVITYID='QTJZOA2002KP')   


[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 | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 11/25/2024 5:11:44 PM