QE-DEF-0285 Logon failure

[yeewaitu]

hi All,

I am trying to install COgnos Reportnet 1.1 MR2.

There are 3 servers:

- BI Server (Report server and content manager components)
- web Server (Gateway components)
- Database server (Oracle 10g)

The content store has been created in oracle and I am seeing the Cognos Connection page successfully.

However, when I try to add a new data source through reportnet, it throws me the following error from crnserver.log:

---------
Original Error: QE-DEF-0285 Logon failure.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is
missing or the host is inaccessible.
QE-DEF-0068 Unable to connect to at least one database during a
multi-database attach to 1 database(s) in:
testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0532 Data Source is not accessible: "GOSL.IGWAPDWHSE18".
ORA-12154: TNS:could not resolve the connect identifier specified
Trace back:
WPBIBusMethod.cpp(190): QSException: CCL_CAUGHT: WPBIBusMethod::run
Source/CQEConnection.cpp(304): QSException: CCL_RETHROW: CQECommon
Source/CQEConnection.cpp(303): QSException: CCL_CAUGHT: CQECommon
Source/QE_QsApi.cpp(2959): QSException: CCL_RETHROW: QE
Source/QESqlServer.cpp(3064): QSException: CCL_THROW: QE
10.236.136.21:9300 1452 2005-10-21 10:23:30.781 +8
010:2f13a058-41d9-11da-9013-9366995aeed2:0821465762
4CjlhMdCMws4w8yGvMqjGGMs8d4j489Gq28984lw 1 Thread-21
DISP 1139 1
Audit.Other.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler
Request Failure <messages><message><messageString>Client
Error</messageString></message><message><messageString>QE-DEF-0285 Logon
failure.</messageString></message><message><messageString>QE-DEF-0323 The
DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is
inaccessible.</messageString></message><message><messageString>QE-DEF-0068
Unable to connect to at least one database during a multi-database attach
to 1 database(s) in: &#10;
testDataSourceConnection&#10;</messageString></message><message><messageString>UDA-SQL-0031
Unable to access the &quot;testDataSourceConnection&quot;
database.</messageString></message><message><messageString>UDA-SQL-0532
Data Source is not accessible:
&quot;GOSL.IGWAPDWHSE18&quot;.</messageString></message><message><messageString>ORA-12154:
TNS:could not resolve the connect identifier
specified</messageString></message><message><messageString>Trace
back:</messageString></message><message><messageString>WPBIBusMethod.cpp(190):
QSException: CCL_CAUGHT:
WPBIBusMethod::run</messageString></message><message><messageString>Source/CQEConnection.cpp(304):
QSException: CCL_RETHROW:
CQECommon</messageString></message><message><messageString>Source/CQEConnection.cpp(303):
QSException: CCL_CAUGHT:
CQECommon</messageString></message><message><messageString>Source/QE_QsApi.cpp(2959):
QSException: CCL_RETHROW:
QE</messageString></message><message><messageString>Source/QESqlServer.cpp(3064):
QSException: CCL_THROW: QE</messageString></message></messages>
<trace>reportService.server</trace>
10.236.136.21:9300 1452 2005-10-21 10:25:40.859 +8 Thread-20 caf
0 1 Audit.caf Request error - SecureErrorId:
2005-10-21-10:25:40.843-#2
---------

I have entered the SQL * NET COnnect string as defined in the tnsnames.ora file. Any ideas to resolve this? Appreciate your help. I can connect to the oracle database using SQLplus, and tnsping.

Thanks!

 

[yeewaitu]

I have found the answer.

Just add the following environment variables under (System Properties > Advanced > Environment Variables)

- ORACLE_HOME (path of oracle client holding the 'bin' folder)
- CRN_ROOT (path of crn root directory eg: c:\program files\cognos\crn)