This article addressed the following error while pushing network devices from UCMDB to AM.

Caused by: Error (12,011): Index error: A record in table 'Brands (amBrand)' with the value 'CISCO_SYSTEMS_INC' for field 'Bar code (BarCode)' already exists in the database

Error in fcmdb.push.all.log.

2022-07-13 20:31:59,977 DEBUG [AdHoc:AD_HOC_TASK_PATTERN_ID-2362-1657724496781] - >> Push: Select AQL (0 ms): SELECT lBrandId FROM amBrand WHERE Name = 'Cisco_systems_inc'

2022-07-13 20:32:01,617 DEBUG [AdHoc:AD_HOC_TASK_PATTERN_ID-2362-1657724496781] - >> Push: Select AQL (0 ms): SELECT lBrandId FROM amBrand WHERE Name = 'Cisco_systems_inc'

2022-07-13 20:32:01,695 ERROR [AdHoc:AD_HOC_TASK_PATTERN_ID-2362-1657724496781] - >> Push: Execution Failed: INSERT INTO amBrand ( lBrandId, Barcode, Name) values (52484417, 'CISCO_SYSTEMS_INC', 'Cisco_systems_inc')

java.lang.reflect.UndeclaredThrowableException

at com.sun.proxy.$Proxy118.execAql(Unknown Source)

...

Caused by: Error (12,011): Index error: A record in table 'Brands (amBrand)' with the value 'CISCO_SYSTEMS_INC' for field 'Bar code (BarCode)' already exists in the database.

 

at com.peregrine.ac.api.AmApi98JNI.AmDbExecAql(Native Method)

at com.peregrine.ac.api.AmApi98.AmDbExecAql(AmApi98.java:81)

at com.peregrine.ac.api.AmApi.execAql(AmApi.java:228)

... 50 more

2022-07-13 20:32:01,695 DEBUG [AdHoc:AD_HOC_TASK_PATTERN_ID-2362-1657724496781] - >> Push: Select AQL (0 ms): SELECT lCpyId FROM amCompany WHERE Name = 'N / A'

2022-07-13 20:32:01,711 DEBUG [AdHoc:AD_HOC_TASK_PATTERN_ID-2362-1657724496781] - >> Push: Select AQL (0 ms): SELECT lModelId FROM amModel WHERE BarCode = 'C24'

Read the full knowledge doc and resolution here.