SAP Knowledge Base Article - Public

3255051 - Error message "Validation failed for one or more entities. See 'EntityValidationErrors' property for more details" when creating Data source in Report module

Symptom

Unable to create a Data Source in the Report Module for some specific tables.

Error message is displayed in Report module when trying to create a new report "Validation failed for one or more entities. See 'EntityValidationErrors' property for more details"

Reproducing the Issue

  1. Login in CPQ
  2. Go to setup, then General -> Report Module
  3. Go to administration -> Data Source
  4. Add a new one
  5. Enter any name in "Display name field"
  6. Select one of the followings options in "Name": "[demoadmin].[sys_BusinessPartnerCustomFieldDefinition]", "[demoadmin].[sys_BusinessPartnerCustomFieldDefinitionML]", or "[demoadmin].[sys_BusinessPartnerCustomFieldPermissions]"
  7. Hit save, the error is displayed.

Resolution

Instead of view, query should be picked and entered with required table. Create report will return requested data. 

See Also

The error message is displayed only for some specific tables:

"sys_BusinessPartnerCustomFieldDefinition", "sys_BusinessPartnerCustomFieldDefinitionML", or "sys_BusinessPartnerCustomFieldPermissions"

Keywords

Report module Data source , KBA , CEC-SAL-CPQ , Sales Cloud CPQ , Problem

Product

SAP CPQ all versions