Error

The user does not exist or is not unique.

To fix this error try changing the Group Owner.

Group –> Settings –> Group Settings –> Owner

 

Trying to use an Event Handler in SharePoint 2007 my test user was seeing this error:

Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

The error was being triggered by an ItemUpdated or ItemAdded event.

fix:

Public Overrides Sub ItemUpdated(ByVal properties As SPItemEventProperties)
SPSecurity.RunWithElevatedPrivileges(AddressOf mCode)
End Sub

Private Sub mCode()
Dim eFire As hEventFiring = New hEventFiring
Using spsSite As SPSite = New SPSite(sPi.WebUrl)
Using spwWeb As SPWeb = spsSite.OpenWeb

Dim iSPl As SPListItem = spwWeb.Lists(sPi.ListId).GetItemById(sPi.ListItem.ID)

Try

eFire.dEventFire()
Dim roleAssig As New SPRoleAssignment(spwWeb.SiteGroups(mGroup))
roleAssig.RoleDefinitionBindings.Add(spwWeb.RoleDefinitions(“Contribute”))

If iSPl.HasUniqueRoleAssignments = False Then
iSPl.BreakRoleInheritance(True)
End If

For Each spra As SPRoleAssignment In iSPl.RoleAssignments
spra.RoleDefinitionBindings.RemoveAll()
spra.Update()
Next

iSPl.RoleAssignments.Add(roleAssig)
iSPl(“CommentField”) = mGroup
iSPl.Update()
eFire.eEventFire()

Catch ex As Exception
iSPl(“CommentField”) = ex.Message.ToString
iSPl.Update()
Finally
End Try
End Using
End Using
End Sub

Class hEventFiring
Inherits SPItemEventReceiver

Public Sub dEventFire()
Me.DisableEventFiring()
End Sub

Public Sub eEventFire()
Me.EnableEventFiring()
End Sub

End Class

————

What I’m doing:

1. Use RunWithElevatedPrivileges to call the code that updates the item.

2. Disable event firing with eFire.dEventFire

3. Break role inheritance using BreakRoleInheritance

4. Assign permissions using iSPl.RoleAssignments.Add(roleAssig)

5. Enable event firing eFire.eEventFire.

The key to this working is Dim iSPl As SPListItem = spwWeb.Lists(sPi.ListId).GetItemById(sPi.ListItem.ID)

Using a Workflow to update a Lookup field in a Library in SharePoint I ran into this error:

Value does not fall within the expected range

I had no issue obtaining the value of a value from the Lookup field.

Dim sString As New SPFieldLookupValue(DirectCast(wfP.Item(“Field-R”), String))
sString= sString.LookupValue

BUT, what I failed to pay attention to was the hyphen in the field name.

Using the U2U CAML Query Builder I discovered my problem.

The real field name was Field_x002d_L

wfP.Item(“Field_x002d_L”) = New SPFieldLookupValue(1, “Value”)

…. Make sure you are updating the correct field name.

code:

spLibItem.Item(sField) = New SPFieldLookupValue(sValueID, sValue)

In Visual Studio 2008.

I was trying to get the value of Lookup field in a Document Library and would see a result like this:

sLookup = workflowProperties.Item(“FieldName”).ToString

but it returns: 9;#FieldValue

This is how I went about fixing the string (if there is a better way, please tell me!)

sLookup = Right(workflowProperties.Item(“FieldName”).ToString, Len(workflowProperties.Item(“FieldName”).ToString) – InStr(workflowProperties.Item(“FieldName”).ToString, “#”))

After spending way too many hours messing with this, I got it to work. I was trying to update the Assigned To in a Form Library (also works in a Document Library) using a Workflow in Visual Studio 2008. SharePoint being SharePoint, nothing is ever easy.

In the VS I created a Sequential Workflow. Then I added a Code activity (codeActivity1) to the design. After that, double click codeActivity1 in the design window.

Create the Public variable wfP:

Public wfP As SPWorkflowActivationProperties = New Microsoft.SharePoint.Workflow.SPWorkflowActivationProperties

Then add the following code to your codeActivity1 module.

Dim site As SPWeb = New SPSite(wfP.WebUrl).OpenWeb()

Dim list As SPList = site.Lists(wfP.List.Title)

Dim listItem As SPListItem = wfP.Item

listItem(“Assigned To”) = site.Groups(“gLeads”)

listItem.Update()

It should look like this when you are done:

Private Sub codeMoveToLead_ExecuteCode(ByVal sender As System.Object, ByVal e As System.EventArgs)

Dim site As SPWeb = New SPSite(wfP.WebUrl).OpenWeb()

Dim list As SPList = site.Lists(wfP.List.Title)

Dim listItem As SPListItem = wfP.Item

listItem(“Assigned To”) = site.Groups(“gLeads”)

listItem.Update()

End Sub

Trying to set the .AssignedTo never worked for me.

Dim siteName As String = workflowProperties.WebUrl

easy…

In Visual Studio 2008 I was trying to get the current sites URL. Doing this will allow for the workflow to be dynamically used in other sites.

When creating my SharePoint 2010 sandbox farm I wasn’t able to get past connecting to the database server.  This is the error I was seeing:

An error has occurred while validating the configuration settings.  An exception of type System.ArgumentNullException was thrown.  Additional exception information: The errorData argument cannot be null or zero length.  Parameter name: errorData

I logged into my SQL Server 2008 R2 VM and updated the Start Mode of SQL Agent and SQL Serve Browser to Automatic.

What / Where / How

Start –> All Programs –>SQL Server XXX –>Configuration Tools –> SQL Server Configuration Manager

After it opens select SQL Server Services, right click on SQL Server Browser, select properties, click on Service, then set Start Mode to Automatic.  Repeat these steps on SQL Server Agent service.

After doing this I restarted the server.

——– edit

if you are having trouble finding your SQL Server, Server Name try looking here:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER

SNI10.0 — LastConnect

There you will find the name of your SQL Server