How to fix: RENDER FAILED issue when you try to filter a SharePoint List (WSS3.0)

You have a SharePoint list that has more than 500 items. The list has a column of "People and Groups" type with the "Allow multiple selections" setting set to "Yes". If you click Show Filter Choices in this list, you receive the following error message:

#RENDER FAILED

My SharePoint log displayed the below error:

Unknown SQL Exception 4104 occured. Additional error information from SQL Server is included below.  The multi-part identifier "UserData.nvarchar5" could not be bound.  The multi-part identifier "UserData.tp_ID" could not be bound.  ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Applying KB article : 970946 will fix the issue

How to fix: "The security validation for this page is invalid." error

When you want to programmatically update a column for a list or library item, an error similar to the below might be thrown.

The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.

Now, I have many web methods which are updating many different libraries in my site, but this particular issue occurred on one of the web methods connected to one particular library. Though I have not been able to understand why, but I was able to resolve the issue by using the following command.

myWeb.AllowUnsafeUpdate = true;

myListItem["Status"] = "Approved";

myListItem.Update(); 

I still want to know the reason why only one of the web method and library needed this extra piece of code? All other web methods are updating library items without the use of this code.

I would appreciate your comments if you may know the reason for this. If you have found this helpful, let me know that too :)

How to fix: "Unable to display this Web Part" when you want to initiate a workflow manually

Issue

This was a recent encounter (error message below) while starting a Workflow manually in MOSS (SharePoint 2007).

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator.

For your better understanding, let me first explain you where I was at, and where I was heading. I wanted to start a workflow manually on a Document Library. [That wasn't tough :)]

I navigated to the:

• Document Library >
• Library Item >
• Edit Menu >
• Click on Workflows.
• Under Start a New Workflow section, I clicked on the Workflow and was eye to eye with the error.

Analysis

As the error was instructing me to use SharePoint Designer, so I opened. And since this was a web part that was failing, I thought if I could remove the web part from the page and add it again. This was my source of greater understanding.

But since this was related to Workflows, I opened the particular workflow that was failing and noticed an .aspx page in the bundle (as below). This ASPX page represents the page that we use to manually run the workflow.

Resolution

I backed up this .aspx page, merely by changing its name. I then opened the Workflow (.xoml file) and published it. This action created a new ASPX page for me.

Now when I clicked on Start a New Workflow, the page appeared fine and I was able to run the workflow.

Download latest InfoPath form templates

"Change is inevitable", and it is true to InfoPath forms as well. Quite often the client asks you to make changes to the InfoPath forms and you may not have the original files.

Perhaps the files you have in your network location are outdated and old and have been gone through many update iterations.

You can download the latest form by navigating to the following path:

http://<domain>/FormServerTemplates/FormTemplate.xsn

Select the Form and click Save As or Download a copy

Note: The URL path may be different for you depending on your SharePoint Site hierarchy.

SPD Workflow error: Path needs to point to valid member

I had created a workflow and its always interesting to make few changes to it, or is it? It is not so welcoming though, but when you have a client instruction, you welcome it with a smile.

So here I was updating/editing the workflow. After updating it when I clicked Finish (this will associates the workflow to a SharePoint List), I received an error as below.

I haven't found any reference on the web or workaround for this issue.

(0, 0) Activity 'ID9355' validation failed: Path '_x005f_String135' used to specify member for 'ROOT' is invalid. Path needs to point to valid member.
(0, 0) Activity 'ID9325' validation failed: Path '_x005f_String136' used to specify member for 'ROOT' is invalid. Path needs to point to valid member.

I realized I had backed up the workflow before making any changes to it. So I opened the copy in Notepad (.xoml file) and was trying to trace the String '_x005f_String135' and '_x005f_String136' as in the above error.

I found that this string was referenced couple of times in the document. I then started comparing both the workflows (the one I was editing and the backed up copy).

Found that a statement like below were missing in the copy I was editing:

<ns0:WorkflowDataField Name="_x005f_String135" Type="System.String" />
<ns0:WorkflowDataField Name="_x005f_String136" Type="System.String" />

I believe this to be a declaration of strings used in the workflow which apparently went missing when I was updating the workflow. I have no idea why did this happen.

So I copied this part from the backup and pasted in the file I was editing. I then saved the .xoml file, opened the workflow and clicked Finish (to associate with SharePoint List.)

It worked!

Lesson Learnt, or rather an Affirmation to myself - Continue backing up often.

Unable to add Active Directory group in SharePoint

SharePoint Users are usually Active Directory Users when using SharePoint in intranet. A strange thing I came across was I was able to add individual AD users in SharePoint but when I was trying to add an AD group, it said "No exact match found." Even though the AD group is present in the domain's active directory.

•  Now to resolve this issue, browse to the Active Directory and right click the group to open it's properties.
• On the General tab, find the section Group Type.
• If it is set to Distribution, change that to Security.
• Now you should be able to add the AD group into SharePoint.

For details regarding Group Types, refer Microsoft TechNet Site here.

In brief:

Distribution Group

This is used only with e-mail applications (like Exchange) to send e-mails to a group. This is not security enabled.

Security Group

To give an AD group controlling access to shared resources, you need to use Security Groups. A concept called discretionary access control lists (DACLs)

Hope this helped!

Screenshot on HTC Chacha

Red button (Call End button) + Home button (on the screen)

Did you get it?