17 November, 2011

Error opening MS project .mpp file

MPP documents are Microsoft Project files. Microsoft Project is a software program that helps program managers to define project scopes and plans, assign tasks and keep track of project progress. One user has opened a ticket with our team and mentioned then following details:
Problem description: - MS project files are stored in a document library. After check out the file and tried to edit- I am getting the error.
Error message: The document could not be opened for editing. A Microsoft SharePoint foundation Compatible application could not be found to edit the document.
Machine configuration:
1.     OS-Windows XP
2.     Internet Explorer: IE 7.0
3.     Office Installed: Office 2007
4.     Project application Installed: Project professional 2007
Important points to consider while troubleshooting:
1.  All Office files which consist of Microsoft word excel and PowerPoint files are opening fine without any issues so the problem is with the .MPP files only i.e. Project files.
2.  If we try opening the project files by means of Desktop i.e. user’s machine then file opens fine without any problems
3.  This is vital point which can be consider  as workaround:
v Go to the document library in which project files resides
v Hover your mouse to any project file and select ‘edit in Microsoft Office Project’
v It will give you a pop up by selecting the ‘SharePoint drafts’ option
v Click ok / you can do a check out also by selecting the ‘SharePoint draft’ option
v Now the document is in check out condition so go to the SharePoint drafts location on your machine (Location: \My Documents\SharePoint drafts)
v Open the document by means of draft location, do the changes and save it.
v Go back to the SharePoint site and check in the document.
v Changes will be successfully saved without any problems.
Now, let’s come back to main problem-If you don’t check the “SharePoint drafts’ check box while editing the document then you will get the generic error message as mentioned above i.e. “this component is not compatible …..”
Resolution: Please refer the article which has been posted by Mr. Pratik Vyas-http://sharepointpratik.blogspot.com/2010/07/document-could-not-be-opened-for.html  
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 youJ

How to find out the site collection ID

A SharePoint Site is a collection of pages, lists, and libraries configured for the purpose of achieving an express goal. A site may contain sub-sites, and those sites may contain further sub-sites. Typically, sites need to be created from scratch, but sites can also be created according to pre-defined templates that provide packaged functionality. Examples of Site templates in SharePoint include: Blogs, MySites, collaboration (team) sites, document workspaces, groupwork sites, and meeting workspaces.

Sites have navigation, themes/branding, custom permissions, workflows, and have the ability to be configured or customized in a number of ways. In order to achieve a greater degree of maintainability, sites typically inherit site-level settings from their parent sites.

While working on one SharePoint issue in collaboration with the SQL, I need to run a SQL query against a specific site collection by using its ID. So you must be aware how to find out the ID of a site collection. Its takes some time to find out the answer but would like to share with all of you so that you can take the benefit of the same and your time will be saved, Thank you

Here is my analysis regarding the same:
1. Open the Central Administration

2. Application Management
3. SharePoint Site Management
4. Site collection quotas and locks
5. Select the appropriate site collection and you will get the ID of that specific site collection on top of the browser.

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

How to find out the ID of a subsite

A subsite is a single SharePoint site within a site collection. A subsite can inherit permissions and navigation structure from its parent site or these can be specified and managed independently. Creation of subsites can be delegated to users of a site collection, but creation of site collections must be performed by a service administrator. A sub-site can also have sub-sites of its own. Because every site below the top-level site is actually a sub-site, each sub-site is generally called simply a site.
There might be a situation arise in which you need to find out the ID of the subsite. I had spend some time on this to debug and got the solution. Please refer the following steps and use your subsite ID to fulfill your project requirements, Thank youJ
How to find out the ID of a subsite
1. Save the current site as site template [.STP extension]
2. Save it to disk somewhere.
3. Now, navigate to that location and rename the file to .CAB extension.
4. Extract the CAB file and find the manifest.xml file.
5. Now, in the file check for the site ID/TemplateID string and get the value.
6. Navigate to end of this post for the TemplateID to Name mapping.
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
Reference:
1. Determining Between SharePoint Site Collections and Sub-Sites
2. What is a SharePoint site or subsite?-
3. Videos-How to create subsites in SharePoint 2010 and SharePoint 207-

How to find out site ID

How to find out the ID of a site collection, subsite and list
While working on one ticket, I did some research and fetched some things regarding ID’s.

Site collection, Subsite and List are important entities which are widely used on day to day basis.

There are times when you need to find out the Id/Guid of a site collection, subsite or list as per the project requirements, analysis of guids will be very useful to resolve many issues in SharePoint environments.

Here is my analysis regarding this as How to find out the ID/GUID of the above mentioned entities:

How to find out the ID of a site collection:

1.     Open the Central Administration
2.     Application Management
3.     SharePoint Site Management
4.     site collection quotas and locks
5.     Select the appropriate site collection (Please refer the following screenshot) and you will get the ID of that specific site collection.


How to find out the ID of a subsite:
1.     Save the current site as site template [.STP extension]
2.     Save it to disk somewhere.
3.     Now, navigate to that location and rename the file to .CAB extension.
4.     Extract the CAB file and find the manifest.xml file.
5.     Now, in the file check for the site ID/TemplateID string and get the value.
6.     Navigate to end of this post for the TemplateID to Name mapping.

