OraFAQ Forum: Forms » FRM- 41213: Unable to connect to the report server error

Home » Developer & Programmer » Forms » FRM- 41213: Unable to connect to the report server error

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

FRM- 41213: Unable to connect to the report server error [message #149117]

Wed, 30 November 2005 02:25

bijayad
Messages: 11
Registered: August 2005

Junior Member

Hi,

I am trying to integrate report within forms 9i. So, I have written following syntax:

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,
'rep_hp11');
where 'rep_hp11' is the report server name created in the folder /Reports/conf/rep_hp11.conf.

But I am getting following error:
FRM- 41213: Unable to connect to the report server rep_hp11.

How to resolve this error.Please help me.
Regards,
Bijaya

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #149128 is a reply to message #149117]

Wed, 30 November 2005 04:01

manjuvasu
Messages: 22
Registered: May 2005

Junior Member

Try this first

In your browser, give as http://hostname/reports/conf/showjobs

then call u'r report from form.

bye

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #149160 is a reply to message #149128]

Wed, 30 November 2005 06:57

bijayad
Messages: 11
Registered: August 2005

Junior Member

Hi,
I am unable to browse this side. Give me alternate solution. Can you tell me how to pass 3 parameters from form 9i to report 9i.

Thanks.
Bijaya

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #149260 is a reply to message #149160]

Wed, 30 November 2005 21:06

manjuvasu
Messages: 22
Registered: May 2005

Junior Member

u try this http://hostname/reports/rwservlet/showjobs

to pass parameters from form use add_parameter built-in.

bye.

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #150051 is a reply to message #149160]

Tue, 06 December 2005 01:47

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #152173 is a reply to message #150051]

Wed, 21 December 2005 08:25

ddshah
Messages: 16
Registered: December 2005

Junior Member

Hello David,

I have similar problem

receiving error FRM-41213 ( able to run web.show_document but unable to run run_report_object) also how to pass multiple user parameters in reports 10g

Can you guide please.

Thanks

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #152229 is a reply to message #149117]

Wed, 21 December 2005 15:32

ddshah
Messages: 16
Registered: December 2005

Junior Member

My code is working - source given in message #152217

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #152720 is a reply to message #152229]

Mon, 26 December 2005 19:24

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Would you put the full link into your reply please. '152217' isn't doing it for me.

David

Report message to a moderator

Re: FRM- 41213: Unable to connect to the report server error [message #153086 is a reply to message #149117]

Wed, 28 December 2005 23:59

ddshah
Messages: 16
Registered: December 2005

Junior Member

Hello David,

the link is as follows:
http://www.orafaq.com/forum/t/56738/80375/

I am pasting the source code itself.

declare
report_id Report_Object;
ReportServerJob VARCHAR2(100);
vc_rep_status VARCHAR2(100);
vjob_id VARCHAR2(100);
repsvr varchar2(21) := 'rep_MYSERV';

BEGIN

report_id:= find_report_object('REPORT1');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,file);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESNAME,'rpout1.html');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'HTMLCSS');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,repsvr);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER, 'paramform=no');

ReportServerJob:=run_report_object(report_id);
vjob_id := substr(reportserverjob,length(repsvr)+2);
vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);

WHILE vc_rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED', null)
LOOP
vc_rep_status:=REPORT_OBJECT_STATUS(ReportServerJob);
END LOOP;

IF vc_rep_status='FINISHED' THEN
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'|| vjob_id ||'?server='||repsvr,'_blank');
ELSE
message ('Report failed with error message '|| vc_rep_status);
END IF;
END;

FRM-41213 ERROR STOPPED AFTER I USED THE ABOVE CODE.

Hope you'll find this OK.

[Updated on: Thu, 29 December 2005 00:31]

Report message to a moderator