Transformer Unix: Error finding DB in IQD

[Exie]

Hi,

I've got power grid running and connecting ok, I've got transformer syncronizing ok, but when I select Server->Generate Server Categories ... I get the following error:

(TR0118) Tansformer cant read database [AMSPVWA] defined in /apps/cognos/data/extract.iqd

... our oracle SID is simply PVWA, and the credetials for the DB are stored in the model. Do I need to define my database (AMSPVWA) on unix like I do in Impromptu ??

PS. We're running Oracle9i and I have the ORACLE_HOME set.

 

[Draoued]

in your transformer model , if you double click your extract.iqd source , in the Data Sources window.
In the properties , you can see which database signon it s using.
You can also edit in notepad the IQD , and see if it s really PVWA or AMSPVWA , that will depend on the name you gave for the database in Impromptu catalog.

 

[Exie]

Thanks Draoued,
My IQD starts off as follows:
[blue]COGNOS QUERY
STRUCTURE,1,1
DATABASE,AMSPVWA
DATASOURCENAME,N:\InfoServices\DWG\Cogapps\cubegen\Data Warehouse\CASE\Extract.imr[/blue]
It referrs to [green]AMSPVWA[/green] which is what I called the Database in Impromptu. Looking at the tables in the catalog it's structured as AMSPVWA->CASE->MY_TABLE

When I go into Catalog Menu->Database I have my oracle connection called [green]AMSPVWA[/green] with an SQL*Net connect string of [red]PVWA[/red] (my real oracle SID for the DB)

I've tried changing the IQD manually to refer to:
[blue]DATABASE,PVWA[/blue]
but the same issue, I wondered if I needed to confiure my databases somewhere on Unix like I do in Impromptu. On my PC, the actualy database references are stored in my COGNOS.INI file (c:\program files\cognos\). On my PC I have a reference like so:
[blue]AMSPVWA=^User ID:^?Password:;LOCAL;OR;ORACLE@%s@PVWA/%s[/blue]
I'm not sure if I need a similar file on unix, or where it would go.

FYI - In transformer, under the data source properties, my DB signon is for [green]AMSPVWA[/green]

I hope that all makes sense

 

[Draoued]

You should be able to rename the database name as you did manually in the IQD.
So Open IQD, Change the DB name to DATABASE,PVWA , save the IQD.
In Model, double-click the Source, to update it. It should ask you for the Signon and Password . If it doesn't you can right-click the datasource and click "Modify Columns..." this will for sure ask you for the db signon and password.

Then you should be able to run it in Unix, after synchronisation.

 

[Exie]

Hi,

I changed this as you mentioned, however it still did not resolve it. I scanned through all the log files and found some errors about oracle libraries. I then discovered my oracle home path was wrong!

I fixed this, which in turn fixed up my LD_LIBRARY_PATH and everything is hunky-dory now.

I've managed to produce a number of .MDC's .... and I've now converted 3 models all to build on unix.

Many thanks for all your help Draoued.