Hi Community, I am recently seeing that multiple select options in OTBI is not working perfectly and the report jobs are getting failed. Is someone else facing this issue? What is the reason behind this issue and what is the fix?
It is working only once and then it starts failing. Need some suggestions
Anand,
What is the issue! What is the error message? What is the sql you issue to get that error message? (cut paste since most people for security must not read attachments by strangers on the internet)
Assume this is a publisher report in OTBI (yellow) not an analysis in OTBI (blue). You said report jobs so does it fail if you run without schedule? Does it fail if you run data model without report? In the data model is your data set type sql with i) data source 1 of 3 application database or ii) logial query from subject areas data source biee? The syntax for multiple select is different as each is a different version syntax of SQL.
Hi,
The report is running successfully but only once in 10
times. Rest times it is failing with Error:
SQL query time exceeds the limit (600 sec). Stopped processing.
[INSTANCE_ID=bip.bi_server1]
Note: This error is coming when I am scheduling the Report and the successful run is giving the report within 2 minutes
Please find the below screenshot where out of 7 schedules only one ran successfully(Parameters is same for all these runs)
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
