Loading...

Error “Content DB collecting failed: Cannot insert the value NULL into column ‘owner’, table ‘tem

Title

Error “Content DB collecting failed: Cannot insert the value NULL into column ‘owner’, table ‘tem

Description

Please wait...

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.

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.

Leave a Reply