HTTP Error 503. The service is unavailable.

For one reason or another, Central Administration wouldn’t come up and the only thing i could see was HTTP Error 503. The service is unavailable..

easy fix.

Check the Application Pools for SharePoint Central Administration v3 and make sure it’s running.

*Note*
If you have recently updated the password for the service account that the app pool runs under, you might see this. simply update the login and password the app pool is using.

done!

IE 8 Error in Windows 7?

After upgrading to Windows 7, I’m unable to view List’s in Datasheet View.

Error:
The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.

Solution

I was running IE 8 (64 bit), when I tried editing the list in Datasheet view with the 32 bit version, everything was back to normal.

It appears a 64 bit version of Office will be out for the 2010 release.

http://arstechnica.com/microsoft/news/2009/04/confirmed-office-2010-will-come-in-32-bit-and-64-bit.ars

BDC – Business Data Catalog – Security

This is the connection string I use for all my BDC files.  Once the file is imported into the BDC, I then assign permission accordingly.

<LobSystemInstances>
<LobSystemInstance Name=”BDC_Unique_Name_RI”>
<Properties>
<Property Name=”DatabaseAccessProvider” Type=”System.String”>SqlServer</Property>
<Property Name=”AuthenticationMode” Type=”System.String”>RevertToSelf</Property>
<Property Name=”RdbConnection Data Source” Type=”System.String”>Database_Server_Name</Property>
<Property Name=”RdbConnection Initial Catalog” Type=”System.String”>Database_Name</Property>
<Property Name=”RdbConnection Integrated Security” Type=”System.String”>SSPI</Property>
<Property Name=”RdbConnection Pooling” Type=”System.String”>false</Property>
<Property Name=”RdbConnection Trusted_Connection” Type=”System.String”>false</Property>
<Property Name=”RdbConnection User ID” Type=”System.String”>User_Name</Property>
<Property Name=”RdbConnection Password” Type=”System.String”>User_Password</Property>
</Properties>
</LobSystemInstance>
</LobSystemInstances>

In SQL Server I assing User_Name Select permissions on the items referenced in the BDC file.

NOTE

Make sure your default search account has access to the BDC file once it’s imported.  I applied Execute and Selectable in clients permissions on both the Application and Entity.

“How do I find the default accout?”

Shared Services Administration: SSP1 > Search Administration > Default content access account

Server was unable to process request. —> Access is denied.

I was seeing this error when trying to create new email address for a Document Library.

When setting up email in SharePoint, make sure your Application Pool account, Timer account, and the account you are using for mail access are all the same.

After updating this, the Server was unable to process request. —> Access is denied. error went away.


In Windows Server 20008 the Application Pools are located here:

Server Manager –> Roles –> Web Server (IIS) –> Internet Information Services
Under the Connections section click on Application Pools

App Pool Setp

On the right side of the screen you will see Actions.  From there click on Advanced Settings…

App Pool User

The value in the Identity field is the same account we use for the Timer Service and the account that has access to Active Directory.

How to check or update the Windows SharePoint Services Timer:

Open Server Manager, in Windows Server 2008 this can be found in the Start Menu (start button) or  type Server Manager in the search box in the Start Menu.  Once you have this open click on Configuration –> Services then locate Windows SharePoint Services Timer.

Windows Server 2008 Server Manager

From there right click on Windows SharePoint Services Timer and select Properties.  Now, click on the Log On tab.  The account listed should also be the same as the account you were using in the Application Pool.

server manager user

Let me know if you have any questions.

Adding a dedicated server for crawling

I used the following site to configure a dedicated front end server for crawling:

http://technet.microsoft.com/en-us/library/cc261810.aspx

In doing this, the only issue I ran into was this error:

The search service is currently offline.  Visit the Services on Server page

in SharePoint Central Administration to verify whether the service is

enabled. This might also be because an indexer move is in progress.

My issue was related to the existing server having a file index location of C:\Index.

Central Administration > Application Management > Manage this Farm’s Shared Services > New Shared Services Provider

Once I created a folder in the same location, on the new server, the error went away.

Only thing I can imagine is SharePoint wanted to move the index from the old server to the new server.  SharePoint being SharePoint, it wanted the index folder in the same exact location.

Update:

If you are moving to Windows Server 2008 make sure you read this KB article.

Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify the account you are using has “Full Read” permissions on the SharePoint Web Application being crawled.(The item was deleted because it was either not found or the crawler was denied access to it.)”

http://support.microsoft.com/kb/896861

