Hi all,
I'm working on a report package in a layered model - it works fine in my dev environment but not in my test environment. Even though I've checked all my data sources and data views are correct in both dev and test. I hid all the layers in the package, and just selected all the child objects of the Presentation layer - Cognos gave me that informational check at the end, but said it would still include the database objects even though I de-selected them.
But when I go to use the package in the test environment I get "UDA-SQL-0107 A general exception has occurred during the operation "prepare".ORA-00942: table or view does not exist". Like I said, the pkg works fine in dev but not test.
So I'm wondering, are my views in the database layer not present in test, or somehow is my package definition not seeing them? Here's a screenshot of my pkg definition.
Quote from: ry1633 on 06 Apr 2016 08:49:44 AM
Hi all,
I'm working on a report package in a layered model - it works fine in my dev environment but not in my test environment. Even though I've checked all my data sources and data views are correct in both dev and test. I hid all the layers in the package, and just selected all the child objects of the Presentation layer - Cognos gave me that informational check at the end, but said it would still include the database objects even though I de-selected them.
But when I go to use the package in the test environment I get "UDA-SQL-0107 A general exception has occurred during the operation "prepare".ORA-00942: table or view does not exist". Like I said, the pkg works fine in dev but not test.
So I'm wondering, are my views in the database layer not present in test, or somehow is my package definition not seeing them? Here's a screenshot of my pkg definition.
Hi,
Everything the package needs in terms of layers is included. I suspect the issue is that you're using a different schema, and you might have the schema name from DEV baked in to your FM model? If you look at the SQL in one of the underlying data sources, is there a reference to the DEV schema? What do you see if you expand the Data Sources folder in the tree in FM and click on your data source - what's defined in the Catalog and Schema properties?
Cheers!
MF.
I see it. Catalog is blank, but Schema points to my dev schema. What do I do? Is there a way I can blank that. In other projects I have, that Schema property is blank, and so I can get the packages to work just fine in either environment.
boom. sure enough that was it. :) I took out all those references so that they were blank and now the new package is ok. I would have never thought to look at that – must have been something I did when I first set up the project data source. Thanks for the help!
Quote from: ry1633 on 06 Apr 2016 10:26:50 AM
boom. sure enough that was it. :) I took out all those references so that they were blank and now the new package is ok. I would have never thought to look at that – must have been something I did when I first set up the project data source. Thanks for the help!
Great result! Thanks for updating us! :)
Cheers!
MF.