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:

Symptoms

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[1].$and[0].<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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.