OraFAQ Forum: Reports & Discoverer » Bursting and Distributing a Report Error

Home » Developer & Programmer » Reports & Discoverer » Bursting and Distributing a Report Error (Oracle Reports 6i, AS 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Bursting and Distributing a Report Error [message #421540]

Wed, 09 September 2009 02:37

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

Report message to a moderator

Re: Bursting and Distributing a Report Error [message #421559 is a reply to message #421540]

Wed, 09 September 2009 04:17

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Do these directories and file

/d:/orawin90/reports/dtd/distribution.dtd

exist?

Report message to a moderator

Re: Bursting and Distributing a Report Error [message #421694 is a reply to message #421559]

Wed, 09 September 2009 20:58

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

Attachment: Inventoryreport_Kashif_dist.rdf
(Size: 92.00KB, Downloaded 1507 times)

Report message to a moderator

Re: Bursting and Distributing a Report Error [message #421827 is a reply to message #421694]

Thu, 10 September 2009 22:50

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

Report message to a moderator

Re: Bursting and Distributing a Report Error [message #421838 is a reply to message #421827]

Fri, 11 September 2009 00:13

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Thank you for the feedback!

Report message to a moderator

Previous Topic:	Adding new parameter for Ageing 7 Bucket report
Next Topic:	percentage difference

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 05:11:17 CDT 2024