If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Data Source Error - XQE-DS-0006

Started by SG1907, 12 Aug 2014 09:47:18 PM

Previous topic - Next topic

SG1907

****Background***
Cognos 10.2.1 Bi Server - 64 bit
Oracle 11g - 64 - bit
Oracle_SID=orcle (this in which my project producion data exists)
Oracle_SID=COGNOS(content store database)
Windows 7 - 64 bit
IIS 6
I have installed all of the above in my laptop meaning no installing of these components in different computers.

I have copied ojdbc5.jar and ojdbc6.jarfiles
from below location
C:\app\SrinivasGaddam\product\11.2.0\dbhome_1\jdbc \lib
to the below location
C:\Program Files\IBM\cognos\c10_64\webapps\p2pd\WEB-INF\lib

All the Cognos services are getting started successfully (included content store database service)

Created virtual directories....

I could see Public Folder in the browser from the below url
http://localhost:80/ibmcognos/cgi-bin/cognos.cgi

My tnsname file is as below:
COGNOS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = COGNOS)
)
)

LISTENER_COGNOS =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)



Now I need to create a datasource in cognos connection so that it is connected to ORACLE_SID:orcl (where I have production data)

Created New Datasource creation in cognos connection as below

Data source Name:TestOracle
Type: Oracle
Isolation level: use the default object gateway
Checked..Configure JDBC connection
SQL*Net connect string: ORCL
USER: SSFS931
PW: SSFS931 (with this user i can connect to oracle 11g in sqlplus command window)
Connection Type: Service ID
Server Name: Srinivas Gaddam (as my computer name is Srinivas Gaddam)
Port: 1521
Oracle Service ID: ORCL
Test connection
connection failed with below error
Oracle (JDBC) / Dynamic Failed - XQE-DS-0006 - Unable to logon to the data source

MFGF

Quote from: SG1907 on 12 Aug 2014 09:47:18 PM
****Background***
Cognos 10.2.1 Bi Server - 64 bit
Oracle 11g - 64 - bit
Oracle_SID=orcle (this in which my project producion data exists)
Oracle_SID=COGNOS(content store database)
Windows 7 - 64 bit
IIS 6
I have installed all of the above in my laptop meaning no installing of these components in different computers.

I have copied ojdbc5.jar and ojdbc6.jarfiles
from below location
C:\app\SrinivasGaddam\product\11.2.0\dbhome_1\jdbc \lib
to the below location
C:\Program Files\IBM\cognos\c10_64\webapps\p2pd\WEB-INF\lib

All the Cognos services are getting started successfully (included content store database service)

Created virtual directories....

I could see Public Folder in the browser from the below url
http://localhost:80/ibmcognos/cgi-bin/cognos.cgi

My tnsname file is as below:
COGNOS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = COGNOS)
)
)

LISTENER_COGNOS =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)



Now I need to create a datasource in cognos connection so that it is connected to ORACLE_SID:orcl (where I have production data)

Created New Datasource creation in cognos connection as below

Data source Name:TestOracle
Type: Oracle
Isolation level: use the default object gateway
Checked..Configure JDBC connection
SQL*Net connect string: ORCL
USER: SSFS931
PW: SSFS931 (with this user i can connect to oracle 11g in sqlplus command window)
Connection Type: Service ID
Server Name: Srinivas Gaddam (as my computer name is Srinivas Gaddam)
Port: 1521
Oracle Service ID: ORCL
Test connection
connection failed with below error
Oracle (JDBC) / Dynamic Failed - XQE-DS-0006 - Unable to logon to the data source

Hi,

Copying both ojdbc5.jar and ojdbc6.jar is not a good idea - one is for Java version 1.5 and the other is for Java version 1.6. Make sure you have the right ojdbc file for the version of java you are running, and delete the other.

Copying the ojdbcx.jar file to \p2pd\WEB-INF\lib is fine for content store access, but for JDBC data source access you also need to have the file copied into v5dataserver\lib. You didn't state that you did this, so it's worth checking.

One last step is to make sure that after copying in the correct ojdbc file to both locations, you need to stop and restart the IBM Cognos service.

Cheers!

MF.
Meep!

sdf

i advise you to use computer name or IP address instead of localhost for any connection made for Database.

you also need just one ojdbc jar. ojdbc5 always works for me.

also you can check first if the client machine you are using knows the server "Srinivas Gaddam"