Oracle 10g terminated_with_error
while iam running a 10g report using the following code :
declare repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(50); BEGIN repid := FIND_REPORT_OBJECT('REPORT1'); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'rep_app_oracle_forms'); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'HTML'); v_rep := RUN_REPORT_OBJECT(repid); rep_status := REPORT_OBJECT_STATUS(v_rep); message(rep_status); message(rep_status); WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP rep_status := report_object_status(v_rep); END LOOP; IF rep_status = 'FINISHED' THEN --Display report WEB.Show_Document('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)|| '?destype=cache&desformat=pdf/html&server=' || 'rep_app_oracle_forms', '_blank'); ELSE message('Error...'); END IF; END;
an error message appears : unable to run report and the report status becomes terminated_with_error
so please send me why it happens and how to solve it
Software/Hardware used:
report builder 10g ,application server 10g
declare repid REPORT_OBJECT; v_rep VARCHAR2(100); rep_status VARCHAR2(50); BEGIN repid := FIND_REPORT_OBJECT('REPORT1'); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_server, 'rep_app_oracle_forms'); SET_REPORT_OBJECT_PROPERTY(repid, REPORT_DESFORMAT, 'HTML'); v_rep := RUN_REPORT_OBJECT(repid); rep_status := REPORT_OBJECT_STATUS(v_rep); message(rep_status); message(rep_status); WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP rep_status := report_object_status(v_rep); END LOOP; IF rep_status = 'FINISHED' THEN --Display report WEB.Show_Document('/reports/rwservlet/getjobid' ||substr(v_rep,instr(v_rep,'_',-1)+1)|| '?destype=cache&desformat=pdf/html&server=' || 'rep_app_oracle_forms', '_blank'); ELSE message('Error...'); END IF; END;
an error message appears : unable to run report and the report status becomes terminated_with_error
so please send me why it happens and how to solve it
Software/Hardware used:
report builder 10g ,application server 10g
ASKED:
February 13, 2011 11:58 AM
UPDATED:
February 16, 2011 9:13 PM
RELATED QUESTIONS
- Can't operate Oracle Reports 10g from a form called by another form on the application server
- A problem in calling Oracle report by using WEB.Show_Document
- Call parameter from Oracle Reports 10g web.show_doc
- Problems calling report using WEB.SHOW_DOCUMENT
- Oracle Forms 10g - Disable the save button in PDF as well as in IE
Answer Wiki:
Thanks for your share. Your site is really good, and it is very worthy to visit again. Welcome to our bridal gowns online store <a href="http://www.bridalgownsstore.com/">http://www.bridalgownsstore.com/</a>
To see all answers submitted to the Answer Wiki: View Answer History.
Are you able to run the report from the developer suite without calling it from a Form ?
Where does that ‘unable to run the report’ message come from ? is it a message from your form, a message from the application server, or something else ?
I would suggest putting an explicit test for the value of “repid” after the call to FIND_REPORT_OBJECT. My suspicion is that this is returning NULL.
If it is NULL, there are quite a few posts on the web about problems invoking this. If it is not NULL, there are some that mention problems running with a report server name that includes underscores.
Just a couple of suggestions.