Unable to delete Shared Services

DESCRIPTION: Unable to Delete Shared Services when it's database is deleted from SQL server.

SYMPTOMS: Unable to delete Shared Services. There are still some objects which are dependent on configuration database and on project serve, due to which users are unable to delete SSP. Manually deleting of SSP using stsadm -o deletessp -title "ssp_name" command also shows same error.

ERROR MESSAGE: “An object in the SharePoint administrative framework, "SharedResourceProvider Name=SSP Parent=SPFarm Name=MOSS", could not be deleted because other objects depend on it. Update all of these dependants to point to null or different objects and retry this operation. The dependant objects are as follows: ProjectPSISharedApplicationTimerJob Name=Project Server Synchronizing Job for 'SSP' Parent=ProjectApplicationService Name=ProjectApplicationService”

RESOLUTION: ° Identify the GUID for the problem SSP. ° Use STSADM -o deleteconfigurationobject -id "id retrieved from object table" to remove these items from the configuration database.

Use the following procedure to identify the Shared Services GUID:

Login to SQL server. ° Open SQL Management Studio and expend Databases. ° Expand Configuration Database & Tables. ° Opened table for dbo.object. ° Executed following query in query analyzer: SELECT * FROM [MOSS_CFG_CA_01].[dbo].[Objects]where name like 'Name of the Shared Services'. ° Copy the ID of object referenced in objects table of configuration database. ° Open command prompt and changed directory to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN> and executed following command to delete the Shared Services using the ID which was copied: Stsadm -o deleteconfigurationobject -id "id retrieved from object table"

Shared Services should be deleted from the Cenral Administration.

Step by Step Guide on Publishing InfoPath Forms to SharePoint Site.

1. Creating and Configuring Forms Library in SharePoint.
2. Configuring InfoPath Form 2007. 3. Configure Form Submit Options.
4. Publishing InfoPath Form to SharePoint 2007.
5. Adding the Published form as Content type to the Forms Library.

Note: There are 2 types of InfoPath Forms.
a) User Form:- Only fields to be entered, where there is no Active code or programming added to the Form. These forms can be directly published to SharePoint Site. To Publish this Form, the user should be an Owner or Administrator of the Site Collection.
b) Admin Form:- These Forms have .net coding or Programming with the code which should run in the background once the Form is submitted. These Forms should be uploaded on the Central Administration and Activated for the Web Application to be used with. To publish this Form, the user should be a Farm Administrator.

Creating and Configuring Forms Library in SharePoint.

1. Browse to the SharePoint site you need to create the Forms Library.
2. Click in Site Actions -> Create -> Select “Form Library” under Libraries Section.
3. Enter the Name and the Description for the Form, Click on “Create”
4. Once the Form Library is created -> Select Settings -> Form Library Settings

5. Select “Advanced Settings” .
6. Select “Yes” for Allow Management of Content Types.
7. For “Browse-enabled Documents” -> Select “Display as Web Page”. This option is beneficial when users do not have InfoPath 2007 installed on their local machine. The Form will open in the browse if this option is selected.
8. Click Ok.

Configuring InfoPath Form 2007

1. Once the Form is Designed and Created, we have to perform some pre-requisite tasks to be able to successfully publish to the SharePoint Site.
2. From the Tasks pane -> Select “Design Checker”

3. Select “Change Compatibility Settings”. Enter the data as in below screenshot.
Note:- The URL to be entered should be of the “Site Collection”. Not of a Subsite or Form Library URL. The user publishing this Form should be the Owner/Administrator of the Site Collection URL specified.

Note:- If you select “Backward Compatibility” option for Office 2003, some of the controls that are not support in InfoPath 2003 will not function as expected. Select it at your own risk. If you have configured the Form Library to open the Form as a Web Page, this option will not be required to be selected.
4. Click Ok.

Configuring Form Submit Options

1. Select “Tools” Menu -> “Submit Options”. You will get the below dialog box.

2. After entering the details as required, click “Add” button for “Choose a data connection for Submit”
3. You will get “Data Connection Wizard” -> Copy the Form Library URL Link (created during 1st step) and paste it.
4. When you click on “fx” button you will get the “Insert Formula” dialog box. Click on “Insert Field or Group” button you will get “Select a Field or Group” dialog box.
5. Select the Field, whose data should be taken as the file name, once the Form is submitted.
6. Select “Allow overwrite if file exists” as per your requirement and the data you will be entering in the Form. If you select this option you can also Enable Versioning on the library.
7. Click “Next”. Enter a Friendly name for the Data Connection. Click “Finish”. It will again come back to the Submit Options dialog box, Click OK.

Publishing InfoPath Form to SharePoint 2007.

1. Click File Menu -> Publish. Publishing Wizard will open up.
2. Select the option to publish to SharePoint server and click on “Next”
3. Now again enter the URL of the “Site Collection” and click on “Next”
4. Make sure that the Check box is selected as the screen shot. It is recommended to select “ Site Content Type (advanced)” to avoid manual creation of the content type. Click on “Next”.
Note:- The 3rd option “Administrator-approved Form Template (advanced)” is to be selected when the Form has Active code or any .net Programming added to the form.
5. Select “Create a new Content Type”, so that we don’t overwrite the default content type of SharePoint. Click on “Next”
6. Enter a Friendly Name and Description for the Content Type. Click on “Next”
7. You will need the URL of a Document Library. You can copy the shortcut as shown in the screen shot. Then paste it in the Publishing Wizard and click on “Next”

8. Add Columns to your Form Library. Click on “Next”
9. At the end it will give the summary of the options selected and Click on “Publish” button. Once you get the Message “Your Form template was Published Successfully” Click on the “Close” button.

Adding the Published form as Content type to the Forms Library.

1. Browse to the Forms Library -> Select Settings -> Form Library Settings. You will Content Types as below. “Form” is the default content type. We have to add the new InfoPath Content type that got created while publishing the InfoPath form.
2. Click on “Add from existing site content Types”. From the drop down list select “Microsoft Office InfoPath”. Add the “Content Type”. Click on OK.
3. You will now see 2 Content types, the default (Form) and the one you just added. You can delete the default content type if required.

Now you can go ahead and create a New Form, the published Form should open up in Web browser.

Not able to Export Survey list with more than 100 responses to Excel Spreadsheet

Issue:- While Exporting a Survey List, only 100 responses are exported.

No Error is logged or generated.

Resolution:- Open the Sharepoint Survey List in Sharepoint Designer. For both Overview.aspx and Allitems.aspx do the following.

Change the RowLimit element Paged property set to FALSE.

RowLimit Paged="FALSE">100</RowLimit

Change the value to True (using SP Designer 2007), otherwise it will limit the items display and export to excel.

RowLimit Paged="TRUE">100</RowLimit