Graph/view doesn't return records while they're query-able

(0) Share

Report

Posted on by Jeroen J

Dear reader,

I have a form in which a graph is included. Graph and view are public (ofcourse, I guess?).
Being a systemadministrator with this role, I get to see a beautiful graph with the values I was expecting. As soon as I remove the sysad role, I'm told that "a chart cannot be displayed because the view or filter criteria that you selected did not return any records".
Well, that could make sense. However, if I open advanced find, I can query all records that I was looking for. So, I do have access to them (not being sysad that is), but they're just not shown on the graph.

I have this uncomfortable feeling that I'm overlooking something here. Any other security thing that I'm missing? Any ideas or clues?

Thanks in advance,
regards,
Jeroen

*This post is locked for comments

All responses (17)

Answers (0)

Suggested answer

Rasmus R. Aardal on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

Hello,

Just chipping in here very late, in case you are still having this issue;

When you remove the copied sysadmin role, which role(s) do the users have when they can't see the records in the charts?

Default security roles have a whole host of hidden privileges that are not visible in the security role editor, but that are required for many operations. Roles that are created from scratch do not contain these hidden privileges, which means that a user that only has roles of this type and no "out of the box" or copied OOB roles is missing a lot of required privileges.

Don't ask me why it's set up this way, just make sure that the users in question have at least one OOB security role to make sure they have these hidden privileges. I ran into this issue in an org where we meticulously set up each role from scratch because we needed complete control of the privileges, which resulted in a bunch of privilege errors everywhere even though a few of the roles looked exactly like the system roles.

Regards,

Rasmus
Jeroen J on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

Hi,

I'm afraid not. User still uses systemadmin rights in order to see what's needed
Lior Efraim 30 on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

hi Jeroen,

did you find an answer? i'm experiencing the same problem.

thanks.
Jeroen J on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

Ah! That part of security you mean. I'm using a role that is a direct copy of Sysad role. Without any changes, so it's all full and green.

I did the trace as requested, even though I figured that wouldn't help since there doesn't seem to be a real error. Well, proved me wrong (in some way). One particular error shows up everytime this form is loaded but I can't make any peanutbutter from it (freely translated from Dutch, meaning it doesn't mean anything to me at all). Might you have any idea?

at DisplayRuleEvaluator.EvaluatePrivilegeRulePart(PrivilegeRulePart rulePart, String primaryEntity, String currentEntity) ilOffset = 0x57
at DisplayRuleEvaluator.EvaluateRulePart(RulePart rulePart, String primaryEntity, RibbonTabInformation tabInfo, DisplayRuleInformation displayRuleInformation) ilOffset = 0x2D2
at DisplayRuleEvaluator.EvaluateRule(String primaryEntity, RibbonTabInformation tabInfo, DisplayRuleInformation trimRuleInformation) ilOffset = 0x57
at RibbonDisplayRuleEvaluator.GetHiddenControls(Dictionary`2 controlMap, Dictionary`2 ruleDefinitions, String primaryEntity, DisplayRuleInformation trimRuleInformation, HashSet`1 webHiddenControls, HashSet`1 offlineHiddenControls, HashSet`1 onlineHiddenControls) ilOffset = 0x70
at RibbonDisplayRuleEvaluator.GetHiddenIds(HashSet`1 displayRuleIds, Dictionary`2 mapCommandToRule, RibbonTabInformation tabInformation, DisplayRuleInformation displayRuleInformation, HashSet`1 webHiddenControls, HashSet`1 offlineHiddenControls, HashSet`1 onlineHiddenControls, Dictionary`2 dynamicCommandDefinitions, Dictionary`2 dynamicCommandToControlMap, IOrganizationContext context) ilOffset = 0x52
at RibbonDescription.CalculateHiddenControls(DynamicMenuInformation dynamicMenuInformation, HashSet`1 currentTabCommands, RibbonTabInformation tabInformation, String entityLogicalName) ilOffset = 0x1C9
at RibbonDescription.AddCommandsForTab(String tabIdForFetch, String entityLogicalName, RibbonTabInformation tabInformation) ilOffset = 0xF0
at RibbonDescription.AddTabs() ilOffset = 0x92
at RibbonData.GetRibbonDescription(PageResourceManager currentHeader, Boolean suppressTabs) ilOffset = 0xFE
at RibbonData.CreateClientControl(PageResourceManager currentHeader, Boolean suppressTabs, EventManager parentEventManager) ilOffset = 0x7
at FormDataPage.Render(HtmlTextWriter writer) ilOffset = 0x1D6
at Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) ilOffset = 0x22
at Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ilOffset = 0x8A4
at Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ilOffset = 0x3C
at Page.ProcessRequest() ilOffset = 0x14
at Page.ProcessRequest(HttpContext context) ilOffset = 0x33
at CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() ilOffset = 0x18D
at HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) ilOffset = 0x15
at PipelineStepManager.ResumeSteps(Exception error) ilOffset = 0x27C
at HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) ilOffset = 0x31
at HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) ilOffset = 0xD3
at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) ilOffset = 0x11E
at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) ilOffset = 0x9
at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) ilOffset = 0xFFFFFFFF
at UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) ilOffset = 0xFFFFFFFF
at PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) ilOffset = 0x1C8
at PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) ilOffset = 0x9
*** MSCRM:ASSERTEX *** - Unrecognized privilege depth: None
tw0sh3ds 5,600 on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

This is my security role for example. Can you post your role? You say you have many, but are they all needed? Simply check if you have all of the privileges that are presented on this screen.

Also if you are on-premise, enable tracing, reproduce error and check the logs - sometimes that are useful information regarding missing privileges.
Jeroen J on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

Hmm, afraid you have to help me a bit with what you mean.

On the chart there is no security role setting, the form in which the chart is shown is shown to a set of roles that I also (all of them besides sysad) posess, the public view is public so no roles.
tw0sh3ds 5,600 on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

Ok and what exactly are the security role settings on Customization tab? Because I don't think this error is about not returning records, looks like rather a problem with accessing some kind of metadata
Jeroen J on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

By all means (you'll probably get why this is about to drive me nuts):

even when hoovering over the header (which usually shows the Reload, Records and Enlarge buttons), nothing happens. So, this might be pointing out that the chart itself really isn't showing..?
tw0sh3ds 5,600 on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

No, it should be there even if there are no records. Can you post some screenshot of the chart?
Jeroen J on at

Like (0)

Report

RE: Graph/view doesn't return records while they're query-able

In this case, it's not there. Probably because no records are returned.