NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm

Dataform Save Error: "Object reference not set to an instance of an object..."

Application Scope: CORE

Problem

You attempt to add a new field to a dataform and receive the error "Whoops - something went wrong..."  When you check the exception logs you find the slightly more detailed error:  "Object reference not set to an instance of an object. Url: http://yourinstall.clientspace.net/Next/Admin/ProjectAttribute/Detail" the system will not allow you to save the field.

Cause

You have attempted to use a field name that is already in use on the dataform. This could be a system generated field, such as CreateDate, UpdateDate, CreatedByUserID, UpdatedByUserID, etc. SQL will not allow you to create two columns on the same table with exactly the same name, hence the error.

Solution

Change the field name and re-save. Avoid using any of the names for the existing fields on the dataform, or any of the system protected fields. If you are unsure of the pre-existing field names, you should run the "Dataform Specification" report to get a list of all the current dataform field names.


Article Images:


NOTICE: You are in the old ClientSpace Help system. Please link to the new ClientSpace Help here https://extranet.clientspace.net/helpdoc/home/ClientSpace.htm