When running Data Gathering in Site Administrator for SharePoint the following error is seen in the QSPSCollector.log:
“12/02 11:41:25:654 | DBContentCollImpl_6.cpp(205) | 3568 | ERROR | Content DB collecting failed: Cannot insert the value NULL into column ‘owner’, table ‘tempdb.dbo.#spdbdesc 00010001BA6D’; column does not allow nulls. INSERT fails.[EIP: 0x10068BB3,0x1007E271] 0x80040E2F
12/02 11:41:25:654 | ProcessStateReporter.cpp(181) | 3568 | DBG | (SetTaskStateInformation) ID ‘142bf077-cde0-4579-a77f-4b6367581e77’, Date ‘Thu 12/February/2009 11:41’, State ‘2’, Description ‘Cannot collect information from Virtual server content databases. Error: Cannot insert the value NULL into column ‘owner’, table ‘tempdb.dbo.#spdbdesc 00010001BA6D’; column does not allow nulls. INSERT fails.'”
The Data Gathering finishes with non 100% result.
Title
Error “Content DB collecting failed: Cannot insert the value NULL into column ‘owner’, table ‘temDescription
Cause
One of the SharePoint Content Databases of the problem Virtual server has Unknown owner. This causes an error when running procedure exec sp_helpdb @dbname = 'CONTENT_DATABASE_NAME' on the master DB.
Resolution
Change the owner of the Content Database to any valid user. You can use the sp_changedbowner system stored procedure to change the database owner.
Example:
Use WSS_Content
EXEC sp_changedbowner 'domainuser'
Defect ID
One of the SharePoint Content Databases of the problem Virtual server has Unknown owner. This causes an error when running procedure exec sp_helpdb @dbname = 'CONTENT_DATABASE_NAME' on the master DB.