SP2010 upgrade - Test-SPContentDatabase complains about Microsoft.Office.Excel.WebUI.dwp

Test-SPContentDatabase -Name ABCD_Content -WebApplication
http://yoursite

Category : MissingSetupFile
Error : True
UpgradeBlocking : False
Message : File [Features\ExcelServerSite\Microsoft.Office.Excel.WebUI.dwp] is referenced [2] times in the database [ABCD_Content], but exists only under Windows SharePoint Services 3.0 setup folder. Consider upgrading the feature/solution which contains this file to the latest version.
Remedy: One or more setup files are referenced in the database
[ABCD_Content], but are not installed on the current farm. Please install any feature or solution which contains these files


Solution
There was an issue with this Web part and the Test-SPContentDatabase command. You should be able to ignore it and upgrade will work.

It worked for me!

Ref:
http://social.technet.microsoft.com/Forums/en/sharepoint2010setup/thread/539c4086-0bfe-4c87-9b0a-c4d65642340f

SharePoint 2010 -People and Groups All People Link is missing

In SP2010 All People Link is missing. Which is a useful link when you want to see all people who have access to the site or delete the user completely from the site collection, rather than going group by group to delete the user.

So the workwround is click any one group and check the URL
"/_layouts/people.aspx?MembershipGroupId=7"
Change the MembershipGroupId value to 0 "/_layouts/people.aspx?MembershipGroupId=0" and now you should be able to see all the people.

VS2010 Compilation failed. Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

I have upgraded my sharepoint VS2008 workflow VS2008 project to VS2010 and When I did the build I got this error

"Compilation failed. Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information. "

To resolve it

Go to assembly file and remove this attribute and do a build should work
[assembly: SecurityTransparent()]

Windows 7 Installation Error 0x80070017

The Windows7 DVD was burned using higher speed.

Re write your DVD with 4X speed and install it again.

"Access Denied” to Edit a Workflow Task evn though I have full access!

Even though I have full control/Contribute permission on the Site/task list/TaskItem-

http://www.mstechblogs.com/paul/moss-tells-me-access-denied-to-edit-a-workflow-task-but-i-really-do-have-access

Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

We got this error when the client try to add permission to an Item. The content databases status was offline in the central admin as well.

checked event viewer, found out the SQL server transaction log was full. Because it was set it to fixed size before and we changed it to grow automatically.

MOSS:How to recycle application pool from command line or by batch file?

c:\windows\system32\inetsrv\APPCMD.EXE Recycle APPPOOL "your application pool name"

eg:

c:\windows\system32\inetsrv\APPCMD.EXE Recycle APPPOOL "SharePoint - 80"

MOSS: How to restart SQL Server from command line?

net stop yoursqlInstanceName

net start yoursqlInstanceName

In my VM my instance name is MSSQL$OFFICESERVERS

net stop MSSQL$OFFICESERVERS

net start MSSQL$OFFICESERVERS

You can create batch file to execute both the commands together.

MOSS: How to restart SharePoint Timer Service from command line?

net stop SPTimerV3

net start SPTimerV3

You can create batch file to execute both the commands together.

How to add webparts on Item Display Form Page through browser

Easy!- With out using sharepoint designer, you can able to add webparts on List Item Display Page.

All you need to do is open the displayform page-Dispform.aspx (view item), then amend the url of the page by removeing everything after the ID number and add this

&PageView=Shared&ToolPaneView=2

So the url will look like

http://%7byoursite/%7DLists/Tasks/DispForm.aspx?ID=1&PageView=Shared&ToolPaneView=2

Now the page will be in edit mode and you should be able to add webparts!

Also the Edit Page option under siteaction is visible after the first modification

credits goes to Eric!