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

Article ID	1032	Posted Date	2/25/2005
Product(s)		Updated Date	2/25/2005

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.