Cognos Framework manager development memory issue

[drdre1978]

Goodmorning IBM techs,
 

I've got a question.

Environment:

1 gateway server (2 gig mem) Development, Test ,Acceptance ,

1 dispatch server (4 gig mem) Development,

1 framework server Development, Test, Acceptance.

A sybase datawarehouse (IQ) and a SQL server repository. The problem is that i can fire a query on a framework model on acceptance who gives me 200.000 rows in 10 seconds. When i fire a query in development it takes 30 seconds - 1 minute and it gives a CCLOutOfMemory Exception:

BmtActionsHelper.cpp(475), CCLOutOfMemoryError:CCL_RETHROW: BmtActionsHelper::DoAction. CCLIDOM_Element.ccp(108): CCLOutOfMemoryError:CCL_THROW:CCLIDOM -> Xerces

The Framework manager closes and this query is using 3 gig instead of 1 gig on acceptance. Beside of that i somethimes get a runtime error on BMT.exe

Extra info: I reinstalled the framework manager and tested de query on sybase. After the install same result , on sybase no problems

Kind regards,

 

André
PS: For you information, i changed the environment into a large business environment to comply to the Java Heap memory setting in Cognos.

[blom0344]

Framework manager is a client development tool and therefore supposed to be used on a client station. For test purposes you can set query options to fetch a limited set of data. Disable the number of records to fetch and you will very likely blow the tool to pieces, causing it to freeze especially if you fetch by row basis instead of aggregated results.
The proper route is to publish a package from framework manager and build testreports to run against the package. For normal BI purposes you will fetch aggregated sets of data (default behavior of the measures) Framework manager is not the best place for this type of testing!!

[drdre1978]

In my opionion you can use a Windows server as a client too, just choose the application server option, it's just another operating system and Framework manager works fine on Acceptance and Production this way.
You have to be careful with using to much memory for some applications and some applications don't work on a server, but Framework manager works fine this way on production and on Acceptance.

I have tested a query limit, till 150.000 records, after that it gives up. Like i've said 250.000 records from Acceptance is there in no time.

Kind regards,

André

[drdre1978]

I can imagine that it can blow, but 250.000 records are not that much. And your right with aggregation and filtering.  I will talk it over with BICC.

[drdre1978]

We didn't zoom in to aggregation just wanna focus on a normal set of rows which don't work on O & T.
Are there more ideas?

[blom0344]

dr. dre, it is a modelling tool.. Why on earth would you want to read 250.000 individual rows within a modelling tool? The test options are there to perform a check on the technical design of your model.
You are trying to use it in a way it was not designed for. Sure it will work installed on a server, but the idea is that you build a model, publish a package and test