Hi,
I'm using Oracle Data Integrator version 12.2.1.4. Couple of days ago I was preparing a list of ODI objects ( .lst file ) for export for out upcoming production deploy and noticed that 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.
When I scroll at the end of error log, I noticed that there is a query that tries to perform SELECT over SNP_MAPPING repo table.
When I took that query and run it in Toad, it worked normally. Fot testing purposes I tried giving GRANT SELECT on SNP_MAPPING table to ODI WRK schema but it didn't worked.
If it's not about GRANT's, does somebody know what can I do to make the export from .lst file work?
Thanks in advance!
kovar