FATAL SugarCRM - Error fetching relationship from cache

[Nisbet]

Hi all.


I have run into a problem with a couple of module relationships, and was hoping someone could point me in the right direction here. One relationship is between contacts and a custom module the other is between two custom modules, for some reason all of the values(i.e. every contact in the system) show up in the sub panel whether they have been associated or not. When I look at the sugarcrmlog I see a lot of the folowing

FATAL SugarCRM - Error fetching relationship from cache custom_a_custom_b



This doesn't happen on all of my relationships just these two. I have run the repairs on relationships, database, and indexes and cleared the vardef cache. I have also verified that the entire cache directory is world writable , and that my php.ini file has safe mode off and a 128MB memory limit.

Any one have any ideas I can try to get this fixed?

Thanks

[Nisbet]

Forgot my details

Sugar CE 5.0.0f
MSQL running on a Gentoo linux system.

[Nisbet]

Anybody got any ideas for me here? I really need to find a resolution to this problem.

[andopes]

Hi Nisbet

Go to Admin -> Repair -> Rebuild Relationships / Rebuild Database

Cheers

[Nisbet]

Thanks for the reply,

I have done that many times, and it doesn't seem to resolve the problem

[Nisbet]

Can someone from the sugar team point me to where the html for these relationships is rendered, so I can try and get this problem resolved?


Thanks

[Nisbet]

Ok, I will try presenting this problem another way. Does anyone know if it is possible to disable the use of the cache with in Sugar? I am guessing not, but I am really grasping at straws here.


Thanks

[clint]

Look at the files in the metadata directory. Your custom relationships are defined there.

[lijith]

Hi Nisbet

Go to Admin -> Repair -> Rebuild Relationships / Rebuild Database

Cheers

This resolves my proble. Thanks :-)

[Briedis]

I have stucked with this "Error fetching relationship from cache " too.
I have created relationship between to my custom modules, this relation din't work normaly so I removed it.

After removal of reletionship ( or may be even after it creation)

when I click open right module in edit, detail view or close from edit view without saving ( cancel) one record in sugarcrm.log apears "[FATAL] Error fetching relationship from cache <my-relationship-name>"

when save record , four records like this apears:
FATAL] Error fetching relationship from cache <my-relationship-name>
[FATAL] Error fetching relationship from cache <my-relationship-name>
[FATAL] Failed to load relationship viaq_templ_q_quate_detail while saving <module Name>
[FATAL] Error fetching relationship from cache <my-relationship-name>

I have rebulded relationships, DB,EXT ETC few times. Also I have try to remove relationship as descrbed there

I have not found any files like
custom/Extension/application/Ext/TableDictionary/<relationship_name>.php
or custom/metadata/<relationship_name>Meta.php

but inside file custom/Extension/modules/<Right ModuleName>/Ext/Vardefs/vardefs.ext.php i have found lines with such code

 $dictionary["ViaQ_Quate_detail"]["fields"]["viaq_templ_q_quate_detail"] = array (
  'name' => 'viaq_templ_q_quate_detail',
  'type' => 'link',
  'relationship' => 'viaq_templ_detail_viaq_quate_detail',
  'source' => 'non-db',
  'vname' => 'LBL_VIAQ_TEMPL_DETAIL_VIAQ_QUATE_DETAIL_FROM_VIAQ_TEMPL_DETAIL_TITLE',
);
$dictionary["ViaQ_Quate_detail"]["fields"]["viaq_templ_te_detail_name"] = array (
  'name' => 'viaq_templ_te_detail_name',
  'type' => 'relate',
  'source' => 'non-db',
  'vname' => 'LBL_VIAQ_TEMPL_DETAIL_VIAQ_QUATE_DETAIL_FROM_VIAQ_TEMPL_DETAIL_TITLE',
  'save' => true,
  'id_name' => 'viaq_templ4a9a_detail_ida',
  'link' => 'viaq_templ_q_quate_detail',
  'table' => 'viaq_templ_detail',
  'module' => 'ViaQ_Templ_detail',
  'rname' => 'name',
);
$dictionary["ViaQ_Quate_detail"]["fields"]["viaq_templ4a9a_detail_ida"] = array (
  'name' => 'viaq_templ4a9a_detail_ida',
  'type' => 'link',
  'relationship' => 'viaq_templ_detail_viaq_quate_detail',
  'source' => 'non-db',
  'reportable' => false,
  'side' => 'right',
  'vname' => 'LBL_VIAQ_TEMPL_DETAIL_VIAQ_QUATE_DETAIL_FROM_VIAQ_QUATE_DETAIL_TITLE',
); 
  

When I comment it nothing happens. After rebuilding of relationships I found this lines uncommented again.

Any help is very appreciated