OWB 11.2 Deployment Fails With Error "RTC-5161, SQLException: no rows found for select into statement" After Database Upgrade From 11.2 to 12.1.0.x (Doc ID 2040222.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

After Database upgrade from 11.2.0.3/11.2.0.4 to 12.1.0.x, deployment of an OWB 11.2 mapping fails with the following error:

 

Changes

 Database with OWB repository was upgraded from 11.2.0.3/11/2/0.4 to 12.1.0.x

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms