Report is failed with subquery contains tooman

Gopi Krishna P

We have a report built with based on the results of sub queries in the filters and it is working fine last week in production all of sudden from this week it is giving the error like below without any changes in OAS.

Same report is working fine in the OBIEE 12c. it is giving the issue in OAS only.

can someone please assist on this what might be the issue.

if I remove the subquery2 in the filters condition it is working in OAS, but still I have too many values in subquery

I waswonder.

[Deleted User]

If you are using OAS then stick with your question in the OAS forum. Don't double post.

https://community.oracle.com/products/oracleanalytics/discussion/21414/report-is-failed-with-subquery-contains-too-many-values-for-in-predicate-in-oas