FRM-41213: Unable to connect to report server
862194May 16 2011 — edited May 16 2011Hi
In my development server I have a Server 11g Forms and Reports Server 11g.I'm having trouble with the report server.
If I use this link on my browser the report works perfectly :
http://vmwsrvforms11g:9002/reports/rwservlet?server=ReportsServer_oracle-lx2l6mrl_asinst_1&userid=USER/PASSWORD@test.world&report=UGF001R.rdf¶mform=no&destype=Cache&desformat=PDF
I would like to use a different method though. This link includes the parameters of the database connection and this
is not tolerable. I created a form for the launch of the report using a report object using this code:
v_repid := find_report_object('UGF002R');
SET_REPORT_OBJECT_PROPERTY(v_repid,REPORT_DESNAME, 'UGF002R');
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_EXECUTION_MODE, BATCH);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESTYPE, cache);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESFORMAT, 'PDF' );
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_SERVER, 'ReportsServer_oracle-lx2l6mrl_asinst_1');
v_rep := RUN_REPORT_OBJECT(v_repid);
Unfortunately RUN_REPORT_OBJECT(v_repid) returns an exception: "FRM-41213: Unable to connect to report server"
I read something on the forum but have not managed to solve this problem. Unfortunately I am not an
expert .... I think the problem is the server configuration but I would not know how to solve .....
I really need help
thanks
Drake
Edited by: user5768158 on 16-mag-2011 6.14