Importing an EXP file throws error "ORA-20008: Could not find user"

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

When "TESTUSER" tries to import an exp file, the below error is seen:

 

ErrorMsg: AwE-5001 Database Query Error

Details: ORA-20008: Could not find user  "'TESTUSER'" 

ORA-06512: at "SCHEMA_NAME.AWAPI2", line 4661

ORA-06512: at "SCHEMA_NAME.AWOP_API", line 675

ORA-06512: at "SCHEMA_NAME.AWOP_API", line 107

ORA-06512: at "SCHEMA_NAME.AW_WEB_API", line 39

ORA-06512: at line 1

 

aw_web_api.aw_impexp_request

0 tranmode: IN:VARCHAR2:java.lang.String:AF

1 errorcode: IN:OUT:INTEGER::null

2 errortext: IN:OUT:VARCHAR2::null

3 method: IN:VARCHAR2:java.lang.String:I

4 filename: IN:VARCHAR2:java.lang.String:test_exp

5 mapfile: IN:VARCHAR2:java.lang.String:test_exp

6 audit: IN:VARCHAR2::null

7 api_username: IN:VARCHAR2:java.lang.String:TESTUSER

8 api_password: IN:VARCHAR2:java.lang.String:*****

 

sID-19130213 

java.sql.SQLException: ORA-20008: Could not find user  "'TESTUSER'" 

ORA-06512: at "SCHEMA_NAME.AWAPI2", line 4661

ORA-06512: at "SCHEMA_NAME.AWOP_API", line 675

ORA-06512: at "SCHEMA_NAME.AWOP_API", line 107

ORA-06512: at "SCHEMA_NAME.AW_WEB_API", line 39

ORA-06512: at line 1

 

aw_web_api.aw_impexp_request

0 tranmode: IN:VARCHAR2:java.lang.String:AF

1 errorcode: IN:OUT:INTEGER::null

2 errortext: IN:OUT:VARCHAR2::null

3 method: IN:VARCHAR2:java.lang.String:I

4 filename: IN:VARCHAR2:java.lang.String:test_exp

5 mapfile: IN:VARCHAR2:java.lang.String:test_exp

6 audit: IN:VARCHAR2::null

7 api_username: IN:VARCHAR2:java.lang.String:TESTUSER

8 api_password: IN:VARCHAR2:java.lang.String:*****

 

 

 

 

 

Environment

Applications Manager version 9.3.5 to 9.4.4

Cause

This occurs when the Username and Password for a User is the same.

Resolution

This is fixed in Applications Manager version 9.5.1

Workaround:
Ensure that the User's username and password is not the same value

Example: Username is TESTUSER and password is also TESTUSER