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

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

blocked file types-SharePoint 2010

File types can be blocked on a per Web application basis or globally.

The settings are made from the operations tab of the central administration web site.

Essentially it is a list of file extensions that are not allowed. SharePoint only checks the extension and then allows/disallows it.

So if you try to upload an exe file and find that it is blocked, you can change the extension to .doc and upload the file. Antivirus checks the file content and decides whether it is a .doc or .exe file.

The default list of disallowed file extensions is as follows:

ade, adp, app, asa, ashx, asmx, asp, bas, bat, cdx, cer, chm, class, cmd, com, cpl, crt, csh, dll, exe, fxp, hlp, hta, htr, htw, ida, idc, idq, ins, isp, its, jse, ksh, lnk, mad, maf, mag, mam, maq, mar, mas, mat, mau, mav, maw, mda, mdb, mde, mdt, mdw, mdz, msc, msi, msp, mst, ops, pcd, pif, prf, prg, printer, pst, reg, rem, scf, scr, sct, shb, shs, shtm, shtml, soap, stm, url, vb, vbe, vbs, wsc, wsf, wsh