Oracle 10g terminated_with_error

70 pts.
Tags:
Oracle 10g
Oracle 10g error messages
SQL Server Report Builder
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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>

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    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 ?
    68,495 pointsBadges:
    report
  • Kccrosser
    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.
    3,830 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following