Error while Loading ATG ProductCatalog Data Into DataWarehouse Server - Attempt to set property named name (WarehouseRepository:product:301) with value = null (class=null). A null value is not allowed for a required property

(Doc ID 1576687.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle ATG Web Commerce Business Intelligence - Version 9.1 and later
Information in this document applies to any platform.


You are trying to preload the data warehouse with the /atg/reporting/datawarehouse/service/ProductCatalogLoader.loadAllAvailable method for product catalog data, but you see  this error...

The problem is in the ARF_PRODUCT table where name is a required field but this field maps to the product's display_name field which is nullable and is empty.

How can you get around this problem? 


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms