Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, September 28, 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!
 Web Forums - SalesLogix Web Client (Pre-7.2)
Forum to discuss using & developing the legacy SalesLogix Web Client (For versions 7.0 and earlier). View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to SalesLogix Web Client (Pre-7.2) | New ThreadView:  Search:  
 Author  Thread: Stress testing with Saleslogix Web Customer Portal
Snow Monkey
Posts: 214
 
Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 01 Dec 06 10:31 AM
fiogf49gjkf0d
When our QA stress tested the Cutomer Portal with 10 users logging in and doing regualr things for 1 hour, the system craashed with the following error...

Access violation at address 01824A54 in module 'slxweb.dll'. Read of address 6373655C

I am at slx 6.2.4 with NO HFs...

What is going on ? Any idea other than telling me to upgrade to v7.0??

I have looked at the System Performance Logs and everything looked normal..
[Reply][Quote]
Jeff Ballard
Posts: 326
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 01 Dec 06 6:54 PM
fiogf49gjkf0d
Nandu,

Are you running on a server with multiple processors? See my last reply on this thread http://www.slxdeveloper.com/forum.aspx?forumid=4000&postid=4530#4531

While it's not thread safe, a single processor isn't as likely to exhibit the error, but if I understand it right, it is possible on a single processor machine that a thread could access another threads memory if the time slicing doesn't allow the first thread to finish and the second thread hits the same memory location and finds something it doesn't expect. The problem is multiplied, though, if you have multiple processors. So if you have a multiple processor machine, it will occur more frequently than on a single processor, but it's drastically less likely on a single processor.

