1 Reply Latest reply: Jan 5, 2013 10:54 AM by Paul M. RSS

    FRM-41213: Unable to connect to Report server

    978817
      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