Dashboard reports not showing data

[timritchie]

I have been having a problem with Dashboard reports using SugarCRM CE Version 5.2.0k (Build 5837). I have several opportunities created under a user account (in a variety of sales stages), but the Report | Dashboard reports all display an error: No Displayable Data.

I had a consultant look at the problem and they fixed it, but the charts would only show up when logged into the Admin account, not the user account that created the Opportunities. When logged into the user account, I continued to get the same error. There is data that should show using the reporting parameters I set.

In an attempt to fix this, I used the Admin | Repair function to clear the chart data cache, rebuild relationships, and rebuild Sugar Dashlets. Now the reporting doesn't work for either the Admin or user account.

The Cache directory permissions are set to 777 and the XML permissions set to 775.

HELP!

[hazyumps]

Just for fun go into the sugar system settings and turn on developer mode and try to repair your permissions again. Hell just remove the cache manually and itll all rebuild

I would first do 'chown -R 777 cache' from the root dir and if that didnt help try to wipe out the cache with

rm -r cache/*

it just sounds to me like your having issues with sugar wanting to pull older cache files that are still floating for whatever reason

[timritchie]

WHO'S THE SMARTEST GUY IN THE HOUSE??? Thanks so much for your help. Clearing the cache didn't work. Manually deleting the cache didn't work. But, changing the permissions on the cache folder to 777 did. I can now see all the charts/graphs. Thanks for bringing 8 weeks of troubleshooting to an end.

[timritchie]

My euphoria was shortlived... All Opportunities by Lead Source and My Pipeline by Result graphs are working great. My Pipeline and (all) Pipeline reports are still showing "data not available". There are opportunities within the require parameters, so both graphs should be showing data... Any ideas?

[hazyumps]

hey - sorry for the late response(**understatement**) but try clicking the settings (little pencle) button on the pipeline dashlet and check and make sure that the dates are correct - i ran into that about a week ago (wierd)...

letme know - hazyumps@gmail.com

[timritchie]

I'm afraid they are... Data is showing up fine in the All Opportunities by Lead Source and My Pipeline by Sales Stage. Actually, now that I look at it, only Closed Won and Closed Lost opportunities are showing up in the My Pipeline by Sales Stage dashlet.

I appreciate your help. No worries about the delayed response.

[AlexAv]

I have been having a problem with Dashboard reports using SugarCRM CE Version 5.2.0k (Build 5837). I have several opportunities created under a user account (in a variety of sales stages), but the Report | Dashboard reports all display an error: No Displayable Data.

I had a consultant look at the problem and they fixed it, but the charts would only show up when logged into the Admin account, not the user account that created the Opportunities. When logged into the user account, I continued to get the same error. There is data that should show using the reporting parameters I set.

In an attempt to fix this, I used the Admin | Repair function to clear the chart data cache, rebuild relationships, and rebuild Sugar Dashlets. Now the reporting doesn't work for either the Admin or user account.

The Cache directory permissions are set to 777 and the XML permissions set to 775.

HELP!

Change the default_permissions in the config.php

This change

 ...
    'default_permissions' =>
    array (
    'dir_mode' => 1528,
    'file_mode' => 432,
    'user' => '',
    'group' => '',
    ),
... 
  

To this

 ...
     'default_permissions' => 
  array (
    'dir_mode' => 1533,
    'file_mode' => 436,
    'user' => '',
    'group' => '',
  ),
... 
  

And then clear XML directory.

[timritchie]

AlexAV - I gave that a shot and it resulted in several errors. Fortunately, updating the permissions to 777 on the cache directory and purging the cache worked great. All charts are showing now.

Thanks for your help.

[kenlyle]

setting permissions on the cache directory to 777 worked for me, too.

Thanks!
K

[responset]

I am having trouble with some of my dashboard reports not showing data.

Pipeline by Sales Stage and All Opportunities by Lead Source are fine for all users. None of the other reports are working such as Outcome by Month and My Pipeline By Sales Stage. There is definitely information that can be shown.

At first none of the reports were working. I changed the Cache folder permissions to 777 and the Pipeline by Sales Stage and All Opportunities by Lead Source charts show up, but that is it.

Does anyone have anymore ideas?

I am running v5.5.1(Build 1202)