Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error with Synonym Mode Insert_Update

Milan Kanti Paul-OracleAug 28 2017 — edited Aug 28 2017

Hi,

I am importing an existing package scenarios with some changes in it.

While using Synonym Mode Update, I am not getting any error, but no objects are getting imported.

While used Synonym Mode Insert_Update, getting below error. Only when deleted the object and imported the scenario it worked.

I have lot of objects (scenarios) to be imported in the same way. Any suggestion towards solution will be appreciated.

Synonym Mode Insert Update Error

com.sunopsis.core.SnpsDuplicateAKException: ODI-10035: SNP_SCEN : 'PC_INCOMING_COLLECTION_REJECT Version 001' (with global id: 2636fa2a-c74d-4c56-8fc8-352096b10935 and internal id: 264) violates alternate key constraint AK_SNP_SCEN (SCEN_NAME,SCEN_VERSION) for values (PC_INCOMING_COLLECTION_REJECT,001)

at com.sunopsis.dwg.DwgObject.processAkViolation(DwgObject.java:3661)

at com.sunopsis.dwg.DwgObject.insertActionForDuplication(DwgObject.java:3517)

at com.sunopsis.dwg.DwgObject.insertForDuplication(DwgObject.java:3918)

at com.sunopsis.dwg.DwgDuplicationTools.importOtherObjects(DwgDuplicationTools.java:4430)

at com.sunopsis.dwg.DwgDuplicationTools.synonymImport(DwgDuplicationTools.java:3687)

at com.sunopsis.dwg.DwgObject.importFromObjectLst(DwgObject.java:9087)

at com.sunopsis.dwg.DwgObject.internalImportObjectList(DwgObject.java:7846)

at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java:8306)

at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java:6830)

at com.sunopsis.dwg.DwgObject.internalImportFromXmlWithCommit(DwgObject.java:6950)

at com.sunopsis.dwg.DwgObject.access$100(DwgObject.java:241)

at com.sunopsis.dwg.DwgObject$6.doAction(DwgObject.java:7166)

at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)

at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)

at com.sunopsis.dwg.DwgObject.importFromXmlWithCommit(DwgObject.java:7159)

at com.sunopsis.dwg.DwgObject.importFromXmlWithCommit(DwgObject.java:7091)

at com.sunopsis.graphical.dialog.SnpsDialogImportXml.doInternalImport(SnpsDialogImportXml.java:583)

at com.sunopsis.graphical.dialog.SnpsDialogImportXml.doImport(SnpsDialogImportXml.java:331)

at com.sunopsis.graphical.dialog.SnpsDialogImportXml$4.doInBackground(SnpsDialogImportXml.java:1109)

at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker$1.call(SwingWorker.java:240)

at java.util.concurrent.FutureTask.run(FutureTask.java:262)

at com.sunopsis.graphical.tools.utils.swingworker.SwingWorker.run(SwingWorker.java:278)

at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:947)

at java.lang.Thread.run(Thread.java:745)

Regards

This post has been answered by rpc1 on Aug 28 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 25 2017
Added on Aug 28 2017
4 comments
345 views