Home » Developer & Programmer » Reports & Discoverer » please help me!!!!! I have to finish the application tomorrow:frm-41213 connexion...  () 1 Vote
icon12.gif  please help me!!!!! I have to finish the application tomorrow:frm-41213 connexion... [message #184594] Thu, 27 July 2006 03:18 Go to next message
reyzom
Messages: 1
Registered: July 2006
Location: Tunisia
Junior Member
when execution the form the application shows this message:
frm-41213 connexion au serveur report dsikallelstg impossible(connection to the server impossible)
even if the report is OK and the oradevreports is in.
this is the code:


declare
repid report_object;
v_rep varchar2(100);
rep_status varchar2(20);
server_name varchar2(200) := 'dsikallelstg';
longueur number;
begin
repid := find_report_object('ETAT137');
set_report_object_property(repid,report_execution_mode,batch);
set_report_object_property(repid,report_comm_mode,synchronous);
set_report_object_property(repid,report_filename,'C:\stage\etat\test_1.rdf');
set_report_object_property(repid,report_destype,cache);
set_report_object_property(repid,report_desformat,'pdf');
set_report_object_property(repid,report_server,server_name);
set_report_object_property(repid,report_other,'paramform=no');
v_rep := run_report_object(repid);
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
longueur := length(server_name) + 2;
web.show_document('http://dsikallelstg:8888/stage/'||substr(v_rep,longueur)||'?server='|| server_name,'blank');
else
message('Error');
end if;
end;

I'll be thankful if some finds the solution to this problem Razz

[Updated on: Thu, 27 July 2006 05:00]

Report message to a moderator

Re: please help me!!!!! I have to finish the application tomorrow:frm-41213 connexion... [message #185391 is a reply to message #184594] Tue, 01 August 2006 08:53 Go to previous message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
I assume you checked the following (from the documentation)?

Ensure that the Reports Server being referenced in the RUN_REPORT_OBJECT code is started.

Make sure that the OC4J instance for Oracle Reports is started.

Make sure that parameters being passed to RUN_REPORT_OBJECT have no spaces in their values, or are enclosed in single quotes.

Previous Topic: garbage in PDF reports display or printing
Next Topic: Disco Std Apps EUL Install
Goto Forum:
  


Current Time: Tue Jul 02 10:15:03 CDT 2024