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;
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;


6 comments:
Thanks for excellent post.
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?
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...
@Meltem: thanks for the feedback! Appreciate it. Hopefully it will help others to look at the port#, too.
ora-44416 -invalid acl:unresolved principle apex_040100
ora-44416 has to do with an illegal user or role, while defining the ACL.
Check your syntax.
Post a Comment