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

ORA-12154: TNS:could not resolve the connect identifier specified

Started by Prerna Chaudhary, 07 Dec 2015 12:10:54 PM

Previous topic - Next topic

Prerna Chaudhary

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.



cognostechie

Transformer needs an .ini file somewhere , I don't remember in which folder though. Why not build the model using a package from FM?

Prerna Chaudhary

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.

Michael75

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.