WebSphere Commerce Enterprise

Troubleshooting: ID not resolved when calculation codes are loaded into extended site stores

The error occurs if the Data Load utility or the Catalog Upload feature attempts to load catalog calculation codes into the wrong asset store.

Problem

The error The ID was not resolved for the table CALCODE with the unique index data occurs when either the Data Load utility or the Catalog Upload feature attempts to load catalog calculation codes into the wrong asset store.

Solution

You must load catalog calculation codes into the appropriate asset store.
  • Catalog calculation codes are stored in the Storefront Asset store.
If you are loading catalog calculation codes with the Catalog Upload feature, select the appropriate store from the store list. If you are loading catalog calculation codes with the Data Load utility, specify the appropriate store identifier in the data load environment configuration file.