Cato Antonsen’s Weblog

November 5, 2008

Consolidating Application Pools

Filed under: IIS, Sharepoint 2007 — Cato @ 1:26 pm

I had a need to consolidate application pools for several MOSS 2007 sites I had created on my development machine. I had been so stupid that I just created a new application pool each time I created a site. Since Sharepoint Search crawls every site, a new work process (w3wp.exe) was created for each site – even though I didn’t use them. No need to say that this eats valuable memory in my VPC…

This was what I did:

  • Make sure all sites use the same application pool acount in Central Administation > Operations > Service Accounts. I use Network Service for simplicity
  • Make sure authentication providers use NTLM in Central Administration > Application Management > Authentication Providers
  • Do a IISRESET and test that all sites works OK. If something doesn’t work now, it’s easy to go back if you remembered to make a note of previous settings for the first two steps
  • Go to IIS Manager
  • Create a new Application Pool:
    • Call it something reasonable, like “Sharepoint Shared App Pool”
    • Set Identity to the same identity as you used in the first step
  • Configure Application Pool for each web site under Web Sites that you want to colsolidate
    • Right click root of web site and select Properties
    • Under Home Directory, change Application pool to the newly created application pool
    • Expand the _layouts-folder under root and change the application pool for both images and inc
  • Do a IISRESET and test that all sites works OK
  • Delete the application pools you no longer use (when testet that everything works ok!)

November 3, 2008

View more rows in Edit in Data Sheet

Filed under: Sharepoint 2007 — Cato @ 2:58 pm

I received an requirement from my boss to display more than the default 6 rows in the Edit in Datasheet view of data lists. I hate this beast (ie. datasheet) because it is really unpredictable (see my previous posting).

After messing around I found the simplest solution was to alter the OOB core.js:

Changed:
cGCMinimumHeight=200;

to:
cGCMinimumHeight=600;

This offcourse makes the change global for all Datasheets and very exposed to future updates from Microsoft. So add it to your list of things to check after next upgrade… ;-)

October 6, 2008

Sharepoint Edit in Datasheet locks or freezes Internet Explorer

Filed under: Sharepoint 2007 — Cato @ 1:01 pm

Recently I had an issue with a new masterpage for one of the companies in our group of companies. The design is pretty much the same for all companies, just different logo, header illustration and footer image. For some reason IE would hang if the user selected “Edit in Datasheet” in a Document Library.

Googling the problem gave me a couple of hints:

… but none of them helped in my situation.

I tried to implement the new design step-by-step and noticed that the freeze-problem only occured when I changed the footer image. After a lot of trial and error I found what seemed to be the culprit of my problem. The footer image that worked was 322×19 pixels. The image that didn’t work 316×21 pixels. By resizing the footer image I found that as long as the height was 19 pixels I could change the width without any problem. Don’t ask why I tried this in the first place…

This correlates to Tom’s discovery which suggests that the GC-functions that resizes the grid is dependant on the scroll height. When the footer image got taller than 19 pixels – scroll height changes too.

Conclusion: Edit in Datasheet is VERY dependant on the layout. Hope Microsoft can fix this soon!

September 17, 2008

Enable debug information in Sharepoint

Filed under: IIS, Sharepoint 2007 — Cato @ 12:45 pm

Just a reminder for myself:

 

<?xml version=”1.0″ encoding=”UTF-8″ standalone=”yes”?>
<configuration>
  <configSections>
    <sectionGroup name=”SharePoint”>
      <section name=”SafeMode” type=”Microsoft.SharePoint.ApplicationRuntime.SafeModeConfigurationHandler, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” />
    </sectionGroup>
  </configSections>

  <SharePoint>
    <SafeMode MaxControls=”200″ CallStack=”true” DirectFileDependencies=”10″ TotalFileDependencies=”50″ AllowPageLevelTrace=”false” />
  </SharePoint>

  <system.web>

    <customErrors mode=”Off” />

    <compilation batch=”false” debug=”true” />

  </system.net>
</configuration>

Blog at WordPress.com.