Home » Developer & Programmer » Reports & Discoverer » Bursting and Distributing a Report Error (Oracle Reports 6i, AS 10g)
Bursting and Distributing a Report Error [message #421540] Wed, 09 September 2009 02:37 Go to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Dear All,

Following the example of bursting and distribution in below document
as similar case is required in my production environment.

http://download-west.oracle.com/docs/html/B10602_01/orbr_dist.htm


i have followed the entire sequence as mentioned except i have to place it on Application server path
and run it from Application Server path URL

http://MYSERVER:7778/reports/rwservlet?report=Inventoryreport_Kashif_dist.rdf
&userid=oe/oe@kashif&authid=admin/admin&distribute=yes&destination=distribution.xml

where distribution.xml and inventoryreport_kashif_dist.rdf are in same directory

but it returns the following errors

REP-34304: /d:/orawin90/reports/dtd/distribution.dtd (No such file or directory)
REP-34304: Distribution failed to complete; review the distribution lists


Any help would be appreciated

Regards,
Kashif
Re: Bursting and Distributing a Report Error [message #421559 is a reply to message #421540] Wed, 09 September 2009 04:17 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do these directories and file
/d:/orawin90/reports/dtd/distribution.dtd
exist?
Re: Bursting and Distributing a Report Error [message #421694 is a reply to message #421559] Wed, 09 September 2009 20:58 Go to previous messageGo to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Thanks for reply

distribution.dtd exist in Oracle_Home/reports/dtd folder on Application Server but i don't know where /d:/orawin90 came from.

My Report is attached.

And Distribution.xml is mentioned Below

<destinations>
<!-- Generate a file for each warehouse -->    
 <foreach>
  <file id="MyFiles" name="Oracle_Home/Reports/Rep_&amp;&lt;city&gt;.pdf" format="pdf" instance="this">
    <include src="report"/>
  </file>
 </foreach>
<!-- Send a mail with an attachment for each warehouse -->   
 <mail id="ex1" 
       to="kashif.ali786@hotmail.com" 
       from="kashif.ali786@hotmail.com" 
       subject="This mail contains one attachemnt per city">
   <body srcType="text">
        This is the body of the message.
   </body>
   <foreach>
      <attach format="pdf" name="report_&amp;&lt;city&gt;.pdf" srcType="report" instance="this">
        <include src="mainSection"/>
      </attach>
   </foreach>
  </mail>

<!-- Send a mail for each warehouse with the corresponding file attaceed-->    
 <foreach>
 <mail id="ex2" 
       to="kashifali.786@hotmail.com" 
       from="kashifali.786@hotmail.com" 
       subject="This mail contains the files for &amp;&lt;city&gt;">
   <body srcType="text">
        This is the body of the message.
   </body>
      <attach format="pdf" name="report_&amp;&lt;city&gt;.pdf" srcType="report" instance="this">
        <include src="mainSection"/>
      </attach>
  </mail>
 </foreach>

</destinations>


Regards,
Kashif
Re: Bursting and Distributing a Report Error [message #421827 is a reply to message #421694] Thu, 10 September 2009 22:50 Go to previous messageGo to next message
sirfkashif
Messages: 70
Registered: September 2007
Location: Rawalpindi
Member
Problem is gone actually the URL

http://MYSERVER:7778/reports/rwservlet?report=Inventoryreport_Kashif_dist.rdf&userid=oe/oe@kashif&authid=adminadmin&distr ibute=yes&destination=distribution.xml

was not getting distribution.xml for some unknown reasons

and when i used below path it worked like a charm

http://MYSERVER:7778/reports/rwservlet?report=/home/oracle/test/test/Reports/Inventoryreport_Kashif_dist.rdf&userid=oe/oe@kashif& amp;authid=admin/admin&paramform=YES&destination=/home/oracle/test2/test/test/distribution.xml&distribute=yes

Regards,
Kashif
Re: Bursting and Distributing a Report Error [message #421838 is a reply to message #421827] Fri, 11 September 2009 00:13 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Thank you for the feedback!
Previous Topic: Adding new parameter for Ageing 7 Bucket report
Next Topic: percentage difference
Goto Forum:
  


Current Time: Tue Dec 03 05:40:03 CST 2024