Hello,
I have installed a fresh instance of Oracle and imported a dump from another server. I am able to pull up the tables and the information stored within them.
However,I am facing issue when trying to create a new model from iqd.
Getting the below error :
ORA-12154: TNS:could not resolve the connect identifier specified
I have rechecked my tnsnames.ora file. It seems to be valid.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.64.27.jaz)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.jaz)
)
)
The entire setup has been done on one server(Cognos 32 bit, Windows 64 bit, Oracle 32 bit).
The content store is up and running with resource type as Oracle. But I am unable to build a model from iqd in transformer. Listener is also working and I have required privileges as well for the user credentials used while creating the model.
Any help appreciated.
Transformer needs an .ini file somewhere , I don't remember in which folder though. Why not build the model using a package from FM?
I have made changes to the Cognos .ini file as well. But no luck.
The source file is an iqd and we are not using FMW Manager for the mdoelling part.
QuoteTransformer needs an .ini file somewhere
I think what you're after is cs7g.ini (or maybe you've already got there). See this exchange from a couple of years ago:
Quotehttp://www.cognoise.com/index.php?topic=22281.0
which could give you an idea of what to put in it.