In the account´s page, when viewing the performance subpanel if you click on "show more" field it shows you the first 5 months duplicated. (see image attached) How can we change this?
Hi Sara Moncasi
Is that a custom module? Where its data come from?
HI André Lopes I'm referring to one of the subpannels (performance) inside the account module. The data displayed is the one collected by performing on our site by different steps.
It may be an issue on relationship.
Update log level to debug, access again the Account, open the sugarcrm.log and look for the queries query related to that subpanel.
Let us know it.
In order to update log level to debug do the following:
Go to Admin
Then go to System Settings
And then go to Logger Settings
Hi André Lopes, thanks a lot for the super clear explanation with the screenshots. Really appreciated! After following those steps, I'm stucked whith how to "open the sugarcrm.log and look for the queries related to that subpanel" . Can you please indicate me how to do that??Obrigada!
In the above screenshot which Mr André Lopes mentioned you are having a link called view log.
You can clickon that to view your log
or you if you are accessing file access you can navigate to your base path <>/sugarcrm.log
or you can go to admin -> Diagnostic Tool -> uncheck everything except-SugarCRM Log File and click on execute diagnostic file
Hi André Lopes please find the sugarcrm.log results attached in the main question.
Waiting for your feedback.
Can you also check by rebuilding the relationships and doing a quick repiar and rebuild.
Hi sidhu sidhu, can you explain me all the steps to rebuild the relationships and do a quick repiar and rebuild.??? Thanks
Then you will get this page,where you need to click the repair link under the system tab
Then go to
First Repair Relationships and then quick repair and rebuild.It is better you first do it in a sandbox instance.
Hi sidhu sidhu what do you mean by doing it in a sandbox? I did all the steps you indicated and the issue is still remaining.
Bit more info and details will be appreciated.
Thanks a lot!
Hi Sara Moncasi
A sandbox is a testing environment of your instance.
You should first check in the db whether there are any duplicate records for that account
HI sidhu sidhu, no duplicated records in the DB, all perfet there, but it appears duplicated when requestes "see more data".
Retrieving data ...