cancel
Showing results for 
Search instead for 
Did you mean: 

synchronization FAILS since it owns 18 duplicate Media IDs

SAPSupport
Employee
Employee
0 Kudos
We are trying to sync from productos fro catalog default:staged to productCatalogB2C: Staged, however,  it fails due to Cannot use source catalog version Default/StagedPHONE_NUMBER5) for synchronization since it owns 18 duplicate Media IDs

We need to find those 18 duplicate media IDs. Can you please help us ASAP?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee

Execute the below Flexible Search script in HAC to find the duplicate media ID:

select {m:code} from {Media as m} where {m:catalogVersion} = '8796093088345 ' group by {m:code} having count(*) > 1

Answers (1)

Answers (1)

VajraReddy
Explorer
0 Kudos

Thanks for valuable info