3 Replies Latest reply on Feb 28, 2014 9:09 AM by Jpeelman-Oracle

    ODI 12c: problem parametrizing OdiStartOwbJob



      when trying to set the location name in an OdiStartOwbJob step the following error pops up:

      ODI-13702: Unexpected error when connecting to OWB workspace OWB_OWNER.OWB_WS.   

      StatementCallback; bad SQL grammar [SELECT LOCATION_NAME, LOCATION_TYPE, LOCATION_TYPE_VERSION FROM OWBSYS.OWB_ODI_LOCATIONS]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist.


      This is no surprise since there is no table or view in schema OWBSYS by the name OWB_ODI_LOCATIONS. I can imagine that such a view might filter locations which don't contain any runnable mapping or process flow.

      I didn't install any patches. What's missing?


      best regards