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

Error- 1139 "Frame Pinned Record Block Limit Exceeded"

Started by dxwallace, 17 Mar 2008 09:04:37 AM

Previous topic - Next topic

dxwallace

When I test a Measures Dimension Created from a Query Subject I get the following error:

This query contains an error and cannot be executed
It is recommended that you review the Query feedback int he "Query Information" tab
RQP-DEF-0177 An error Occurred while performing operation '
'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation 'sqlUpenResult' is inactive.
UDA-SQL-0104 A general exception has occurwed during the operation 'open result'
ERROR: 1139: Frame pinned record block limit exceeded

The underlying table is HUGE 13 to 16 tera-bytes. If I filter the underlying Qsubject and create a smaller subset, the the test of the dimension will actually run. However I want to know what this means for my application that I am trying to put together for the huge table.

Thanks