This content has been marked as final. Show 3 replies
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?