Categories
Data model cannot be executed because of an error
Answers
-
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
0 -
you have to logon with administrator user
0 -
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
0 -
0
-
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
0 -
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
0 -
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?
0 -
what is the version ?
0