My Oracle Support Banner

Running Updateconnectionpool Command Fails With "ORA-01005: null password given" Error (Doc ID 2820133.1)

Last updated on JULY 11, 2022

Applies to:

Oracle Analytics Server - Version 5.9.0 and later
Information in this document applies to any platform.


Running a report in OAS fails with the below error after using updateConnectionpool script as noted in OAS Documentation.


Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43093. [nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement. (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1005, message: ORA-01005: null password given; logon denied at OCI call OCISessionBegin. (HY000)


 Trying to update the connection pool information using the updateConnectionpool command.


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

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