My Oracle Support Banner

When Attempt to Import Repository Data Using startSQLImport Utility Error ORA-00001 Occurs (Doc ID 2161696.1)

Last updated on JUNE 12, 2017

Applies to:

Oracle Commerce Platform - Version 11.2 and later
Information in this document applies to any platform.

Symptoms

When attempt to import repository data using startSQLImport utility the Oracle database error ORA-00001 occurs.

**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : BatchCheckoutSQL.doInitialAuxiliaryOrMultiTableClone() SQL:INSERT INTO dcs_prd_chldsku
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog (SKU_ID, PRODUCT_ID, SEQUENCE_NUM, ASSET_VERSION, SEC_ASSET_VERSION)
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog SELECT DISTINCT t2.SKU_ID, t2.PRODUCT_ID, t2.SEQUENCE_NUM, ? , ?
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog FROM dcs_sku t1, dcs_prd_chldsku t2
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog WHERE t1.sku_id IN ( ? , ? , ? )
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog AND t1.is_head = ?
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog AND t1.branch_id = ?
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog AND t1.sku_id = t2.sku_id
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog AND t1.asset_version = t2.sec_asset_version
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : p[1] = {pd: asset_version} -1 (java.lang.Integer)
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998586 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : p[2] = {pd: asset_version} -2 (java.lang.Integer)
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998587 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : p[3] = {pd: historyIdProperty} sku10 (java.lang.String)
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998587 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : p[4] = {pd: historyIdProperty} sku20 (java.lang.String)
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998587 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : p[5] = {pd: historyIdProperty} sku30 (java.lang.String)
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998587 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : p[6] = {pd: is_head} true (java.lang.Boolean)
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998587 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : p[7] = {pd: branch_id} 10100 (java.lang.String)
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog pool-73-thread-1 : SQL Statement Failed: INSERT INTO dcs_prd_chldsku
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog (SKU_ID, PRODUCT_ID, SEQUENCE_NUM, ASSET_VERSION, SEC_ASSET_VERSION)
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog SELECT DISTINCT t2.SKU_ID, t2.PRODUCT_ID, t2.SEQUENCE_NUM, ? , ?
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog FROM dcs_sku t1, dcs_prd_chldsku t2
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog WHERE t1.sku_id IN ( ? , ? , ? )
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog AND t1.is_head = ?
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog AND t1.branch_id = ?
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog AND t1.sku_id = t2.sku_id
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998590 /atg/commerce/catalog/ProductCatalog AND t1.asset_version = t2.sec_asset_version
**** debug Wed Jul 06 17:46:38 CEST 2016 1467819998595 /atg/commerce/catalog/ProductCatalog CheckOutLockReleaserSynchronization.afterCompletion(): Releasing checkout locks in afterCompletion(). Lock Keys : [product+prod2, sku+sku20, sku+sku10, sku+sku30]
**** info Wed Jul 06 17:46:38 CEST 2016 1467819998803 /com/decathlon/repository/loader/service/SqlImporter [info@2016-07-06 17:46:38.803] import cancelled
**** info Wed Jul 06 17:46:38 CEST 2016 1467819998803 /com/decathlon/repository/loader/service/SqlImporter
**** info Wed Jul 06 17:46:38 CEST 2016 1467819998804 /com/decathlon/repository/loader/service/SqlImporter [info@2016-07-06 17:46:38.804] import cancelled
**** info Wed Jul 06 17:46:38 CEST 2016 1467819998804 /com/decathlon/repository/loader/service/SqlImporter
**** info Wed Jul 06 17:46:38 CEST 2016 1467819998804 /com/decathlon/repository/loader/service/SqlImporter [info@2016-07-06 17:46:38.804] import cancelled
**** info Wed Jul 06 17:46:38 CEST 2016 1467819998804 /com/decathlon/repository/loader/service/SqlImporter
**** Error Wed Jul 06 17:46:38 CEST 2016 1467819998808 /com/decathlon/repository/loader/service/SqlImporter --- CONTAINER:atg.adapter.gsa.sqlimport.ImportException; SOURCE:CONTAINER:atg.adapter.gsa.sqlimport.ImportException; SOURCE:CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ATGDB_CUBE1_PUBLISHING.DCS_PRD_CHLDSKU_P) violated

 

Cause

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
Symptoms
Cause
Solution


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