Jump to content
Changes to the Jaspersoft community edition download ×

Error when calling jasper report in apex, acl is also created, but it still gives an error


nasimabdolahzadeh

Recommended Posts

Hi, I did everything in this article:

 

https://pretius.com/blog/jaspersoft-apex-integration

 

But when running, I encounter an acl error, and even though I created an acl, it still gives me the same error, what should I do?

I use Oracle 11g, Apex 21, Tomcat 9, and Jasper Server 7.5.

this code use in apex:

DECLARE
  v_blob                 BLOB;
  v_file_type            VARCHAR2 (25) :='pdf';
  v_file_name            VARCHAR2 (25) := 'employee.'||v_file_type;
  v_vcContentDisposition VARCHAR2 (25)  := 'inline';
  v_DEPTNO               NUMBER := :P10_DEPTNO;
  v_hostname   VARCHAR2(30) := 'localhost'; -- your hostname, eg: localhost
  v_port       NUMBER       := '5080'; -- port for your JasperReports Server, eg: 8081
  v_username   VARCHAR2(50) := 'anonymousUser'; -- jasperreports server username 
  v_password   VARCHAR2(50) := 'anonymousUser'; -- jaspereports server password
  v_jasper_string VARCHAR2(30) := v_username || ';' || v_password;
  v_login_url  VARCHAR2(100) := 'http://' || v_hostname || ':' || v_port || '/jasperserver/rest/login';
  v_report_url VARCHAR2(100) := 'http://' || v_hostname || ':' || v_port || '/jasperserver/rest_v2/reports/reports/' || v_file_name;
BEGIN
  -- log into jasper server
  v_blob := apex_web_service.make_rest_request_b(
    p_url => v_login_url,
    p_http_method => 'GET',
    p_parm_name => apex_util.string_to_table('j_username;j_password',';'),
    p_parm_value => apex_util.string_to_table(v_jasper_string,';')
  );
  -- download file
  v_blob := apex_web_service.make_rest_request_b(
    p_url => v_report_url,
    p_http_method => 'GET',
    p_parm_name => apex_util.string_to_table('p_dept',';'),
    p_parm_value => apex_util.string_to_table(v_DEPTNO,';')
  );
  --OWA_UTIL.mime_header ('application/pdf', FALSE);  -- view your pdf file
  OWA_UTIL.MIME_HEADER( 'application/octet', FALSE ); -- download your pdf file
  HTP.p('Content-Length: ' || DBMS_LOB.GETLENGTH(v_blob));
  HTP.p('Content-Disposition: ' || v_vcContentDisposition ||'; filename="' || v_file_name || '"');
  OWA_UTIL.http_header_close;
  WPG_DOCLOAD.DOWNLOAD_FILE(v_blob);
  APEX_APPLICATION.STOP_APEX_ENGINE;

END;

 

 

and this error:

 

 

1 error has occurred

  • ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1339 ORA-29261: bad argument ORA-06512: at "APEX_200100.WWV_FLOW_WEB_SERVICES", line 1284 ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-24247: network access denied by access control list (ACL)

 

 

Thank you for helping me

Link to comment
Share on other sites

  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.
 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...