Import error "ORA-00001: unique constraint (SO_DOC_IDX1) violated"

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

I am trying to import a exported file into our Application Manager and I get the following error:

ERROR at line 1:
ORA-00001: unique constraint (SCHEMANAME.SO_DOC_IDX1) violated
ORA-06512: at "TEST.AWAPI3", line 296
ORA-06512: at "TEST.AWAPI", line 4073
ORA-06512: at "TEST.AW_IMPORT", line 3213
ORA-06512: at "TEST.AW_IMPORT", line 4457
ORA-06512: at "TEST.AW_IMPORT", line 4602
ORA-06512: at line 5

IMPORT Failed

 

Environment

Release : 9.4.x

Cause

Can be caused by an import file that has too many objects

Resolution

If the Import file contains hundreds of objects or more, split the import into smaller imports.

For example, when exporting Process Flows between environments, instead of exporting 400 Process Flows, export 100 Process Flows at a time.