Failed to get value of the “Approval Status”

The full error message reads “Failed to get value of the “Approval Status” column from the “Moderation Status” field type control”. This error has started occuring on document libraries containg web part pages that were upgraded from SPS 2003. The Hidden property on the Approval Status field has somehow been set to false. The Hidden property should be True.

I found this fix. Download a utility called SharePoint Manager 2007 from this site.
Run the application on a SharePoint server.
Go to View – Object Model and make sure “Full” is selected.
Browse to the library in the treeview.
Open the list of Fields and select the Approval Status field.
Change the Hidden property to True.
If the property is already set to True then change it to false and save it. Then change it back to True and save again.

403 Forbidden and Forms Authentication with MOSS

We have a public MOSS site setup to use Forms Authentication for protected content. When the user hits files in certain document libraries, the user is automatically redirected to the login page and then returned to the document after a successful login. However, for some users, when they click a link to view a protected file they are not redirected to the login page and a “403 Forbidden” error message is displayed in Internet Explorer. This behavior does not occur in non-IE browsers (Firefox, Safari).

After some research I found this article. It looks like the culprit is a Microsoft add-in for Office Live.

Fix: Uninstall the application called “Microsoft Office Live Add-in 1.3”. That solved the problem right away. No system reboot or browser restart necessary…

MOSS Search Indexer “Access is Denied”

Have a MOSS farm the a web front-end and a separate search indexer. After installing some patches the indexer started failing with an Access is Denied message. MOSS configures a dedicated index machine by adding an entry to the HOSTS file that points the MOSS sites to the indexer’s IP address. If you try to connect to your MOSS site on the Indexer’s desktop you will unable to connect.

The patches are KB960803 and KB963027. You can read the notes here.

Following the instructions for Method 1 in the article fixed the problem and indexer was able to access and index the content again. The fix is a small registry entry that allows local connections to other host names.

Blank Dialog Using Send To

You can setup a “Send To” destination for a library so that users can easily copy files and all of it’s properties to another library. Very handy if you have a lot custom columns on the document library.

When a user selects “Send To” and a predefined destination on a SharePoint document, the user is redirected to a page with the destination and if the author should be prompted to send out updates. When the user clicks OK, a dialog box pops up with no message.

We found that this issue was solved by having the user run Microsoft Office 2007 diagnostics. This utility appears to fix the problem.

BTW, Firefox doesn’t have this problem… 🙂

Datasheet View Issues and Library Not Registered

A follow-on to a previous post on issues with the datasheet view and other issues related to conflicts with Office 2007 and 2003. We ran across another error where the datasheet view would display with no records and a javascript error. The javascript error reported “Library not registered”.

The fix is to do the following:

– Open Word
– Click the Office button (Top-left in the window)
– Click Word Options
– Click Resources
– Click the Diagnose button
– Click through the wizard until it’s finished
– Close all browser windows

That’s fixed all of our issues…

Errors Uploading Files to SharePoint After SP1

We have 2 different MOSS farms (internal and external) and most of our users upload files ranging in size from under 1 MB to over 100 MB. In the past we had the typical SharePoint issues with users uploading large files when they were in remote locations with a slow upload speed.

We installed WSS and MOSS SP1 on our external farm first and immediately received reports of problems uploading files over 2 MB. About a month later we upgraded our internal farm to SP1 and, again, immediately had reports of problems uploading files.

After much digging and not seeing anyone else with this problem, I ran across a Microsoft KB article that eventually solved my problem. I tried several things before I found the magic fix.

So what’s the fix?
Modify the web.config in your SharePoint site to include the following:

Look for this line:
<httpRuntime maxRequestLength=51200 />

Change it to this
<httpRuntime executionTimeout=999999 maxRequestLength=51200 />

The Microsoft KB article is here

This small change fixed the problem on both of our farms.

Datasheet View Errors With Office 2007

We recently started upgrading all of our employees to Office 2007 (from 2003). We’ve seen a lot of different errors but nothing pandemic. One of the errors is related to the datasheet view. I started doing some research and this blog has everything you need…