Query Failing when performing a JOIN

[ahmerzaidi]

I'm not sure where to post this question in this section or the Framework manager section. I'm working on building a framework model and in the process I'm writing reports to validate the outputs.

Scenerio:
I have 2 queries which work as expected.  When joining the 2 queries using the JOIN object the query gives me an "Invalid Object" error.  When performing the pseudo join within a single query the results are as expected.

When trying to view tabular data for the join query I recieve the follow error:

"RSV-SRV-0040

The report server encountered an internal error. Check additional information associated with this error message. If cause of problem cannot be ascertained, increase the logging level in the IBM Cognos administration tool and reproduce the conditions that caused the error. If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos_Business_Intelligence. "

Any suggestions?  What Logging do I increase?