Intermittent ora-31011 error
I have a plsql package that is called to run a report that creates several files. Lately I'm getting an ora-31011, ora-19202,lpx-00104 "warning: element "html" is not declared in the DTD error at line 2". This particular pkg has been running fine for the last year. This report runs everyday but I have received this error 3 times in the last 2 months. The pkg is called from our db server (10g - 10.2.0.1.0). Our AS is 10.1.0.4.2. Below is the code to run the report and the distribution xml. Can anyone give me some insight as to what to look for? Much appreciated.
begin
utl_http.set_transfer_timeout (3500);
p_list := portal.srw_paramlist(portal.srw_parameter('',''));
srw.add_parameter(p_list,'GATEWAY','http://mydomain:7778/reports/rwservlet');
srw.add_parameter(p_list,'server','myserver');
srw.add_parameter(p_list,'report','/home/oracle/active/reports/SLS_FLSH.rdf');
srw.add_parameter(p_list,'userid','myuserid');
srw.add_parameter(p_list,'cmdkey','repauthid');
srw.add_parameter(p_list,'destype','file');
srw.add_parameter(p_list,'desformat','pdf');
srw.add_parameter(p_list,'distribute','yes');
srw.add_parameter(p_list,'destination','/home/oracle/active/reports/sls_flsh_distribution.xml');
job_id := srw.run_report(p_list);
end
<destinations>
- <!-- Generate a file for each salesperson
-->
- <foreach>
- <file id="FLSH" name="/home/oracle/active/reports/tmp/flash_rpt_&<sort_div_id>&<rundate>.pdf" format="pdf" instance="this">
<include src="report" />
</file>
</foreach>
</destinations>