13 May, 2012

SP 2010 - Loading the Document Information Panel in MS Word throws a warning when 'Run ActiveX controls & PlugIns' for internet zone is set to 'Administrator Approved'

While working on document panel recently, I came across the strange error:

If a site falls in the intranet zone and the internet security setting “Run ActiveX controls and plug-ins” for the internet zone is configured to “Administrator Approved” and a user tries to create a new document within a document library, they gets the following warning

Microsoft InfoPath
One or more ActiveX controls could not be displayed because either:

1) Your current security settings prohibit running ActiveX controls on this page, or
2) You have blocked a publisher of one of the controls.

As a result, the page might not display correctly.

Not able to find out the root cause behind this but wanted to share the step that leads to resolve this issue:

Note: before making any changes to the registry, I can suggest you to take the backup so that in case anything goes wrong then we can restore t easily.

Roll out the following registry modification to all users:
-HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\AllowedControls

- Create a new DWORD value that is the GUID for the Managed Metadata control, which is: {64247C52-5C34-4597-B2A3-17BF5617F17F}

- Set this value to: 0

That’s it and your issue will be resolved J J

Please let me know in case of any queries/questions regarding the above mentioned information. I am providing some links to all of you relates to same as how to take the registry backup.

Microsoft has published a document on this:

How to take registry backup in windows 7

How to take registry backup in windows XP

10 May, 2012

Incoming Emails .msg attachments missing/not coming

Recently I worked on one issue which was very interesting, in fact easy to troubleshoot but difficult to believe/conclude the results.
One of our users raised an incident ticket with my team and it came to me for research and debugs the issue. The issue based on ‘incoming email settings’. More than 10-20 users send an email with attachments to SharePoint document library in which incoming email functionality is enabled.
What exactly the issue is?
If I send an email with an .msg file as attachment then the attachment goes missing. If I send an email by attaching word document, excel document or PDF document then it works properly i.e. email goes to the document library as per the expected behavior.
Note: One think I would like to highlight is “.msg is not a blocked file type” in any blocked extensions which are provided by MS list.
Troubleshooting done:
-block file types already checked in central administration: no difference
-if the settings in the incoming email document library are set as per unique permissions then we can change it to “any sender” settings for the troubleshooting purpose
-tried changing the settings “save all attachments in folders” to “save all attachments in the root folder: didn’t make any difference
-tried changing the mime type by means of outlook (to be specific: from MIME to UUEncode or BinHex): didn’t make any difference
Note: this issue is not machine/user specific. This is complete farm issue in which you can cross verify on any portal/web application.
Conclusion: this seems to be a by design behavior/Product limitation of the SharePoint.
If anybody has a perfect resolution for this then please shares the same here so that it would be very helpful for all the SharePoint communities. Thank you

08 May, 2012

Cannot delete a Corrupted lookup Column from the list

Issue : Just Today i came accross a issue in Which the User had a List with many columns and One of the column Which was a look up column was corrupted

used to give a error "Unknown Error"

We were not able to Delete or edit the column

After a lot of research we found a work around to delete the Column

Checked the Url and found the below

/_layouts/FldEditex.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription

Which is a wrong url it should be

/_layouts/FldEdit.aspx?List=%7B37920121%2D19B2%2D4C77%2D92FF%2D8B3E07853114%7D&Field=Product%5Fx0020%5FDescription

Just remove ex from FldEditex.aspx => FldEdit.aspx

And you will be able to get to the inside of the column where you can edit or Delete the column .

Cause - Unknown

06 May, 2012

Sharepoint 2010 - Delete A service application using Powershell

Some times You will find that you are not able to Delete the Service Application using the GUI . That`s the time when I have used the Powershell Command which works almost 100 % and quick .

Before you delete a service application, verify that its removal will not adversely affect users. As a best practice, you should ensure that no Web applications are currently consuming the service application that you are going to delete

When you delete a service application, you have the option to also delete the service application database (not all service applications have databases).

To delete a service application by using Windows PowerShell

  • On the Start menu, click All Programs.
  • Click Microsoft SharePoint 2010 Products.
  • Click SharePoint 2010 Management Shell.
  • At the Windows PowerShell command prompt, type the following commands.
To retrieve the service application that you want to delete, type the following command

$spapp = Get-SPServiceApplication -Name "<Service application display name>"

Where <Service application display name> is the display name of the service application that you want to delete.

The service application information will be stored in the $spapp variable Or You can also UseGet-SPServiceApplication cmdlet to list all service applications

To delete the selected service application, run one of the following commands. In both cases, you are prompted to confirm the deletion.

To delete the selected service application without removing the service application database, type the following command:

Remove-SPServiceApplication $spapp

To delete the selected service application and also delete the service application database, type the following command:

Remove-SPServiceApplication $spapp -RemoveData

If you Know the ID of the service application Then you can Also Use

Remove-SPServiceApplication -Identity <ID> -Remove Data

Service applications basics SharePoint 2010

Manage Administrators of a Service Application
You must be a member of the Farm Administrators group to manage service
Application administrators.
1. On the Central Administration home page, in the Application Management
Section, click Manage Service Applications.
2. On the Manage Service Applications page, click the row of the service
Application for which you want to manage administrators.
3. On the management Ribbon, in the Operations section, click Administrators.
4. In the Administrators dialog box, add or remove users or groups.
5. For users or groups you add, use the check boxes to configure permissions.
6. Click OK to save the settings.
Delete a Service Application
You must be a member of the Farm Administrators group to delete a service
Application.
1. On the Central Administration home page, in the Application Management
Section, click Manage Service Applications.
2. On the Manage Service Applications page, click the row of the service
Application you want to delete.
3. on the management Ribbon, in the Operations section, Click Delete.
4. In the confirmation dialog box, click the Delete Data Associated With The
Service Applications check box if you want to delete the associated database.
5. Click OK to delete the service application.