Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Configure Printer in Oracle Forms

Received Response
82
Views
6
Comments

Summary

Configure Printer in Oracle Forms

Content

Hi All,

I am using Oracle BI Publisher 11g.

And I configured Printer Delivery option as like below.image

But when I run the report, it shows the below error

Delivery failed. [INSTANCE_ID=lenovooo-PC.1460088690811] [OUTPUT_ID=1016] Document delivery failed [INSTANCE_ID=lenovooo-PC.1460088690811] [DELIVERY_ID=1016]Error deliver document to printer::Exception happened when calling deliver API::Error deliver document to printer::Exception happened when calling deliver API::oracle.xdo.delivery.DeliveryException: oracle.xdo.delivery.DeliveryException: java.net.ConnectException: Connection refused: connectoracle.xdo.service.delivery.DeliveryException: oracle.xdo.delivery.DeliveryException: oracle.xdo.delivery.DeliveryExcepti

I can connect to my printer configured in a local pc by running

\\192.168.0.186\epson

What I need is, when I call the report from Oracle forms (version 12c), the BI report should directly print that report on a local printer. No need to preview the report.

Is this possible? What the error message actually mean? Is my URI is correct?

Regards,

Soofi

Answers

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    pl check if the printer is added in the server where BI is installed.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Sources of "java.net.ConnectException: Connection refused: connect"

    • Client and Server, either or both of them are not in the network. <- not likely for you seeing as you can connect
    • Server is not running <- not likely for you seeing as you can connect
    • The server is running but not listening on the port, a client is trying to connect. <- you connect without port; no connect with port 631
    • Firewall is not permitted for host-port combination <- you connect without port; no connect with port 631
    • Host Port combination is incorrect. <- you connect without port; no connect with port 631
    • Incorrect protocol in Connection String <- you connect without ipp; no connect with ipp

    Read more: http://javarevisited.blogspot.com/2013/02/java-net-ConnectException-Connection-refused.html

    Oracle Docs on the setup:   https://docs.oracle.com/cd/E21764_01/bi.1111/e13880/T526699.htm  <-- IPP assumes you have BIP installed in windows ... if in Linux then you need and CUPS setup

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

    can you try the below ..

    ipp://localhost.localdomain:631/printers/epson

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Is your printer configured/enabled to 'talk' on the ipp protocol?  is port 631 the port it listens on?

    what is the actual model of your Epson printer?

  • Sufissky
    Sufissky Rank 3 - Community Apprentice

    Yes of course.

    The BI Publisher is installed in local (192.168.0.186) and the printer in configured on the same pc.

    I can access the printer by calling

    \\192.168.0.186\epson

    Regards,

  • Sufissky
    Sufissky Rank 3 - Community Apprentice

    Thanks for your reply,

    Now I changed the URI from

    ipp://192.168.0.186:631/printers/epson

    to

    \\192.168.0.186\epson

    and Got the below error

    Delivery failed. [INSTANCE_ID=lenovooo-PC.1460088690811] [OUTPUT_ID=1019] Document delivery failed [INSTANCE_ID=lenovooo-PC.1460088690811] [DELIVERY_ID=1019]Error deliver document to printer::Exception happened when calling deliver API::Error deliver document to printer::Exception happened when calling deliver API::oracle.xdo.delivery.DeliveryException: oracle.xdo.delivery.DeliveryException: java.net.UnknownHostException: tp92.168.0.186\epsonoracle.xdo.service.delivery.DeliveryException: oracle.xdo.delivery.DeliveryException: oracle.xdo.delivery.DeliveryException:

    What do you mean by

    you connect without port; no connect with port 631

    you connect without ipp; no connect with ipp

    Thanks in advance.

    Regards,

    Soofi