Limit the number of fields for object types

Applies to: All deployment types

If you have many fields, the SQL used to update the reporting schema dynamically can become too large. The reporting schema has an SQL limitation of 32,000 characters. When the reporting schema exceeds this limit, you might get errors when you create or re-create the reporting schema.

Follow these best practices:
  • Limit the number of fields that are associated with each object type. In particular, limit the number of enumerated fields and currency fields.
  • Evaluate whether you need all of the fields for reporting. If not, you can exclude them from the reporting schema. For more information, see Selecting the fields to exclude.
  • Run the Schema Analysis report before you add more fields to an object type. For more information, see Running the Schema Analysis report.

If you already have many fields and you are getting errors when you create or re-create the reporting schema, you can resolve the issue by excluding fields from the reporting schema. For more information, see Excluding fields from a subsystem and Selecting the fields to exclude.