EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI

Received Response
149
Views
11
Comments
User_1JG01
User_1JG01 Rank 3 - Community Apprentice
edited Aug 13, 2024 6:01PM in Oracle Analytics Cloud and Server

HI,

m getting following error in our OBIEE server while running couple of reports

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

I read one of the article :

https://businessintelligence.technology/2012/10/05/evaluate_support_level-inside-nqsconfig-ini-is-not-set/

that says

Edit the NQSConfig.INI file, located at: OBIEE_INSTANCE/config/OracleBIServerComponent/coreapplication_obisn

change below value from 0 to 2

: EVALUATE_SUPPORT_LEVEL = 2;

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

However m not sure what is the impact if I change this to 2 , for the reports that already running,

Can you please share some insight on it, is this the right of way doing it or is there anything that I could adjust through EM or somewhere?

Please let me know

I appreciate all your help in advance

Regards:

Bhaksker.V

Jsglp

«1

Answers

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi Bhaskar,

    Did you forgot to post the error message? Setting that parameter (to 1 or 2) allows OBIEE users to call database functions. Here is the documentation.

    https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-C2C5B43E-4BB9-4ED7-94DE-D262698DCF98.htm#BIMIG-GUID-C2C5B43E-4BB…

    Edit: There shouldn't be any impact to existing reports (but you would know better in term's of security who needs what access). Also you cannot  do it through EM.

  • 3427784
    3427784 Rank 4 - Community Specialist

    I was in the same boat a while back. I believe setting it at level 2 lets all users call database functions in OBIEE. If I find my reference from my notes, I'll post it over here.

  • User_1JG01
    User_1JG01 Rank 3 - Community Apprentice

    Sherry George,

    sorry my bad

    here you go

    ++++++++++++++++++++++++++++++++++++++++++++++++

    Odbc driver returned an error (SQLExecDirectW).

    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)
    ++++++++++++++++++++++++++++++++++++++++++++++++
  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    ok, and did you confirm that the report that throws the error uses "Evaluate" in it's criteria? If so change the value of the param to 1 or 2 and test. Here is the 11g doc for the same.

    https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/configfileref.htm#BIESG417

    The links  explain the usage and what the values mean and possible security vulnerabilities if  not set to zero.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Just to add to all above comments:

    EVALUATE_SUPPORT_LEVEL value 1 or 2 meaning:

    For value 1 Evaluate is supported for users with manageRepositories permission(it is assigned through application policies to an application role of which user is part of)

    For value 2 Evaluate is supported for any user.

  • User_1JG01
    User_1JG01 Rank 3 - Community Apprentice

    Hi Sherry

    thanks for your inputs, yes i have noticed EVALUATE function has been used across various fields in couple of reports

    guess based on above definition also provided by Syed , i m thinking to go for

    VALUATE_SUPPORT_LEVEL = 1;

    So once i make these changes, should i have to request my IT team to restart the entire OBIEE servers or is  there anything that i could do from my end through EM/Console to have these changes reflected immediately

    Please share your inputs

    Regards:

    Bhasker.V

    Jsglp

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    Hi Bhaskar,

    If you set the value to 1 then only  users with the manageRepositories permission will be able to run the reports. And normal bi user's doesn't have that permission. But if this is required only for users with that permission then set the value to 1 and restart BI services or if all users need to run reports with "Evaluate" in it, then set to 2 and restart services.And you can restart the services from EM.

  • Syedsalmancs110
    Syedsalmancs110 Rank 6 - Analytics Lead

    Make the change in NQSConfig.INI i.e. define EVALUATE_SUPPORT_LEVEL

    EVALUATE_SUPPORT_LEVEL = 1;

    Save the file

    Through either EM or through command console restart your OPMN managed BIEE Services(coreapplication_obis1,coreapplication_obips1 etc..)

  • User_1JG01
    User_1JG01 Rank 3 - Community Apprentice

    sure

    EVALUATE_SUPPORT_LEVEL = 2;

    guess i wanted to go with 2 with your explanation,

    is there a way to change it from the front end applications, rather than doing this from back end

    where i searched for this in the directoty i have 2 of these files NQSConfig.INI

    one located under instance/instance1/....../coreapplication_obis1/

    Other one is under Oracle_BI/bifoundation/......./OracleBiServerComponent/

    Please let me know

    Regards:

    bahsekr.V

    jsglp

  • Sherry George
    Sherry George Rank 7 - Analytics Coach

    You should make the edit in the file itself. And the file is the one under the instance directory. Also take a backup before editing the file.