General System Stability

[Nisbet]

Good Morning All.

I was wondering if anyone else has had issues with the stability of relationships? I am seeing some real problems with data falling out of sync, requiring repairs often. We have been thinking about moving from the Community edition to the Professional version, but I have concerns about the applications stability, and wanted to get peoples thoughts.


Thanks

[clint]

What Sugar version are you using? Can you be more specific about when you are running into the issues? Is it when you are modifying relationships in Studio or in Module Builder.

The relationship editor in Studio/MB is new to 5.1 and we are fixing issues around it now. Any specific data or use cases you could provide would be most helpful.

[Nisbet]

We are currently using the Community edition of Sugar 5.0.0f running on a Linux system with Mysql as a back end data base. We have two custom modules that are having relationship problems.

Module A has a relationship with Contacts that is broken. By broken I mean that when you pull an instance of Module A it's contacts sub-panel will list every contact in the system.

Module B which has a relationship with Module A displays similar behavior.

This is not a problem in other places, for example contacts associated with the Accounts module show up correctly.

We have run the relationship and database repair utilities multiple times, and we have manually verified that the data in the association table between Module A and Contacts is correct.


We are in the process of migrating to 5.1, but it will take some time as we are refactoring many of the relationships to take advantage of the enhanced functionality.

[Nisbet]

Good Morning,

Clint,

when you say fix the studio application, what problems have been discovered?
We have run into some odd studio problems while working on our 5.1 upgrade. Adding custom integer fields to the accounts module does not work. the fields will show up in the studio UI, but no columns are created in the accounts_cstm table, and the views are broken(presumably because the db and the application are out of sync). We have tried to repair many times, and also tried removing the accountVardefs file from the cache to see if a regeneration of this file fixes the problem. I am just curious if the problems you are referring to involve issues like this.


Thanks

[clint]

Good Morning,

Clint,

when you say fix the studio application, what problems have been discovered?
We have run into some odd studio problems while working on our 5.1 upgrade. Adding custom integer fields to the accounts module does not work. the fields will show up in the studio UI, but no columns are created in the accounts_cstm table, and the views are broken(presumably because the db and the application are out of sync). We have tried to repair many times, and also tried removing the accountVardefs file from the cache to see if a regeneration of this file fixes the problem. I am just curious if the problems you are referring to involve issues like this.


Thanks

You can do a search in http://bugs.sugarcrm.com to see what has been reported for Studio in 5.1. I just did that search and found this bug report that seems to be the exact issue you reported here. It was fixed in 5.1.0a. Are you running patch A yet? 5.1.0 Patch B is coming out in the next few days as well.

[eggsurplus]

I bet he had the same issue searching http://bugs.sugarcrm.com as me. I tried searching for this and it took over a minute to search and then just went to a white screen which never finished loading. So I just went to the link you have there for that issue and it look 12-15 seconds for that to load. Searching on the bugs site is just horrendous. It's just not worth the lost productivity to do it. From personal experience with the SOAP interface there are ways to speed this up on the search side. (Posted at http://www.sugarcrm.com/forums/showp...74&postcount=2)

The biggest way to speed up that search is pagination and #3 on that post. I've submitted that enhancement in the past. Instead of calling get_related_list which calls the slow SugarBean->build_related_list_where create a faster function which only returns the rows it needs for pagination and uses a join query instead of an IN clause.

Sorry to vent, but I just can't use that bugs search as I'd like to. Which is, at all.

[clint]

I bet he had the same issue searching http://bugs.sugarcrm.com as me. I tried searching for this and it took over a minute to search and then just went to a white screen which never finished loading. So I just went to the link you have there for that issue and it look 12-15 seconds for that to load. Searching on the bugs site is just horrendous. It's just not worth the lost productivity to do it. From personal experience with the SOAP interface there are ways to speed this up on the search side. (Posted at http://www.sugarcrm.com/forums/showp...74&postcount=2)

The biggest way to speed up that search is pagination and #3 on that post. I've submitted that enhancement in the past. Instead of calling get_related_list which calls the slow SugarBean->build_related_list_where create a faster function which only returns the rows it needs for pagination and uses a join query instead of an IN clause.

Sorry to vent, but I just can't use that bugs search as I'd like to. Which is, at all.

Vent away! I completely agree with you. We're working on the bug tracker replacement now. Let me tell you, it won't come soon enough.

[eggsurplus]

Thanks for understanding Clint.

[clint]

We have a hot fix for the relationship issues now. Please let us know if this resolves your problems.