Our customer today updated their prod system to use processor affinity (Sage's recommendation), so I can't say how that will help. Their situation was bad enough that it required a scheduled reboot every night and there were still problems during the day. Hopefully the processor affinity adjustment today will help. Monday and continuing on will tell.

Jeff
[Reply][Quote]
Nick Hollis
Posts: 549
Top 10 forum poster: 549 posts
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 04 Dec 06 2:19 AM
fiogf49gjkf0d
Jeff,

Thanks for this post - if only Sage could have told me this a few months back when I had the same issue - the only solution I had was to remove half of my customisations and 'simplify' execution. Considering 100% of our customers use multiple processors its quite an important Salesogix Web 'feature' to be aware of!

Thanks,

Nick
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 04 Dec 06 1:37 PM
fiogf49gjkf0d
hehe....Feature huh?

Anyways most of my customs are done in aspnet and SLX portal is used for logon and view tickets ONLY.I looked for any errors in my server and i got several which was pointing at a wrong server(something whose name will not resolve) and i took off that step from our QA load scripts and after that it seems to be running OK with system in a stable mode.

Jeff, thankssssssss...!!!!!You are really helpful.As to the question of Multiple processors, i will inquire with my server guys about the settings and see if something can be done to set those affinity parameters in 2003.
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 04 Dec 06 1:57 PM
fiogf49gjkf0d
This is the url which will set Processor affinity in IIS6.0

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/529588d3-71bc-45ea-a84b-267914674709.mspx?mfr=true
[Reply][Quote]
Jeff Ballard
Posts: 326
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 04 Dec 06 2:59 PM
fiogf49gjkf0d
Nick,

Depending on when you brought the issue to their attention, they may not have know what it is. My project manager and I had to actually drive the street to Sage's office and sit with their tech support people as we reproduced the issue on an eval database. It's been a long slow process, but it was only recently they acknowledged to us that it indeed was a defect related to multiple threading. We spent a fair amount of time diagnosing the issue, and while we knew it was somehow threading-related, we couldn't know for sure without source code, which, of course, we don't have. It's nice to finally have it [the defect] acknowledged.

As for day 1 for our customer using processor affinity, we haven't heard anything bad. So hopefully all is well. I'll post again when I have more feedback.

Jeff
[Reply][Quote]
Jeff Ballard
Posts: 326
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 04 Dec 06 3:02 PM
fiogf49gjkf0d
Also, as an FYI for all, it can't be set in IIS 5.0.

Jeff
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Dec 06 1:41 PM
fiogf49gjkf0d
Jeff , Is everything good with your customer after setting the processor affinity in the web server?

Pls let me know as this has started happening to us!!!!!!!!!!!!!!!

[Reply][Quote]
Jeff Ballard
Posts: 326
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Dec 06 1:51 PM
fiogf49gjkf0d
Nandu,

Yep...it's much, much better now. We still see some errors in the event logs, but there have only been two "access violation" errors between 12/1 and 12/13. Normally, we'd see 20-30 per *day*. The errors that we're seeing now, we still can't reproduce all the time, but the messages are more informative so we can realistically troubleshoot. Stability is waaaay up - they don't have to reboot 2-3 times/day like they used to. They have an auto-reboot at night, but that's probably not even necessary.

I'd recommend that *anyone* that has a multiple processor web server and/or hyperthreading implement processor affinity if running Win2K3 and IIS 6.0.

Supposedly a fix is coming from Sage in a SP, but, until then, affinity is the way to go.

Jeff
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Dec 06 2:43 PM
fiogf49gjkf0d
Jeff, i spoke to them , the fix for this is coming in slx 7.0 hf6 and slx6.2.4 sp6.

Till then, we will have to be OK with the workaround.

Do you have something written up as to how to fix it(which my server guys can follow) if we have to do this?
[Reply][Quote]
Jeff Ballard
Posts: 326
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Dec 06 4:44 PM
fiogf49gjkf0d
Nandu,

The only doc we used was this one:

http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/1bd3352d-57ac-4aa6-8273-b8ac1bbaf898.mspx?mfr=true

which is related to the one you had linked above. We basically used the second set of steps in the "procedures" section that reads "To assign processor affinity by binding an application pool to a specified processor".

Essentially, we had 4 processors, two virtual and two hyperthreaded. We set up four ports to run SalesLogix, each with its own application pool and used processor affinity to assign each app. pool to a specific processor.

Jeff
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Jan 07 11:42 AM
fiogf49gjkf0d
Jeff , We completed the load testing for the new setup(4 cpus setup was altered to 2 cpu setup) and the system is 50 times more stable now than ever!!!

However , there was another concern pointed out by someone here.How to make use of those 4 CPUs ultimately? Can we have 4 sites created which is pointing to the same db? If so , do you know any procedure to make that happen.I tried, but was unable to get that to work.Any defined procedure that we can do ? Once those sites are done , we are going to load balance those websites and hopefully things would be little more better.
[Reply][Quote]
Jeff Ballard
Posts: 326
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Jan 07 12:13 PM
fiogf49gjkf0d
Nandu,

I assume that you turned off hyperthreading which brought you from four to two? If so, you can turn on hyperthreading (again) and use processor affinity to set four application pools with each one affinitized to a single processor.

As for creating each of the four sites to use the same database, it's definitely doable. On 5.2, one of my customers had eight web sites pointing to the same DB. Just set up the web sites in IIS. Log in to web manager and go to the Profile/Server configuration. Select the profile and click "Action-->New-->Server". On the general tab, give the profile a name, select one of the web sites you created in IIS from the "Web Site Name" drop down. Make sure it puts the right port number - if not, correct it. Select the "ADO Connection" tab and select the ADO Connection that points to your database. Then verify that the directories it points to on the "Directories" tab are correct. Click the "Save" icon. Now, select the profile again, and click "Action-->New-->Server" again and repeat the process for the next web site.

When you're done, you should have one profile and four server configurations. Do an iisreset and try hitting each of the web sites. Make a change to data on the first site and it should show up when you hit the next site.

Jeff


[Reply][Quote]
Jeff Ballard
Posts: 326
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Jan 07 12:14 PM
fiogf49gjkf0d
One other thing I forgot - 6.2 SP 6 is now in beta, which allegedly has a fix for the issue.

Jeff
[Reply][Quote]
Snow Monkey
Posts: 214
 
Re: Stress testing with Saleslogix Web Customer PortalYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Jan 07 2:33 PM
fiogf49gjkf0d
Thanks Jeff again....

Now i have 4 websites with its own app pools .Tommorow we will be running those affinity and then do load testing on all of them again.

I have also put together a doc which details on how to do load balancing for slxweb.

and Yes i know about the SP6.Just that our setup is so big that even a sp upgrade is close to impossible due to different reasons(both technical and political)
[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): 9/28/2024 6:19:25 PM