How to find out the List ID:
1.     Navigate to the SharePoint list using the browser.
2.     Select the Settings + List Settings menu command.
3.     Copy the URL from the browser address bar into Notepad. It will look something like:

Delete everything before and including “List=”.
Change “%7B” to “{”
Change all “%2D” to “-“
Chnage “%7D” to “}”
You are now left with the Id:

{47F2F5E2-6474-4929-B986-64BBE801C97A}

List of MOSS 2007 Template ID Information

0 - GLOBAL (SetupPath=global) - "Global template"
1 - STS - "windows SharePoint Services Site", "Team Site", "Blank Site", "Document Workspace"
2 - MPS - "Basic Meeting Workspace", "Blank Meeting Workspace", "Decision Meeting Workspace", "Social Meeting Workspace", "Multipage Meeting Workspace"
3 - CENTRALADMIN - "Central Admin Site"
4 - WIKI - "Wiki Site"
7 - BDR - "Document Center"
9 - BLOG - "Blog"
20 - SPS (OBSOLETE) - "SharePoint Portal Server Site"
21 - SPSPERS - "SharePoint Portal Server Personal Space"
22 - SPSMSITE - "Personalization Site"
30 - SPSTOC (OBSOLETE) - "Contents area Template"
31 - SPSTOPIC (OBSOLETE) - "Topic area template"
32 - SPSNEWS (OBSOLETE) - "News area template"
33 - SPSNHOME (SubWebOnly) - "News Home template"
34 - SPSSITES - "Site Directory area template"
36 - SPSCOMMU (OBSOLETE) - "Community area template"
38 - SPSREPORTCENTER - "Report Center Site"
39 - CMSPUBLISHING (SetupPath=SiteTemplates\PUBLISHING) - "Publishing and Team Collaboration Site"
40 - OSRV (SetupPath=SiteTemplates\OSRV) - "Shared Services Administration Site"
47 - SPSPORTAL - "Corporate Intranet Site"
50 - SRCHCEN - "Search Center"
51 - PROFILES - "Profiles"
52 - BLANKINTERNETCONTAINER - "Internet Presence Web Site"
53 - BLANKINTERNET - "Publishing Site", "Press Releases Site", "Publishing Site"
54 - SPSMSITEHOST - "My Site Host"
90 - SRCHCENTERLITE (SetupPath=SiteTemplates\SRCHCENTERLITE) - "Search Center Lite"
6221 - PWA (SetupPath=SiteTemplates\PWA) - "Project Web Access Site"
6215 - PWS (SetupPath=SiteTemplates\PWS) - "Project Workspace"
14483 - OFFILE - "Records Repository", "Records Repository"

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 J Thank you

16 November, 2011

Ambiguous name detected: tmp.dde

Guys,

Today I m very happy to write this article, not because I have resolved this issue, not because I have done research on this, not because I did any debugging on this... but the reason behind this is-One of my colleague named “Vinesh Kapoor” has resolved this issue and registers his name by making an entry in the knowledgebase. As I always share the articles to benefit the SharePoint communities so here are the details:

Problem Description: Whenever user tries to open a word document in SharePoint, she get the error "Ambiguous name detected: tmp.dde"

Error message: Ambiguous name detected: tmp.dde

Resolution:
1) Close the entire word document and rename NORMAL.DOTM
2) You will find that under : \Documents and Settings\<your account>\Application Data\Microsoft\Templates
3) Open a blank word document and close it.
4) Check the location again, you will find that normal.dotm will be created.
5) Ask the user to open the word document from the SharePoint site and it worked fine

Reference to the same, a simple question comes to my mind as what is the function of this NORMAL.DOT file, if this file does not exist on the computer then will it make any difference, can we make changes inside this file, if we make any changes then does it impact the normal functioning of word files???

Questions will be many but let’s try to understand the basics so that we will understand the base functioning.

Here is my analysis:
What is NORMAL.DOT FILE?-The normal.dot file is the default Microsoft Word TEMPLATE. This file is used to store the default settings such as font, font size, content of a file, etc. that is used with each of the Microsoft Word file you open. This can be useful if you find yourself having to adjust the font type, font size, or other setting each time you open Microsoft Word.

How do I modify the normal.dot file?
-Open the normal.dot file and change the settings you wish to adjust. For example, if you want the default font size to be 14 each time you open Microsoft Word open the normal.dot file change the font size to 14 and save the document.

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 J

Code blocks are not allowed in this file

One of my user has opened a ticket with my team by mentioning “He is not able to browse his SharePoint Team Site and getting the below mentioned error message.

Problem Description: Not able to browse the SharePoint site

Error Message: An error occurred during the processing of /site/My Documents/Forms/Alldocuments.aspx. Code blocks are not allowed in this file.
Here is my analysis regarding the same:
    1) Check the site settings page is opening or not.
   How to check that? - Site URL/_layouts/settings.aspx
   2) If you are using any specialized master page in your environment then make sure it is properly selected under the master page galleries
How to check that? – Site actions-site settings-Under look and feel-master page galleries
   3) Check the default.aspx page is existing or not
