08 December, 2011

An error has occurred. Please contact your system administrator if this problem persists.

While working with a user yesterday, i have noticed that users could not view Excel files in browser and getting the below mentioned error message:

Error Message:
An error has occurred.
Please contact your system administrator if this problem persists. 

ULS Logs shows the following entry:
There was an error in communicating with Excel Calculation Services http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 401: Unauthorized.

Checked the event viewer and found the following:

Event Viewer entries:
Event Type:        Error
Event Source:    Office SharePoint Server
Event Category: Excel Services Web Front End
Event ID:  5234
Date: 12/7/2012
Time: 2:50:06 PM
User: N/A
Computer: XXX
Description:
No Excel Calculation Services is available in the farm.[User:
SHAREPOINT\system]

Event Type:        Error
Event Source:    Office SharePoint Server
Event Category:  Excel Services Web Front End
Event ID: 5239
Date: 12/7/2012
Time: 2:50:06 PM
User:                     N/A
Computer: XXX
Description:
There was an error in communicating with Excel Calculation Services
http://sharepoint:28963/SPAdmin/ExcelCalculationServer/ExcelService.asmx
exception: Unable to connect to the remote server
[Session: (null)
User: SHAREPOINT\system].

Troubleshooting Done:

1-checked this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/8bba2694-7276-4505-85a5-02f91b92bb1d  which states that find the ssp which is giving the problem and recycle the app pool to which the ssp is referrencing.

2-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/321cb536-39d6-4ee9-b9ef-65db9e133d97but cannot apply this resolution as in my case the excel services are running fine for other portals and not working for only one web application.

3-http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/5968cb82-2e65-44c0-bfa8-ce05d70154ff this article has mentioned 3 fixes which will varies from the farm to farm i.e. enviornment to enviornment.

4-Checked alternate access mappings as per this article:http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/c0c59a6a-1cf6-4280-a2ca-9667b2cadd33/ but AAM seetings are fine in our enviornment.

5-Ran this below mentioned commands but no results:
stsadm -o setsharedwebserviceauthn -negotiate
stsadm -o execadmsvcjobs

6-checked SSP pool account is running or not as per this article: http://social.msdn.microsoft.com/Forums/en-US/sharepointexcel/thread/85310dd3-a7e7-4673-b258-b0fec7823b8d  but it is fine and no problems

7-excel services are running or not is already checked: http://njbblog.blogspot.com/2008/04/sharepoint-v3-error-excel-services.html

Resolution that fix our issue:
If you get this problem the solution in my case was to by pass the proxy for local requests, this was done by editting the web.config for the relevant web app & adding:

<system.net>

<defaultProxy>

<proxy proxyaddress="http://<ProxyServer>:<port>" bypassonlocal = "true"/>

</defaultProxy>

</system.net>
------------------------------------------
what we have added in this: bypassonlocal = "true"

Issue has been resolved and excel services started working without any issues, Thank you

If you have any queries/questions regarding the above mentioned information then please let me know.
I would be more than happy to help you as well as resolves your issues, Thanks

Move files from one document library to another document library in SharePoint Server 2010

I have created two document libraries named as Source Library and Destination Library, now we have a requirement- How to transfer the documents from one library to another.
Please follow the below mentioned steps and let me know in case of any issues:
1-Open two document libraries in separate browsers/internet explorers
2-Click on LIBRARY on the top for both the document libraries
3-Select "Open with Explorer" for both the document libraries


4-this will open up a new window in which you can see you documents
5-now simply copy it and paste it in the destination document library
Note: It will take some time to transfer depending upon the size of the documents
If you have any queries/questions regarding the above mentioned information then please let me know.
I would be more than happy to help you as well as resolves your issues, Thank you
References:
1.   How to: Access, Copy, and Move Files:

2.   Document library planning (SharePoint Server 2010)

3.   Move the contents of a document library using explorer view.
http://msmvps.com/blogs/shane/archive/2006/01/12/move-the-contents-of-a-document-library-using-explorer-view.aspx

01 December, 2011

Best practices, Capacity planning, Implementations, Hardware requirement’s for SharePoint Server 2010

