SharePoint Stuff



Author Archive

Luke Smith

I’ve been working with Microsoft Technologies for over 20 years, my main focus now being Microsoft Online Services. I manage the Cloud Services at ElysianIT Limited and as a P-SELLER at Microsoft. I have worked with many organisations from SMC to Enterprise. I’ve been working with Microsoft Technologies since DOS 5.0, to date I have been working on Microsoft’s latest cloud technology Windows Azure, Windows 10 Office 365 and Microsoft SharePoint

Sharepoint Out of memory OOM exception

Written by Luke Smith. Posted in Microsoft

Issue
====
You may receive but no all of the following:

following errors are displayed on a sharepoint page

Failed to render “Title” column because of an error in the “Single line of text” field type control. See details in log. Exception message: Server out of memory there is no memory on the server to run your program. please contact your administrator with this problem ..

Failed to render “Page Content” column because of an error in the “Publishing HTML” field type control. See details in log. Execption message: Server out of memory on the server to run your program. Please contact your administrator with this problem

The event Logs show:

Out of memory (OOM) Exception

The following is always logged in the SPS Logs

While initializing navigation, found Page placeholder but object was not found at: /<SITE>/<PAGE>/<PAGE>.ASPX.

Behaviour
=======

W3WP.exe worker process used by your Sharepoint site increases to 1.2GB of memory rapidy and then errors. Once the process memory has been consumed, the memory is clearned and decreases back to normal utilisation (200 -650Mb)

The site which is trying to load, utilises a Site Navigation bar and contains over 50 pages

The site navigation bar is utilising the SiteMapProvider “SPNavSiteMapProvider”

Resolution
========

Edit your sites master.page using sharepoint designer 2007

Find the following

SiteMapProvider=”SPNavSiteMapProvider”

Change the SiteMapProvider

SiteMapProvider=”GlobalNavSiteMapProvider”

I would also recommend reducing the amount of pages contained in the site (try to keep this as small as possible.

Also consider moving to a 64bit platform and increase the amount of memory on the server (over 4GB recommeneded)

If you are receiving OOM exeption within custom code please see http://code.msdn.microsoft.com/SPDisposeCheck
and
http://msdn.microsoft.com/en-us/library/aa973248.aspx

This applies to MOSS 2007 (RTM and all updates) running on a 32bit windows 2003 environment

Thanks to Nick Lloyd-Jenkins for identifying this one

BTS 2004 Control Message Check Missing Restart Msg in Spool table

Written by Luke Smith. Posted in Microsoft

After running Biztalk MessageBoxViewer (MBV) http://blogs.technet.com/jpierauc/default.aspx

You recieve the following error

Control Message Check Missing Restart Msg in Spool table (can prevent some svc instances to be resumed, terminated or suspended)

Navigate to <drive>:<BizTalk 200x Folder>Schema,
Open “MsgBoxSchema.sql”
Find INSERT INTO Spool (uidMessageID… copy the statment into query analyser and run.
Below are the ones you should execute

NOTE: Remember to backup your databases before running


-- ******************************************************
-- For 2004 you will need the following 1 control message

— ******************************************************
— Inserting Restart Message for use in service recovery
IF (SELECT COUNT (*) FROM Spool WHERE uidMessageID = N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’) = 0
BEGIN
INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 0, 0, 0xD4E0906C1849D311A24200C04F60A53302000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F007000650072007400690065007300000001000000010820010000000000000000000700000098000000540069006D0065007200490044005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F0078006C0061006E00670073002D00720075006E00740069006D0065002D00700072006F0070006500720074006900650073000000010000000008004A000000300030003000300030003000300030002D0030003000300030002D0030003000300030002D0030003000300030002D003000300030003000300030003000300030003000300030000000)
INSERT INTO MessageRefCountLogTotals (uidMessageID, snRefCount) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 1)
END
GO

— *******************************************************
— For 2006 you will need the following 4 control messages
— *******************************************************

— Inserting Restart Message for use in service recovery

INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’61EAA7FC-AC85-42d9-BF3E-1BED258B82BE’, 0, 0, 0xD4E0906C1849D311A24200C04F60A53302000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F007000650072007400690065007300000001000000010820010000000000000000000700000098000000540069006D0065007200490044005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F0078006C0061006E00670073002D00720075006E00740069006D0065002D00700072006F0070006500720074006900650073000000010000000008004A000000300030003000300030003000300030002D0030003000300030002D0030003000300030002D0030003000300030002D003000300030003000300030003000300030003000300030000000)

— Inserting Suspend Control message

INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’2BE3D5B8-5685-40F2-BD97-51ADA3D02347′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C000000020000000008002A000000410064006D0069006E00530075007300700065006E00640049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00340037004100450033003300380034002D0031003000410041002D0034003400430033002D0038003200350036002D003200350033003400380045004200390032004200320031007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)

— Inserting Terminate Control message

INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’57E5E753-0207-435D-8BE7-2B9F3C6556F9′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C000000020000000008002E000000410064006D0069006E005400650072006D0069006E0061007400650049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00350032003500390031004600310031002D0046003700370034002D0034003600330038002D0042004300390041002D003200380034003800380034003600300034003500450032007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)

–Inserting Resume in Debug Mode message

INSERT INTO Spool (uidMessageID, nNumParts, nCounter, imgContext) VALUES (N’50D173AF-5D6F-4D5F-AE23-1A7178CEBDC3′, 0, 0, 0xD4E0906C1849D311A24200C04F60A53303000000000000001E000000420069007A00540061006C006B0043006F006E00740072006F006C0000000200000000080026000000410064006D0069006E004400650062007500670049006E007300740061006E00630065000000000000000C0000004A006F006200490044000000020000000008004E0000007B00330032003800330030004500450045002D0035004400330041002D0034003700370037002D0041003200440035002D003100320033004100450035004600340044004500420039007D000000090000009800000050006100720074004E0061006D00650073005E0068007400740070003A002F002F0073006300680065006D00610073002E006D006900630072006F0073006F00660074002E0063006F006D002F00420069007A00540061006C006B002F0032003000300033002F006D006500730073006100670065006100670065006E0074002D00700072006F00700065007200740069006500730000000100000001082001000000000000000000)

For more information please see http://blogs.technet.com/jpierauc/archive/2008/07/22/msgboxviewer-mbv-q-a.aspx