Some Interesting SharePoint 2007 Questions

Some interesting questions from a reader.
Hi Matloob,
1. You are saving a "web" or site as template.  this feature only applied to creating sub sites only.  To make your template appear in site collection Create page you have to develop your site definition and deploy it to the SharePoint server machine.
2. Themes are site specific by nature they can not be applied to all sites.  to apply same theme to all sites and subsites you have to develop a master page.
3. No.  To get the results of search on SharePoint Server or wss you have to make sure that
a. WSS Search Service is running
b. SharePoint Server Search is Running
c. You have an SSP
d. Go to Search Settings page in SSP admin site then go to content sources and run full crawl on all sites.
e. Make sure you have items in the index on search settings page.
f. The Reduced, partly redueced and maximum are index performance categories.  This impact your machine performance if you have set it maximum so indexer will try to use full resources of the machine to index data.
g. To make sure that new sites are index quickly set the incremental crawl schedule to run in every 10 minutes to 30 minutes.  This way the new data will be index quickly.
Tough questions but good questions.

On Mon, Dec 21, 2009 at 1:37 AM, Matloob Ali Raza wrote:

Salam, how are you
While working on MOSS 2007, i got some quesitons which are as follows; please dont mind of these as i am just a bignner in it.
Question 1
when i save a wss site as a template; it does add to a custom tab which is ok. My question is that when i prefer to create a new site in another web application i
cant see that template. why is that??
Do i have to download the .stp file and upload it to the site template gallery of the desired web application ??
Question 2
I have a collaboration portal created, which has multiple sites lile document center, search, news and reports. My question is that while changing the theme on parent
site why it dont get applied on  all chield sites???
Can we do so ??
Question 3
While i created a collaboration portal by default a subsite is created for searching the contents; if i try to search some conetents it always result with empty
list, but the contents do exist in the site.
I have look in to sharepoint services section and sharepoint server serarch service is running and its configured as "Reduced" instead of Partly reduced or Maximum.
Do i have to change that so that when ever a new activity or site is created it get sync at that time instead of after a while??

Matloob Ali

Mergecontentdbs Command – Some Good How 2s.

If you want to move some site collections from one web application to another which mostly happen when you have huge number of mysites and finally you have decoded to move to new content db.  You have to use 3 command together with configuring mysite.

STSADM –o enumsites

STSADM –o enumcontentdbs

STSADM –o mergecontentdbs

Look at the articles given below to learn quickly.  Listed below are by quality.

Move Site Collections in a Single Bound

Ensuring that My Sites are used in a compliant manner.

MOSS 2007 – How to move MySites from one Web Application and Content Database to another.

Microsoft.SharePoint.Publishing.PagesListCPVEventReceiver after SharePoint Sp2

Error loading and running event receiver Microsoft.SharePoint.Publishing.PagesListCPVEventReceiver in Microsoft.SharePoint.Publishing, Version=, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Additional information is below.

: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

To work around this issue, please follow these steps:

1. Open the SharePoint Central Administration Web page.

2. Click “Operations”, and then click “Diagnostic logging”.

3. In the Select a category box, click “General” under “Event Throttling”.

4. In the “Least critical event to report to the event log” box, click “None”.

5. In the Least critical event to report to the trace log” box, click “Verbose”.

6. Click “OK”.

For more information, please refer to: 


It is also on (Cover up for copy paste 🙂 .

Publishing Portals – A real Life Scenario

One of the real life scenario in SharePoint 2007 deployments for internet sites is the power users creating pages on different areas of the site but more probably they do not have rights on the home page as it is strictly controlled by the SharePoint Administrators.  The page layouts are created by the SharePoint Administrators and sometime the Administrators change the permissions of Master Page and Page layout Gallery.  This will most probably resulted in Contributors or event designer get “Access Denied Error” When they try to create a page on any sub site on publishing portal.  So If you receive this error sometime WRT to power users simply create a SharePoint Group with Read Permission on the home site and then add this group to the permissions of Master Page Gallery with read permissions.  They will be able to create pages easily.

SharePoint Magazine – Business Data Catalog Series

A Great Series on Business Data Catalog

Series Outline

With that, that nearly brings us to a close for this first article. But before we let you go, here is an outline on how we are structuring this series.  To get the full value, you should go through these in order, but we’ll try to keep them discrete so that you can jump around and focus on the ones that are most important to you. Note: these may slightly change as we go through each of these.

Part 1
In this first part, as you have now read, the focus is be on the concepts, the value it can bring organizations, the architecture, and an overview of each article in the series.

Part 2
This article will introduce the Application Definition File. By the end, you’ll understand the role it plays, how it works, and have a high-level grasp of its schema.  We’ll also introduce tools that allow you to generate these XML files.  Securing ADFs will also be covered in this article.

Part 3
This article will cover how the Web Services can be used instead of a direct connection to a database.  It will look at the kind of Web methods you’ll need to write if you want to expose your systems to BDC this way.

Part 4
This will be a two-part article.  In first half, we’ll look at the out of the box Web Parts that BDC provides.  These is the most common way that this structured data is presented to users, so we’ll give it a solid overview.  The second half will cover how you can cache BDC data into SharePoint lists.  This will allow you to marry SharePoint data and BDC together into one consolidated view.

Part 5
This article will cover everything you need to know to to configure Enterprise Search to crawl BDC data.  We’ll cover content sources, scopes, and how to configure MOSS for both full and incremental crawls of your structured data.

Part 6
As mentioned above, BDC can supplement properties contained within User Profiles. This allows you to pull critical data elements from external ERP or HR systems and map them to out-of-the-box or custom User Profile properties.  This article will cover everything you need to know to get this working for you.

Part 7
This article will apply mostly to the developers out there and will cover the BDC Object Model.  You’ll see how custom Web Parts, application pages or other custom-built SharePoint applications can consume BDC database without your having to write another data layer.

Part 8
In the final article, we will cover Custom Actions how these can be used to safely write changes to the back-end database or Web Service.  While not used often, this may prove to be a practical way for users to maintain some of the data in these external systems.

MOSS BDC;BDC;BDC Development;