My Oracle Support Banner

Unregistering OWB 11.2 User After it Was Dropped and Recreated on Database Level Fails With ORA-20007: WORK_USER is not a registered user of this workspace. (Doc ID 2056910.1)

Last updated on JULY 03, 2018

Applies to:

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

Symptoms

You are unable to register/unregister user in OWB 11.2.

Errors are:

ERROR at line 1:
ORA-20024: The user with name:WORK_USER has already registered to the workspace <name>
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1270
ORA-06512: at line 1

 

Attempt to drop OWB user failed with error:

ORA-01086: savepoint 'SVPT' never established in this session or is invalid

 

Attempt to re-register the same user fails with error:

ORA-20024: The user with name:WORK_USER has already registered to the workspace


Attempt to re-register the same user after having tried to unregister fails with error:


SQL> exec owbsys.wb_workspace_management.REGISTER_WORKSPACE_USER('WORK_USER');
BEGIN owbsys.wb_workspace_management.REGISTER_WORKSPACE_USER('WORK_USER'); END;
*
ERROR at line 1:
ORA-20003: WBSecurityHelper found the SQL error:ORA-20007: WORK_USER is not a registered user of this workspace.
ORA-06512: at "OWBSYS.WB_WORKSPACE_MANAGEMENT", line 1366

 

Changes

 Database user was dropped without being unregistered in OWB before and then recreated with the same name.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.