OWB Mapping Deployment Fails With ORA-29532 And ORA-28817: PL/SQL function returned an error

(Doc ID 1263144.1)

Last updated on MAY 09, 2017

Applies to:

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

Symptoms

Deployment of an OWB mapping fails with:

ORA-29532: Java call terminated by uncaught Java exception: java.sql.SQLException: decryption failure ORA-28817: PL/SQL function returned an error.
ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 67
ORA-06512: at "SYS.DBMS_CRYPTO", line 44
ORA-06512: at "OWBSYS.WB_RT_SERVICE_CONTROL", line 268
ORA-06512: at "OWBSYS.WB_RT_SERVICE_CONTROL", line 323
ORA-06512: at line 1

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