Issues with Survey in Sharepoint

Issue:
========
The number of total responses count is different than tabulated response.

Cause:
========
After further technical investigation, I found that when a user responds to a survey, it is necessary for him to click on Finish at the end of the survey to complete the response.

If a user does not click on Finish, the response is not completed, but the incomplete response is saved anyway:

The number of responses is updated in the view Overview of the survey
In addition, the response does not appear in the view Graphical Summary of the survey.
In the view All Responses of the survey, the response is visible only to the user who began to respond. Others users only see the completed responses.

Solution:
=========
Only the user who began to response can solve this issue. Other users (including users with "Full Control" permissions, the owners of the TeamPlace and even the administrators of the TeamPlace servers) cannot solve it as they can't show the incomplete responses.

This user has to go the view All Responses of the survey, to find the response that is not completed, and to select Edit Response in the drop-down menu.

Then the user has to complete the response and to click on Finish at the end of the survey.
This is a by design behavior.

MOSS 2007 SP2 issues

After Microsoft releases Service Pack 2 for the WSS and MOSS (SharePoint 2007 SP2) I tried to update my Sharepoint environment to SP2.
There are no issues when you update clean environment, but for customized application there are few things you should be aware about.
Error 1:
=======
[SPDatabaseGbwSequence] [ERROR] Upgrade object too new (build version = 12.0.0.6341, schema version = 2.0.0.0). Current server (build version = 12.0.0.4518, schema version = 3.0.1.0).
When installed SP2 and run Configuration Wizard
This error tells you nothing what relates to the actual problem. You could think that you installed any hotfixes that changed your database schema or content database might be not in right state. I had the same thoughts but this didn't help at all.
The root of the problem lies in other side.
Cause:
======
Investigating this issue I found that free SharePoint template from Microsoft cause you such issue, especially GroupBoard. If you have this template installed - that's the problem, because it interacts with the database schema and doesn't allow SharePoint SP2 to be installed.
Solution:
========
Uninstall GroupBoard template
Install SharePoint SP2
Install GroupBoard template.
Error 2:
========

“Feature '20477d83-8bdb-414e-964b-080637f7d99b' is not installed in this farm, and can not be added to this scope.”

If you get an error during the psconfig phase and you find this entry in the update.log file
“Feature '20477d83-8bdb-414e-964b-080637f7d99b' is not installed in this farm, and can not be added to this scope.”


Cause:
========
A timer Job is missing.

Resolution:
===========

You need to install this feature to be able to proceed with the update.stsadm -o installfeature -name PublishingTimerJobs

Installation of Certificate Server on Windows Server 2003 enterprise

Here are some easy steps for Installation of Certificate Server on Windows Server 2003 enterprise

• Click Start, point to Control Panel, and then click Add or Remove Programs.
• In Add or Remove Programs, click Add/Remove Windows Components.
• In the Windows Components Wizard, under Components, select Certificate Services.
• Read the warning about domain membership, and then click yes.
• Click Next.
• On the CA Type page, click Enterprise root CA, and then click next.
• On the CA Identifying Information page, in the Common name for this CA box, type Server Name (CERT-CA1), and then click next.
• On the Certificate Database Settings page, accept the defaults in the Certificate database box and the Certificate database log box, and then click next.
• When prompted to stop Internet Information Services, click yes.
• When asked if you want to enable Active Server Pages (ASP), click yes.
• After the wizard completes the installation, click Finish.

Office 2003 documents Open in Read-Only Mode

If you click on an Office document in SharePoint to open it - it loads it in the relevant application, but in Read-Only mode. The way to open a document to edit - is to access the context menu and select "Edit in Microsoft Office Word. This is especially annoying when searching for documents, since the search results does not show the context menu and does not provide a link to the document library containing the document. So the only option is to load the document in Read Only mode but then to save it - the user needs to know which document library it belongs to and then manually navigate to it.

There is however a workaround as detailed in http://support.microsoft.com/?kbid=870853. It involves adding a new registry key on every desktop as follows:

1. Quit all Office 2003 programs that are running.

2. Click Start, click Run, type regedit in the Open box, and then click OK.

3. Locate and then right-click the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Internet

4. Point to New, and then click DWORD Value.

5. Type OpenDocumentsReadWriteWhileBrowsing, and then press ENTER.

6. Right-click OpenDocumentsReadWriteWhileBrowsing, and then click Modify.

7. In the Value data box, type 1, and then click OK.

8. On the File menu, click Exit to quit Registry Editor.

If you like, you can paste the following into a command box:

reg add HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Common\Internet /vOpenDocumentsReadWriteWhileBrowsing /t REG_DWORD /d 1 /f

SharePoint Content Database Tables

Here are some importent tables of SharePoint Content Database

• Features Table that holds information about all the activated features for each site collection or site.
• Sites Table that holds information about all the site collections for this content database.
• Webs Table that holds information about all the specific sites (webs) in each site collection.
• UserInfo Table that holds information about all the users for each site collection.
• Groups Table that holds information about all the SharePoint groups in each site collection.
• Roles Table that holds information about all the SharePoint roles (permission levels) for each site.
• AllLists Table that holds information about lists for each site.
• GroupMembership Table that holds information about all the SharePoint group members.
• AllUserData Table that holds information about all the list items for each list.
• AllDocs Table that holds information about all the documents (and all list items) for each document library and list.
• RoleAssignment Table that holds information about all the users or SharePoint groups that are assigned to roles.
• SchedSubscriptions Table that holds information about all the scheduled subscriptions (alerts) for each user.
• ImmedSubscriptions Table that holds information about all the immediate subscriptions (alerts) for each user.

Configuring Usage Analysis Processing using stsadm

I ran into a problem recently when attempting to enable and configure Usage Analysis Processing (UAP)using stsadm, I needed to do this as part of a fully scripted installation of MOSS 2007 that I was assisting a customer with. Looking at the stsadm documentation, the following commands are available:

stsadm -o setproperty
-propertyname usageprocessingenabled
-propertyvalue {Yes | No}
stsadm -o setproperty
-propertyname job-usage-analysis
-propertyvalue {Yes | No}

I then ran the following two commands to configure UAP:
stsadm -o setproperty -pn job-usage-analysis -pv "daily between 08:00 and 09:00" To configure the time that the process runs.
stsadm -o setproperty -pn usageprocessingenabled -pv "Yes” To enable Usage Analysis Processing.
However when I browsed to Central Administration – Operations – Usage analysis processing the following was displayed



If you look closely you can see that the time has been set correctly but it hasn’t enabled usage analysis processing. As you can see this is grayed out meaning that Enable logging must be selected before it can be enabled – but how do I enable logging? After much investigation I eventually found out (from a colleague- thanks Kirk) that the following stsadm can be used to enable this.
stsadm -o setproperty -pn loggingenabled -pv "Yes”To put this all together I need to run the commands in this order to achieve my objective:

• stsadm -o setproperty -pn loggingenabled -pv "Yes”
• stsadm -o setproperty -pn job-usage-analysis -pv "daily between 08:00 and 09:00"
• stsadm –o setproperty -pn usageprocessingenabled -pv "Yes”

Enterprise Content Management (ECM)

Hi All These are some good blogs and links for Enterprise Content Management

Blogs
==============
blogs.msdn.com/ecm/
blogs.msdn.com/ecm/archive/2006/06/09/624520.aspx
blogs.msdn.com/sharepoint/archive/2008/01/03/new-beta-extranet-collaboration-toolkit.aspx
blogs.msdn.com/.../30/announcing-the-first-release-of-the-microsoft-sharepoint-administration-toolkit.aspx

Sites
==============
office.microsoft.com/en-us/sharepointserver/HA101747881033.aspx
office.microsoft.com/en-us/sharepointserver/HA102063591033.aspx
msdn.microsoft.com/en-us/library/aa830818.aspx

YouTube
==============
www.youtube.com/watch?v=8zT4NsSSa6g

Other resources
===============
www.andrewconnell.com/blog/articles/MossWcmResources.aspx
www.microsoft.com/downloads/details.aspx?FamilyID=6D94E307-67D9-41AC-B2D6-0074D6286FA9
www.1stafftraining.com/b2b/outlines/1Staff_50003.pdf