Schema Synchronization Job Failed with Java.lang.NullPointerException (Doc ID 2915892.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Using Enterprise Manger Cloud Control 13c, Schema Synchronization job between source and target database fails with the following error:

2022-09-20 19:13:10,074 [RJob Step 637021] ERROR job.ChangeMgrJob executeCommand.425 -
Synchronization: IN generateSynchScript...

Synchronization: validated parameters.

Starting Synchronizationjob testing...

........

........

- open source connection

- open dest connection
Change Manager Back-end Exception: java.lang.NullPointerException
java.lang.NullPointerException
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchTableWorkItem.checkIotPK(CMSynchTableWorkItem.java:2747)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchTableWorkItem.analyzeOneDiff(CMSynchTableWorkItem.java:2539)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchWorkItem.analyzeDiffs(CMSynchWorkItem.java:1843)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchStoredObjWorkItem.analyzeDiffs(CMSynchStoredObjWorkItem.java:283)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchTableWorkItem.analyzeDiffs(CMSynchTableWorkItem.java:3788)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchWorkItem.initialProcess(CMSynchWorkItem.java:1786)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchTableWorkItem.initialProcess(CMSynchTableWorkItem.java:358)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchGenerator.reportCompResult(CMSynchGenerator.java:3791)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchGenerator.genFromCompResults(CMSynchGenerator.java:3674)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchGenerator.synchNewVersion(CMSynchGenerator.java:2337)
at oracle.sysman.dbTarget.db.changemgr.emo.util.CMSynchGenerator.process(CMSynchGenerator.java:1457)
at oracle.sysman.dbTarget.db.changemgr.emo.job.AbsSynchJob.generateSynchScript(AbsSynchJob.java:569)
at oracle.sysman.dbTarget.db.changemgr.emo.job.SynchScriptGenerationJob.executeSpecific(SynchScriptGenerationJob.java:80)
at oracle.sysman.dbTarget.db.changemgr.emo.job.ChangeMgrJob.executeCommand(ChangeMgrJob.java:347)

........

Cause

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