Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FRM-41213: Unable to connect to Report server

978817Jan 5 2013 — edited Jan 5 2013
Calling report in forms 11g r2

DECLARE
Repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := FIND_REPORT_OBJECT('MYREPORT');
set_report_object_property(repid, REPORT_EXECUTION_MODE, BATCH);
set_report_object_property(repid, REPORT_SERVER, 'rptsvr_shiva-pc_asinst_1');
set_report_object_property(repid, REPORT_COMM_MODE, SYNCHRONOUS);
set_report_object_property(repid, REPORT_DESTYPE, CACHE);
set_report_object_property(repid, REPORT_DESFORMAT, 'html');
set_report_object_property(repid, REPORT_FILENAME, :parameter.repname);
set_report_object_property(repid, REPORT_OTHER,'FROMDATE="' ||TO_CHAR(:MAINBLOCK.FROMDATE,'DD-MM-RRRR')
|| '" TODATE="' ||TO_CHAR(:MAINBLOCK.TODATE,'DD-MM-RRRR')
|| '" select1="'||:mainblock.SELECT1|| '"');

v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);

if rep_status = 'FINISHED' THEN
web.show_document('http://Shiva-PC:9002/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||
'?'||'server=rptsvr_shiva-pc_asinst_1','_blank');
else
message('Report Failure'||rep_status);
end if;
END;
--------------------------------------
Sir,
hyphen (-) contains in report server name does not matter. Please guide me.
My Report server name: rptsvr_shiva-pc_asinst_1

First time report was running fine after restart the pc show the error message :-

Report Failure :-
FRM-41213: Unable to connect to the Report Server rptsvr_shiva-pc_asinst_1

I have checked the url :-
http://shiva-pc.oracledistilled.com:9002/reports/rwservlet/server=rptsvr_shiva-pc_asinst_1
Error
No such Web command (server=rptsvr_shiva-pc_asinst_1).

http://shiva-pc.oracledistilled.com:9002/reports/rwservlet/startsever
Error:
No such Web command (startsever).

http://shiva-pc.oracledistilled.com:9002/reports/rwservlet/getserveinfo
Error:
No such Web command (getserveinfo).

thanks & regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2013
Added on Jan 5 2013
1 comment
1,266 views