Planning and architecture for SharePoint Server 2010
IT pros can use the content in the planning and architecture guides to develop
conceptual, logical, and physical designs for configuring Microsoft SharePoint
Server 2010 features, servers, and topologies. It also provides
recommendations for system designs based on customer scenarios and includes
information to help IT pros design a highly reliable, consistently available, and
scalable system.
http://technet.microsoft.com/en-us/library/cc261834.aspx
Downloadable book: Planning and architecture for Office SharePoint Server 2007
This book provides information and guidelines to lead a team through the steps of planning the deployment of a solution based on Microsoft Office SharePoint Server 2007. The audiences for this book are business application specialists,
line-of-business specialists, information architects, IT generalists, program
managers, and infrastructure specialists who are planning a solution based on
Office SharePoint Server 2007. It also includes links to planning worksheets for recording information related to your planning and deployment activities.
http://technet.microsoft.com/en-us/library/cc262757(office.12).aspx
Hardware and software (SharePoint Server 2010)
Hardware Requirements
The requirements in the following table apply to the facilities of a single server
with integrated database and the facilities of a server farm that includes a single
server or multiple servers.
http://technet.microsoft.com/es-ar/library/cc262485.aspx
Software Requirements
The requirements of the following tables apply to installations of a single server
with integrated database and facilities of a server farm that includes a single
server or multiple servers.
Preparation Tool Products Microsoft SharePoint (which can be accessed from the
homepage of SharePoint Server 2010) can facilitate the installation of the software
prerequisites for SharePoint Server 2010. Make sure you have an Internet
connection, as some of these prerequisites are installed from the Internet. For
more information, see Deploying a single server with SQL Server (SharePoint Server 2010) http://technet.microsoft.com/es-ar/library/cc262243.aspx 
Deploying a single server with an integrated database (SharePoint Server 2010) http://technet.microsoft.com/es-ar/library/cc263202.aspx  and
Multiple servers to a group or server farm of three levels (SharePoint Server 2010)
http://technet.microsoft.com/es-ar/library/ee805948.aspx
If you have any queries/need any further information information then please let me know.
I would be more than happy to help you as well as resolves your issuesJ

29 November, 2011

"Email Users" action not working


Yesterday I worked on one ticket in which the user had mentioned the problem description “email users” action is not working. This issue has been resolved with the following analysis:

The groups consist of approximately 100 users. If you select all the users and performed an action “actionàEmail users” then it has to open a mail window by including the email ID’s of all the selected users but no redirection and nothing happens.

If I select some users in the range 10-20 then it will perform the exact action as expected. This condition leads me to think that there should be some limitation on which it has to work/stopped working after the range exceeds.

Did research and found out that it is known issue as per this: http://support.microsoft.com/kb/208427

Here is the detail why it happens.
-There is a limit of 2048 characters for URI in IE. in case the length increases , the page wont popup us with error, it shall simply tries redirecting to same page
-In case, the length is within limit, it shall redirect to the page and  call JavaScript, which in turn shall invoke client email application.

Now the question is-How to resolve this issue?
1)      Open the siteàsite actionsàsite settings
2)      Users and groups
3)      Open that specific group in which we need to extract the users list
4)      Change the view from ‘detail view’ to ‘List view’
5)      Copy the list by normal windows ‘copy’ command and paste it in excel
6)      Now it’s easy to get the list and request has been completed

If you have any queries regarding the above mentioned information then please let me know.
I would be more than happy to help you as well as resolves your issues, Thank you

27 November, 2011

Cannot retrieve the URL specified in the XML Link property. For more assistance, contact your site administrator

You can use the XML Web Part to display Extensible Markup Language (XML) and apply Extensible Stylesheet Language Transformations (XSLT) to the XML before the content is displayed.  The content displayed in the XML Web Part cannot contain an HTML <FORM> element. If you need to use the <FORM> element, consider using the Page Viewer Web Part or the Form Web Part.  This is little bit tricky issue and took lot of time to investigate and research to find out the root cause behind this issue.

Problem Description:
Microsoft out-of-box XML web part returns an error when connecting to any SharePoint Web Service - owssrv.dll, lists.asmx, feed.rss. Works fine with static XML data file.

Error message:
Cannot retrieve the URL specified in the XML Link property. For more assistance, contact your site administrator

What exactly I am doing:
Use of the 'XML Web Part' to display the RSS feed from a List.

When I entered the URL to the feed into the 'XML Link' field I receive the message "Cannot retrieve the URL specified in the XML Link property. For more assistance, contact your site administrator."

Troubleshooting Done:
1)   If I click the 'Test Link' a new window opens and correctly shows the feed. 

2)   When I checked the SharePoint logs and found out that no credentials are being supplied with the GET request to listfeed.aspx

3)   Web parts settings are ok as i checked the XSL as well as XML properties.

4)   As the credentials are not being supplied then i had checked the web application pool account is a part of ISS_WPG and WSS_WPG (Worker process groups) and found out that the app pool account is already added inside the mentioned groups

5)   Along with above mentioned groups, there is one more group exist in Active directory called as "WSS_ADMIN_WPG". Now the questions arises-Does the application pool account is a part of this group or not? I checked and found out it's not a part of that group (i.e. WSS_ADMIN_WPG), added the same web application pool account inside the group and check the results but still no success.

6)   Now the final step which is a vital one is "Anonymous", Allowing anonymous access to that web application (Central Administration > Application Management > Application Security > Authentication Providers section). now let’s go to the site collection and allowed anonymous access to a specific list where the problem resides ( Open the site collection-site actions-site settings-advanced permissions-settings-anonymous access-select list and libraries only)

That’s it-as soon as I applied the above mentioned steps and comes back to the home where the xml web part resides-it works without any issues.

Conclusion/Resolution steps:
1)   Web application pool account should be a part of WSS_WPG, ISS_WPG and WSS_WPG

2)   Anonymous access for the web application and list & libraries section at the site collection

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.