Monday, November 07, 2011

APEX PDF Printing II and ORA-20001 "Printing Engine"

If you use APEX PDF printing with an 11G database, make sure you configure the acl. 11G does NOT allow alless to the www by default!
When you run into this error:

ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified

Then, try this:
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'www.xml',
description => 'ACL for ApEx Printing',
principal => 'APEX_040100'
is_grant => true,
privilege => 'connect');

DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'www.xml',
principal => 'APEX_040100',
is_grant => true,
privilege => 'resolve');

DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'www.xml',
host => 'your.FOP.host.here');
END;
/
COMMIT;
at

12 comments:

  1. net X sol5/15/2012 7:46 PM

    Thanks for excellent post.

    ReplyDelete
  2. meltem7/25/2012 9:47 AM

    Hello, I'm using oracle 10.2.0.4... That's why I dont need ACL privileges. But I'm still getting the same error. Why, Do you have any idea?

    ReplyDelete
  3. meltem7/25/2012 10:13 AM

    Hello again,
    it was due to wrong port of bi publisher...the default ise 9704, but with the trial edition it gets up with port 7001...

    ReplyDelete
  4. Frank8/04/2012 1:01 PM

    @Meltem: thanks for the feedback! Appreciate it. Hopefully it will help others to look at the port#, too.

    ReplyDelete
  5. Rahul8/07/2012 7:45 PM

    ora-44416 -invalid acl:unresolved principle apex_040100

    ReplyDelete
  6. Frank8/08/2012 9:28 AM

    ora-44416 has to do with an illegal user or role, while defining the ACL.
    Check your syntax.

    ReplyDelete
  7. Anonymous7/01/2014 11:24 AM

    Cheers, fantastic post. Got my error resolved and I had to add localhost in host parameter.

    ReplyDelete
  8. Unknown3/18/2016 11:57 AM

    it's work.
    But if i do it from: shared components->report queries -> test report

    if i do it from application it's not working!

    ReplyDelete
  9. Unknown6/14/2016 5:01 PM

    Nice sharing,thanks thats have been helping me

    ReplyDelete
  10. Unknown9/02/2016 2:40 PM

    connect by sys

    run below command

    BEGIN
    DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'www.xml',
    description => 'ACL for ApEx Printing',
    principal => 'APEX_040200',
    is_grant => true,
    privilege => 'connect');

    DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'www.xml',
    principal => 'APEX_040200',
    is_grant => true,
    privilege => 'resolve');

    BEGIN
    DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'www.xml',
    host => 'localhost',
    lower_port => 7001);
    END;


    END;
    /

    principal => 'APEX_040200', It will be Apex version which is installed in your machine .

    Hostname will be name of machine on which bi is installed.

    after this works for me i am able to print pdf by apex.

    thanks



    ReplyDelete
  11. Frank9/04/2016 5:08 PM

    First of all, this post is over 5 years old. Secondly: how is your solution different in any way from what is not mentioned above?

    ReplyDelete
  12. Frank9/04/2016 5:08 PM

    First of all, this post is over 5 years old. Secondly: how is your solution different in any way from what is not mentioned above?

    ReplyDelete