FRM-41213: Unable to connect to Report server
978817Jan 5 2013 — edited Jan 5 2013Calling 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