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
- Login in CPQ
- Go to setup, then General -> Report Module
- Go to administration -> Data Source
- Add a new one
- Enter any name in "Display name field"
- Select one of the followings options in "Name": "[demoadmin].[sys_BusinessPartnerCustomFieldDefinition]", "[demoadmin].[sys_BusinessPartnerCustomFieldDefinitionML]", or "[demoadmin].[sys_BusinessPartnerCustomFieldPermissions]"
- 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