Things to remember when migrating to a new farm

I will continue to update this list…

1. Check your new Farm for blocked file types.

Central Administration > Operations > Blocked File Types

2. InfoPath forms.  Make sure you check that your forms are working in the new Farm.  In my case, the forms had the old URL and wouldn’t work.  I had to also update / relink the forms to their corresponding library.

3. PDF icon

http://support.microsoft.com/kb/837849

4. When we created the new Farm we also used all new AD accounts.  When I tried to crawl our network I was only able to crawl public folders. Fix? Replace the old crawl account on the domain with the new account or update your new Farm with the old crawl account.

Shared Services Administration: SSP1 > Search Administration > Default content access account

5. BDC.  This has turned out to be a big one.  I wasn’t able to simply export the BDC definition files from the old Farm and import them into the new Farm.  I had to recreate all the BDC files, security, and update all the pages that were using the BDC data.  If you are not using BDC Metaman, you need to start!

6. If you are moving to Windows Server 2008 make sure you read this KB article.

Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify the account you are using has “Full Read” permissions on the SharePoint Web Application being crawled.(The item was deleted because it was either not found or the crawler was denied access to it.)”

http://support.microsoft.com/kb/896861

7. Search Scopes, none, zero, nothing was moved over when we migrated.  i’m now in the process of trying to recreate all the search scopes.

8. reapply the Adobe PDF filter to the Farm.  This post goes into great detail on how to apply the update.

http://bloggingabout.net/blogs/harold/archive/2008/10/02/index-pdf-documents-on-sharepoint-using-adobe-pdf-ifilter-9.aspx

How to Relink Multiple InfoPath Forms in SharePoint

After our farm migration, we realized that our new domain name and InfoPath didn’t get along.  Our old domain name was a simple http://intranet and all the InfoPath Forms were linked to that name.  After being asked to re-link several thousand forms (clicking one at a time) I started looking around the web for a solution.
Here is what I found:
1)    Open the library. Click Settings –> Form Library Settings –> Relink documents to this Library. Now copy the URL in your address bar.
2)    Open this page in SharePoint Designer. File –> Open –> paste the URL in the File name: field and click Open.
3)    If you don’t see the split screen layout, complete the following steps. Click on View –> Page –> Split
4)    Locate the <FORM> tag within the HTML section of the page and place the following code before the </FORM> tag.
<script type=”text/javascript” language=”javascript”>
function CheckAll(chk)
{
for (i = 0; i < chk.length; i++)
chk[i].checked = true ;
}
</script>
<input type=”button” value=”Check All” onclick=”CheckAll(document.forms.aspnetForm.chkRepair)” >
5) Save, Refresh the page, you should now see a Check All button in the bottom left corner of the page.

Here is what my HTML looks like:

<FORM id=”SubmitRepairDocsForm” method=”POST” action=””>
<INPUT id=”SubmitRepairRedirectList” type=”hidden” name=”SubmitRepairRedirectList” />
<INPUT id=”SubmitRepairRedirectFolder” type=”hidden” name=”SubmitRepairRedirectFolder” />
<INPUT id=”SubmitRepairDocs” type=”hidden” name=”SubmitRepairDocs” />
<SharePoint:FormDigest runat=server ForceRender=”true”/>
<script type=”text/javascript” language=”javascript”>
function CheckAll(chk)
{
for (i = 0; i < chk.length; i++)
chk[i].checked = true ;
}
</script>
<input type=”button” value=”Check All” onclick=”CheckAll(document.aspnetForm.chkRepair)” >

</FORM>

Edit…

If you want to speed up this process, you can also edit the RowLimit property.
Search in the code for RowLimit, by default it’s set to 100, change it to 500.

RowLimit Paged=”TRUE”&gt;500&lt;

An error occurred trying to publish this page on the set schedule. Republish the page with a new date or view the log if the problem continues.

An error occurred trying to publish this page on the set schedule. Republish the page with a new date or view the log if the problem continues.

 Following a recent server migration, we noticed that items were not being published at their designated start times.  Check Central Admin to make sure the following Timer Job Definitions are listed

Central Administration > Operations > Timer Job Definitions

Scheduled Approval 
Scheduled Page Review 
Scheduled Unpublish 
 
Variations Propagate Page Job Definition 
Variations Propagate Site Job Definition 

First, make sure you have the Office SharePoint Server Publishing Feature enabled.

Home > Site Settings > Site Features

Second, if the Feature is enabled, try to Deactivate then Activate.  This should install the Time Jobs in Central Admin.