NQSConfig [Cache]

Question

Hi,

I am running OBIEE 11g with the value of Enable=No under [CACHE] in NQSConfig.ini file. Whenever I restart the BI services using StartStopServices.cmd start_all, the value of Enable changes to "YES" automatically; How can I make it the constant (with value "NO")?

Regards,

[Deleted User] · Answer

+1. The file states very clearly that you aren't supposed to touch this setting manually in the file, but use Enterprise Manager.

The documentation is even clearer about this: https://docs.oracle.com/middleware/11119/biee/BIESG/configfileref.htm#CACGIGGF

Edit: Sorry that was a 12c link ...this is the real 11g one

Syedsalmancs110 · Answer

Just to add When your environment is up and running and if you directly change value for a parameter in cofiguration files like instanceconfig.xml,NQSConfig.INI etc, for parameter which are defined to be controlled by Enterprise Manager then upon server and services restart value is rolled back to previously set value as change parameter setting as per enterprise manager still points to previous set value you can find the information on same within biee-domain.xml file.

Here is what you did:

a) Your OBIEE sever and services were up and running.

b) You changed the value for [Cache] Enable=NO and saved the file.

c) You restarted the server and services.

But since as per FMW (EM) control settings BI Server cache was still TRUE i.e. YES(You can check in biee-domain.xml) hence parameter setting will be set back to the value as defined in EM.

So avoid all the confusion and from future all the parameter which says "# This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control" do not intervine with these parameter values manually within the file instead use EM(Enterprise Manager)

If you are not aware with navigation of EM here is blog(Under Section Application Level) which talks about naviagtion to disable BI Server Cache through EM:

Oracle Business Intelligence: Enable / Disable Cache in OBIEE 11g

Gianni Ceresa · Answer

Hi,

Did you set that value in the file directly?

Because, as the file says with "ENABLE = NO;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control" this value is set by Enterprise Manager.

So go in Enterprise Manager and turn off cache there.