8/16/2025 2:29:39 AM
|
| |
| 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 the use of the SalesLogix Web Platform, Client and Customer Portals, and the Application Architect (For version 7.2 and higher only). View the code of conduct for posting guidelines.
|
|
|
|
[Resolved] 7.5 Error on Account entity: "Load Group XML Failed"
Posted: 28 Oct 08 9:58 AM
|
[Resolution]
A 'broken' group was the cause, and deleting the group (through SQL-QA) restored full Account main entity functionality. This seems like an annoyingly obvious solution when stated like that, especially given the lengths of investigation outlined below, but at least if someone else has this issue, my experience should be helpful to them.
The group contains several logical errors in the Conditions tab; brackets and "NOT ... <>" (i.e. double-negatives) all over the place! Although the group does work in the LAN client, it causes the client to hang for several seconds. The group also contains several apparently redundant columns, specifically it has 5 Account Name columns, 4 of which are hidden as though the author was not aware how to delete them from the layout. Incidentally, the group was never likely to retrieve the desired information anyway; it was apparently designed to get a list of Contacts with invalid email address, so the author deciding to build it in the Account main view surely doomed it to failure from the out-set.
I'm not entirely sure if it was a time-out on trying to render this group, or an error on interpreting its conditions, or possibly even the multiple duplicate columns which caused the 'Load Group XML Failed' message to appear. The group name was unremarkable, all columns represented were valid, and the group did work (sort of) in LAN.
[Original message]
Hi guys,
I'm experiencing an error in 7.5 which essentially means I can't enter the Account main entity page, either in list/detail view (or rather, I don't get far enough to make that choice). It is only the Account main entity page which is giving me this error.
I've exhausted all the potential fixes I can find and none of them have made any difference; I'll outline what I've tried below. First, this is the error I get when I attempt to enter Accounts (from the navbar, or by link from a Contact record/grid, or by direct url...):
http://i383.photobucket.com/albums/oo277/simplealec/web75_account_fail.jpg
The methods I've tried to fix this issue are as follows:
(i) Checked event viewer for errors encountered. None are apparent (that is, no errors are thrown from the client).
(ii) Run SLx Profiler to establish that valid grid SQL is being used. The list view's SQL statement* is valid, and correctly returns about 49,000 rows. One other SQL statement** is executed after this, though I'm not sure what this one does, it is valid, and returns 1 row (containing '0').
(iii) Checked for group names which contain an ampersand ('&') symbol, in case this issue was related to a known Defect 1-60525 in 7.2.2. There were 5 such groups, I deleted them, so assume remaining group names are valid.
(iv) Registered 'GroupTranslator.dll' from "C:\Program Files\SalesLogix\GroupTranslator.dll", as suggested by Ryan Farley in this Sage Newsgroups thread: http://discuss.sagecrmsolutions.com/Default.aspx?newsgroup=sage.bp.crm.SalesLogix.Web7.5&index=63
(v) Deleted contents of "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files" folder as per Task 55 in Sage document 'Upgrading Sage SalesLogix from Version 7.0.x to 7.5.pdf'.
(vi) Reset IIS on multiple occasions, restarted VM a few times also.
(vii) Uninstalled the Web Host, deleted the web site, re-installed the Web Host and allowed it to create a new website and configure the database accordingly, and deployed to this new web site. This was in attempt to achieve the same results as Stephen Redmond (first reply) in this slxdeveloper.com thread: http://www.slxdeveloper.com/forum.aspx?forumid=4002&postid=18611 . Note that I also tried the method in the third reply to clean 'bad groups'.
Despite having tried all of these fixes, I'm still not able to get into the Account main entity page. The error has been the same throughout.
If anyone can suggest something I haven't tried, I'd really appreciate the help! Please ask if there's any further information I've forgotten to provide.
Thanks,
Alec D
Environmental information:
Database formerly 7.0.1 upgraded to 7.5.0, VFS Hotfix applied.
Database on remote server (SQL 2k5), otherwise everything is within a Virtual Machine (Windows Server 2k3).
*SQL statement executed by Account list view: SELECT A1.ACCOUNTID, A1.ACCOUNT, A2.CITY A2_CITY, A1.MAINPHONE, A1.TYPE, A1.STATUS, A1.ACCOUNTMANAGERID, A1.SECCODEID, A1.ACCOUNT_UC, XUSERINFO0.USERNAME ACCOUNTMANAGERIDNAME, XSECCODE0.SECCODEDESC SECCODEIDNAME FROM ACCOUNT A1 INNER JOIN ADDRESS A2 ON (A1.ADDRESSID=A2.ADDRESSID) LEFT OUTER JOIN USERINFO XUSERINFO0 ON ( A1.ACCOUNTMANAGERID = XUSERINFO0.USERID) LEFT OUTER JOIN SECCODE XSECCODE0 ON ( A1.SECCODEID = XSECCODE0.SECCODEID) ORDER BY ACCOUNT ASC
**Secondary SQL statement: select count(activity0_.ACTIVITYID) as x0_0_ from ACTIVITY activity0_, USER_ACTIVITY useractivi1_ where ((activity0_.ACTIVITYID=useractivi1_.ACTIVITYID ))and(((useractivi1_.USERID='ADMIN ' ))and((activity0_.TYPE in(262145 , 262146 , 262147 , 262162)))and(((useractivi1_.CONFIRMED<>'D' )))and((((useractivi1_.ALARMTIME<'20081028 11:56:24' )and(useractivi1_.ALARM='T' ))or((useractivi1_.ALARMTIME is null )and(activity0_.ALARM='T' )and(activity0_.ALARMTIME<'20081028 11:56:24' )))OR((((activity0_.STARTDATE<='20081028 11:56:24' )and(activity0_.TIMELESS='F' )or(activity0_.TIMELESS is null ))or((activity0_.STARTDATE<'20081027' )and(activity0_.TIMELESS='T' )))and((useractivi1_.ALARMTIME<'20081028 11:56:24' )or(useractivi1_.ALARM='F' )or(useractivi1_.ALARM is null )))OR((((useractivi1_.CONFIRMED<>'T' )))and((useractivi1_.ALARMTIME is null ))))) |
|
|
| |
|
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!
|
|
|
|
|
|
|
|