Popular Posts

Saturday 30 November 2013

[nQSError: 43113] EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE


EVALUATE_SUPPORT_LEVEL is missing in NQSConfig.INI

In one of our application in real time project, we faced the below error in our reports:
"OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE"

We had upgraded our OBIEE version from 11.1.1.5 to 11.1.1.7. But in all the reports, where we had used evaluate function, we were facing the error.

How to resolve the below error?

"[nQSError: 43113] EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE"
Solution:

1. Take a back-up copy of NQSConfig.ini file.
2. Open the NQSConfig.ini file for editing. You see the following two entries
EVALUATE_SUPPORT_LEVEL = 2;
EVALUATE_SUPPORT_LEVEL = 0;
(If you are not able to see the above entries in the file, then please do the following

Get the latest copy of NQSConfig.ini file  (please take back up) and add the tag
 EVALUATE_SUPPORT_LEVEL = 2;
 as above in the Server section.

See the example below:
DISCONNECTED = NO; 
AUTOMATIC_RESTART = YES; 
VARIABLE_VALUE_LIMIT = 30720; 

EVALUATE_SUPPORT_LEVEL = 2; 

FMW_SECURITY_SERVICE_URL = "http://172.25.170.43:61072"; # This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager - This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control
FMW_SECURITY_SERVICE_MAX_NUMBER_OF_CONNECTIONS = 2000; 
FMW_SECURITY_SERVICE_MAX_NUMBER_OF_RETRIES = 0; 
# FMW_SECURITY_SERVICE_RETRY_EXCEPTION_SUBSTRING = "forcibly closed";
FMW_UPDATE_ROLE_AND_USER_REF_GUIDS = NO; )

3. Comment out EVALUATE_SUPPORT_LEVEL = 0.
4. Restart all the services.

Note:
EVALUATE_SUPPORT_LEVEL must be set to 2 for the Evaluate function to work.


Thanks,

Angad.

No comments:

Post a Comment