Error 'The field [AttributeName] cannot be populated' Triggered When Attempting to Select Values on Dynamic Menus for New Data Columns on Live Tables
(Doc ID 2757086.1)
Last updated on OCTOBER 18, 2023
Applies to:Oracle BigMachines CPQ Cloud Service - Version 21 A and later
Information in this document applies to any platform.
When attempting to modify a commerce dynamic menu, nothing appears in the drop down and the following error appears at the top of the page or as a tooltip message on the attribute:
The field [AttributeName] cannot be populated. Please contact your system administrator.
In the bm.log, the following error can be observed:
[ERROR] com.bm.xchange.services.commerce.bs.DynamicMenuDataTableServiceImpl.fetchData(DynamicMenuDataTableServiceImpl.java:119) - Invalid token <columnName> at the following path $and.$and.<columnName>.
Field <ColumnName> doesn't exist or is not accessible in resource <TableName> for current user.
Additionally, the new column cannot be selected on a single select pick list in configuration that uses this table as a domain.
This issue also impacts ability to use the new column in a dynamic menu filter. When trying to save dynamic menu with a filter is the following error occurs
The query is invalid. See Online Help for more information on MongoDB query syntax.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document