rpwillis / SharePoint-Learning-Kit

15 stars 8 forks source link

SLK 1.8 Permission Error - Help Requested #5

Open pwburton opened 6 years ago

pwburton commented 6 years ago

Hi Richard,

I hope life is treating you well. I have the SLK working on multiple sites on the same server. We have an API that we use to create classes using a workflow that calls the functions within the SLK. All of our existing sites work the same. They are all working correctly, except this new one. All sites are on Server 2012R2 / SQL Server 2016 Each site has its own SLK database. We are getting the below error message on this one new site when we are trying to create an assignment. We have verified that the permissions and settings are identical at the following places on the working and non-work sites. IIS Pool account Web.config file for the 2 sites (working and Non-working) Database SLKSettings files are identical Site Collection Site Features Site Lists involved

Any ideas as to what I might be overlooking?

error in ULS log

Microsoft.SharePointLearningKit.SafeToDisplayException: The assignment (ID 4) does not exist or you may not have permission to access it.
at Microsoft.SharePointLearningKit.SlkStore.LoadAssignmentProperties(AssignmentItemIdentifier assignmentId, SlkRole slkRole)
at SVRSLab_Utility.AssignmentObject.GetAssignments()
at Virto.Sharepoint.Activities.Extensions.Auto.ExecuteCustomCode_D028FCA9.ExtensionPoint.CustomCode(ExecuteCustomCodeContext Context)
at Virto.Sharepoint.Activities.ExcuteCustomCode.a()
at Microsoft.SharePoint.Utilities.SecurityContext.RunAsProcess(CodeToRunElevated secureCode)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(WaitCallback secureCode, Object param)
at Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(CodeToRunElevated secureCode)
at Virto.Sharepoint.Activities.ExcuteCustomCode.Execute(ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
at System.Workflow.Runtime.Scheduler.Run()

You help and insight would be GREATLY appreciated!

Regards, Perry

rpwillis commented 6 years ago

I've not looked at SLK for a couple of years. From memory you get that when the user isn't an instructor or learner on the assignment that they are trying to access. The SQL generated checks that when returning the resultset, and if they are not associated with the assignment, then nothing is returned. That's assuming that the assignment (ID = 4) does exist in the DB.

pwburton commented 6 years ago

Thank you that should help us

On Fri, Aug 3, 2018, 9:06 PM Richard Willis notifications@github.com wrote:

I've not looked at SLK for a couple of years. From memory you get that when the user isn't an instructor or learner on the assignment that they are trying to access. The SQL generated checks that when returning the resultset, and if they are not associated with the assignment, then nothing is returned. That's assuming that the assignment (ID = 4) does exist in the DB.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/rpwillis/SharePoint-Learning-Kit/issues/5#issuecomment-410410811, or mute the thread https://github.com/notifications/unsubscribe-auth/AMzYNvz6xjM_g8Ng49npWmXv-E_URsyCks5uNPOagaJpZM4VutLT .