You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Using analysis as a sub query - many values for the IN predicate error

    edited Jul 30, 2020 5:20PM in Reporting and Analytics for HCM 4 comments

    Summary

    Using analysis as a sub query - many values for the IN predicate error

    Content

    Hi,

     Using OTBI  analysis as a sub query for a field for the another analysis . While running the main analysis ,  facing an issue as  'Subquery contains too many values for the IN predicate. (HY000)' .
     
    View Display Error
    Odbc driver returned an error (SQLExecDirectW).
    State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)

     If we run the sub query analysis separately , the analysis is running fine  . But when we are adding this as a sub query for another analysis ( it has a single field - person number only) , we are facing the  issue - Subquery contains too many values for the IN predicate..

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!