nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE EVALUATE function not working

2985260

We have OBIEE and I had to use EVALUATE function for an analysis. I have changed the NQSConfig.ini as mentioned in 1488008.1. We get the desired results in Dev, but in CERT, we still get the error [nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. Checked the RPD functions and both the environments are identical. Can anyone please guide.

Thanks,

Rakesh.

Find more posts tagged with

Accepted answers

All comments

ArijitC

Did you restart the services after you made changes in other environment? What is evaluate support level in new environment ? is it 2? if it is 1 then check if the user has manageRepositories permission.

# 1: evaluate is supported for users with manageRepositories permssion

# 2: evaluate is supported for any user.

# other: evaluate is not supported if the value is anything else.

Thanks

Arijit

3068122

Hi ,

Stop opmn services (or you can stop only obis component)
- If you are using OBIEE 11g , you can do it using "[INSTANCE_HOME]\bin"opmnctl.bat/sh" stopall. If you are using OBIEE 12c , you can do it using "[DOMAIN_HOME]\bitool\bin\stop.cmd/sh" -i obis1
Backup NQSConfig.INI
set EVALUATE_SUPPORT_LEVEL = 2
If it is 11g then start opmn services , if it is 12c the use [DOMAIN_HOME]\bitool\bin\start.cmd/sh
Check report that you use evaluate function

2985260

I did restart the services. Both the environments have EVALUATE_SUPPORT_LEVEL = 2. its strange that how one works and the other doesn't.

2985260

Yes, i did follow all the processes you mentioned, but we are still facing the issue. Please let me know if there are any other steps which we are missing.

Thanks,
Rakesh.

ArijitC

What version you have. Check if this bug applies to the environment.

Doc ID 1922648.1

2985260

We have 11.1.1.7.140415. I am not sure if it qualifies as a bug because we have the same version in Dev and Test. It works fine in Dev but not in Test.

Sherry George

Compare your NQSconfig files from both the environments using some text file compare tool to see if you made any accidental errors.

2985260

Yes I did compare and they both are identical.

Robert Angel

With this being evaluate could the differences be on the underlying databases, can you check a use of a function that is available to all on the DB like "nvl" (assuming it is Oracle DB) just to double check that the problem is evaluate and not rights on the function that you are trying to call on the DB.