Survey in SP2010 - Error when answering survey questions

Posted on 2011-02-22
Medium Priority
Last Modified: 2013-06-05

I've got a decent sized Survey on a SP2010 Team Site that contains about 50 or 60 questions.  The survey contains branching logic, if that makes any difference.

When attempting to respond to the survey, all of my users are getting an error that comes up after clicking "next" when answering the first question:

Exception from HRESULT: 0x80131904

Troubleshoot issues with Microsoft SharePoint Foundation.

Correlation ID: 6bdd9edb-f3fc-4da8-ad14-a600f433510e

Date and Time: 2/20/2011  7:03:24 PM

 Go back to site

Following up some posts on Google, I checked the size of the content database housing this site, and it comes out to 8,447MB...so it's no where near the 200GB limit.

Using that correlation ID, I've gone looking into the ULS logs under C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\LOGS.  There doesn't seem to be a whole lot of solid definition going on for what is happening (most of it is just the correlation ID next to the page retrieval/loading times).

However, I was able to get the following area in the logs...but it's pretty hard to read and I'm not sure exactly what's going on....

MetadataNavigationContext Page_InitComplete: No XsltListViewWebPart was found on this page[/internal/resources/Lists/ClimateSurvey/NewForm.aspx?IsDlg=1].  Hiding key filters and downgrading tree functionality to legacy ListViewWebPart(v3) level for this list.      7e80cc7c-4b22-4635-b34c-5c43c0bbc682

WARNING: Cannot change FormContext.FormMode to [Invalid] because it is already set to [New]	7e80cc7c-4b22-4635-b34c-5c43c0bbc682

WARNING: Cannot change FormContext.FormMode to [Invalid] because it is already set to [New]	7e80cc7c-4b22-4635-b34c-5c43c0bbc682

Open in new window

WcfSendRequest: RemoteAddress: 'http://sp2010server:32843/e062434eb2f44f85b2f8f549142da8a9/MetadataWebService.svc' Channel: 'Microsoft.SharePoint.Taxonomy.IMetadataWebServiceApplication' Action: 'http://schemas.microsoft.com/sharepoint/taxonomy/soap/IDataAccessReadOnly/GetChanges' MessageId: 'urn:uuid:dde9d576-ac61-4882-81f3-48a23e11b9e7'	 

Open in new window

System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'tp_DocId', table 'content_cmdgroup.dbo.AllUserData'; column does not allow nulls. INSERT fails.  The statement has been terminated.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()     at System.Data.SqlClient.SqlDataReader.get_MetaData()     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavi...	7e80cc7c-4b22-4635-b34c-5c43c0bbc682

Open in new window

...or runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)     at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)     at Microsoft.SharePoint.Utilities.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQ...	7e80cc7c-4b22-4635-b34c-5c43c0bbc682

Open in new window

SharePoint Foundation         	Database                      	880i	High    	...ueryData monitoringData, Boolean retryForDeadLock)	7e80cc7c-4b22-4635-b34c-5c43c0bbc682

Open in new window

I know that's a lot to look through, so if there's any more information that I can provide please let me know.  I'm not sure exactly where to start on this one, other than what I've already done.

Any ideas?  Thanks, folks!
Question by:ThatSharepointGuy
  • 2
  • 2

Expert Comment

ID: 34960906
Have you tried using ULS Viewer and filter on the correlation id given.


Author Comment

ID: 34963009

I have not  used ULS Viewer in the past...what a great tool!
I ran it, hit the "record" option, and then produced the error, and turned recording off.
One line in ULS Viewer showed up as orange, a "Critical" error:

Unknown SQL Exception 515 occurred. Additional error information from SQL Server is included below.  Cannot insert the value NULL into column 'tp_DocId', table 'content_internal.dbo.AllUserData'; column does not allow nulls. INSERT fails.  The statement has been terminated.

The odd thing is...I export the survey to a spreadsheet and realized that the first part(B1-B2) of the survey are was exported.  So I created a test survey using the template and deleted B1-B2, and the new survey works as normal without errors.

Somehow the first part of survey have not been added to the database.  Still no idea on what's causing this, and I've been monkeying around with it all night/morning.


Accepted Solution

psv1973 earned 2000 total points
ID: 34968636
I'm glad that ULs Viewer has helped you a lot already.

it looks like DOCId is a required field but it doesn't get set for some reason

Details on this table:


Could you try creating a small survey and se if that works, I wonder if your survey is hitting size limits somewhere.

Yiou might also want to look at the lines related to that ciritcal message ( same correlation ID) in ULS viewer you can filter on that ID by right clicking on the message and then set a quick filter.

Author Comment

ID: 35007930
I created a small test survey and it worked fine.  I tried expanding on it, to include branching logic, and it worked fine as well.  I'm not quite sure what causes this on this other list, but creating a new list ended up having the new list not getting this issue.  I'm just trying to found out the "why" of why it happened.

Good info on  ULS and the table ;-)   I'll keep digging into it, but haven't seen any issues with other lists come up lately.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
OfficeMate Freezes on login or does not load after login credentials are input.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question