Cannot Get Sample Reports to run under Oracle 9i

[donb410]

All: I have been struggling with installing the sample databases and reports in CRN. Framework manager displays the models correctly, and I can execute the reports but I get the following errors: Unable to execute this request. QE-DEF-0177 An error accurred while performing operation 'sqlPrepareWith Options' status = 1-201'.

UDA-SQL-0446 Oracle returned an error message. ORA-00942: table or view does not exist UDA-SQL-0450 An unexpected error encountered during the "declare" operation.

UDA-SQL-0196 The table or view "SALES_STAFF" was not found in the dictionary.
...
UDA-SQL-0196 The table or view "SALES_TARGET" was not found in the dictionary.
...
UDA-SQL-0196 The table or view "ORDER_DETAILS" was not found in the dictionary.
...
and so on. I need help knowing what to tell the database people is wrong in order to get this fixed. Any suggestions would be most appreciated! Thanks, Don

Thanks,
Don
(Perpetual Innovations, LLC)

http://www.perpetualinnovations.com

 

[donb410]

I received several suggestions from various sources all of which proved to not solve the problem. It turns out that the database people had to create synonyms in oracle for several tables that appear in multiple sample databases with the same name. An example is:

CREATE SYNONYM COUNTRY FOR GOSL.COUNTRY;

These synonyms helped get the reports running - although we suspect there will have to be some additional synonyms created (other than the 18 that have been made so far).

Thanks,
Don
(Perpetual Innovations, LLC)

http://www.perpetualinnovations.com