Smart import not working

Mahesh25

Hi,

When i am trying to export for UAT environment, and import in PRODUCTION environment, it is throwing me below error.

Smart Import from UAT to Production is failing .

oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10018: The repository 553 is not coherent between the current repository and the import file.

at com.sunopsis.dwg.smartie.SmartImportManager.runSmartImport(SmartImportManager.java:2397)

at oracle.odi.impexp.smartie.impl.ISmartImportInstanceImpl.runSmartImport(ISmartImportInstanceImpl.java:346)

at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:251)

at oracle.odi.ui.smartie.imp.ImportSmartWizard$1.doInBackground(ImportSmartWizard.java:1)

at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)

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

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

Caused by: oracle.odi.impexp.smartie.OdiSmartImportException: oracle.odi.impexp.smartie.OdiSmartImportException: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10018: The repository 553 is not coherent between the current repository and the import file.

Here,

Production Repository Number:- 601

UAT Repository Number:- 553.

Environment Details:-

OBIA 11.1.1.8.1 ODI 11.1.1.7

We arefacing this problem since UAT repository renumbering.

Regards,

Mahesh

Mahesh25

I have tested in my env to see exactly and I can tell you for sure the issue is happening because you have in the source env 2 rows:

553, Timestamp 1362461626312 - which is the current Repository ID - correct

553, Timestamp 1362461626311 - incorrect

select *

from BID EV_BIA_ODIREPO.SNP_M_IMPORT_REP

where REP_SHORT_ID=553

I need to set 1362461626312 instead of 1362461626311 for the REP_SHORT_ID=553 , then export again from source and import into target.

--update 1 record:

update BIDEV_BIA _ODIREPO.SNP_M_IMPORT_REP set REP_TIMESTAMP=1362461626312 where REP_SHORT_ID=553 and

REP_TIMESTAMP=1362461626311;

commit;

Remember to export again from source and import into target.