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.

Access denied by Business Data Connectivity

Microsoft SharePoint Server 2010 and the Microsoft Office 2010 suites include Microsoft Business Connectivity Services, which are a set of services and features that provide a way to connect SharePoint solutions to sources of external data and to define external content types that are based on that external data.
Recently I was giving training to group of people on BCS (Business Data Connectivity) functionality and I've been getting a few questions from people who have been trying this out, but stumbled onto some problems with it in terms of permissions when they tried it out themselves.
When you've created your external list and try to access it (even as the same user, Administrator which created it) you might get the following error:

If you are facing the same problem then here is the solution that you are looking for:
§  Central Administration
§  Application management
§  Manage service applications
§  Business Data Connectivity Service
§  Your Entity
§  Set Permissions
§  Now set the permissions as per your project requirements, You might want to use different permissions in your environments


In my farm, I am using this:

That’s it and you are done:
You should now be able to access the external list and see the desired result.

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