Skip to content
Loading...
QuickApps Product Logo in header
меню

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

<p>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.</p>

Resolution

<p>Change the owner of the Content Database to any valid user. You can use the <strong>sp_changedbowner</strong> system stored procedure to change the database owner.</p><p>Example:</p><p>Use WSS_Content</p><p>EXEC sp_changedbowner 'domainuser'</p>

Defect ID

<p>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.</p>
See More Quick Apps for SharePoint Articles

Leave a Reply