Home » Developer & Programmer » Reports & Discoverer » frm-41213 unable to find report server
frm-41213 unable to find report server [message #441220] Fri, 29 January 2010 09:23 Go to next message
mmsalman87
Messages: 41
Registered: September 2009
Location: kuwait
Member
when i call report from forms
this message appear i don't know why
frm-41213 unable to find report server
Re: frm-41213 unable to find report server [message #441239 is a reply to message #441220] Fri, 29 January 2010 11:29 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Perhaps because there's no report server there?
Re: frm-41213 unable to find report server [message #441315 is a reply to message #441220] Sat, 30 January 2010 11:07 Go to previous messageGo to next message
mmsalman87
Messages: 41
Registered: September 2009
Location: kuwait
Member
no the report server is running
i don't know what i can do ??
Re: frm-41213 unable to find report server [message #441384 is a reply to message #441315] Sun, 31 January 2010 02:45 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
we dont know your versions(OS,FORMS,reports or DS).
We don`t know wheather you are kidding or true that you report server running(as your examples/cmnds missing 100 % here)

whats your report path?
did you test to execute a Reports with rwclient ?

sriram Smile
Re: frm-41213 unable to find report server [message #441389 is a reply to message #441384] Sun, 31 January 2010 03:29 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Denis Segard has created a form that might help find the reason of this error. This form is now available at Metalink (see note 291955.1); however, if you visit this OTN Forms forum thread, you can ask him to send it to you.
Re: frm-41213 unable to find report server [message #441395 is a reply to message #441220] Sun, 31 January 2010 05:46 Go to previous message
mmsalman87
Messages: 41
Registered: September 2009
Location: kuwait
Member
i was formatted my pc and the same problem
note that the same program running on another pc normally
i am using windows xp service pack 3
and using oracle 10.1.2.0.2 last version from oracle

this is my code to call the report from form :

DECLARE
        repid                                                 REPORT_OBJECT ;
        v_rep                                                 varchar2(100);
        rep_status                                 varchar2(20);
        PL                                  PARAMLIST ;

BEGIN
	if :empid is null and :date_from is null and :date_to is null then
		message('íÌÈ ÊÚÈÆÉ ÇÍÏ ÇáÍÞæá');
				message('íÌÈ ÊÚÈÆÉ ÇÍÏ ÇáÍÞæá');
raise form_trigger_failure;	
		end if; 
        repid := find_report_object('REPORT17');    
        pl:=get_parameter_list('paraformlist'); 
        if not id_null(pl) then
                destroy_parameter_list(pl);
                end if;

        -- Adjust form report obeject
        SET_REPORT_OBJECT_PROPERTY (repid,report_execution_mode,batch);
        SET_REPORT_OBJECT_PROPERTY (repid,report_comm_mode,synchronous);
        SET_REPORT_OBJECT_PROPERTY (repid,report_destype,cache);
        SET_REPORT_OBJECT_PROPERTY (repid,report_desformat,'htmlcss'); 
        SET_REPORT_OBJECT_PROPERTY (repid,report_server,'hr_rep_serv');   
    pl:=create_parameter_list('paraformlist');
        add_parameter(pl,'paramform',text_parameter,'no');
 
add_parameter(pl,'P_EMPID',text_parameter,:empid);
add_parameter(pl,'P_date_from',text_parameter,:date_from);
add_parameter(pl,'P_date_to',text_parameter,:date_to);
 
  SET_APPLICATION_PROPERTY(CURSOR_STYLE,'BUSY');
  ----
        v_rep := RUN_REPORT_OBJECT(repid,pl);
        rep_status := REPORT_OBJECT_STATUS(v_rep);
        WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
                rep_status := report_object_status(v_rep);
        END LOOP;
        IF rep_status = 'FINISHED' THEN
                /*Display report in the browser*/
                WEB.SHOW_DOCUMENT('http://dev_ora-pc:8889/reports/rwservlet/getjobid'|| substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=hr_rep_serv', '_blank');
        ELSE
                message(' Error when running report ');
                message(' Error when running report ');
        END IF;

  ----change cursor
  SET_APPLICATION_PROPERTY(CURSOR_STYLE,'DEFAULT');
  ----

END;


attached the picture
  • Attachment: untitled.JPG
    (Size: 45.63KB, Downloaded 170 times)
Previous Topic: report shown nothing.
Next Topic: oraclerepserverqas service returned service specific error 186
Goto Forum:
  


Current Time: Sun Dec 04 10:32:03 CST 2016

Total time taken to generate the page: 0.14014 seconds