[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Survey in SP2010 - Error when answering survey questions

Posted on 2011-02-22
4
Medium Priority
?
3,937 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 6

Expert Comment

by:psv1973
ID: 34960906
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
ID: 34963009
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 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:

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

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

656 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