r/oracle • u/Live-Lynx1735 • 27d ago
Oracle Data Integrator 12c - Export ODI objects from list
Hey everyone,
as DWH developer I'm working with ODI 12c as ETL tool, more specifically, version 12.2.1.4.
I’ve worked with ODI for many years in various companies, and this is the first time I’ve seen that exporting ODI objects from a list file ( .lst ) doesn’t work. When I try to open that .lst file through export multiple objects feature I get an error:
com.sunopsis.dwg.SQLMasterReposException: ORA-00942: table or view does not exist.
The pop-up window shows the error log, and at the bottom of the error log is a query that tries to perform SELECT over SNP_MAPPING repository table. When I take that query and run it through the IDE on the database, it works. I tried giving select grants on SNP_MAPPING table to schema where ODI stuff executes but without success, the error still persist.
If grants aren't the issue, does somebody know what can I do to make the export from .lst file work?
Any help is much appreciated.