we just upgraded out test systems from 4.1 to 4.2 the latest.
We have having issues with opening PDF reports from APEX. these are standard Interactive reports export to PDF option and also custom BI publisher reports
for interactive reports .. the application just opens the blank pdf document.
for other custom reports based on BI, it gives below error. This used to work in previous version. Please help. We are using BI Publisher as Print server
Error processing request.
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.
o ORA-06512: at "APEX_040200.WWV_FLOW_PRINT_UTIL", line 127
o ORA-06512: at "APEX_040200.WWV_FLOW_RENDER_QUERY", line 1750
o ORA-06512: at "APEX_040200.WWV_FLOW_RENDER_QUERY", line 1835
o ORA-06512: at "APEX_040200.WWV_FLOW", line 5941
Have you enabled Network Services on your schema? (Not sure if the APEX upgrade changes previously enabled ACL)
This may prevent communication with your BI Publisher server?
yes they are enabled this again after I viewed this article through other threads...below is the script DBA sent they have used for ACL.
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');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'www.xml',
host => ‘w216706ldbs2017');
I'm no DBA, but I usually have to do it each time I create a new APEX workspace with it's own schema - I have to add the privilege for the specific schema name.
(I am working with Version 4.2.0.00.27)
-- Look for the ACL currently assigned to '*' and give SCHEMA_NAME
-- the "connect" privilege if SCHEMA_NAME does not have the privilege yet.
SELECT ACL INTO ACL_PATH FROM DBA_NETWORK_ACLS
WHERE HOST = '*' AND LOWER_PORT IS NULL AND UPPER_PORT IS NULL;
IF DBMS_NETWORK_ACL_ADMIN.CHECK_PRIVILEGE(ACL_PATH, 'SCHEMA_NAME','connect') IS NULL THEN
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(ACL_PATH,'SCHEMA_NAME', TRUE, 'connect');
-- When no ACL has been assigned to '*'.
WHEN NO_DATA_FOUND THEN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL('power_users.xml','ACL that lets power users to connect to everywhere','SCHEMA_NAME', TRUE, 'connect');