3 Replies Latest reply: Feb 28, 2014 3:09 AM by jpeelman RSS

    ODI 12c: problem parametrizing OdiStartOwbJob

    tdombrow

      Hi,

      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

      Thomas