Data Extract Fails With The 'ORA-01940' / 'ORA-01920' Errors.

(Doc ID 230622.1)

Last updated on OCTOBER 27, 2011

Applies to:

Oracle Clinical - Version: to 4.5.3 - Release: 4 to 4.5
Information in this document applies to any platform.


SAS data extract problem getting SQL error
If running Data Extract View and for any reason there are failures when it is performing grants or if the user stops the PSUB process, the system will leave the studyname@CURRENT username in use and any subsequent data extract runs will continue to FAIL.


Initially seeing the following in the log file:

ERR level 1
View: PBO102$CURRENT.HEMAHEMT ORA-00957: duplicate column name

ERR level 1
Create view failed

The above problem caused users to stop/abort the data extract process via PSUB.
Thereafter all subsequent runs come up with the following errors in the log file:

Connected to ORACLE as user RXC_MAA.
Error dropping user PBO102$CURRENT
ORA-01940: cannot drop a user that is currently connected

Error creating user PBO102$CURRENT
ORA-01920: user name 'PBO102$CURRENT' conflicts with another user or r
ERR level 1
Unable to create account.
ERR level 1
Error when calling create_account
Connected to ORACLE as user /.
Connected to ORACLE as user RXC_MAA.



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