Hello,
this may not belong here, but I am experiencing a message. that I don’t know how to investigate and troubleshoot:
[FATAL] Missing relationship definition cases_opportunities. skipping cases_opportunities subpanel
from sugarcrm_xxx.log
Does anyone have an idea how to fix?
Thanks and regards,
Pegal
If you do a Quick Repair and Rebuild, and scroll down to the bottom of the messages, does it say you have an incoherence between vardefs and database, and offer an SQL command to fix it?
Hello and thanks for your fast reply. Both in sugar6.5.24 and the already migrated Suite7.6 show the following result after “Quick Repair and Rebuild”: Neither returned the SQL-code you are referring to, unfortunately.
===================start sugar 6.5.24=========================
Clearing Vardefs from cache…done
Clearing language files from cache…done
Clearing Template files from cache…done
Clearing JS files from cache…done
Clearing Vardefs from cache…done
Clearing JS Language files from cache…done
Clearing language files from cache…done
Clearing Sugar Dashlet files from cache…done
Clearing Sugar Feed Cache…done
Clearing Smarty templates from cache…done
Clearing Theme Cache…done
Clearing XML files from cache…done
Clearing Unified Search Cache…done
Clearing External API Cache File…done
Rebuilding Extensions…
Rebuilding Include…
Rebuilding Language…en_us
Rebuilding ActionViewMap…
Rebuilding ActionFileMap…
Rebuilding ActionReMap…
Rebuilding Administration…
Rebuilding EntryPointRegistry…
Rebuilding Extensions…
Rebuilding FileAccessControlMap…
Rebuilding Layoutdefs…
Rebuilding GlobalLinks…
Rebuilding LogicHooks…
Rebuilding Menus…
Rebuilding Include…
Rebuilding ScheduledTasks…
Rebuilding UserPage…
Rebuilding Utils…
Rebuilding Vardefs…
Rebuilding JSGroupings…
Rebuilding DC Actions…
Rebuilding RelationshipsRebuilding TableDictionary…
Updating the admin warning message…
Rebuilding Audit Tables…
ACLAction not Audit Enabled…
ACLRole not Audit Enabled…
Relationship not Audit Enabled…
Audit table for Leads already exists. skipping…
Audit table for Cases already exists. skipping…
Audit table for Bugs already exists. skipping…
User not Audit Enabled…
CampaignLog not Audit Enabled…
Project not Audit Enabled…
Audit table for ProjectTasks already exists. skipping…
Audit table for Campaigns already exists. skipping…
ProspectList not Audit Enabled…
Prospect not Audit Enabled…
EmailMarketing not Audit Enabled…
CampaignTracker not Audit Enabled…
Release not Audit Enabled…
EmailMan not Audit Enabled…
Scheduler not Audit Enabled…
SchedulersJob not Audit Enabled…
Audit table for Contacts already exists. skipping…
Audit table for Accounts already exists. skipping…
Audit table for Opportunitys already exists. skipping…
EmailTemplate not Audit Enabled…
Note not Audit Enabled…
Call not Audit Enabled…
Email not Audit Enabled…
Meeting not Audit Enabled…
Task not Audit Enabled…
User not Audit Enabled…
Employee not Audit Enabled…
Currency not Audit Enabled…
Tracker not Audit Enabled…
ImportMap not Audit Enabled…
UsersLastImport not Audit Enabled…
Administration not Audit Enabled…
UpgradeHistory not Audit Enabled…
vCal not Audit Enabled…
Version not Audit Enabled…
Role not Audit Enabled…
Document not Audit Enabled…
DocumentRevision not Audit Enabled…
FieldsMetaData not Audit Enabled…
InboundEmail not Audit Enabled…
SavedSearch not Audit Enabled…
UserPreference not Audit Enabled…
MergeRecord not Audit Enabled…
EmailAddress not Audit Enabled…
EmailText not Audit Enabled…
SugarFeed not Audit Enabled…
EAPM not Audit Enabled…
OAuthKey not Audit Enabled…
OAuthToken not Audit Enabled…
Audit table for Inv01_Partss already exists. skipping…
Audit table for Inv01_Inventorys already exists. skipping…
Audit table for PL001_Production_Liness already exists. skipping…
KReport not Audit Enabled…
Done
Database tables are synced with vardefs
===================End sugar 6.5.24=========================
===================start Suite 7.6 migrated from sugar 6.5.24 =========================
Clearing Vardefs from cache…done
Clearing language files from cache…done
Clearing Template files from cache…done
Clearing JS files from cache…done
Clearing Vardefs from cache…done
Clearing JS Language files from cache…done
Clearing language files from cache…done
Clearing SuiteCRM Dashlet files from cache…done
Clearing SuiteCRM Feed Cache…done
Clearing Smarty templates from cache…done
Clearing Theme Cache…done
Clearing XML files from cache…done
Clearing Unified Search Cache…done
Clearing External API Cache File…done
Rebuilding Extensions…
Rebuilding Include…
Rebuilding Language…en_us
Rebuilding ActionViewMap…
Rebuilding ActionFileMap…
Rebuilding ActionReMap…
Rebuilding Administration…
Rebuilding EntryPointRegistry…
Rebuilding Extensions…
Rebuilding FileAccessControlMap…
Rebuilding Layoutdefs…
Rebuilding GlobalLinks…
Rebuilding LogicHooks…
Rebuilding Menus…
Rebuilding Include…
Rebuilding ScheduledTasks…
Rebuilding UserPage…
Rebuilding Utils…
Rebuilding Vardefs…
Rebuilding JSGroupings…
Rebuilding Actions…
Rebuilding DC Actions…
Rebuilding RelationshipsRebuilding TableDictionary…
Updating the admin warning message…
Rebuilding Audit Tables…
ACLAction not Audit Enabled…
ACLRole not Audit Enabled…
Relationship not Audit Enabled…
Audit table for Leads already exists. skipping…
Audit table for Cases already exists. skipping…
Audit table for Bugs already exists. skipping…
User not Audit Enabled…
CampaignLog not Audit Enabled…
Project not Audit Enabled…
Audit table for ProjectTasks already exists. skipping…
Audit table for Campaigns already exists. skipping…
ProspectList not Audit Enabled…
Prospect not Audit Enabled…
EmailMarketing not Audit Enabled…
CampaignTracker not Audit Enabled…
Release not Audit Enabled…
EmailMan not Audit Enabled…
Scheduler not Audit Enabled…
SchedulersJob not Audit Enabled…
Audit table for Contacts already exists. skipping…
Audit table for Accounts already exists. skipping…
Audit table for Opportunitys already exists. skipping…
EmailTemplate not Audit Enabled…
Note not Audit Enabled…
Call not Audit Enabled…
Email not Audit Enabled…
Meeting not Audit Enabled…
Task not Audit Enabled…
User not Audit Enabled…
Employee not Audit Enabled…
Currency not Audit Enabled…
Tracker not Audit Enabled…
ImportMap not Audit Enabled…
UsersLastImport not Audit Enabled…
Administration not Audit Enabled…
UpgradeHistory not Audit Enabled…
vCal not Audit Enabled…
Alert not Audit Enabled…
Role not Audit Enabled…
Document not Audit Enabled…
DocumentRevision not Audit Enabled…
FieldsMetaData not Audit Enabled…
InboundEmail not Audit Enabled…
SavedSearch not Audit Enabled…
UserPreference not Audit Enabled…
MergeRecord not Audit Enabled…
EmailAddress not Audit Enabled…
EmailText not Audit Enabled…
SugarFeed not Audit Enabled…
EAPM not Audit Enabled…
OAuthKey not Audit Enabled…
OAuthToken not Audit Enabled…
Audit table for AM_ProjectTemplatess already exists. skipping…
Audit table for AM_TaskTemplatess already exists. skipping…
Favorites not Audit Enabled…
Audit table for AOK_Knowledge_Base_Categoriess already exists. skipping…
Audit table for AOK_KnowledgeBases already exists. skipping…
Reminder not Audit Enabled…
Reminder_Invitee not Audit Enabled…
Audit table for FP_eventss already exists. skipping…
Audit table for FP_Event_Locationss already exists. skipping…
Audit table for AOD_IndexEvents already exists. skipping…
Audit table for AOD_Indexs already exists. skipping…
Audit table for AOP_Case_Eventss already exists. skipping…
Audit table for AOP_Case_Updatess already exists. skipping…
Audit table for AOR_Reports already exists. skipping…
AOR_Field not Audit Enabled…
AOR_Chart not Audit Enabled…
AOR_Condition not Audit Enabled…
AOR_Scheduled_Reports not Audit Enabled…
Audit table for AOS_Contractss already exists. skipping…
Audit table for AOS_Invoicess already exists. skipping…
Audit table for AOS_PDF_Templatess already exists. skipping…
Audit table for AOS_Product_Categoriess already exists. skipping…
Audit table for AOS_Productss already exists. skipping…
Audit table for AOS_Products_Quotess already exists. skipping…
Audit table for AOS_Line_Item_Groupss already exists. skipping…
Audit table for AOS_Quotess already exists. skipping…
AOW_Action not Audit Enabled…
Audit table for AOW_WorkFlows already exists. skipping…
AOW_Processed not Audit Enabled…
AOW_Condition not Audit Enabled…
Audit table for jjwg_Mapss already exists. skipping…
Audit table for jjwg_Markerss already exists. skipping…
Audit table for jjwg_Areass already exists. skipping…
Audit table for jjwg_Address_Caches already exists. skipping…
Audit table for Calls_Reschedules already exists. skipping…
Audit table for SecurityGroups already exists. skipping…
Audit table for OutboundEmailAccountss already exists. skipping…
Audit table for TemplateSectionLines already exists. skipping…
Audit table for Inv01_Partss already exists. skipping…
Audit table for Inv01_Inventorys already exists. skipping…
Audit table for PL001_Production_Liness already exists. skipping…
KReport not Audit Enabled…
Done
Database tables are synced with vardefs
===================end Suite 7.6 migrated from sugar 6.5.24 =========================
Have you tried Admin -> Repair -> Rebuild Relationships?
Hello,
executing the command “Rebuild Relationships” results into the same:
[a213ec4e-0e5c-dfb7-8528-501bd8b3a69a][FATAL] Missing relationship definition cases_opportunities. skipping cases_opportunities subpanel
BTW: searching for “a213ec4e-0e5c-dfb7-8528-501bd8b3a69a” results into a folder here./cache/modules/Emails/a213ec4e-0e5c-dfb7-8528-501bd8b3a69a
The respective folder is empty. Deleting it would not change anything.
I basically executed all commands from the Admin -> Repair. No change.
Any other idea?
Thanks.
A few more questions…
Did you do any customizations? Is this in a custom module?
When exactly does that error happen? When you open a specific email, or what?
Because that id seems to be from an email, I wonder what that has to do with cases_opportunities?
Maybe you could go into phpMyAdmin and look for that id in the database, I wonder if that error is about a missing row in a relationship table (though I wouldn’t say that, from the text).
Hello pgr,
thaks for your fast reply. Yesm there has been some customization: This database is running since 2012 and was particularly used for case tracing. We have also associated opportunities to cases and did set up a many-to-many relationshsip. To be honest, I have never thoroughly checked the logfiles until the upgrade from sugar to suite failed.
I already searched the database from PHPMYADMIN and have 17782 matches in various places. Sorry, all German: “Treffer” means “matches”
18 Treffer in accounts Anzeigen Löschen
18 Treffer in accounts_audit Anzeigen Löschen
0 Treffer in accounts_bugs
0 Treffer in accounts_cases
0 Treffer in accounts_contacts
0 Treffer in accounts_cstm
0 Treffer in accounts_inv01_inventory_1_c
0 Treffer in accounts_opportunities
48 Treffer in acl_actions Anzeigen Löschen
4 Treffer in acl_roles Anzeigen Löschen
0 Treffer in acl_roles_actions
0 Treffer in acl_roles_users
0 Treffer in address_book
0 Treffer in aos_contracts
0 Treffer in aos_contracts_audit
0 Treffer in aos_contracts_documents
1 Treffer in aos_invoices Anzeigen Löschen
0 Treffer in aos_invoices_audit
21 Treffer in aos_line_item_groups Anzeigen Löschen
0 Treffer in aos_line_item_groups_audit
2 Treffer in aos_pdf_templates Anzeigen Löschen
0 Treffer in aos_pdf_templates_audit
1 Treffer in aos_product_categories Anzeigen Löschen
0 Treffer in aos_product_categories_audit
2003 Treffer in aos_products Anzeigen Löschen
0 Treffer in aos_products_aos_products_1_c
1 Treffer in aos_products_audit Anzeigen Löschen
0 Treffer in aos_products_cstm
52 Treffer in aos_products_quotes Anzeigen Löschen
11 Treffer in aos_products_quotes_audit Anzeigen Löschen
17 Treffer in aos_quotes Anzeigen Löschen
0 Treffer in aos_quotes_aos_invoices_c
93 Treffer in aos_quotes_audit Anzeigen Löschen
0 Treffer in aos_quotes_cstm
0 Treffer in aos_quotes_os_contracts_c
0 Treffer in aos_quotes_project_c
0 Treffer in aow_actions
0 Treffer in aow_conditions
0 Treffer in aow_processed
0 Treffer in aow_processed_aow_actions
0 Treffer in aow_workflow
0 Treffer in aow_workflow_audit
0 Treffer in bugs
0 Treffer in bugs_audit
2 Treffer in c0001_contracts Anzeigen Löschen
0 Treffer in c0001_contracts_audit
0 Treffer in c0001_contracts_cstm
0 Treffer in c0001_contrcts_accounts_c
0 Treffer in c0001_contrpportunities_c
31 Treffer in calls Anzeigen Löschen
0 Treffer in calls_contacts
0 Treffer in calls_cstm
0 Treffer in calls_leads
31 Treffer in calls_users Anzeigen Löschen
0 Treffer in campaign_log
0 Treffer in campaign_trkrs
0 Treffer in campaigns
0 Treffer in campaigns_audit
771 Treffer in cases Anzeigen Löschen
1175 Treffer in cases_audit Anzeigen Löschen
0 Treffer in cases_bugs
0 Treffer in cases_cstm
0 Treffer in config
44 Treffer in contacts Anzeigen Löschen
17 Treffer in contacts_audit Anzeigen Löschen
0 Treffer in contacts_bugs
0 Treffer in contacts_cases
0 Treffer in contacts_cstm
0 Treffer in contacts_users
0 Treffer in cron_remove_documents
0 Treffer in currencies
0 Treffer in custom_fields
3 Treffer in dms_saved_layouts Anzeigen Löschen
229 Treffer in document_revisions Anzeigen Löschen
231 Treffer in documents Anzeigen Löschen
0 Treffer in documents_accounts
0 Treffer in documents_bugs
0 Treffer in documents_c0001_contracts_1_c
0 Treffer in documents_cases
0 Treffer in documents_contacts
0 Treffer in documents_opportunities
0 Treffer in eapm
0 Treffer in em_events
0 Treffer in em_installed
1 Treffer in email_addr_bean_rel Anzeigen Löschen
0 Treffer in email_addresses
0 Treffer in email_cache
0 Treffer in email_marketing
0 Treffer in email_marketing_prospect_lists
4 Treffer in email_templates Anzeigen Löschen
0 Treffer in emailman
1200 Treffer in emails Anzeigen Löschen
4 Treffer in emails_beans Anzeigen Löschen
0 Treffer in emails_email_addr_rel
0 Treffer in emails_text
0 Treffer in enhanced_search_3_queries
0 Treffer in fields_meta_data
5 Treffer in folders Anzeigen Löschen
0 Treffer in folders_rel
6 Treffer in folders_subscriptions Anzeigen Löschen
0 Treffer in import_maps
1 Treffer in inbound_email Anzeigen Löschen
0 Treffer in inbound_email_autoreply
0 Treffer in inbound_email_cache_ts
89 Treffer in inv01_inventory Anzeigen Löschen
0 Treffer in inv01_inventory_audit
0 Treffer in inv01_inventory_cstm
0 Treffer in inv01_inventory_documents_1_c
7 Treffer in inv01_parts Anzeigen Löschen
0 Treffer in inv01_parts_audit
0 Treffer in inv01_parts_cstm
0 Treffer in inv01_parts_inv01_inventory_c
270 Treffer in jjwg_address_cache Anzeigen Löschen
0 Treffer in jjwg_address_cache_audit
0 Treffer in jjwg_areas
0 Treffer in jjwg_areas_audit
0 Treffer in jjwg_maps
0 Treffer in jjwg_maps_audit
0 Treffer in jjwg_maps_jjwg_areas_c
0 Treffer in jjwg_maps_jjwg_markers_c
0 Treffer in jjwg_markers
0 Treffer in jjwg_markers_audit
0 Treffer in job_queue
11 Treffer in kreports Anzeigen Löschen
0 Treffer in kreportschedules
0 Treffer in kreportscheduleslog
0 Treffer in kreportsfavorites
0 Treffer in kreportsnapshots
0 Treffer in kreportsnapshotsdata
0 Treffer in kreportstats
4336 Treffer in la_loginaudit Anzeigen Löschen
0 Treffer in la_loginaudit_audit
0 Treffer in leads
0 Treffer in leads_audit
0 Treffer in leads_cstm
0 Treffer in linked_documents
2 Treffer in meetings Anzeigen Löschen
0 Treffer in meetings_contacts
0 Treffer in meetings_cstm
0 Treffer in meetings_leads
0 Treffer in meetings_tasks_1_c
2 Treffer in meetings_users Anzeigen Löschen
1592 Treffer in notes Anzeigen Löschen
0 Treffer in notes_cstm
0 Treffer in oauth_consumer
0 Treffer in oauth_nonce
0 Treffer in oauth_tokens
165 Treffer in opportunities Anzeigen Löschen
101 Treffer in opportunities_audit Anzeigen Löschen
0 Treffer in opportunities_cases_c
0 Treffer in opportunities_contacts
0 Treffer in opportunities_cstm
0 Treffer in opportunities_inv01_inventory_1_c
0 Treffer in opportunities_pl001_production_lines_1_c
0 Treffer in outbound_email
5 Treffer in pl001_production_lines Anzeigen Löschen
0 Treffer in pl001_production_lines_accounts_c
1 Treffer in pl001_production_lines_audit Anzeigen Löschen
0 Treffer in pl001_production_lines_cstm
0 Treffer in pl001_production_lines_opportunities_c
0 Treffer in pm_process_completed_process
0 Treffer in pm_process_filter_table
0 Treffer in pm_process_task_call_defs
0 Treffer in pm_process_task_email_defs
0 Treffer in pm_process_task_task_defs
1 Treffer in pm_processmanager Anzeigen Löschen
0 Treffer in pm_processmanager_audit
0 Treffer in pm_processmanager_entry_table
0 Treffer in pm_processmanagerstage
0 Treffer in pm_processmanagerstage_audit
0 Treffer in pm_processmanagerstagetask
0 Treffer in pm_processmanagerstagetask_audit
0 Treffer in pm_processmgerstagetask
0 Treffer in pm_processmmanagerstage
12 Treffer in project Anzeigen Löschen
0 Treffer in project_cstm
0 Treffer in project_task
0 Treffer in project_task_audit
0 Treffer in projects_accounts
0 Treffer in projects_bugs
0 Treffer in projects_cases
0 Treffer in projects_contacts
0 Treffer in projects_opportunities
0 Treffer in projects_products
0 Treffer in prospect_list_campaigns
0 Treffer in prospect_lists
0 Treffer in prospect_lists_prospects
0 Treffer in prospects
0 Treffer in prospects_cstm
0 Treffer in relationships
0 Treffer in releases
0 Treffer in rls_linkedinparserconfig_users_c
0 Treffer in roles
0 Treffer in roles_modules
0 Treffer in roles_users
0 Treffer in saved_search
0 Treffer in schedulers
0 Treffer in schedulers_times
0 Treffer in so_users
1549 Treffer in sugarfeed Anzeigen Löschen
38 Treffer in tasks Anzeigen Löschen
3436 Treffer in tracker Anzeigen Löschen
0 Treffer in upgrade_history
61 Treffer in user_preferences Anzeigen Löschen
36 Treffer in users Anzeigen Löschen
0 Treffer in users_feeds
6 Treffer in users_last_import Anzeigen Löschen
0 Treffer in users_password_link
2 Treffer in users_signatures Anzeigen Löschen
1 Treffer in vcals Anzeigen Löschen
0 Treffer in versions
0 Treffer in zr2_Report
2 Treffer in zr2_ReportContainer Anzeigen Löschen
12 Treffer in zr2_ReportParameter Anzeigen Löschen
0 Treffer in zr2_ReportParameterLink
0 Treffer in zr2_ReportTemplate
It would help if you answered all my questions, not just one of them… I still don’t know where this is happening, if only for the detail of one record, or what?
About your MySQL results: that’s a lot of stuff for just one id… I’m assuming you searched for a213ec4e-0e5c-dfb7-8528-501bd8b3a69a
First, you would need to understand what that id is… I would pay special attention to these:
1 Treffer in aos_invoices
1 Treffer in aos_product_categories
1 Treffer in aos_products_audit
1 Treffer in email_addr_bean_rel
1 Treffer in inbound_email
1 Treffer in pl001_production_lines
1 Treffer in pm_processmanager
1 Treffer in vcals
They have only one result, so they can be the tables where you’ll find that id as a primary key. Maybe it’s an email.
All the other results would be references to this record, which is impressive due to their very large number…
This is all just a beginning to an investigation, tracking down how your DB structure is, and where it’s broken…
Hello pgr,
apologies for not answering all your questions:
“Did you do any customizations?”
Answer: particularly the customization was done by adding the opportunity to any case, because any account could have several opportunities (in our case “systems” that could have a failure.
“Is this in a custom module?”
Answer: I have no idea how to find out. The changes were done in the Admin -> Studio.
“When exactly does that error happen? When you open a specific email, or what?”
Answer: Opening a case, this error happens.
Because that id seems to be from an email, I wonder what that has to do with cases_opportunities?
Answer: I will check your comment and see where this ID reers to.
Thanks for the hints.
Hello,
Surprisingly I figured that the ID a213ec4e-0e5c-dfb7-8528-501bd8b3a69a is an active user. Apparently this user has been very busy in the system. This, however, does not clarify the problems in the logfile FATAL.
I am lost. Anyone’s idea most welcome. Thank you.
Yes this is a tough one.
The case that you open to get the error, you can get it’s ID from the URL visible in your browser when you go into detail view.
Then you can try and follow that in the database - from the Cases table, to the table with the relationship connecting it to Opportunities, etc.
Or, if this really happens only with one case, consider just deleting it and creating a new one…