Innovative Survey & Feedback Solutions

Phone Contact

A field or property with the name 'Category Text' was not found on the selected datasource.

Article ID: 1032 Posted Date: 2/25/2005 12:15:27 PM
Products: Ultimate Survey - Enterprise .NET Edition Updated Date: 2/25/2005 12:15:27 PM

Symptom:
When trying to edit a survey in Ultimate Survey Enterprise survey software via Internet Explorer, an error is thrown that looks similar to the following:

Server Error in '/UltimateSurvey' Application.
-----------------------------------------------------------
A field or property with the name 'Category Text' was not found on the selected datasource.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: A field or property with the name 'CategoryText' was not found on the selected datasource.

Cause:
One or more of the matrix questions in Ultimate Survey have been corrupted.

Resolution:
1. Log out of Ultimate Survey.
2. Run the following script in query analyzer

update rz_matrixcategory set categorytext = '' where categorytext is null
3. Log in to Ultimate Survey and the survey will be fixed.