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 - Upgrades
Forum to discuss upgrading SalesLogix from version to version. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Upgrades | New Thread

View: Search:

Author

Thread: Custom Groups Not Working After Upgrade From SLX 6.1 to 7.5 - Malformed Group Query

Bailey1
Posts: 57

Custom Groups Not Working After Upgrade From SLX 6.1 to 7.5 - Malformed Group Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 May 09 7:31 AM

We have run thru several upgrades from 6.1 to 7.5 in our DEV environment, and each time our cuctom groups fail due to a "malformed group query" error. We have 1 group per rep, and the group is needed by the 3rd party software that runs on the rep's blackberry (used for synchronization). The only work-around we have is to edit the group to delete all of the fields from the layout tab except accountid and then it works. We were told by Sage that we needed to re-create/modify all of the groups post upgrade, but we have around 700 of them, so that will be a lot of work and they need to work immediately after upgrade. Has anyone run into this? Any ideas on how to update the groups using a query/TSQL? Any ideas would be appreciated.

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Custom Groups Not Working After Upgrade From SLX 6.1 to 7.5 - Malformed Group Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 May 09 9:24 AM

Yeap...

There are a couple of items that I am aware Sage is looking into.

When we upgraded (and we had upwards of 20,000 groups) we also changed schema, so I wrote a utility to fix schema, but working with SAGE they have identified that there were a few things that changed that required the groups metadata to be updated, but it only applies to certain issues: Special Characters, Use of Literals (specially with Subqueries).

If you have only a few groups, you could try editing them, removing any special Characters, and if you have any Embedded Subqueries, move them to the bottom of the Conditions list.

As stated, I have built a couple of update utilities for the Groups, so it is possible to automate it, as long as you know the cause of the problem you are running into.

[Reply][Quote]

Bailey1
Posts: 57

Re: Custom Groups Not Working After Upgrade From SLX 6.1 to 7.5 - Malformed Group Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 May 09 3:37 PM

Could you tell me more about the utilties you have to update the Groups?

[Reply][Quote]

Raul A. Chavez
Posts: 1300

Re: Custom Groups Not Working After Upgrade From SLX 6.1 to 7.5 - Malformed Group Query Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 May 09 3:42 PM

Well, in my case, my changes related to Schema.

My utility was based on the Group Translator. I would extract the Group to XML, then made the changes I needed on the Different Collections and Save it back to the DB.

[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/25/2024 7:20:59 PM