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

framework manger error

Started by firoz, 24 Aug 2012 11:12:43 AM

Previous topic - Next topic

firoz

When I am testing query subject in framework manager i got following error.

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-SOR-0005 Unable to write the file.

I tried that but it's not working..I have created joins in database view..when I am testing the table in database view it's pulling the data..but I am facing problem in intermediate view..because in intermediate view that table having joins with multiple tables.
example:
I have master table as some x..this x table joins with 10 other tables.

x.id=a.id
x.id=b.id
x.id=c.id

When I am including the table a with x then it pulling the data.when I am including b table along with A table to x then its showing this error.
and apart from that I have large volume of data in the tables approximately 4o crore records.

tjohnson3050