Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Data model cannot be executed because of an error

Received Response
550
Views
18
Comments
2»

Answers

  • Rank 5 - Community Champion

    I am logged as admin but I don't believe this version has the same tabs or at least not at the same place?

    this is what I see

  • Rank 7 - Analytics Coach

    you have to logon with administrator user

  • Rank 5 - Community Champion

    How do we capture queries when report job is fails?

    while scheduling report I did not see a diagnostic tab to choose log files, the only tabs I see are "General" "Output" "Schedule" and "Notification"

    Where do I find the log file to upload and check for the timestamp?

    Thanks

  • Rank 7 - Analytics Coach

    bip scheduler.PNG

  • Rank 7 - Analytics Coach

    could you able capture queries when report job is failed? then you can easily find the error what causing error , while scheduling report there is option in diagnostic tab to choose log files , select last option then schedule report. whenever report failed , upload log file using report failed time stamp, you can find queries fired for that failed report. Thanks

  • Rank 5 - Community Champion

    I am using Oracle BI Publisher 11.1.1.7.160719  (build:20160620.0157)

    The query above is for my class LOV

    How do I confirm that one or more params are null when it breaks?

    The "NULL Value Passed" option is selected so when the user select "All" Departments, a null value is passed to the class LOV and the ...(least(:P_DEPT) is null.. function kicks in to take in consideration all department. I use this method instead of "All Value passed" option because we might have more than 999 value to pass.

    Thanks

  • Rank 4 - Community Specialist
    select distinct CLASS_ID || '-' || CLASS_DESCR clsfrom S_DEPT_CLASS_SUBCLASwhere (least(:P_DEPT) is null or DEPARTMENT_ID || '-' || DEPT_NAME in (:P_DEPT))and BUSINESS_UNIT_ID = (:P_BU)ORDER BY TO_NUMBER(regexp_substr(CLS,'^[0-9]+')),LOWER(CLS)

    Is this a LOV or a Data Set query?

    In the first case the error could occure then any the other Paramter LOVs were not executed correctly.

    If it's a Data Set the error shouldn't occure.

    Can you confirm that one (or even more) parameter is null everytimes it breakes?

  • Rank 7 - Analytics Coach

    what is the version ?

Welcome!

It looks like you're new here. Sign in or register to get started.