Home » Developer & Programmer » Reports & Discoverer » Error when running report
Error when running report [message #404927] Mon, 25 May 2009 08:56 Go to next message
hamdan102
Messages: 16
Registered: May 2009
Location: jordan
Junior Member

Hi everybody

I have Installed
oracle DB 10g
and
oracle dev. 10g
into My Laptob(i have't connection with Internet Or LAN just localy)

I want to run report localy into my laptob?

the oc4j service is running successfuly and
the rwserver service is running successfuly
but i can't do that?



please help me
thanks

Re: Error when running report [message #404960 is a reply to message #404927] Mon, 25 May 2009 15:54 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Until you tell us which error you got, I'm afraid we won't be able to help.
Re: Error when running report [message #404988 is a reply to message #404960] Tue, 26 May 2009 00:21 Go to previous messageGo to next message
hamdan102
Messages: 16
Registered: May 2009
Location: jordan
Junior Member

i use this code
----------------
declare
repid REPORT_OBJECT;
v_rep VARCHAR2(200);
rep_status VARCHAR2(50);
pLIST PARAMLIST;

begin
pLIST := GET_PARAMETER_LIST('pLIST');
IF NOT ID_NULL(pLIST) THEN
DESTROY_PARAMETER_LIST(pLIST);
END IF;
pLIST := CREATE_PARAMETER_LIST('pLIST');
--ADD_PARAMETER(pLIST, 'NAME PARAM IN REPORT', TEXT_PARAMETER,:reports.s_date);
--ADD_PARAMETER(pLIST, 'pstud_Serial', TEXT_PARAMETER,:CHECK_PRINT.stud_serial);
repid := find_report_object('remarks');
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,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'repserver');
v_rep := RUN_REPORT_OBJECT(repid,pLIST);
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://127.0.0.1:8889/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repserver','_blank');
ELSE
message('Error when running report');
END IF;


END;
----------
i see this error
"'Error when running report'"

notice: i have no connection to internet or LAN(just localy)

[Updated on: Tue, 26 May 2009 00:33]

Report message to a moderator

Re: Error when running report [message #405021 is a reply to message #404988] Tue, 26 May 2009 01:44 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Hm, error message isn't very descriptive. Did you try to go to Help - Display Error (in a form menu)? Perhaps it will display some more information (such as ORA-xxxxx code or similar).
Re: Error when running report [message #405039 is a reply to message #405021] Tue, 26 May 2009 02:48 Go to previous messageGo to next message
hamdan102
Messages: 16
Registered: May 2009
Location: jordan
Junior Member

frm-41213:unable to connect to the .....
Re: Error when running report [message #405041 is a reply to message #405039] Tue, 26 May 2009 03:07 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
FRM-41213: Unable to connect to the Report server %s.

Cause:  There is a problem connecting to the specified Report server.

Action:  Check the Report server and make sure it is up and running
Re: Error when running report [message #405045 is a reply to message #405041] Tue, 26 May 2009 03:17 Go to previous messageGo to next message
hamdan102
Messages: 16
Registered: May 2009
Location: jordan
Junior Member

sure Report server is up and running
Re: Error when running report [message #405056 is a reply to message #405045] Tue, 26 May 2009 03:38 Go to previous messageGo to next message
hamdan102
Messages: 16
Registered: May 2009
Location: jordan
Junior Member

i thank the problem in
netwrok configuration
because i have no connect to internet or LAN


Re: Error when running report [message #405063 is a reply to message #405056] Tue, 26 May 2009 04:04 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You don't need LAN if both the database and Developer Suite are installed on your computer.
Re: Error when running report [message #405083 is a reply to message #405063] Tue, 26 May 2009 05:12 Go to previous message
hamdan102
Messages: 16
Registered: May 2009
Location: jordan
Junior Member

okay
Forms are running correctly
but reports are not
Previous Topic: How to centeralized Repeating frame
Next Topic: Inventory Valuation with Fifo and Lifo
Goto Forum:
  


Current Time: Sun Dec 04 00:15:18 CST 2016

Total time taken to generate the page: 0.07229 seconds