Hi All,
8.1's transformer had a file called cognos.ini where we could specify the databases. This seems to be missing in 8.3. I'm guessing that because of 8.3 unified architecture, Transformer looks for the databases in the IQD in the main cognos configuration. As a result, if the main gateway is down, then Transformer will be unable to open the model file because it cannot find the information for the database specified in the IQD, whereas in 8.1 even if the main gateway was down, because the databases were specified in cognos.ini, it could still build cubes.
Is this correct? Thanks
Actually, the gateway being up is not an issue.
It seems that when an 8.1 model is saved as an .mdl and opened in 8.3, it opens fine the very first time. Once you build the cube and close the .mdl and try to open it again is when a TR1102 error comes i.e. unable to locate the databse specified within the IQD
In 8.3 iqds are completely gone.
You should create framework manager packages (query subjects) to use instead of iqds.
The files are saved as mdl and open it on the transformer instead of ini. Then its working fine and no more iqds are there in cognos8.3. you can create the packages and publish the models
"cogtr.xml" may be what you need to look at...
My 2 cents.
PS: before you modify it, back it up!
cognos.ini is a Series 7 based file. This file is still required for use with IQDs, but must be created manually in any Cognos 8.x environment.
Simply copy the 8.2 cognos.ini over to your 8.3 environment and you should be all set.
IQDs are still valid data sources in 8.3. First you need to install the series 7 iqd bridge from the transformer disk, then you need to copy the data source connections from the cognos.ini file into the cs7g.ini file which lives in the X:\Program Files\Cognos\c8\CS7Gateways\bin. Stop and start the services. now you should be able to use the IQDs in trasnformer. You can see:
KB#1038388
http://support.cognos.com/knowledgebase/googlesearch?load_kb_document=1&dr=kb1&uniqueid=137406
if you are a supported customer.
hope this helps
Jeff
thanks for your reply guys
i did chance upon the solution of opening the .pyi files, saving them as .mdl's and then opening the .mdl's in 8.3 transformer
but i also realized that for it to work correctly the second time, the mdl must be saved as .pyj in 8.3 transformer. Otherwise, the next time you open the .mdl, Transformer gives a sign-on error saying it could not find the database.