Recently we have faced an issue where we got the error invalid username/password this has happened randomly on one morning and every user has same error.
We have tried the username/password directly on database and it is working fine but its not working with OBIEE. The connection pool is also having the same username/password.We didn't know what went wrong.
When we started debugging we came to know that the DSN used was having a username/password which was delimited as part of DB maintenance activity as it is no longer used. But how come it is responsible for our issue, because we are using the latest username/password.
Resolution for this was to enable Shared Logon
Select this option if you want all users whose queries use the connection pool to access the underlying database using the same user name and password.
If this option is selected, then all connections to the database that use the connection pool use the user name and password specified in the connection pool, even if the user has specified a database user name and password in the DSN (or in user configuration).
If this option is not selected, connections through the connection pool use the database user ID and password specified in the DSN or in the user profile.
We have tried the username/password directly on database and it is working fine but its not working with OBIEE. The connection pool is also having the same username/password.We didn't know what went wrong.
When we started debugging we came to know that the DSN used was having a username/password which was delimited as part of DB maintenance activity as it is no longer used. But how come it is responsible for our issue, because we are using the latest username/password.
Resolution for this was to enable Shared Logon
Select this option if you want all users whose queries use the connection pool to access the underlying database using the same user name and password.
If this option is selected, then all connections to the database that use the connection pool use the user name and password specified in the connection pool, even if the user has specified a database user name and password in the DSN (or in user configuration).
If this option is not selected, connections through the connection pool use the database user ID and password specified in the DSN or in the user profile.
No comments:
Post a Comment