May 31, 2010

SharePoint 2010 - Browsing to site gives a blank page (on server).


Issue:
          Browsing to the site results in blank page

Solution:
         
1) Go to Central Admin > Application Management

2) Click on "Configure Alternate Access Mapping" as shown below


3) As shown below, make sure the internal url is same as the external url (in this case http://localhost/)

Conceptually,
* Internal URL represents the incoming request to the website.
* PublicURL for Zone represents the outgoing response URL..

In otherwords, Incoming request can be different (like http://... or https://...) but when the response is sent it will be represented by a single URL (like https://...).

May 13, 2010

Creating Graphs or Charts in SharePoint and WSS Lists ( sparklines )

Sparkline are small graphs which generally indicates the trends or variations associated with entities like stocks, temperature, currency and so on. Nothing can express better then a picture itself (Note: Typo for the Temperature in the screen shots)

Implementation Steps

1) Create the SharePoint List or Document Library with the require data as shown below



2) Add some calculated fields like average, max, min in the List as shown below


In similar fashion calculate the Minimum and Average using the formula field.

=Min(January,February,March,April,May,June,July,August,September,October,November,December)

=Max(January,February,March,April,May,June,July,August,September,October,November,December)


3) Create a calculated column called "variation", which will have the chart populary called Sparkline

Add the following formula, as shown in the screenshot below:




i.e. ="<DIV><IMG src='http://chart.apis.google.com/chart?cht=bvs&chs=200x125&chd=t:"&[January]&","&[February]&","&[March]&","&[April]&"............................&chco=4d89f9,c6d9fd&chbh=20&chds=0,100' /></DIV>"

4) Create a View having the following columns
           City, Variation, Min, Max and Average
    Navigate to the View and it will appear as shown below:

 

5) Edit the Page and add Content Editor Webpart at bottom of the page in hidden mode with the following source

6) Now the Sparkline Graph should appear as shown below




OR

References

http://code.google.com/apis/chart/docs/making_charts.html

http://viralpatel.net/blogs/2009/04/generate-pie-bar-line-charts-using-google-chart-api.html

May 6, 2010

SharePoint Portal does not render properly in Internet Explorer or Internet Explorer Crashes for SharePoint Portal

Portal does not render the content pages properly, although the master page is coming quite well.

We tried bunch of things, like setting the IE to default settings, looking into the logs, Javascript Error and so on.

What worked is starting the Internet Explorer in safe mode ....

Click Start > Run > iexplore -extoff


Update:

Internet Explorer Crashes, when clicking on items in the document library.

This generally occurs, when we update office from 2003 to office 2007, or lets say downgrade office 2007 to office 2003 or some other office 2007/2003 related installs.

Either use
Click Start > Run > iexplore -extoff

or apply the following patch if possible

Microsoft Hotfix link




If this wouldn't have solved the issue, I would have rather started the client machine Operating System in Safe Mode, so that only basic components are loaded and anything customized or configured because of the other applications are not loaded.

May 3, 2010

Measuring Application Performance on Windows Server and the Key Perfomance Counters or Indicators

The performance counter data helps determining system bottlenecks and fine tune the application performance. We can utilize the "perfmon utility" on the server. Start > Run > Perfmon and this brings up the perfmon console. Other testing tools which can gather performance counters are Load Runner, VSTS, ...

Steps to measure perfomance counters using out of  box "Perfmon":

1) Download the following "Performance Monitor Wizard" on your server

2) Execute the wizard by double clicking it, give it a name, select terminal server, select all counters, specify path where to save log file and finish the wizard without starting it. So, now we have configured a perfmon template.

3) Open Perfmon, when you want to collect performance counters

4) Start and Stop the configured perfmon (lets say in our case configured template name is "t") as shown below.







Analyze the collected data i.e. performance counters

In the perfmon, do the following as shown in the below image






Click on the data tab and select the counters as shown below:



Now the graph below shows the performance counter selected:


Few Important Key Performance Indicators or Performance Counters to Monitor

Object                                                   Performance                                   Counter Indicates

Processor                                             % Processor Time/_Total                   Processor use level


Memory                                               Available Bytes                                  Amount of memory available


Network                                              Interface Bytes Total/sec                    Amount of network traffic traveling to & from test client
                                                                                                                      (Network contention).


Memory                                              Memory\Pages/sec                             The number of paging operations to disk during the 
                                                                                                                      measuring interval, and this is the primary counter to watch
                                                                                                                      for indication of possible insufficient RAM to meet your
                                                                                                                      server's needs.



The counters mentioned above can help to find out the possibly the bottlenecks and can help in deciding whether to scale up or scale wide. Generally, thumb rule is processor on an average during peak hours should not exceed 60% and page fault should not be more then 50 per seconds.

Pages