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!

MOSS: Report of Users and their permissions

-- All users in site collection

Select tp_Title,tp_Login, tp_IsActive from UserInfo order by tp_Title,tp_Login, tp_IsActive


-- All users in a group

Select Distinct Title, tp_Title,tp_Login from Groups gr

inner join GroupMembership grm on gr.ID = grm.GroupID

inner join UserInfo usr on usr.tp_ID = grm.MemberId

order by Title,tp_Title,tp_Login




-- All groups for a user

Select Distinct tp_Title,tp_Login, Title from Groups gr

inner join GroupMembership grm on gr.ID = grm.GroupID

inner join UserInfo usr on usr.tp_ID = grm.MemberId

order by tp_Title,tp_Login,Title


Thanks to my mate Navneet Singh.

MOSS: Report how many web pages are under the SiteCollection

You can find only by using SQL query


Select distinct DirName,LeafName from AllDocs where DirName like '%Pages' and LeafName like '%.aspx'

order by DirName,LeafName

Office documents prompt for login in anonymous SharePoint site

I have a MOSS 07 site that is configured for anonymous access. There is a document library within this site that also has anonymous access enabled. When an anonymous user clicks on a PDF file in this library, he or she can read or download it with no problem. When a user clicks on an Office document, he or she is prompted with a login box. The user can cancel out of this box without entering a log in, and will be taken to the document.

This happens in IE but not FireFox.

Solutions

Unfortuantly the only work around I've found breaks some functionality for logged in users (can't upload multiple files, connect to outlook ect..)
If that is acceptable, or you want to try it and see:
In central admin > application management > application security > authentication providers select your web app and select your provider (likely "default").
Select No for client integration and save the settings.

Open your web config, find the line add verb="OPTIONS,PROPFIND,PUT,LOCK,UNLOCK..... and remove the verb OPTIONS.

You should no longer be asked in ie for credentials.

Reference:
http://stackoverflow.com/questions/375390/office-documents-prompt-for-login-in-anonymous-sharepoint-site