Implementation restriction on OpenActivities.

I’m having a problem with users that don’t have admin rights being able to see a skuid page. The page is for an individual record.

This is the error message I see:
There is an implementation restriction on OpenActivities. When you query this relationship, security evaluation is implemented for users who don’t have administrator permissions, and only a single parent record may be evaluated. An unexpected error has occurred. Your solution provider has been notified. (skuid)

I’m not sure what’s causing the problem.  We have one template field that counts the number of Open Activities related to custom object that has a detail to master relationship to the primary object on the page. However, when I remove that field from the page, we still get the same error.  

Any advice is much appreciated.


I found a field that was in one of the Models called OpenActivities and deleted that. That allows the user to see the page.

OK glad you were able to fix the problem.  Below is some deeper explanation from our Lead Developer. 

------------

This is actually a fairly common error message, and you’ll encounter it in weird places on various Standard objects. It only ever happens for non-Admin users, because non-Admin users’ access to records is governed by the Salesforce Security Model, whereas Admins have the “View All Data” permission, which means that Salesforce ignores the Security Model completely for them when choosing which records to let Admins access. So for Salesforce’s purposes, it’s a lot more “expensive” to try to determine which records a non-Admin user should have access to, because Salesforce has to evaluate the whole Sharing Model for a given object when a non-Admin user runs a query on that object. Therefore Salesforce puts in these “Implementation Restrictions” that limit how many records of these Standard Objects that non-Admin users can request in a particular transaction. This makes sense for standard Objects like Task and Event for which there are often millions of records in customers’ orgs, because Salesforce’s Query Optimizers have to do a lot more work to try to search through these millions of records trying to find ones that a non-Admin user has access to.

@“Rob Hatch” I’m having this same error message. This managed package was installed by our old administrator and I can’t find anything on what it does or what it impacts, but last weekend all of a sudden I’m getting multiple unhandled exception messages per hour with this same error. Any suggestions on where to start, Sales Optimizer’s support age has been unresponsive.

ajs432: Are your users accessing Salesforce data using Skuid pages? Is the Skuid Managed package being used? Why do you mention Sales Optimizer? There is no relation between our two solutions. Im confused.

Skuid will not generate “unhandled exception” errors. These messages will only happen in the Skuid page UI. They will only happen if your users attempted queries that include open activities across multiple records. You will have to change your Skuid Page construction. Or you will have to look elsewhere to find where this error is coming from.

Sorry.

@Rob_Hatch Sorry, didn’t realize Skuid was a product, thought this was a message board as it came up while searching this error message. It looks like there is confusingly labeled, now defunct app exchange product out there called “Open Activities” by a company called Sales Optimizer LLC that is calling the OpenActivity object which is causing my error.

Sorry for the confusion.

No worries. I’m glad we could help in some small way. You should check out Skuid - we think its a great product!