RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResu

[gruposenda]

Hi :
I'm creating a query subject based on data that exists in the model. After adding a column that comes from a view and testing the query subject definition appears the 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-SQL-0564 [Microsoft OLE DB Provider for SQL Server]Transaction (Process ID 66) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. (SQLSTATE=40001, SQLERRORCODE=1205)

If I run a query of the view (select * from DWH_VHInformation) with the query analizer I don't have any error.

Thanks in advance.

 

[blom0344]

You will need a DBA for this I guess. The deadlock suggest there is a second transaction active that is given higher priority. If your query-subject consists of more than just the view, then that transaction could have an insert/update lock on one of the other database objects.

The fact that you can still read with query analyzer suggest that:

1. The lock may indeed associated with another database table/view
2. You're using ODBC with query analyzer and this uses a different isolation level (like read uncommitted/dirty read) than the OLE DB used by Cognos

My advice:

List the datsbase objects involved and ask the DBA if there is another transaction (Process ID) that locks one of those objects..

Ties Blom