Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RPE-01012 when deploying mappings

peter_ATMar 31 2009 — edited Apr 1 2009
hi,
when deploying mappings, i get
"RPE-01012: Cannot deploy PL/SQL maps to this target schema. The target schema must be in the same instance as the Control Center and have the OWB_USER role granted."
i´ve found some threads in this forum, tried all of the suggested actions - no result.

my setup:

- target/repository DB: 11.1.0.6.0, 64-bit SLES10
- owb client: 11.1.0.6, winXP
- applied patch 6770194 to OHome at db machine
- control center service running at repository db machine (show_service.sql says "Available")
- created a repository using repository assistant, owned by REP_OWNER
- created a repository user REP_USER
- created a target user, added user to list in global explorer -> security, granted OWB_USER role
- created a db-location with credentials of target schema
- defined a target module, selected connection details specified in previously created location
- created time dimension using wizard
- successfully deployed table + sequence to target schema

any help appreciated!

thanks,
peter

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 29 2009
Added on Mar 31 2009
#data-warehousing, #warehouse-builder
34 comments
5,460 views