Data model cannot be executed because of an error

Youssef_B_82

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

Venkat Thota - BIP

you have to logon with administrator user

Youssef_B_82

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

Venkat Thota - BIP

Venkat Thota - BIP

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

Youssef_B_82

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

Sketz

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?

Venkat Thota - BIP

what is the version ?