Zephyr's SharePoint Blog

My Sharepoint world experience notes on day to day basis…..

Archive for May, 2009

Change number of site collections view in Site Collection List

Posted by fillzephyr on May 14, 2009

Go to

Central Administration>Application management> Site Collection List

Default you can see 10 site collections in a list at a time.

I want to change it to 20 as I have 376 site collections and I don’t want to go long way to click for more pages.

So to change it I go to

C:\Program Files\Common Files\Microsoft Shared\web server extensions\ 12\ TEMPLATE\ ADMIN\sitecollections.aspx

Open sitecollection.aspx page

Find PageSize and do the following thing:

change the number 10 to your “specified number” in PageSize=” your number”



Posted in MOSS Funstuff | Leave a Comment »

Solutions Deployment Hungs up on Deploying/retracting in MOSS 2007

Posted by fillzephyr on May 11, 2009

Problem: During the execution of a retraction/deployment the timer job may hang showing ‘Retracting’ or ‘deploying’ and never completes

Cause: This is cause from one of the WFE not being able to finalize the retraction or deployment.

Solution: For each WFE in the farm execute a stsadm.exe -o execadmsvcjobs. I had follow up these two good articles to come out from deploying /retracting status.



But what next when I try to deploy/retract the solution again. It hung’s up.  So I tried to figure out whats the problem causing this thing. I checked in my Timer job status (Central Administration>Operations>Timer Job Status) and it show that the Solution is tried to deploy on my one WFE and the index server.   I had not found any deployment on my other WFE So I had executed the command stsadm.exe -o execadmsvcjobs manually on the other WFE server. And it works like a charm the solution deployed/retracted successfully.

Also I had tried to check the time of my servers and my CA web application to confirm that they both are on the same time zone sometime this may also create a problem for deploying/retracting the solutions on the servers. In my case they are on the same time zone. To check the time zone for your CA site just


Central Administration>Application Management>Web Application General Settings

Select your central administration web application. In Default Time Zone just checks out the time to match with your servers. If it’s not matched then select the appropriate time zone and click OK.


Feedback appreciated.

refrences :




Posted in Errors, SharePoint Blogs, Uncategorized, Warnings in MOSS | Tagged: , , , | 4 Comments »

An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID:5566

Posted by fillzephyr on May 3, 2009

I tried to open the InfoPath form from the form library as web-browsable form and I fall on to this error:

An error occurred accessing a data source. An entry has been added to the Windows event log of the server.

Log ID: 5566

The cause of this error is the installation of .net 3.5 SP1. So to resolve this error you have to add key to the registry on all of the servers I have 2 WFE and 1 Application server. I had change the registry key on the entire server and restart the servers. The first server I restart is of course WFE on which my CA resides and the other WFE and then Application server. I think it’s always best to change first in Server on which CA resides.

I had followed these steps on all my servers and it works for me:

  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
  3. Right-click Lsa, point to New, and then click DWORD Value.
  4. Type DisableLoopbackCheck, and then press ENTER.
  5. Right-click DisableLoopbackCheck, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Exit Registry Editor.
  8. Restart the computer.

Reference: http://support.microsoft.com/kb/926642

Posted in Errors, infopath | Tagged: , | 6 Comments »

The server is currently being taken down for maintenance. Check with your system administrator to see when this server is scheduled to come back online.

Posted by fillzephyr on May 3, 2009

I had setup a new farm with 2 WFE and 1 Application server in an x64 production. I had to move a few site collections from a dev environment to prod environment. I had the farm installed with the MOSS SP1. The dev environment is with the latest February cumulative updates. So when I move the site collections it will give me error that the site is not going to be restoring as the prod environment is not up to date to the dev environment and so I run the February cumulative updates. And then restore the site and it went successfully. After few days I got a task of uploading some InfoPath forms and then I got this error.


The reason for this error is that the Server farm is in a Quiescent Condition.  So I gone to the Operations in CA and then under the the Global Configuration there is an option of Quiesce Farm.

Go to Central Administrator->Operations->Global Configuration-> Quiesce Farm

I click on it and I check the farm conditions and it shows me the status as Quiesced.

As shown below:


Set the minutes to 3  min and then click reset farm.

After the farm reset I tried to upload the form and it went well for me.

Refrence :  http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/DispForm.aspx?ID=242


Posted in Errors, infopath | Tagged: , , | 1 Comment »