error ORA-01017 after connection change

[Former Member]

Hi,

we've recently eddited connection related to few Universes, replacing server and username/password, from DEV entironment to ACC environment. New credentials are ok (i've checked it by testing connection in Universe designer). After exportingh Universe to the server and trying to run query in the report, i recieve error like: Database error: ORA-01017; invalid username/password; logon denied. (IES10901) (Error:INF).

Looks like problem is abuot wrong credentials, but im 100% sure they are ok. I've even created new connection and ive filled it with the same credentials, that the first one. Test runs ok like with pievious one, but when I've replaced existing Universe connection with the new one nothing changes and ORA-01017 appears again.

I've been looking for the solution for two days by now, i've tried to export Universe fiew times, nothing helps.

[Former Member · Accepted solution]

Compare the TNSNames.ora in the server and your client (unless you are using the client tool on the server) and make sure you use the same case sensitivity in the file as in your connection. Also try with the user in uppercase as well.

Test with SQLPlus from the BI server.

If it still does not work in the server, try various combinations with cscheck utility (KBA 2127285)

Below an example from my test environment using a wrong password (same result with wrong user) on DB with alias ROTCAO11

C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0
\win64_x64>cscheck ping -m local -c "Oracle Client" -d "Oracle 11" -u "million"
-p "wrongPassword" -s "ROTCAO11"

# Failed:

-------------------------------------------------------------------------------
BusinessObjects Configuration:
Version: 3.2.1.80
Build: 14.1.4.1412
Network Layer: Oracle OCI
DBMS Engine: Oracle 11
Language: en
Charset: CP1252
Library: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterpri
se XI 4.0\dataAccess\connectionServer\drivers\lib64\dbd_oci.dll
SBO: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise X
I 4.0\dataAccess\connectionServer\oracle\oracle.sbo
RSS: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise X
I 4.0\dataAccess\connectionServer\oracle\oracle.rss
PRM: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise X
I 4.0\dataAccess\connectionServer\oracle\oracle.prm
Strategies: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enter
prise XI 4.0\dataAccess\connectionServer\oracle\oracle.stg
-------------------------------------------------------------------------------

DBD
ORA-01017: invalid username/password; logon denied

# Successful:

-------------------------------------------------------------------------------

BusinessObjects Configuration:

Version: 3.2.1.80

Build: 14.1.4.1412

Network Layer: Oracle OCI

DBMS Engine: Oracle 11

Language: en

Charset: CP1252

Library: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterpri

se XI 4.0\dataAccess\connectionServer\drivers\lib32\dbd_oci.dll

SBO: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise X

I 4.0\dataAccess\connectionServer\oracle\oracle.sbo

RSS: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise X

I 4.0\dataAccess\connectionServer\oracle\oracle.rss

PRM: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise X

I 4.0\dataAccess\connectionServer\oracle\oracle.prm

Strategies: C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enter

prise XI 4.0\dataAccess\connectionServer\oracle\oracle.stg

Middleware and DBMS Configuration:

Driver architecture: 32

Charset: UTF8

DBMS name: Oracle

DBMS version: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit

Production With the Partitioning, Real Application Clusters, Automatic Storage M

anagement, Oracle Label Security, OLAP, Data Mining, Oracle Database Vault and R

eal Application Testing options

-------------------------------------------------------------------------------

[Former Member · Accepted solution]

Thx for the answer Romain.

It was problem with Oracle drivers. I've replaced them and now report can refresh data.

But there is still one thing worth of mention in here:

as i've found while looking for help, SAP from version 4.0 (i use 4.1) uses 64bit oracle drivers and in previous versions and still in universe design tool it uses 32bit version. So after installation of client tools on servers they doesn't work, but it's not the issue - i've installed them just to check if it will work and it didn't. So i've replaced oracle drivers and now web version works

And just one more thing - we don't use tnsnames, users specify server by entering whole sting like tnsname entry.

[Former Member · Accepted solution]

Indeed, while the client tools are 32 bits and should leverage the 32bits middleware, the servers are 64bits (most of them) and should therefore be used with 64bits client software. There are still 32bits one, ie: ConnectionServer 32 - used for connection that only exist as 32bits, such as Access DB ODBC drivers which are only available as 32

Glad to hear you figured the problem out in any case.

Regards

[Former Member]

Hi,

I do agree with Romain, this is some thing related with TNS file.

what kind of authentication are you using.

Thanks,

Shakthi Raj Natarajan

[Former Member]

Thanks for the answer Shakthi,

As i've answered to Romain - it wasn't problem with TNS file - we had it empty even, when it worked.

I've replaced Oracle drivers and now problem is gone.