My Oracle Support Banner

Smart Import Fails with "ODI-10245: Cannot Import SNP_SCENSTEP Null" and "ORA-00001: unique constraint ([WORK_SCHEMA].PK_SCEN_STEP) violated" (Doc ID 2998614.1)

Last updated on JANUARY 30, 2025

Applies to:

Oracle Data Integrator on Marketplace - Version 12.2.1.4.230929 and later
Oracle Data Integrator - Version 12.2.1.4.230929 and later
Information in this document applies to any platform.

Symptoms

Trying to Smart Import a package from a source development environment Oracle Data Integrator (ODI) 12.2.1.3 to a target development environment ODI 12.2.1.4, Smart Import fails with below message.

Also renaming a scenario name and Smart Emport/Import is not a good practice and can throw similar error:

 

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!

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