11/26/2024 10:22:19 PM
|
| |
| 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!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
6.2.3 Group Scroll bar locking up
Posted: 03 Nov 06 12:03 PM
|
fiogf49gjkf0d hello,
Going from 6.2.1 to 6.2.3.1092 has been a challenge. There are some things that are very different from 6.2.1. I could really use some help if others have had these issues and found a solution.
Excessive dragging of a scroll bar in a group causes SLX to lock up completely for that user. This is only by clicking in the area BELOW the actual scroll bar button and holding it down to make the scroll bar scroll down. Click and dragging the actual scroll bar button works fine.
Anyone? Anyone?
|
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 03 Nov 06 12:27 PM
|
fiogf49gjkf0d I have not heard of this and don't have an answer, however I am curious.
-Do you see this behavior for all users?
-Do you see the behavior on all groups? |
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 03 Nov 06 4:15 PM
|
fiogf49gjkf0d 1) This is being experienced by all of the users who by habit don't use the scroll button (me included)
2) We do connect via citrix, but I have tried it on different releases of citrix, from different machines with different internet access, it still happens. Plus if it was citrix the entire environment would lock up which it doesn't. it's only the Sales Client. Any other app that is open still works.
3) Integrity checker has no errors.
4) CPU cranks when this happens
5) The group All Accounts DOES NOT lock up. All Accounts is the standard SLX issued group which has no conditions and no custom table data in the layout. For fun, I didn't change the layout and added a custom table condition, and it DID NOT lock up. I added custom data to the layout and it DID NOT lock up.
6) These are static groups that carried over from 6.2.1. So, I made a copy of one and it did lock up.
7) I created a brand new query using the exact same format and it did lock up.
8) And again, this never was a problem on 6.2.1. It only occured when we upgraded to 6.2.3 on Monday.
Any help would be great.....
|
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 03 Nov 06 4:42 PM
|
fiogf49gjkf0d | 2) We do connect via citrix, but I have tried it on different releases of citrix, from different machines with different internet access, it still happens. Plus if it was citrix the entire environment would lock up which it doesn't. it's only the Sales Client. Any other app that is open still works. |
|
It still might be Citrix. What happens if you run the SalesClient without going throught Citrix?
6) These are static groups that carried over from 6.2.1. So, I made a copy of one and it did lock up.
7) I created a brand new query using the exact same format and it did lock up. |
|
I am confused by these two statements. Are these adhoc groups (i.e. groups without a query) or dynamic groups (i.e. groups driven by a SQL Select statement)?
SalesLogix did add something new in 6.2.3 called "virtual server-side cursors". The goal was increase the performance of large groups by doing some of the work on the server. This may be the root cause but I don't think it would come into play in a adhoc group.
|
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 03 Nov 06 10:13 PM
|
fiogf49gjkf0d Sorry for the confusion. I am 2000 miles away from the actual database, so I can't tell you what happens directly on the Sales Client. I may ask the data farm to try that out. I did connect to another company via citrix from my home computer. This company is NOT on the farm but has it all in house. I did get their database to lock up as well on the exact same SLX version as I am.
By static, I meant we use the same groups for years so they were copied over from 6.2.1 to 6.2.3. Either way, whether carried over or created from scratch the groups still lock up.
You got me curious about adhocs. I created an adhoc directly from a dynamic group that locked up and the adhoc didn't lock.
I also noticed today that the more users that are on means that groups lock up more easily. After our users logged off, most groups would not lock up but eventually I got one to lock up. |
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 04 Nov 06 11:43 AM
|
fiogf49gjkf0d Finding out if the goups lock up when Citrix is taken out of the picture is an important data point. You should pursue this.
The fact that is happens more often when more users are logged in could be an indication resource contention issue. Check the Windows Event Logs and SQL Event log on the Database Server, the Windows Event Logs on the SLX Provider system, and the Windows Event Logs on the Citrix server(s).
The issue could be related to the server-side cursors that I mentioned in my earlier email. There is an Icon on right side of the group bar that indicates if the group is using client-side or server-side cursors --look up "Virtual Server-Side Cursors" in SalesLogix Help for an explaination of the icon a am referring to. Then find out what mode the hanging group(s) are using.
Could you also post the SQL from the group?
On last thing: how many records are in the group? |
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 06 Nov 06 2:20 PM
|
fiogf49gjkf0d Well, thanks for another piece to the puzzle. It's only happening in Client Side groups which is almost every group we have. That's why I couldn't get All Accounts to lock up because it's virtual. It locks up on 1000+ groups. I am not sure what the minimum since it tends to varies. All of our groups have been created using this same template. I tried building it from scratch and it still locks up. I took the sorting out, still locked. I reindex the database, still locked. Our CPU keeps maxing out and then releasing from user to user. My guess is this all related to the groups. Our users live and die by those groups all day long.
Any words of wisdom would be great!
SELECT A1.ACCOUNTID, A1.STATUS, A1.ACCOUNT, A2.CITY A2_CITY, A2.STATE A2_STATE, A3.COUNTY A3_COUNTY, A2.POSTALCODE A2_POSTALCODE, A1.MAINPHONE, A3.AWA A3_AWA, A3.FAMILIES A3_FAMILIES, A3.MEMBERS A3_MEMBERS, A3.DENOMINATION A3_DENOMINATION, A3.CONTRACT_DATE A3_CONTRACT_DATE, A3.DAYS_CALLED_IN_ A3_DAYS_CALLED_IN_, A4.USERNAME A4_USERNAME, A1.SECCODEID FROM ACCOUNT A1 INNER JOIN ADDRESS A2 ON (A1.ADDRESSID=A2.ADDRESSID) LEFT OUTER JOIN C_ACCOUNT_EXT A3 ON (A1.ACCOUNTID=A3.ACCOUNTID) INNER JOIN USERINFO A4 ON (A3.SALES_REP=A4.USERID) WHERE (UPPER(A4.USERNAME) LIKE 'BILL JONES%') ORDER BY A3.COUNTY ASC, A2.CITY ASC, A1.ACCOUNT_UC A
|
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 06 Nov 06 2:27 PM
|
fiogf49gjkf0d Further, this is becoming a bigger issue than the scroll bar locking up because I stated in the last post, something is causing the CPU to max out and release. I am confident it has something to do with the groups.
Is there a way to manually switch groups from Client Side to Virtual Side? I looked in the Plugins table and didn't see anything that was obvious. |
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 06 Nov 06 2:46 PM
|
fiogf49gjkf0d I discovered that almost all groups start as Virtual, but if you create a local join to another table and use a field from the locally joined table as a condition or in the layout, it becomes a client side group. Since all our groups are copies of each other, they all contain a local join to UserInfo. Just for fun, I tried a local join to a custom table and it became client side as well. So, that apparently is one of the major differences between Client side and Virtual side... local joins....
With a heavy heart, I am considering re-creating all 100+ groups without the local joins and see if the locking up goes away and the killing of the CPU...
If anyone has any thoughts on the matter, I am all ears. |
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 06 Nov 06 3:55 PM
|
fiogf49gjkf0d Bingo...
Had the vendor at the farm watch my CPU between two identical groups but one was built virtual (no local joins) it cycled through 6, 9 and up to 14% then back to zero and it continued going through this cycle 6,9,14, 0 as I continously scrolled. The Client Side (built with a local join) maxed out at 25% and locked up.
Keep in mind all of these local joined groups existed in 6.2.1 but never had a problem until 6.2.3.
I anticipate that after I rebuild all the groups to virtual and all the users logged in, that scroll bars won't lock up and the CPU doesn't climb so much that everyone starts crawling. I will post any new findings about any residual side effects tomorrow.
I earned my bread and butter today.
|
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 06 Nov 06 6:44 PM
|
fiogf49gjkf0d What 6.2.3 HotFixes have you applied? If you do a help about the patch level will show.
Do you have the SlxProvider configured as a service on the Citrix servers? If not each user starts their own copy of the Provider. This will chew up extra memory on the Citrix server.
Client-side means that the entire record set is sent to the client PC. The client PC is then responsible for sorting and displaying the records. With large groups this can consume a lot of memory on the client PC.
When you create the groups use inner joins where possible and indexed fields for sorting and conditions. This will increase the probability of server-side processing. |
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 06 Nov 06 7:12 PM
|
fiogf49gjkf0d 6.2.3.1080 is where we were at. I was contemplating adding more, but I couldn't find one that addressed this specific problem.
I am not sure how the data farm has the citrix server set up. Since they primarily handle Saleslogix via Citrix, I would assume it's done as a service, but I will check to be sure.
I believe Client-side was the only option in 6.2.1 which is why I am surprised the problem only appeared in 6.2.3. These locally joined groups existed in 6.2.1. That's why I am fairly sure there is a bug somewhere in the program.
I did switch to an inner join to see if that alleviated the problem which it still locked up. All fields are properly indexed, I made sure of that before the latest reindex this past weekend.
Thanks again Frank for pointing out the difference in Client Side and Virtual side. This helped me pinpoint the problem and now I have a workable solution. Stay away from local joins.
|
|
|
|
Re: 6.2.3 Group Scroll bar locking up
Posted: 06 Nov 06 8:22 PM
|
fiogf49gjkf0d Originally posted by Hilary Anglin
6.2.3.1080 is where we were at. I was contemplating adding more, but I couldn't find one that addressed this specific problem. |
|
HF11 may help.
| I believe Client-side was the only option in 6.2.1 which is why I am surprised the problem only appeared in 6.2.3. These locally joined groups existed in 6.2.1. That's why I am fairly sure there is a bug somewhere in the program. |
|
You are correct. The VSSC logic is in the provider components.
| I did switch to an inner join to see if that alleviated the problem which it still locked up. All fields are properly indexed, I made sure of that before the latest reindex this past weekend. |
|
Have you tried using the SLX Profiler Toolkit to optomize your groups? |
|
|
|
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!
|
|
|
|
|
|
|
|