Solved

Survey in SP2010 - Error when answering survey questions

Posted on 2011-02-22
4
3,827 Views
Last Modified: 2013-06-05
Hello!

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:

Error
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!
0
Comment
Question by:ThatSharepointGuy
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:psv1973
Comment Utility
Have you tried using ULS Viewer and filter on the correlation id given.

http://archive.msdn.microsoft.com/ULSViewer/Release/ProjectReleases.aspx?ReleaseId=3308
0
 
LVL 6

Author Comment

by:ThatSharepointGuy
Comment Utility
psv1973,

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.

0
 
LVL 6

Accepted Solution

by:
psv1973 earned 500 total points
Comment Utility
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:

http://msdn.microsoft.com/en-us/library/ee363717(v=prot.13).aspx

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.
0
 
LVL 6

Author Comment

by:ThatSharepointGuy
Comment Utility
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.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now