Report is failed with subquery contains too many values for in predicate in OAS

Gopi Krishna P

we have report built with based on the results of 4 subqueries in the filter conditions. last week it is working fine in OAS prod environment..

but without any changes same report is giving the error in the OAS this week. Below is the error message

if i remove the subquery2 in filter condition it is working fine, but in the subquery1 I have too many values.

same report is working fine in the OBIEE12c , we have an issue with OAS report, can some one please assist on this.

Regards

Gopi

Christian Berg -Oracle

same report is working fine in the OBIEE12c , we have an issue with OAS report, can some one please assist on this.

If this is the case then your first question should be: "What is different between our OBIEE12c and our OAS?"

How differently did you set up OBIEE and OAS? How differently have you configured and parametrized things?

Dori S.-Oracle

Without knowing a lot of detail of your situation, you might take a look at MAX_EXPANDED_SUBQUERY_PREDICATES. There is a similar post about this same topic, but for OBIEE.

https://community.oracle.com/products/oracleanalytics/discussion/6007/obiee-subquery-contains-too-many-values-for-the-in-predicate

Also, you can review: https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/configuration-file-settings.html