• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3988
  • Last Modified:

Survey in SP2010 - Error when answering survey questions


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!
  • 2
  • 2
1 Solution
Have you tried using ULS Viewer and filter on the correlation id given.

ThatSharepointGuyAuthor Commented:

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.

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.
ThatSharepointGuyAuthor Commented:
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now