I noticed the error message below repeatedly in event viewer and realized it was happening every time a profile import was happening.
Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server General
Event ID: 7888
Time: 11:37:17 AM
A runtime exception was detected. Details follow.
Message: Access Denied! Only site admin can access Data Source object from user profile DB.
System.UnauthorizedAccessException: Access Denied! Only site admin can access Data Source object from user profile DB.
at Microsoft.Office.Server.UserProfiles.SRPSite.AdminCheck(String message)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(IDataRecord rec)
at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(String strDSName)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site, Boolean fAllowEveryoneRead)
at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site)
at Microsoft.Office.Server.UserProfiles.BDCConnector.RefreshConfiguration(String sspName)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Turns out that on this server they had a least privileged install done. In this case you need to make sure that within the SSP you have granted your default content access account and your SSP application pool account the manage profile permission. If you need help with that check out this article I wrote on SSPs and their rights. http://msmvps.com/blogs/shane/archive/2007/08/06/give-a-user-access-to-the-ssp.aspx
Shane – SharePoint Consulting
Updated 7/27/08 - I realized the pictures didn't show up the first time.
Have you ever used the feature Storage space allocation from the site collection administrator's menu?
That is a pretty nice view of all of the document libraries in my site collection and their size. You can also click the drop down for show only and get a couple more choices.
How fun. Finding large lists or documents in the site collection is easy as pie now!
Enabling this feature
As you excitedly clicked into site collection administration you probably found you don't have this as an option.
Why not? These menus only show up when you have site collection quotas enabled. Kind of a bummer. Typically what I will do if I want this reporting is enable an arbitrary site collection quota. This is done from Central Admin > Application Management > Site Collection quotas and locks.
Shane SharePoint Consulting