If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cannot run query twice

Started by saragose, 30 Aug 2013 09:34:21 AM

Previous topic - Next topic

saragose

Hi There,
I have a really weird error and really need help with this.
In Framework manager, I have an object that I've created. It is based on a proc in Oracle. The proc receives a value, queries dynamically named table and returns a cursor.
First time I run a test on this query, it returns values.
Second time I run the same test, but change the parameter that I send in, it fails.
If I close framework mananger, reopen it and run the test with the second value first, it works. If I use the first value second, it fails.
I've tried reimporting the proc, recompiling the code, but nothing works.

The error that I get is:
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SQL-0283 Metadata describing "T1.Song_Id" does not match results from the database

I'm stumped. Does anyone have any idea as to what could cause this?

Eric