RQP-DEF-0177 error for Employee training cost example

[kris123]

Hello,
I tried the example in 10.1 developer edition (see attached)
and getting the error

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

this is stated as related to crosstabs etc and need to make it singleton or so....but do not know where to fix etc.

please help
note: my db is oracle 11g express edition

[tjohnson3050]

Your error message says table or view does not exist.  It sounds like the samples have not been fully setup in your environment.

Verify the data source connection tests successfully - correct if necessary.

If that doesn't work, check the Sample Setup information on the IBM Information Center:

http://publib.boulder.ibm.com/infocenter/cbv/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.ig_vpt.10.1.1.doc%2Fc_bv_settingupsamples.html

[kris123]

Hello,
How to find out which tables the report is using?
Can we go that way...rather than reinstalling the samples (also using developer trial edition)

there are datasource (working) and the using a package (i believe it is fine?)
not sure how this reported is created in samples.

I may have to look at a few examples and then try to simulate the report.

[tjohnson3050]

If you right click a field in the metadata tree, select lineage, you can find the table that the field comes from.

You should test the data source connection in Cognos Administration to be sure it connects successfully.