How to check that?

-Open your site, it’s quite obvious that you will get error message
-Be on that same page
-Control + O (from your keyboard)
-This will open the shared view of your site
-if you see the default.aspx page their then go ahead and take the backup of that page in the same location
-It wills create-default1.aspx—this is fine and we are on right track
-In this same shared location, you can see the created subsites i.e. the child sites which are created underneath
-Go to any of the subsite by means of shared drive and copy the default.aspx and paste it at the root location
-Try t browse the site and check the results
-Your site is up and running without any issuesJ

If you have any queries/questions then please let me know.
I would be more than HAPPY to help you as well as RESOLVES your issues, Thank youJ

15 November, 2011

The filtering process could not be initialized. Verify that the file extension is a known type and is correct

Presently I am working on one search issue which is severity-1 and working towards the resolution. Here is my analysis and research that I did on this issue. If anybody has any suggestions then please append the same. I would be more than HAPPY to implement and discuss the same so that SharePoint community will benefit the same. Thank you

This is the site link: URL which is affected and reflecting in the crawl logs: /sites/ccas/applications/secore/shared%20documents/settlements/projects/2010/r1/20091005-%20ccas-so1%20owni%20gw%20correction/project%20plan/200919590_plan_owni_correction.xls

Error Message: The filtering process could not be initialized. Verify that the file extension is a known type and is correct

Problem Description: Search is not working and getting the above mentioned error message. Its happening only for one files i.e. .XLS

Action Taken:
1) Checked the file extension is added or not (How?-Please refer the following steps)
+Central administration
+Shared Service provided
+Search settings
+File Extensions
Reference: http://technet.microsoft.com/en-us/library/cc262700(office.12).aspx


2) Checked file name has any invalid characters but its proper one and no issues with it.

3) Checked IFilter which was released after the initial release of SP2007
reference: http://www.microsoft.com/downloads/en/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC&displaylang=en


4) This is not PPTX/any 2007 document so thats why i haven't checked this(Link to Microsoft 2010 Filter Packs): http://www.microsoft.com/downloads/en/details.aspx?FamilyID=5cd4dcd7-d3e6-4970-875e-aba93459fbee&displaylang=en

5) The document does not consist of any embedded links as per this reference:
http://blogs.msdn.com/b/russmax/archive/2010/11/11/sharepoint-2007-search-trying-to-crawl-office-documents-that-contain-embedded-links.aspx


6) Resetting the crawl index and run a full crawl is not a feasible solution as we cannot do this in production environment.

7) As per this link: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/2906b07f-291d-4ac0-8b3f-d47166cb309d/
We cannot disable the search service and reset & configure everything

The only thing that we can try at this moment is: convert the document to .XLSX and do incremental crawl and check the results
reference: http://social.technet.microsoft.com/Forums/en-US/sharepointsearch/thread/9ee200bd-94c9-43c9-b329-e15b09c6f0f3/

14 November, 2011

This web site does not support workflows created by SharePoint Designer

Workflows help people to collaborate on documents and to manage project tasks by implementing business processes on documents and items in a Microsoft Office SharePoint Server 2007 site. Workflows help organizations to adhere to consistent business processes, and they also improve organizational efficiency and productivity by managing the tasks and steps involved in business processes. This enables the people who perform these tasks to concentrate on performing the work rather than managing the workflow.

Would like to share some resolution details for the workflow issue that I had resolved recently. here are the details:

Error Message: This web site does not support workflows created by SharePoint Designer

Cause: You do not have the permissions necessary to create workflows.

Resolution:
1) In Office SharePoint Designer 2007, in the Folder List, right-click the Workflows library, and then click Properties.
2) Click the Security tab.
3) Click Manage permissions using the browser.
4) In the browser, on the Permissions: Workflows page, click New, and then click Add Users.
5) Add the user to the list.

If you have any queries/questions regarding the mentioned information then please let me know.

Unknown Error Trying To Lock File

Office integration with the SharePoint is the most important achievement as it I the most commonly used product in day to day business activities. Every OS has its own advantages and disadvantages while working with some applications or with some products but we need to understand that if any application is not working just because of machine change/OS change then the problem is not with that application but machine compatibility itself and we need to find what exactly it is lacking and what will be perfect resolution for that??

Problem Description:
Facing problems while editing office documents on windows vista OS

Configuration:
+OS-Windows Vista
+Office 2007
+IE 7.0

Error Message:
Unknown Error Trying To Lock File

Action that needs to be taken when user will be available:
Did research and founds out that although SP1 fixes the issue, registry settings are required to make it work. More info on the KB Article below


Registry changes in case if we don't suggest windows Vista SP-1:
1)   Locate and then click the following registry subkey:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\WebClient\Parameters
2)   On the Edit menu, point to New, and then click Multi-String Value.
3)   Type AuthForwardServerList, and then press ENTER.
4)   On the Edit menu, click Modify.
5)   In the Value date box, type the URL of the server that hosts the Web share, and then click OK.

Note:- You can also type a list of URLs in the Value date box. For more information, see the "Sample URL list" section in this article.
Exit Registry Editor.

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