OraFAQ Forum: Reports & Discoverer » Error when running report

Home » Developer & Programmer » Reports & Discoverer » Error when running report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error when running report [message #404927]

Mon, 25 May 2009 08:56

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

Report message to a moderator

Re: Error when running report [message #404960 is a reply to message #404927]

Mon, 25 May 2009 15:54

Littlefoot
Messages: 21807
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.

Report message to a moderator

Re: Error when running report [message #404988 is a reply to message #404960]

Tue, 26 May 2009 00:21

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

Littlefoot
Messages: 21807
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).

Report message to a moderator

Re: Error when running report [message #405039 is a reply to message #405021]

Tue, 26 May 2009 02:48

hamdan102
Messages: 16
Registered: May 2009
Location: jordan

Junior Member

frm-41213:unable to connect to the .....

Report message to a moderator

Re: Error when running report [message #405041 is a reply to message #405039]

Tue, 26 May 2009 03:07

Littlefoot
Messages: 21807
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

Report message to a moderator